stat 120

stat 120 - Data Warehouse/Data Mart Components Concepts...

Info iconThis preview shows pages 1–12. 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

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight 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: Data Warehouse/Data Mart Components Concepts Characteristics Overview Operational vs Informational Systems Data Warehouse components Data Marts Basic Data Warehouse Architecture Copyright 1997, Enterprise Group, Ltd. Source OLTP Source OLTP Systems Systems Subset Data Marts Subset Data Marts Enterprise Data Warehouse One Version One Version of the Truth of the Truth Operational vs. Informational Systems Information Access Today Information Access Today Operational Operational Systems Systems Order Order Entry Entry Manf. Manf. Operational vs. Informational Systems Information Access Today Information Access Today Operational Operational Systems Systems Informational Informational Systems Systems Operational vs. Informational Systems Most of the advances in end-user programming have run into difficulty in actually accessing data that exists in backbone, operational data bases. Operational data bases have a very, very long life. Large operational systems are converted from one technology to a more advanced one very infrequently (typically every eight to twenty years). Therefore, why not create specific DBs whose role was to make large scale end user access easy to isolate the operational DBs, i.e. a Data Warehouse Operational vs. Informational Systems Operational Operational Systems Systems Informational Informational Systems Systems Information Information Delivery System Delivery System Operational vs. Informational Systems Operational Operational Systems Systems Informational Informational Systems Systems Information Information Delivery System Delivery System Data Data Warehouse Warehouse Operational vs. Informational Systems Operational Operational Systems Systems Informational Informational Systems Systems Information Information Delivery System Delivery System Data Data Warehouse Warehouse Operational vs. Informational Systems Operational Operational Systems Systems Information Information Delivery System Delivery System Data Data Warehouse Warehouse Informational Informational Systems Systems Operational vs. InformationalOperational vs....
View Full Document

This note was uploaded on 06/06/2011 for the course MATH 1201 taught by Professor Asl during the Spring '08 term at UCLA.

Page1 / 24

stat 120 - Data Warehouse/Data Mart Components Concepts...

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

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