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 super-fast 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.

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

Get Oracle Business Intelligence Enterprise Edition 12c - second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.