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 an ‘elaborate’ process which, [...]

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

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

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.

Website Design & Build: tymedia.co.uk