Data Warehouse Concepts & Architecture

Topics To Be Discussed:
• Why Do We Need A Data Warehouse ?
• The Goal Of A Data Warehouse ?
• What Exactly Is A Data Warehouse ?
• Comparison Of A Data Warehouse And
An Operational Data Store.
• Data Warehouse Trends

Why Do We Need A Data Warehouse ?

Our Goal for A Data Warehouse ?
• Collect Data-Scrub, Integrate & Make It Accessible
• Provide Information - For Our Businesses
• Start Managing Knowledge
• So Our Business Partners Will Gain Wisdom !

Data Warehouse Definition
• Subject Oriented
• Integrated
• Time Variant
• Non-volatile
A Data Warehouse Is A Structured Repository
of Historic Data.
It Is Developed in an Evolutionary Process
By Integrating Data From Non-integrated
Legacy Systems.


Building The Data Warehouse





(Continued)










Tasks                                              Deliverables














•  Define D/W Data Reqmts

•  Map ODS to D/W

•  Document Missing Data

•  Develop D/W DB Design

•  Extract and Integrate D/W Data

•  Load Data Warehouse

•  Maintain Data Warehouse














•  Transition Data Model

•  D/W Data Integration Map

•  To Do Project List

•  D/W Database Design

•  Integrated D/W Data
Extracts

•  Initial Data Load

•  On-going Data Access and Subsequent Loads