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 live online training, plus books, videos, and digital content from nearly 200 publishers.