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 ...
Get Databases Illuminated, 4th 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.
