images

CHAPTER8

Designing a Data Warehouse Database

Designing a data warehouse (DW) database is usually different from designing an operational database, which is a database for online transaction processing (OLTP). A DW database can be designed like any other database using the principles of entity-relationship (ER) modeling, such as third normal form (3NF) and so on, but usually that is not an optimal solution because of the need for complex relationships, drill-downs, and so on. Therefore, you can use a logical design technique called dimensional modeling to design a data warehouse database. The biggest difference may be that designing a dimensional ...

Get Oracle SQL Developer Data Modeler for Database Design Mastery now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.