Managing reference data in enterprise databases: binding corporate data to the wider world
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
San Francisco [u.a.]
Kaufmann
2001
|
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XIX, 387 S. Ill. |
| ISBN: | 1558606971 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV025195414 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 100417s2001 a||| |||| 00||| eng d | ||
| 020 | |a 1558606971 |9 1-55860-697-1 | ||
| 035 | |a (OCoLC)247725756 | ||
| 035 | |a (DE-599)BVBBV025195414 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-11 | ||
| 082 | 0 | |a 005.758 | |
| 084 | |a QP 345 |0 (DE-625)141866: |2 rvk | ||
| 100 | 1 | |a Chisholm, Malcolm |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Managing reference data in enterprise databases |b binding corporate data to the wider world |c Malcolm Chisholm |
| 264 | 1 | |a San Francisco [u.a.] |b Kaufmann |c 2001 | |
| 300 | |a XIX, 387 S. |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 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=019836077&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-019836077 | ||
Datensatz im Suchindex
| _version_ | 1804142244521836544 |
|---|---|
| adam_text | Contents
Acknowledgments xiii
Introduction xv
Chapter 1
What Is Reference Data? 1
A Definition of Reference Data 2
Common Data 3
External Data 5
Reference Data in the Literature 6
Conclusion 7
Chapter 2
A Few Database Design Concepts 9
Attributes and Entities 10
Relationships 12
Subtype Relationships 15
Conclusion 17
Chapter 3
The Diversity of Reference Data 19
Referencing the World beyond the Enterprise
with Codes and Descriptions 20
Type Codes 24
Status Codes 27
Contents
Constant Values 33
Global Data 37
Classification Schemes 38
Buckets 41
What Is Not Reference Data 47
Indicators and Flags 49
Conclusion .50
Chapter 4
Characteristics of Reference Data 53
Rate of Change 53
Scope 55
Volume 56
Risk 57
Metadata and Meaning 58
When Reference Data Values Are Known 60
Discrete Sets 61
Independence 62
Source of Update 62
Conclusion 63
Chapter 5
Assigning Values to Codes 65
Descriptions without Acronyms 66
Descriptions with Acronyms 71
Using Sequence Numbers to Represent Descriptions 74
Information Float 75
Providing Data to External Parties 77
Multilingual Issues 78
Conclusion 78
Chapter 6
Relationships within Reference Data 81
Extending Tables Containing Codes and Descriptions 82
Implications of Relationships between Reference Data Tables 85
Hierarchies of Reference Data 85
Conclusion 91
Chapter 7
Redundancy of Reference Data 93
Redundancy of Codes and Descriptions 94
Contents ix
Redundancy across Databases 96
Synchronization of Data 97
Replication of Maintenance Functionality 98
Different Implementation 101
Global Redundancy 106
Conclusion 107
Chapter 8
The Reference Data Life Cycle 109
Current and Historical Reference Data 109
Changing Codes and Descriptions Ill
Referential Integrity Ill
Succession of Codes and Descriptions 118
Dates, Times, and Time Zones 120
Correlating Transactions to Effective Reference Data 123
Succession 124
Business Issues Related to Succession 129
Succession and Sequence Numbers 130
Conclusion 131
Chapter 9
Monitoring the Usage of Reference Data 133
Which Columns Are Codes Used In? 134
Which Codes Are Being Used? 136
Usage of Constant Values 140
Conclusion 143
Chapter 10
Mapping Reference Data 145
The Need for Mapping 146
Semantic Analysis 150
Different Coding Schemes 154
Format Differences 155
Value Differences 156
Undertaking a Mapping Exercise 157
Conclusion 157
Chapter 11
Understanding the Content of Reference Data 159
Entity and Attribute Definitions 160
Definitions of Values 161
Contents
Distributing Reference Data Metadata 164
Conclusion 165
Chapter 12
Programming and Reference Data 167
Hard-Coded Reference Data 167
Efficient Use of Reference Data 171
Using Reference Data as Inputs 173
Other Issues with the Sequence of Reference Data 177
Using Reference Data as Outputs 178
Updating Reference Data from Transactions 179
Conclusion 180
Chapter 13
Implementing Reference Data in a Database 183
Fully Normalized Design 183
Benefit 1: Effects of Change Minimized 187
Benefit 2: Database Navigation Made Easier 189
Benefit 3: Dimensions of Data Made Explicit 190
Controlled Redundancy of Descriptions 198
Fusing Codes and Descriptions 201
Reference Data in Data Warehouses and Data Marts 205
Physical Implementation of Reference Data Tables 207
Conclusion 209
Chapter 14
Populating Reference Data Tables 211
Production versus Test Reference Data 211
Avoidance of Null Values 216
Specifying a Value for Unknown Data 218
Specifying a Value for None 220
Specifying a Value for Other 221
Specifying a Value for Not Applicable 221
Specifying a Value for All 223
Conclusion 223
Chapter 15
External Sources of Reference Data 225
ISO: The International Organization for Standardization 226
ISO 4217: Currency Codes 228
ISO 3166: Country Codes 232
Contents xi
An Example of a Related Standard:
Road Vehicle Distinguishing Signs 234
Standard and Poor s Ratings 236
Conclusion 239
Chapter 16
Multilingual Issues 241
Adding Columns for Translated Text 244
Making Language Part of the Key 246
Sizes of Descriptions 248
Missing Translations 249
Translating Acronyms 251
Tables of Texts and Messages 253
Getting Text Translated 254
Conclusion 255
Chapter 17
How Is Reference Data Different from Other Data? 257
Why Treat Reference Data Differently? 262
Conclusion 263
Chapter 18
Using Reference Data for Queries 265
Traditional Database Queries 266
Queries Using Reference Data 267
Level 1: Identify Reference Tables 268
Level 2: Identify Related Transaction Structure Tables 268
Level 3: Identify Where the Value Is Used 269
How Can It Be Done? 269
Conclusion 270
Chapter 19
Implementing the Management of Reference Data 271
Data Ownership and Data Stewardship 272
Reference Data and Data Stewardship 274
The Role of the Data Steward for Reference Data 274
Who Wants To Be a Reference Data Steward? 278
A Reference Data Repository 279
Distributing Reference Data 280
Legacy Systems 281
Understanding the Target Systems 284
Contents
Manual Distribution of Reference Data 287
Electronic Distribution of Reference Data 288
Managing an Electronic Reference Data Distribution Project 293
The Goals for Reference Data Administration 294
Senior Management Commitment 296
Common Data 300
External Data 301
Conclusion 303
Appendix 1
ISO 4217 Currency Codes 305
Appendix 2
ISO 3166 Country Codes 317
Appendix 3
Distinguishing Signs of Vehicles in International Traffic 327
Appendix 4
Crosswalk Table for ISO 3166 Country Codes and
Distinguishing Signs of Vehicles in International Traffic 333
Appendix 5
Standard and Poor s Long-Term Issue Credit Ratings 345
Appendix 6
Standard and Poor s Long-Term Issuer Credit Ratings 349
Appendix 7
Matrices for Evaluating Reference Data Management
within an Enterprise 353
Glossary 365
Bibliography 375
Index 379
|
| any_adam_object | 1 |
| author | Chisholm, Malcolm |
| author_facet | Chisholm, Malcolm |
| author_role | aut |
| author_sort | Chisholm, Malcolm |
| author_variant | m c mc |
| building | Verbundindex |
| bvnumber | BV025195414 |
| classification_rvk | QP 345 |
| ctrlnum | (OCoLC)247725756 (DE-599)BVBBV025195414 |
| dewey-full | 005.758 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.758 |
| dewey-search | 005.758 |
| dewey-sort | 15.758 |
| 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>01076nam a2200289 c 4500</leader><controlfield tag="001">BV025195414</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">100417s2001 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1558606971</subfield><subfield code="9">1-55860-697-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)247725756</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV025195414</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-11</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.758</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">Chisholm, Malcolm</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Managing reference data in enterprise databases</subfield><subfield code="b">binding corporate data to the wider world</subfield><subfield code="c">Malcolm Chisholm</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">San Francisco [u.a.]</subfield><subfield code="b">Kaufmann</subfield><subfield code="c">2001</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIX, 387 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="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=019836077&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-019836077</subfield></datafield></record></collection> |
| id | DE-604.BV025195414 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T22:28:41Z |
| institution | BVB |
| isbn | 1558606971 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-019836077 |
| oclc_num | 247725756 |
| open_access_boolean | |
| owner | DE-11 |
| owner_facet | DE-11 |
| physical | XIX, 387 S. Ill. |
| publishDate | 2001 |
| publishDateSearch | 2001 |
| publishDateSort | 2001 |
| publisher | Kaufmann |
| record_format | marc |
| spelling | Chisholm, Malcolm Verfasser aut Managing reference data in enterprise databases binding corporate data to the wider world Malcolm Chisholm San Francisco [u.a.] Kaufmann 2001 XIX, 387 S. Ill. txt rdacontent n rdamedia nc rdacarrier HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=019836077&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Chisholm, Malcolm Managing reference data in enterprise databases binding corporate data to the wider world |
| title | Managing reference data in enterprise databases binding corporate data to the wider world |
| title_auth | Managing reference data in enterprise databases binding corporate data to the wider world |
| title_exact_search | Managing reference data in enterprise databases binding corporate data to the wider world |
| title_full | Managing reference data in enterprise databases binding corporate data to the wider world Malcolm Chisholm |
| title_fullStr | Managing reference data in enterprise databases binding corporate data to the wider world Malcolm Chisholm |
| title_full_unstemmed | Managing reference data in enterprise databases binding corporate data to the wider world Malcolm Chisholm |
| title_short | Managing reference data in enterprise databases |
| title_sort | managing reference data in enterprise databases binding corporate data to the wider world |
| title_sub | binding corporate data to the wider world |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=019836077&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT chisholmmalcolm managingreferencedatainenterprisedatabasesbindingcorporatedatatothewiderworld |