Data Model Patterns: A Metadata Map


  • David Hay, Founder and President of Essential Strategies, Inc., Houston, Texas.

In recent years, companies and government agencies have come to realize that the data they use represent a significant corporate resource, whose cost calls for management every bit as rigorous as the management of human resources, money, and capital equipment. With this realization has come recognition of the importance to integrate the data that has traditionally only been available from disparate sources. An important component of this integration is the management of the “metadata” that describe, catalogue, and provide access to the various forms of underlying business data. The “metadata repository” is essential keeping track both of the various physical components of these systems, but also their semantics. What do we mean by “customer?” Where can we find information about our customers? After years of building enterprise models for the oil, pharmaceutical, banking, and other industries, Dave Hay has here not only developed a conceptual model of such a metadata repository, he has in fact created a true enterprise data model of the information technology industry itself.
View full description


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


Book information

  • Published: June 2006
  • ISBN: 978-0-12-088798-9


“A very ambitious undertaking, masterfully described. To the best of my knowledge, this is the first published version of the detailed models implied by the Zachman Framework. David Hay builds the models one step at a time, describing in each increment why the new entities were added, and how they related to the rest of the model. At least as important he sprinkles in lessons learned from his vast experience modeling in various other industries.” — Dave McComb, President, Semantic Arts, and author of Semantics in Business Systems “Dave Hay’s latest book provides detailed metaschemas for the main concepts underlying the Zachman Framework for Enterprise Architecture, incorporating recent proposals from the Business Rules Group. By covering this vast territory in an easy-to-read style, Dave provides a valuable resource that should be of interest to data modeling professionals.” — Terry Halpin, Neumont University

Table of Contents

Chapter 1: About Metadata ModelsChapter 2: DataChapter 3: Activities, Functions, and ProcessesChapter 4: LocationsChapter 5: People and OrganizationsChapter 6: Events and TimingChapter 7: MotivationGlossaryReferences and Further ReadingIndexAbout the Author