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