Data stores, data warehousing, and the Zachman framework: managing enterprise knowledge
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
New York [u.a.]
McGraw-Hill
1997
|
| Series: | McGraw-Hill series on Data Warehousing and Data Management
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XVIII, 358 S. Ill. |
| ISBN: | 0070314292 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV011681781 | ||
| 003 | DE-604 | ||
| 005 | 19991129 | ||
| 007 | t | ||
| 008 | 971211s1997 a||| |||| 00||| eng d | ||
| 020 | |a 0070314292 |9 0-07-031429-2 | ||
| 035 | |a (OCoLC)36485753 | ||
| 035 | |a (DE-599)BVBBV011681781 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-29T |a DE-M347 |a DE-11 | ||
| 050 | 0 | |a QA76.9.D3 | |
| 082 | 0 | |a 005.74/068 |2 21 | |
| 084 | |a QP 345 |0 (DE-625)141866: |2 rvk | ||
| 100 | 1 | |a Inmon, William H. |d 1945- |e Verfasser |0 (DE-588)113317662 |4 aut | |
| 245 | 1 | 0 | |a Data stores, data warehousing, and the Zachman framework |b managing enterprise knowledge |c W.H. Inmon ; John A. Zachman ; Jonathan G. Geiger |
| 264 | 1 | |a New York [u.a.] |b McGraw-Hill |c 1997 | |
| 300 | |a XVIII, 358 S. |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a McGraw-Hill series on Data Warehousing and Data Management | |
| 650 | 7 | |a Data warehouse |2 gtt | |
| 650 | 7 | |a Databanken |2 gtt | |
| 650 | 7 | |a Kennismanagement |2 gtt | |
| 650 | 7 | |a Management informatiesystemen |2 gtt | |
| 650 | 4 | |a Data warehousing | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Management information systems | |
| 650 | 0 | 7 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Betriebliches Informationssystem |0 (DE-588)4069386-7 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |D s |
| 689 | 0 | 1 | |a Betriebliches Informationssystem |0 (DE-588)4069386-7 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Zachman, John A. |e Verfasser |4 aut | |
| 700 | 1 | |a Geiger, Jonathan G. |e Verfasser |4 aut | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=007875708&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-007875708 | ||
Record in the Search Index
| _version_ | 1804126217501147136 |
|---|---|
| adam_text | Foreword xiii
Preface xv
¦H ONE THE NEED FOR AN ARCHITECTURE
Chapter 1 A Look at History with a View to the Future 3
Four Generations • 4
Formation 5
Computer Technology 6
Data Management 7
Programming Languages 7
Methodology 7
Assessment 8
Proliferation 1 o
Computer Technology 1 o
Data Management I i
Programming Languages 12
Methodology 13
Assessment 15
Dispersion 18
Computer Technology 19
Data and Object Management 19
Programming Languages 21
Methodoigy 22
Assessment 23
Chapter 2 Satisfying Modern Information Needs 29
Need for an Architecture 30
Information Systems Architecture 31
Zachman Framework 39
Migration of Legacy Systems 39
Influencing Factors 40
Role of Technology 41
V
Unification 42
Computer Technology 43
Data and Object Management 44
Programming Languages 47
Methodology 48
Assessment 48
¦¦¦ TWO ARCHITECTURAL FRAMEWORK
Chapter 3 The Zachman Framework 55
Zachman Framework Overview 56
Perspectives 57
Dimensions 57
Perspectives—Rows of the Zachman Framework 60
Planner s Perspective 61
Owner s Perspective 63
Designer s Perspective 64
Builder s Perspective 65
Subcontractors Perspective 66
Dimensions—Columns of the Zachman Framework 71
Entities (What?) 71
Activities (How?) 72
Locations (Where?) 73
People (Who?) 74
Times (When?) 75
Motivations (Why?) 76
Rules of the Zachman Framework 78
Dimension Importance 78
Dimension Simplicity 80
Dimension Uniqueness 81
Perspective Uniqueness 82
Cell Uniqueness 82
Dimension Necessity 85
Logic Recursiveness 87
Chapter 4 A Framework for Managing Enterprise Knowledge 93 :
Observations about the Framework 94
The Product Framework 96
i
The Enterprise Framework 98
Relationship to Product Framework 99
Application 101
Engineering Administration 103
Data Administration 104
Data Warehouse and Operational Data Store 105
The Challenge 106
Information Systems Department Framework 107
The Problem 108
Application 11 1
Repository Framework 116
Application 117
Analogy to Engineering Administration 121
Chapter 5 Establishing the Data Warehouse Strategy 127
What Is a Guiding Principle? 128
Motivations Dimension 130
Funding 131
Service Levels 131
Times Dimension 132
Historical View 132
Historical Information 134
Data Currency 134
Locations Dimension 135
Servers 135
Indirect Data Access 137
Activities Dimension I 39
Data Warehouse Methodology 139
Application Development Methodology 141
People Dimension 142
Direct Data Access 142
Interface 143
Security 143
Entities Dimension 143
Quality 144
Data Sources 145
Transformation and Integration ] 45
Data Orientation 145
Metadata 146
Chapter 6 Zachman Framework Based Methodology 149
Methodology Overview 150
Planner s view 152
Commitment to Proceed 152
Owner s View 157
Data Model Analysis 158
Designer s View 164
Breadbox Analysis 164
Technical Assessment 166
Subject Area Analysis 168
Builder s view 169
Source System Analysis 169
Technical Environment Preparation 172
Data Warehouse Design 173
Programming Specifications 176
Technical Environment Preparation 178
Subcontractor s view 179
Programming 179
Technical Environment Preparation 179
Builder s View Revisited 179
Population 179
Metadata 180
Tool Support 180
¦¦¦THREE APPLICATIONS
Chapter 7 Building the First Data Warehouse 185
The Development Life Cycle 186
Commitment to Proceed 187
Motivations 188
People and Locations 189
Entities ] 91
Activities and Times 191
Risk Assessment 192
Project Sponsor Implications 195
Project Manager Implications 195
Source System Analysis 195
Data Model Analysis 196
Removing Operational Data 196
Identifying Business Entities and Attributes 197
Adding a Time Dimenstion 198
Risk Assessment 198
Technical Assessment and Technical Environment Preparation 199
Breadbox Analysis 200
Subject Area Analysis 200
Source System Analysis 200
Data Warehouse Design 200
Specifications 202
Activities 202
Motivations 202
People 203
Locations 204
Times 204
Technical Model Culmination 205
Programming 205
Entities 206
Activities 207
Locations 207
People 207
Times 207
Motivations 208
Out of Context Model Culmination 208
Technical Model Revisited—Population 209
Chapter 8 Extending the Data Warehouse 213
Commitment to Proceed 214
Motivations 214
People 216
Data Model Analysis 217
Entities 218
Attributes 219
Business Rules 219
Data Steward 220
Subject Area Analysis 222
Source System Analysis 222
Data Warehouse Design 225
Staging Area 226
Star Schema 226
Additional Subject Areas 228
Chapter 9 Building the Operational Data Store 233
Contrasts and Similarities 234
Activities 235
Planners Perspective 236
Owner s Perspective 238
Designer s Perspective 239
Builder s Perspective 243
Subcontractor s Perspective 243
Motivations 243
People 243
Entities 246
Business Model 246
System Model 247
Technical Model 247
Out of Context Model 248
Times 248
Locations 249
Operating Environment 250
Chapter 10 Metadata 253
Importance of Metadata 254
Metadata about the Data Warehouse 255
Metadata about People 257
Metadata about Entities 258
Metadata about Activities 260
Metadata about Locations 261
Metadata about Motivations 262
Metadata about Times 263
Combined View 264
Metadata Capture and Maintenance 265
Metadata for the Initial Data Warehouse 266
Metadata for Multiple Data Warehouses 267
Chapter 11 The Data Warehouse as a Means to an End 269
Migrating Legacy Systems 270
The Problem 270
The Opportunity 270
Scope Definition 271
Business Model 274
Technical Model 275
System Model 275
Technical Model Revisited 279
Out of Context Model 279
Impact 280
Summary of System Migration 281
Helping Companies Deal with a Dynamic Business Environment 281
Support from the Zachman Framework 283
Support from the Data Warehouse 286
Support from the Operational Data Store 287
Support from New Operational Systems 287
Total Quality Management 288
Management of Information and Data 290
Competitive Comparisons and Benchmarking 291
Analysis and Use of Company Level Data 291
Management by Fact 292
Root Cause Analysis 292
Chapter 12 Knowledge 295
Glossary 297
Bibliography 329
Index 345
|
| any_adam_object | 1 |
| author | Inmon, William H. 1945- Zachman, John A. Geiger, Jonathan G. |
| author_GND | (DE-588)113317662 |
| author_facet | Inmon, William H. 1945- Zachman, John A. Geiger, Jonathan G. |
| author_role | aut aut aut |
| author_sort | Inmon, William H. 1945- |
| author_variant | w h i wh whi j a z ja jaz j g g jg jgg |
| building | Verbundindex |
| bvnumber | BV011681781 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 |
| callnumber-search | QA76.9.D3 |
| callnumber-sort | QA 276.9 D3 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | QP 345 |
| ctrlnum | (OCoLC)36485753 (DE-599)BVBBV011681781 |
| dewey-full | 005.74/068 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74/068 |
| dewey-search | 005.74/068 |
| dewey-sort | 15.74 268 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01942nam a2200481 c 4500</leader><controlfield tag="001">BV011681781</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">19991129 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">971211s1997 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0070314292</subfield><subfield code="9">0-07-031429-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)36485753</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV011681781</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-29T</subfield><subfield code="a">DE-M347</subfield><subfield code="a">DE-11</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74/068</subfield><subfield code="2">21</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 345</subfield><subfield code="0">(DE-625)141866:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Inmon, William H.</subfield><subfield code="d">1945-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)113317662</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Data stores, data warehousing, and the Zachman framework</subfield><subfield code="b">managing enterprise knowledge</subfield><subfield code="c">W.H. Inmon ; John A. Zachman ; Jonathan G. Geiger</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York [u.a.]</subfield><subfield code="b">McGraw-Hill</subfield><subfield code="c">1997</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVIII, 358 S.</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">McGraw-Hill series on Data Warehousing and Data Management</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data warehouse</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Databanken</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Kennismanagement</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Management informatiesystemen</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data warehousing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Management information systems</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Betriebliches Informationssystem</subfield><subfield code="0">(DE-588)4069386-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Betriebliches Informationssystem</subfield><subfield code="0">(DE-588)4069386-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Zachman, John A.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Geiger, Jonathan G.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=007875708&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-007875708</subfield></datafield></record></collection> |
| id | DE-604.BV011681781 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T18:13:57Z |
| institution | BVB |
| isbn | 0070314292 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-007875708 |
| oclc_num | 36485753 |
| open_access_boolean | |
| owner | DE-29T DE-M347 DE-11 |
| owner_facet | DE-29T DE-M347 DE-11 |
| physical | XVIII, 358 S. Ill. |
| publishDate | 1997 |
| publishDateSearch | 1997 |
| publishDateSort | 1997 |
| publisher | McGraw-Hill |
| record_format | marc |
| series2 | McGraw-Hill series on Data Warehousing and Data Management |
| spelling | Inmon, William H. 1945- Verfasser (DE-588)113317662 aut Data stores, data warehousing, and the Zachman framework managing enterprise knowledge W.H. Inmon ; John A. Zachman ; Jonathan G. Geiger New York [u.a.] McGraw-Hill 1997 XVIII, 358 S. Ill. txt rdacontent n rdamedia nc rdacarrier McGraw-Hill series on Data Warehousing and Data Management Data warehouse gtt Databanken gtt Kennismanagement gtt Management informatiesystemen gtt Data warehousing Database management Management information systems Data-Warehouse-Konzept (DE-588)4406462-7 gnd rswk-swf Betriebliches Informationssystem (DE-588)4069386-7 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 s Betriebliches Informationssystem (DE-588)4069386-7 s DE-604 Zachman, John A. Verfasser aut Geiger, Jonathan G. Verfasser aut HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=007875708&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Inmon, William H. 1945- Zachman, John A. Geiger, Jonathan G. Data stores, data warehousing, and the Zachman framework managing enterprise knowledge Data warehouse gtt Databanken gtt Kennismanagement gtt Management informatiesystemen gtt Data warehousing Database management Management information systems Data-Warehouse-Konzept (DE-588)4406462-7 gnd Betriebliches Informationssystem (DE-588)4069386-7 gnd |
| subject_GND | (DE-588)4406462-7 (DE-588)4069386-7 |
| title | Data stores, data warehousing, and the Zachman framework managing enterprise knowledge |
| title_auth | Data stores, data warehousing, and the Zachman framework managing enterprise knowledge |
| title_exact_search | Data stores, data warehousing, and the Zachman framework managing enterprise knowledge |
| title_full | Data stores, data warehousing, and the Zachman framework managing enterprise knowledge W.H. Inmon ; John A. Zachman ; Jonathan G. Geiger |
| title_fullStr | Data stores, data warehousing, and the Zachman framework managing enterprise knowledge W.H. Inmon ; John A. Zachman ; Jonathan G. Geiger |
| title_full_unstemmed | Data stores, data warehousing, and the Zachman framework managing enterprise knowledge W.H. Inmon ; John A. Zachman ; Jonathan G. Geiger |
| title_short | Data stores, data warehousing, and the Zachman framework |
| title_sort | data stores data warehousing and the zachman framework managing enterprise knowledge |
| title_sub | managing enterprise knowledge |
| topic | Data warehouse gtt Databanken gtt Kennismanagement gtt Management informatiesystemen gtt Data warehousing Database management Management information systems Data-Warehouse-Konzept (DE-588)4406462-7 gnd Betriebliches Informationssystem (DE-588)4069386-7 gnd |
| topic_facet | Data warehouse Databanken Kennismanagement Management informatiesystemen Data warehousing Database management Management information systems Data-Warehouse-Konzept Betriebliches Informationssystem |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=007875708&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT inmonwilliamh datastoresdatawarehousingandthezachmanframeworkmanagingenterpriseknowledge AT zachmanjohna datastoresdatawarehousingandthezachmanframeworkmanagingenterpriseknowledge AT geigerjonathang datastoresdatawarehousingandthezachmanframeworkmanagingenterpriseknowledge |