Wednesday, March 31st, 2004 by Mark Rittman
A colleague and I were working today on an HTML DB application that displayed
a table of customer records. What we needed to do next was to put a checkbox
beside each customer record, so that we could select one or more of them for
subsequent processing.
Having looked through the HTML DB Forum, I came across
this posting that
referred […]
Tuesday, March 30th, 2004 by Mark Rittman
Damir Bersinic shares his top five new Oracle 10g Features to Support Grid
Computing in
this certcities.com article.
Tuesday, March 30th, 2004 by Mark Rittman
Back in January, I posted a link to some DBA interview questions put forward by James Koopman at Databasejournal.com.
Well, James has now posted another article that gives answers to the questions, so if you’re interested in following up the article, check out “Oracle Technical Interview Questions Answered” part one and part two.
Monday, March 29th, 2004 by Mark Rittman
Time to check out the competition. “The next version of Microsoft’s SQL Server, code named Yukon, will include new PIVOT operators, which will make business intelligence reporting much easier. See what PIVOT operators can do for your next database project.” writes Sanders Kaufman, Jr. for Builder.com.
Sunday, March 28th, 2004 by Mark Rittman
There’s a useful couple of new articles on Orafaq by Saikat Goswami that are
worth taking a look at if you’re thinking about developing on the J2EE platform.
"Introduction to
Java Database Connectivity" discusses the different ways in which Java can
communicate with a database, and talks about the traditional different kinds of
drivers together with some sample code to […]
Saturday, March 27th, 2004 by Mark Rittman
"I am trying to link 2 databases through Business Objects to enable Bus
Obs users to run their own reports (querying data from both databases
’simultaneously’) and have reached a stumbling block because (as I’m sure
you’re aware) database links between Oracle and another database (SQL Server
in this instance) is […]
Friday, March 26th, 2004 by Mark Rittman
DBAZine are currently running
an extract from Dennis Shasha and Philippe Bonnet’s book,
"Database Tuning: Principles, Experiments, and Troubleshooting Techniques"
on data warehouse tuning and optimisation. The extract looks at how data
warehouses differ from transactional databases, and how they are tuned for
optimal performance.
Friday, March 26th, 2004 by Mark Rittman
A problem that often seems to happen when Oracle 9iAS 9.0.2 crashes is that you can’t seem to restart OID using
OIDCTL.
For example, a situation might arise when a server is bounced without 9iAS
being shut down cleanly. When you reboot the PC, and use DCMCTL to check the
status of the OC4J instances prior to starting them, […]
Thursday, March 25th, 2004 by Mark Rittman
One question I’m often asked is "Apart from the inclusion of Oracle OLAP
and Oracle Data Mining, what are the benefits of upgrading an Oracle 8i database
to Oracle 9i?".
Well, I recently came across an article
on this subject by Don Burleson, which is worth taking a look at to get a
high level understanding of the benefits […]
Thursday, March 25th, 2004 by Mark Rittman
“Once again, marketing alchemists have cooked up a bowl of confusion with only a few simple ingredients. Everyone in the business intelligence (BI) space is wild about dashboards, but few proponents are talking about the same thing.” writes Stephen Few for IntelligentEnterprise.com.
