Managing Reference Data in Enterprise Databases: Binding Corporate Data to the W

Reference data plays a key role in your business databases and must be free from defects of any kind. So why is it so hard to find information on this critical topic? Recognizing the dangers of taking reference data for granted, Managing Reference Data in Enterprise Databases gives you precisely what you've been seeking: A complete guide to the implementation and management of reference data of all kinds.
This book begins with a thorough definition of reference data, then proceeds with a detailed examination of all reference data issues, fully describing uses, common difficulties, and practical solutions. Whether you're a database manager, architect, administrator, programmer, or analyst, be sure to keep this easy-to-use reference close at hand.

Contents

Introduction

Chapter 1 - What is Reference Data

Chapter 2 - A Few Database Design Concepts

Chapter 3 - The Diversity of Reference Data

Chapter 4 - Characteristics of Reference Data

Chapter 5 - Assigning Values to Codes

Chapter 6 - Relationships within Reference Data

Chapter 7 - Redundancy of Reference Data

Chapter 8 - The Reference Data Life Cycle

Chapter 9 - Monitoring the Usage of Reference Data

Chapter 10 - Mapping Reference Data

Chapter 11 - Understanding the Content of Reference Data

Chapter 12 - Programming and Reference Data

Chapter 13 - Implementing Reference Data in a Database

Chapter 14 - Populating Reference Data Tables

Chapter 15 - External Sources of Reference Data

Chapter 16 - Multilingual Issues

Chapter 17 - How Is Reference Data Different to Other Data?

Chapter 18 - Using Reference Data for Queries

Chapter 19 - Implementing the Management of Reference Data

Annex 1: ISO 4217 Currency Codes

Annex 2: ISO 3166 Country Codes

Annex 3: Distinguishing Signs of vehicles in International Traffic

Annex 4: Crosswalk Table for ISO 3166 Country Codes and Distinguishing Signs of Vehicles in International Traffic

Annex 5: Standard and Poor's Long-Term Issue Credit Ratings

Annex 6: Standard and Poor's Long Term Issuer Credit Ratings

Annex 7: Matrices for Evaluating Reference Data Management Within an Enterprise

Table 1: Criteria for Assessing An Enterprise's Reference Data Strategy

Table 2: How to decide if a Database Table is a Reference Data Table

Table 3: Criteria for Assessing Life Cycle Management in a Reference Data Table

Table 4: Criteria For Examining Columns in a Non-Reference Data Database Table

Table 5: Criteria for Assessing Metadata for a Reference Data Table

Table 6: Criteria for Assessing Classification Schemes

Table 7: Criteria for Assessing Management of Reference Data during A Systems Development Project

Glossary

Bibliography