CHAPTER 2: Data Warehouse: The Building Blocks. CHAPTER OBJECTIVES Review formal definitions of a data warehouse Discuss the defining features Distinguish between data warehouses and data marts Study each component or building block that makes up a data warehouse
Data Warehouse: The Building Blocks
Figure 2-1 distinguishes between how data is stored in operational systems and in the data warehouse.
Figure 2-1 The data warehouse is subject oriented.
The data in the data warehouse comes from several operational systems.
Figure 2-2 illustrates a simple process of data integration for a banking institution.
Figure 2-2 The data warehouse is integrated.
Before the data from various disparate sources can be usefully stored in a data warehouse, you have to remove the inconsistencies.
Figure 2-3 The data warehouse is nonvolatile.
How are They Different?
Figure 2-5 Data warehouse versus data mart.
Figure 2-6 Data warehouse: building blocks or components.
Figure 2-7 illustrates the common types of data movements from the staging area to the data warehouse storage.
Figure 2-7 Data movements to the data warehouse.
Why is metadata especially important in a data warehouse?
It acts as the glue that connects all parts of the data warehouse.
It provides information about the contents and structures to the developers.
It opens the door to the end-users and makes the contents recognizable in their own terms.