Transcript Business Approaches to Data Vault Modeling

The Data Vault –
Selected Slides
© Genesee Academy, 2005-2007
http://www.GeneseeAcademy.com
[email protected]
[email protected]
1
http://www.GeneseeAcademy.com
7/17/2015
What is the Data Vault?
The Data Vault is a data modeling approach for the
Enterprise Data Warehouse.
It is uniquely flexible, scalable, consistent and extremely
adaptable to the needs of the enterprise.
It is a data model that is architected specifically to meet the
needs of today’s enterprise data warehouses.
2
http://www.GeneseeAcademy.com
7/17/2015
Where Does It Fit?
Integration
Operational
EDW-DV
Data Marts
Marketing
Gold Mine
Sales
Siebel
ETL
ETL
Staging
Area
ERP
JD Edwards
PeopleSoft
SAP
SCM
ETL
ETL
External Data
Mart
Mart
Mart
Mart
Strategic Marts
ETL
I2 Technologies
Manugistics
Visual Movement
Mart
Mart
ETL
Mart
Mart
Exploration
& Mining
ETL
Mart
Mart
Exploration
& Mining
Traditional Architecture
Enterprise BI Solution
Sales
(batch)
Staging
(EDW)
Finance
Complex
Business
Rules
Staging + History
Contracts
4
Complex
Business
Rules
+Dependencies
Star
Schemas
Conformed Dimensions
Junk Tables
Helper Tables
Factless Facts
Fundamental Architecture
Enterprise BI Solution
Sales
Finance
Star
Schemas
(batch)
Staging
Contracts
(batch)
EDW
Error
Marts
Complex
Business
Rules
Report
Collections
FUNDAMENTAL GOALS
5
• Repeatable • Scalable
• Consistent
• Auditable
• Fault-Tolerant
The business rules are moved closer to the business,
improving IT reaction time, reducing cost and minimizing
impacts to the enterprise data warehouse (EDW)
What are the Entity Types?
 Hub:
 Link:
 Satellite:
List of UNIQUE business keys.
List of UNIQUE relationships between keys.
Historical descriptive data.
Email Information
Records a history
of the interaction
Sat
Sat
Sat
Email ID
Link
Bank Transactions
Sat
Bank ID
Sat
F(x)
Sat
Sat
Hub
Sat
Link
Passenger
ID
Sat
Satellite
Sat
** Dashed Line is a possible New Relationship
6
http://www.GeneseeAcademy.com
Airline Reservations
7/17/2015
What are the Benefits?
 Architecturally Completely Auditable
 Model Directly Aligned to the Business Model
 Extremely Adaptable To Business Change
 Designed and Optimized Specifically for the EDW
 Durable, Consistent and Predictable
 Intelligence Investment Appreciates Over Time
 Terminal Complexity
7/17/2015
Industry Quotes About Data Vault
Bill Inmon: “The Data Vault is functionally strong and a viable architecture in implementing
your Enterprise Data Warehouse.”
“The Data Vault is the optimal choice for DW2.0 architectures.”
Kent Graziano, Denver Public Schools: “We believe that this data modeling technique
is the best suited for designing a central, historic data repository because of its flexibility to
easily add new subject areas and attributes.”
Clive Finkelstein: “This should be called the "Foundational Warehouse Model", and it
looks to be a solid implementation paradigm that's highly scalable.”
Stephen Brobst, CTO Teradata: “The Data Vault is foundationally strong and
exceptionally scalable architecture.”
Doug Laney, META GROUP: “The Data Vault is a technique which some industry experts
have predicted may spark a revolution as the next big thing in data modeling for enterprise
warehousing....” (Wilshire Conferences, Enterprise Data Forum Brochure, November 4-7,
2002),
8
http://www.GeneseeAcademy.com
7/17/2015
Questions?
The Home of the Data Vault
Dan Linstedt
www.DanLinstedt.com
[email protected]
Certification Training
Hans Hultgren
www.GeneseeAcademy.com
[email protected]
Free White Papers
www.TDAN.com
9
Genesee Academy
Rapid ACE
Golden, Colorado USA
Golden, Colorado USA
001-303-526-0340
001-303-526-9080