4
Designing Your Database for OLAP

This chapter highlights some of the most important data warehousing concepts as they pertain to Oracle OLAP. It contains additional information that is specific to a data warehouse that will support applications that use OLAP Catalog metadata, such as the OLAP API and the BI Beans.

This chapter includes the following topics:

• Overview
• Preparing a Database for the OLAP API
• Types of Data Stored in a Data Warehouse
• Data Structures in Relational and Multidimensional Data Stores
• OLAP Metadata Model