March 2022
Intermediate to advanced
682 pages
22h 58m
English
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 ...