ch1 - Ch 1 Dimensional Modeling Primer 1 table of contents...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 4

ch1 - Ch 1 Dimensional Modeling Primer 1 table of contents...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online