Adding Checkboxes To Report Rows Using HTML DB

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 […]

Damir Bersinic’s Top Five Grid Computing Features

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.

Answers To DBA Interview Questions

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.

New ‘PIVOT’ Feature In MS SQL Server ‘Yukon’

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.

Two New Java Articles By Saikat Goswami

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 […]

Using Generic Connectivity To Access Microsoft SQL Server

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 […]

Dennis Shasha and Philippe Bonnet On Data Warehouse Tuning

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.

Cleanly Restarting OID After A 9iAS 9.0.2 Crash

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, […]

What Are The Benefits When Upgrading From Oracle 8i To 9i?

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 […]

Stephen Few On BI Dashboards

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.