Chapter 4: Data Warehousing and On-line Analytical Processing Data Warehouse: Basic Concepts (a) What is a Data Warehouse? (b)Data Warehouse: A Multi-Tiered Architecture (c)Three Data Warehouse Models: Enterprise Warehouse, Data Mart, and virtual Warehouse (d) Extraction, Transformation and Loading (e)Metadata Repository Data Warehouse modeling Data Cube and olap (a cube: A Lattice of Cuboid (b) Conceptual Modeling of Data Warehouses (c) Stars, Snowflakes, and Fact Constellations: Schemas for Multidimensional Databases (d)Dimensions: The role of Concept Hierarchy (e)Measures: Their Categorization and Computation (f Cube Definitions in Database systems (g Typical OLAP Operations (h)a starnet Query Model for querying Multidimensional Databases 22 Chapter 4: Data Warehousing and On-line Analytical Processing ◼ Data Warehouse: Basic Concepts ◼ (a) What Is a Data Warehouse? ◼ (b) Data Warehouse: A Multi-Tiered Architecture ◼ (c) Three Data Warehouse Models: Enterprise Warehouse, Data Mart, and Virtual Warehouse ◼ (d) Extraction, Transformation and Loading ◼ (e) Metadata Repository ◼ Data Warehouse Modeling: Data Cube and OLAP ◼ (a) Cube: A Lattice of Cuboids ◼ (b) Conceptual Modeling of Data Warehouses ◼ (c) Stars, Snowflakes, and Fact Constellations: Schemas for Multidimensional Databases ◼ (d) Dimensions: The Role of Concept Hierarchy ◼ (e) Measures: Their Categorization and Computation ◼ (f) Cube Definitions in Database systems ◼ (g) Typical OLAP Operations ◼ (h) A Starnet Query Model for Querying Multidimensional Databases