Managing Reference Data in Enterprise Databases

Features

• Solves special challenges associated with maintaining reference data.
  
• Addresses a wide range of reference data issues, including acronyms, redundancy, mapping, life cycles, multiple languages, and querying.
  
• Describes how reference data interacts with other system components, what problems can arise, and how to mitigate these problems.
  
• Offers examples of standard reference data types and matrices for evaluating management methods.
  
• Provides a number of standard reference data tables and more specialized material to help you deal with reference data, via a companion Web site

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
  
• 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
  
• Glossary
  
• Bibliography