Data Stores, Data Warehousing, and the Zachman Framework: Managing Enterprise Knowledge

by Inmon, William H.; Zachman, John A.; Geiger, Jonathan G.; Inmon, W. H.

• ISBN13: 9780070314290
• ISBN10: 0070314292
• Edition: 1st
• Format: Paperback
• Copyright: 1997-05-01
• Publisher: Osborne McGraw-Hill

Summary

The Zachman Framework is a framework to organize and analyze data so it can be turned into a source of knowledge. Here is the first and last word on this hot topic from the inventors of the framework. The text explains how companies can apply this technology to their own data warehouses and stores.

Table of Contents

Foreword	xiii	(2)
Preface	xv
PART ONE THE NEED FOR AN ARCHITECTURE	3	(52)
Chapter 1 A Look at History with a View to the Future	3	(26)
Four Generations	4	(1)
Formation	5	(1)
Computer Technology	6	(4)
Data Management	7	(1)
Programming Languages	7	(1)
Methodology	7	(1)
Assessment	8	(2)
Proliferation	10	(8)
Computer Technology	10	(1)
Data Management	11	(1)
Programming Languages	12	(1)
Methodology	13	(2)
Assessment	15	(3)
Dispersion	18	(11)
Computer Technology	19	(1)
Data and Object Management	19	(2)
Programming Languages	21	(1)
Methodology	22	(1)
Assessment	23	(6)
Chapter 2 Satisfying Modern Information Needs	29	(26)
Need for an Architecture	30	(12)
Information Systems Architecture	31	(8)
Zachman Framework	39	(1)
Migration of Legacy Systems	39	(1)
Influencing Factors	40	(1)
Role of Technology	41	(1)
Unification	42	(13)
Computer Technology	43	(1)
Data and Object Management	44	(3)
Programming Languages	47	(1)
Methodology	48	(1)
Assessment	48	(7)
PART TWO ARCHITECTURAL FRAMEWORK	55	(130)
Chapter 3 The Zachman Framework	55	(38)
Zachman Framework Overview	56	(4)
Perspectives	57	(1)
Dimensions	57	(3)
Perspectives--Rows of the Zachman Framework	60	(11)
Planner's Perspective	61	(2)
Owner's Perspective	63	(1)
Designer's Perspective	64	(1)
Builder's Perspective	65	(1)
Subcontractor's Perspective	66	(5)
Dimensions--Columns of the Zachman Framework	71	(7)
Entities (What?)	71	(1)
Activities (How?)	72	(1)
Locations (Where?)	73	(1)
People (Who?)	74	(1)
Times (When?)	75	(1)
Motivations (Why?)	76	(2)
Rules of the Zachman Framework	78	(15)
Dimension Importance	78	(2)
Dimension Simplicity	80	(1)
Dimension Uniqueness	81	(1)
Perspective Uniqueness	82	(1)
Cell Uniqueness	82	(3)
Dimension Necessity	85	(2)
Logic Recursiveness	87	(6)
Chapter 4 A Framework for Managing Enterprise Knowledge	93	(34)
Observations about the Framework	94	(2)
The Product Framework	96	(2)
The Enterprise Framework	98	(9)
Relationship to Product Framework	99	(2)
Application	101	(2)
Engineering Administration	103	(1)
Data Administration	104	(1)
Data Warehouse and Operational Data Store	105	(1)
The Challenge	106	(1)
Information Systems Department Framework	107	(9)
The Problem	108	(3)
Application	111	(5)
Repository Framework	116	(11)
Application	117	(4)
Analogy to Engineering Administration	121	(6)
Chapter 5 Establishing the Data Warehouse Strategy	127	(22)
What Is a Guiding Principle?	128	(2)
Motivations Dimension	130	(2)
Funding	131	(1)
Service Levels	131	(1)
Times Dimension	132	(3)
Historical View	132	(2)
Historical Information	134	(1)
Data Currency	134	(1)
Locations Dimension	135	(4)
Servers	135	(2)
Indirect Data Access	137	(2)
Activities Dimension	139	(3)
Data Warehouse Methodology	139	(2)
Application Development Methodology	141	(1)
People Dimension	142	(1)
Direct Data Access	142	(1)
Interface	143	(1)
Security	143	(1)
Entities Dimension	143	(6)
Quality	144	(1)
Data Sources	145	(1)
Transformation and Integration	145	(1)
Data Orientation	145	(1)
Metadata	146	(3)
Chapter 6 Zachman Framework-Based Methodology	149	(36)
Methodology Overview	150	(2)
Planner's View	152	(5)
Commitment to Proceed	152	(5)
Owner's View	157	(7)
Data Model Analysis	158	(6)
Designer's View	164	(5)
Breadbox Analysis	164	(2)
Technical Assessment	166	(2)
Subject Area Analysis	168	(1)
Builder's View	169	(10)
Source System Analysis	169	(3)
Technical Environment Preparation	172	(1)
Data Warehouse Design	173	(3)
Programming Specifications	176	(2)
Technical Environment Preparation	178	(1)
Subcontractor's View	179	(1)
Programming	179	(1)
Technical Environment Preparation	179	(1)
Builder's View Revisited	179	(1)
Population	179	(1)
Metadata	180	(1)
Tool Support	180	(5)
PART THREE APPLICATIONS	185	(112)
Chapter 7 Building the First Data Warehouse	185	(28)
The Development Life Cycle	186	(1)
Commitment to Proceed	187	(8)
Motivations	188	(1)
People and Locations	189	(2)
Entities	191	(1)
Activities and Times	191	(1)
Risk Assessment	192	(3)
Project Sponsor Implications	195	(1)
Project Manager Implications	195	(1)
Source System Analysis	195	(1)
Data Model Analysis	196	(3)
Removing Operational Data	196	(1)
Identifying Business Entities and Attributes	197	(1)
Adding a Time Dimenstion	198	(1)
Risk Assessment	198	(1)
Technical Assessment and Technical Environment Preparation	199	(1)
Breadbox Analysis	200	(1)
Subject Area Analysis	200	(1)
Source System Analysis	200	(1)
Data Warehouse Design	200	(2)
Specifications	202	(3)
Activities	202	(1)
Motivations	202	(1)
People	203	(1)
Locations	204	(1)
Times	204	(1)
Technical Model Culmination	205	(1)
Programming	205	(4)
Entities	206	(1)
Activities	207	(1)
Locations	207	(1)
People	207	(1)
Times	207	(1)
Motivations	208	(1)
Out-of-Context Model Culmination	208	(1)
Technical Model Revisited--Population	209	(4)
Chapter 8 Extending the Data Warehouse	213	(20)
Commitment to Proceed	214	(3)
Motivations	214	(2)
People	216	(1)
Data Model Analysis	217	(5)
Entities	218	(1)
Attributes	219	(1)
Business Rules	219	(1)
Data Steward	220	(2)
Subject Area Analysis	222	(1)
Source System Analysis	222	(3)
Data Warehouse Design	225	(3)
Staging Area	226	(1)
Star Schema	226	(2)
Additional Subject Areas	228	(5)
Chapter 9 Building the Operational Data Store	233	(20)
Contrasts and Similarities	234	(1)
Activities	235	(8)
Planner's Perspective	236	(2)
Owner's Perspective	238	(1)
Designer's Perspective	239	(4)
Builder's Perspective	243	(1)
Subcontractor's Perspective	243	(1)
Motivations	243	(1)
People	243	(3)
Entities	246	(2)
Business Model	246	(1)
System Model	247	(1)
Technical Model	247	(1)
Out-of-Context Model	248	(1)
Times	248	(1)
Locations	249	(1)
Operating Environment	250	(3)
Chapter 10 Metadata	253	(16)
Importance of Metadata	254	(1)
Metadata about the Data Warehouse	255	(2)
Metadata about People	257	(1)
Metadata about Entities	258	(2)
Metadata about Activities	260	(1)
Metadata about Locations	261	(1)
Metadata about Motivations	262	(1)
Metadata about Times	263	(1)
Combined View	264	(1)
Metadata Capture and Maintenance	265	(4)
Metadata for the Initial Data Warehouse	266	(1)
Metadata for Multiple Data Warehouses	267	(2)
Chapter 11 The Data Warehouse as a Means to an End	269	(26)
Migrating Legacy Systems	270	(11)
The Problem	270	(1)
The Opportunity	270	(1)
Scope Definition	271	(3)
Business Model	274	(1)
Technical Model	275	(1)
System Model	275	(4)
Technical Model Revisited	279	(1)
Out-of-Context Model	279	(1)
Impact	280	(1)
Summary of System Migration	281	(1)
Helping Companies Deal with a Dynamic Business Environment	281	(7)
Support from the Zachman Framework	283	(3)
Support from the Data Warehouse	286	(1)
Support from the Operational Data Store	287	(1)
Support from New Operational Systems	287	(1)
Total Quality Management	288	(7)
Management of Information and Data	290	(1)
Competitive Comparisons and Benchmarking	291	(1)
Analysis and Use of Company-Level Data	291	(1)
Management by Fact	292	(1)
Root Cause Analysis	292	(3)
Chapter 12 Knowledge	295	(2)
Glossary	297	(32)
Bibliography	329	(16)
Index	345