Each attendee learns the components of an OLAP-ready RDBMS application. Using a broad brush, this session discusses the OLAP-ready relational models, analytically enabled SQL, relational OLAP performance and object-based API utilized by BIBeans. Then, it looks at how one can achieve the goal of "everything in 4GL that can be done declaratively can be manufactured in SQL statements."

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.

The presentation covers the Oracle business intelligence tools using an Oracle Portal 3.0 portal to publish and query Web site activities, explore and analyze customer behaviors, analyze trends and forecast.