Table of Contents
Data Warehousing
Motivation: “Necessity is the Mother of Invention”
Data Warehouse
Data Warehouse - Subject Oriented
Data Warehouse - Integrated
Data Warehouse - Non-Volatile
Data Warehouse - Time Variance
Why Separate Data Warehouse?
Why Separate Data Warehouse?
PPT Slide
Data Sources
Data Extraction
Data Cleaning
Load and Refresh
Data Warehouse DBMS
Monitor
Integrator
Metadata Repository
Data Marts
Multidimensional Modeling
Dimensional Modeling
Modeling of Data Warehouses
Star Schema
Snowflake Schema
A Star-Net Query Model
Summary Tables
Multidimensional Indexing
Bitmap Indexes
Bitmap Indexes
Join Indexes
View and Materialized views
Materialized View Issues
Using SQL with Data Warehouses
Data Warehousing: Summary
Data Warehousing Systems
|