v
The Java Solution for OLAP........................................................................................................ 3-6
Oracle Java Development Environment.................................................................................... 3-6
Introducing the BI Beans................................................................................................................... 3-7
Thick-Client Configuration ......................................................................................................... 3-7
Thin-Client Configuration........................................................................................................... 3-9
Metadata ...................................................................................................................................... 3-10
Runtime Repository ................................................................................................................... 3-10
Navigation ................................................................................................................................... 3-10
Formatting ................................................................................................................................... 3-10
Graphs.......................................................................................................................................... 3-11
Crosstabs...................................................................................................................................... 3-11
Tables............................................................................................................................................ 3-11
OLAP BI Beans............................................................................................................................ 3-12
Wizards ........................................................................................................................................ 3-12
Understanding the OLAP API........................................................................................................ 3-12
How the OLAP API Accesses Multidimensional Data......................................................... 3-13
Intelligent Caching ..................................................................................................................... 3-15
Calculation Capabilities............................................................................................................. 3-15
4 Designing Your Database for OLAP
Overview .............................................................................................................................................. 4-2
Preparing a Database for the OLAP API........................................................................................ 4-2
Types of Data Stored in a Data Warehouse ................................................................................... 4-3
Historical Data .............................................................................................................................. 4-3
Derived Data ................................................................................................................................. 4-4
Metadata ........................................................................................................................................ 4-4
Data Structures in Relational and Multidimensional Data Stores ........................................... 4-4
Relational Table Storage .............................................................................................................. 4-4
Multidimensional Table Storage ................................................................................................ 4-5
Temporary and Persistent Analytic Workspaces..................................................................... 4-5
About Star, Snowflake, Parent-Child, and Multidimensional Schemas............................... 4-6
Choosing a Schema for Your Data ............................................................................................. 4-7
OLAP Metadata Model...................................................................................................................... 4-8
Mapping Data Objects to Metadata Objects ............................................................................. 4-8
Measures ........................................................................................................................................ 4-9
