Data Model Patterns: A Metadata Map

The Morgan Kaufmann Series in Data Management Systems: Series Editor: Jim Gray, Microsoft Research

Dedication

Dedication

PREFACE

FOREWORD

Chapter 1: ABOUT METADATA MODELS

WHAT ARE METADATA?*

IN SEARCH OF METADATA

THE ARCHITECTURE FRAMEWORK*

METAMODELS AND THE FRAMEWORK

THE NOTATION: OBJECT AND ENTITY CLASSES

LEVEL OF ABSTRACTION

Chapter 2: DATA

DATA AND THE ARCHITECTURE FRAMEWORK

THE BUSINESS OWNER AND BUSINESS RULES

ROW TWO: BUSINESS TERMS, CONCEPTS, AND FACT TYPES

ROW THREE: THE ENTITY-RELATIONSHIP DIAGRAM

ROW FOUR: DATA DESIGN

ROW SIX: THE PRODUCTION SYSTEM

Chapter 3: ACTIVITIES, FUNCTIONS, AND PROCESSES

ACTIVITIES AND THE ARCHITECTURE FRAMEWORK

DEFINITIONS

TYPES OF PROCESS MODELS

ROW TWO: FUNCTIONS AND BUSINESS PROCESSES

ROW THREE: PROCESSING DATA

ROW FOUR: PROGRAM MODULES

ROW SIX: PROGRAM INVENTORY*

Chapter 4: LOCATIONS

ABOUT LOCATIONS

ROW TWO: PLACING PARTIES, BUSINESS PROCESSES, AND MOTIVATION

ROW THREE: DATA FLOW DIAGRAMS

ROW FOUR: PLACING DATA AND PROGRAMS

ROW SIX: SYSTEM INVENTORY

Chapter 5: PEOPLE AND ORGANIZATIONS

THE PEOPLE AND ORGANIZATIONS COLUMN

ABOUT PEOPLE AND ORGANIZATIONS

ROW TWO: THE BUSINESS OWNER’S VIEW

ROW THREE: THE ARCHITECT’S VIEW

ROW FOUR: THE DESIGNER’S VIEW

ROW SIX: SECURITY AND GOVERNANCE

Chapter 6: EVENTS AND TIMING

THE EVENTS AND TIMING COLUMN

ROW TWO: BUSINESS EVENT TYPES

ROW THREE: SYSTEM EVENTS

ROW FOUR: PROGRAM EVENTS

Chapter 7: MOTIVATION

THE MOTIVATION COLUMN

ROW THREE: THE ARCHITECT’S VIEW

ROW FOUR: THE DESIGNER’S VIEW

ROW SIX: MEASURING DATA QUALITY

GLOSSARY

REFERENCES AND FURTHER READING

ABOUT THE AUTHOR

INDEX

Data Model Patterns: A Metadata Map not only presents a conceptual model of a metadata repository but also demonstrates a true enterprise data model of the information technology industry itself. It provides a step-by-step description of the model and is organized so that different readers can benefit from different parts.

It offers a view of the world being addressed by all the techniques, methods, and tools of the information processing industry (for example, object-oriented design, CASE, business process re-engineering, etc.) and presents several concepts that need to be addressed by such tools.

This book is pertinent, with companies and government agencies realizing that the data they use represent a significant corporate resource recognize the need to integrate data that has traditionally only been available from disparate sources. An important component of this integration is management of the "metadata" that describe, catalogue, and provide access to the various forms of underlying business data. The "metadata repository" is essential to keep track of the various physical components of these systems and their semantics.

The book is ideal for data management professionals, data modeling and design professionals, and data warehouse and database repository designers.

• A comprehensive work based on the Zachman Framework for information architecture—encompassing the Business Owner's, Architect's, and Designer's views, for all columns (data, activities, locations, people, timing, and motivation)
• Provides a step-by-step description of model and is organized so that different readers can benefit from different parts
• Provides a view of the world being addressed by all the techniques, methods and tools of the information processing industry (for example, object-oriented design, CASE, business process re-engineering, etc.)
• Presents many concepts that are not currently being addressed by such tools — and should be

Data management professionals, including data analysts; data modeling and design professionals; data warehouse and database repository designers.