Optimizing Oracle 8i for Business Intelligence

Presented by David Fuston

This presentation covers the DBA tools and techniques used in optimizing Oracle 8i relational database for business intelligence users. The background topics covered include star schema, creation and population of data mart, Express cubes design and development, as well as the differences in MOLAP, ROLAP and HOLAP performance. There is coverage of three different objectives: minimizing space required to build cubes, minimizing cube processing times and getting the best query execution times. Using sample queries, the session then shows examples of performance improvements from two real world data marts. BI optimization tips for both relational and multi-dimensional servers are summarized. Demonstration of both the Express RAA query statistics GUI provided with Express server and the Oracle 8i analyze statistics command are used.

Let’s discuss your options

Contact us to discuss next steps.