This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Ch 1 Dimensional Modeling Primer 1 table of contents The big picture Data assets Goals Architecture Fundamental vocabulary Data Assets We can classify data as belonging either to the operational systems, or data warehouse Operational systems are used to run the business, to manage the day-to-day events constantly update the data bases are characterized by transactions typically accessing few rows Data Warehouses are systems used for storing historical data used for data analysis where data is updated periodically where user queries typically access many rows that are subject-oriented, integrated, time variant and non-volatile collections of data used for decision making. There are many differences between operational and warehouse systems for managing data. Goals of a Data Warehouse The data warehouse must: make information easily accessible present information consistently be adaptive and resilient to change be a secure bastion that protects information serve as the foundation for improved decision making be accepted by the business community Ch 1 Dimensional Modeling Primer...
View Full Document
This note was uploaded on 02/17/2010 for the course ACS ACS-3911 taught by Professor Chen during the Spring '10 term at Windsor.
- Spring '10