Data Warehouse

_ The primary concept of data warehousing is that the data stored

for business analysis can most effectively be accessed by

separating it from the data in the operational systems.

_ A data warehouse is a collection of computer based information

that is critical to the successful execution of enterprise initiatives.

_ Update & delete production data that “Feed”

_ Operational systems create data “Parts”

_ Advantages of a Data Warehouse

_ More cost effective decision – making

_ Better enterprise intelligence

_ Enhanced customer service

_ Business reengineering

_ Information system reengineering

_ Data warehouse components

_ Summarized Data

_ Operational systems of record

_ Integration / transformation programs

_ Current detail

_ Data warehouse architecture or metadata

_ archives

_ Summarized Data

_ Lightly Summarized data : Hallmark of data warehouse

_ Highly Summarized Data : Primarily for enterprise executive

_ Current Detail

_ The heart of data warehouse.

_ Comes directly from operational system

_ Stored as raw data / aggregations of raw data

_ Current detail –lowest level of data granularity

_ System of Record

_ Source of data that feed the data warehouse.