Data Warehouse Concepts & Architecture
© Principle Partners, Inc.
Info@PrinciplePartners.Com
Page 1
PP I
Data Warehouse Concepts 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.
© Principle Partners, Inc.
Info@PrinciplePartners.Com
Page 2
PP I
Data Warehouse Concepts Why Do We Need A Data Warehouse ?
We Can Only See - What We Can See !
© Principle Partners, Inc.
Info@PrinciplePartners.Com
Page 3
PP I
Data Warehouse Concepts Why Do We Need A Data Warehouse ?
BETTER ! FASTER ! CHEAPER !
FUNCTIONALLY COMPLETE !
© Principle Partners, Inc.
Info@PrinciplePartners.Com
Page 4
PP I
Data Warehouse Concepts Data Warehouse Development Perspective
Data Driven
Vs.
Function Driven
O/P Data DSS
A/P Order Processing EIS Data
© Principle Partners, Inc.
Info@PrinciplePartners.Com
Page 5
PP I
Data Warehouse Concepts What Do We Need To Do ? Use Operational Legacy Systems’ Data: To Build Operational Data Store, That Integrate Into Corporate Data Warehouse, That Spin-off Data Marts.
Some May Tell You To Develop These In Reverse!
© Principle Partners, Inc.
Info@PrinciplePartners.Com
Page 6
PP I
Data Warehouse Concepts 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 !
© Principle Partners, Inc.
Info@PrinciplePartners.Com
Page 7
PP I
Data Warehouse Concepts Data Warehouse Definition 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. It Is Usually: • • • •
© Principle Partners, Inc.
Info@PrinciplePartners.Com
Subject Oriented...