You are previewing Data Resource Guide: Managing the Data Resource Data.
O'Reilly logo
Data Resource Guide: Managing the Data Resource Data

Book Description

Are you struggling to find the data that you need to support your business activities? Are you concerned that people may be using the wrong data for their business activities? Are you having difficulty understanding the data that you do find in your data resource? Are you frustrated over documenting that understanding in a manner that is readily accessible to anyone in the organization? If the answer to any of these questions is Yes, then you need to read Data Resource Guide to help identify, understand, access, and use the appropriate data.

Most public and private sector organizations today have no formal, single location for the complete documentation of their data resource that is readily available to everyone in the organization. Many organizations don't even have a concept of how to design, develop, or manage a single repository containing an understanding all the data available to the organization. Yet they are staking their business on those data.

Data Resource Data provided the complete data resource model for an organization's Data Resource Data. Data Resource Understanding provided a detailed description of how to thoroughly understand an organization's data resource through those Data Resource Data. Now, Data Resource Guide provides the detailed specifications for developing a simple, inexpensive, and effective way to document the data resource understanding and make that understanding readily available to anyone in the organization.

Michael Brackett draws on over half a century of data management experience to complete two trilogies for formally managing an organization's as a critical resource. The Data Architecture Trilogy describes the development of a single organization wide data architecture for an organization. The Data Understanding Trilogy describes the acquisition and documentation of understanding about all the data at an organization's disposal.

Table of Contents

  1. FIGURES
  2. PREFACE
  3. ACKNOWLEDGEMENTS
  4. ABOUT THE AUTHOR
  5. Chapter 1 MANAGING THE DATA RESOURCE
    1. THE BOOK
    2. DATA RESOURCE GUIDE FEATURES
      1. Data Deletion
      2. Organization Specific
      3. Business Data
      4. Reports
      5. Calculations
      6. Formal Data Names
      7. Self-Documentation
      8. Access Outside the Data Resource Guide
    3. PRESENTATION RULES
      1. General Design Hierarchy
      2. General Design Navigation
      3. General Design Logic
      4. Data Hierarchy
      5. Multiple Appearances of a Routine
      6. Command Buttons
      7. Data Names
      8. Terminology
      9. Conditional Logic
      10. Editing and Viewing Data
      11. System Identifiers
  6. Chapter 2 DATA RESOURCE GUIDE
    1. DATA RESOURCE GUIDE OVERVIEW
    2. DATA RESOURCE GUIDE EDIT / VIEW TASK
    3. HELP MESSAGE TASK
      1. Help Message View
      2. Help Message Edit
      3. Help Message Reports
    4. HELP MESSAGE DATA ARCHITECTURE
      1. Help Message Data Structure
      2. Help Message Data Definitions
      3. Help Message Data Integrity Rules
    5. ERROR MESSAGE TASK
      1. Error Message View
      2. Error Message Edit
      3. Error Message Reports
    6. ERROR MESSAGE DATA ARCHITECTURE
      1. Error Message Data Structure
      2. Error Message Data Definitions
      3. Error Message Data Integrity Rules
  7. Chapter 3 DATA RESPONSIBILITY
    1. DATA STEWARD TASK
      1. Data Steward
      2. Data Steward Function
      3. Data Steward Level
    2. ORGANIZATION UNIT TASK
      1. Organization Unit
      2. Organization Unit Type
    3. DATA RESPONSIBILITY REPORTS
  8. Chapter 4 DATA INVENTORY
    1. DATA PRODUCT DATA TASK
      1. Data Product
      2. Data Product Set
      3. Data Product Unit
      4. Data Product Code
      5. Data Site
      6. Organization Unit
      7. Data Name Abbreviation Scheme
    2. DATA PRODUCT KEY TASK
      1. Data Product Primary Key
      2. Data Product Foreign Key
      3. Data Relation Cardinality
    3. DATA PRODUCT REFERENCE SET TASK
      1. Data Product Type
      2. Data Product Set Medium
      3. Data Product Set Type
      4. Data Format
    4. DATA PRODUCT MODEL TASK
      1. Data Product Model
      2. Data Product Set Model
      3. Data Model Diagram
      4. Data Model Diagram Type
    5. DATA PRODUCT STEWARD TASK
      1. Data Product Steward
      2. Data Steward
      3. Data Steward Function
      4. Data Steward Level
    6. DATA INVENTORY REPORTS
  9. Chapter 5 COMMON DATA
    1. COMMON DATA TASK
      1. Data Subject
      2. Data Characteristic
      3. Data Characteristic Variation
      4. Data Reference Set Variation
      5. Data Reference Item
    2. COMMON DATA KEY TASK
      1. Primary Key
      2. Foreign Key
      3. Data Relation Cardinality
    3. COMMON DATA REFERENCE SET TASK
      1. Common Data Status
      2. Primary Key Composition
      3. Primary Key Meaning
      4. Primary Key Origin
      5. Primary Key Purpose
      6. Primary Key Scope
    4. COMMON DATA STEWARD TASK
      1. Data Subject Steward
      2. Data Steward
      3. Data Steward Function
      4. Data Steward Level
    5. COMMON DATA MODEL TASK
      1. Data Subject Model
      2. Data Subject Area Model
      3. Data Model Diagram
      4. Data Model Diagram Type
    6. DATA SUBJECT AREA TASK
      1. Data Subject Area
      2. Data Subject Area Assignment
      3. Data Subject Area Purpose
    7. COMMON DATA REPORTS
  10. Chapter 6 DATA LEXICON
    1. COMMON WORD TASK
      1. Data Resource Component Type
      2. Data Name Common Word
      3. Data Name Common Word Thesaurus
    2. DATA NAME ABBREVIATION TASK
      1. Data Name Word Set
      2. Data Name Word
      3. Data Name Abbreviation Algorithm
      4. Data Name Abbreviation Scheme
    3. DATA SUBJECT THESAURUS TASK
      1. Data Subject Thesaurus
    4. BUSINESS TERM TASK
      1. Business Glossary
      2. Business Glossary Item
    5. DATA LEXICON REPORTS
  11. Chapter 7 DATA CROSS-REFERENCE
    1. DATA CROSS-REFERENCE TASK
      1. Data Product Set Cross-Reference
      2. Data Product Unit Cross-Reference
      3. Data Product Code Cross-Reference
    2. DATA CROSS-REFERENCE REPORTS
  12. Chapter 8 DATA PROTECTION
    1. DATA PROTECTION REGULATION TASK
      1. Jurisdiction
      2. Legal Regulation
      3. Data Privacy Regulation
    2. DATA PROTECTION REFERENCE SET TASK
      1. Jurisdiction Type
      2. Legal Regulation Type
    3. DATA PROTECTION REPORTS
  13. Chapter 9 DATA ACCESS
    1. BUSINESS PROCESS TASK
      1. Business Process
      2. Business Process Type
    2. BUSINESS PROCESS STEWARD TASK
      1. Business Process Steward
      2. Organization Unit
    3. DATA PRODUCT PROCESS TASK
      1. Data Product Set Process
      2. Data Product Unit Process
    4. DATA ACCESS REPORTS
  14. Chapter 10 DATA PROVENANCE
    1. DATA TRACK TASK
      1. Data Track
    2. DATA STEP TASK
      1. Data Step
    3. DATA PROVENANCE REPORTS
  15. Chapter 11 DATA SHARING
    1. DATA CLEARINGHOUSE TOPIC TASK
      1. Data Clearinghouse Topic
      2. Data Clearinghouse Keyword
      3. Data Clearinghouse Topic Keyword
    2. DATA CLEARINGHOUSE AUTHOR TASK
      1. Data Clearinghouse Author
    3. SPATIAL AREA TASK
    4. Spatial Area
      1. Spatial Area Type
    5. DATA CLEARINGHOUSE ITEM TASK
      1. Data Clearinghouse Item
      2. Data Clearinghouse Item Topic
      3. Data Clearinghouse Item Author
      4. Data Clearinghouse Item Area
      5. Data Clearinghouse Item Type
      6. Data Steward
      7. Organization Unit
    6. DATA PROJECT TASK
      1. Data Project
      2. Data Project Status
      3. Data Project Topic
      4. Data Project Type
      5. Data Steward
      6. Organization Unit
    7. DATA SHARING REPORTS
  16. Chapter 12 DERIVED DATA
    1. DATA SUBJECT CONTRIBUTOR TASK
    2. Data Subject Contributor
    3. FOREIGN DATA CHARACTERISTIC TASK
      1. Foreign Data Characteristic Assignment
    4. DATA SET HIERARCHY TASK
      1. Data Set Hierarchy
      2. Data Subject Set
      3. Data Subject Set Characteristic
    5. DERIVED DATA REPORTS
  17. Chapter 13 PREFERRED DATA
    1. PREFERRED COMMON DATA TASK
      1. Preferred Data Subject
      2. Preferred Data Characteristic
      3. Preferred Data Characteristic Variation
      4. Preferred Data Reference Set Variation
      5. Preferred Data Reference Item
      6. Preferred Primary Key
      7. Preferred Foreign Key
    2. PREFERRED DATA LEXICON TASK
      1. Preferred Data Name Abbreviation
      2. Preferred Business Glossary Item
    3. PREFERRED DATA PRODUCT DATA TASK
      1. Preferred Data Product
      2. Preferred Data Product Set
      3. Preferred Data Product Unit
      4. Preferred Data Product Code
    4. PREFERRED DATA REPORTS
  18. Chapter 14 DATA TRANSFORMATION
    1. DATA TRANSLATION TASK
      1. Data Characteristic Translation
      2. Data Reference Item Translation
    2. DATA TRANSFORMATION TASK
      1. Data Transform Process
      2. Data Transform Step
      3. Data Transform Unit
      4. Organization Unit
      5. Data Steward
    3. DATA TRANSFORMATION REPORTS
  19. Chapter 15 FUTURE ENHANCEMENTS
    1. PREFERRED DATA PRODUCT DATA
      1. Manual Denormalization
      2. Automated Denormalization
    2. VERY LARGE ORGANIZATIONS
    3. Interim Common Data Sets
    4. Recursive Common Data Set
      1. Data Stewards Coordination
      2. Data Subject Thesaurus
    5. DATA MODELING SOFTWARE INTERFACES
      1. Data Resource Guide Feeds Data Modeling Software
      2. Data Modeling Software Feeds Data Resource Guide
    6. DATA PRODUCT DATA INVENTORY
      1. Database Management Systems
      2. Data Modeling Software
    7. DATA NAME ABBREVIATION
  20. Chapter 16 MANAGING FOR QUALITY
    1. COMMON DATA ARCHITECTURE
      1. Basic Definitions
      2. The Vision
      3. The Hurdles
      4. The Challenge
    2. BUSINESS MANAGEMENT
      1. The Business Architecture Infrastructure
      2. Business Architecture Management
      3. Data Resource Quality
  21. BIBLIOGRAPHY