O'Reilly logo

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial by Adrian Ward, Haroun Khan, Christian Screen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing your database — objectives, rules, and goals

Whenever you create a data warehouse for reporting, you have to consider that there are finite resources. There is never enough space to store data, never enough time to populate the database, and never enough processing power to use a fully normalized source. Even with the latest superfast technologies, such as Oracle Exadata, there is a limit to the amount of data that can be stored or processed in a given time period (ETL window).

The primary objective should always be to speed up the report production, which means using a dimensional model, particularly when storing a large amount of data. As discussed in the Theories and models section, using an entity relational database would reduce ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required