Skip to Main Content
Databases Illuminated, 4th Edition
book

Databases Illuminated, 4th Edition

by Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
March 2022
Intermediate to advanced content levelIntermediate to advanced
682 pages
22h 58m
English
Jones & Bartlett Learning
Content preview from Databases Illuminated, 4th Edition

15.7 Data Models for Data Warehouses

Most operational databases use relational, object-oriented (OO), object-relational (OR), or NoSQL models to store data. Although the models in the data sources may vary, the data warehouse itself must use a model that accommodates OLAP or BI tools and query styles of end users. Data warehouses use different logical models (the way a user thinks about the data) and different implementation models (the way the data is stored). The most common logical organization for data warehouse data is a star schema, or multidimensional model. We discuss the star schema model and a variation of it called snowflake in the first subsection that follows.

Physical storage organization for the implementation of data warehouses ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL and Relational Theory, 3rd Edition

SQL and Relational Theory, 3rd Edition

C.J. Date

Publisher Resources

ISBN: 9781284231595