Data model patterns : a metadata map / David C. Hay.

ISBN:

9780120887989

9780080477039

Title:

Data model patterns : a metadata map / David C. Hay.

Author:

Hay, David C., 1947-

Personal Author:

Hay, David C., 1947-

Publication Information:

Physical Description:

1 online resource (xx, 406 pages) : illustrations.

Series:

The Morgan Kaufmann series in data management systems

Contents:

About metadata models -- Data -- Activities, functions, and processes -- Locations -- People and organizations -- Events and timing -- Motivation.

Local Note:

eBooks on EBSCOhost

Subject Term:

Data warehousing.

Metadata.

Format:

Electronic Resources

Electronic Access:

Click here to view

Publication Date:

2006

Publication Information:

Available:*

Shelf Number	Material Type	Copy	Shelf Location	Status
005.74 22	1:E-BOOK	1	1:ONLINE	Searching... Unknown

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.

Author Notes

David C. Hay is the founder of Essential Strategies, Inc.

Preface	p. xiii
Foreword	p. xix
Chapter 1 About Metadata Models	p. 1
What Are Metadata?	p. 1
In Search of Metadata	p. 5
The Architecture Framework	p. 7
The Rows	p. 8
The Columns	p. 11
Metamodels and the Framework	p. 13
Data	p. 15
Activities	p. 15
Locations	p. 16
People and Organizations	p. 16
Timing	p. 16
Motivation	p. 17
The Notation: Object and Entity Classes	p. 17
Class Model (UML)	p. 18
Entity-Relationship Model	p. 24
Level of Abstraction	p. 29
Chapter 2 Data	p. 33
Data and the Architecture Framework	p. 33
The Business Owner and Business Rules	p. 34
Row Two: Business Terms, Concepts, and Fact Types	p. 37
Terms and Concepts	p. 38
Ontologies	p. 45
Propositions	p. 48
Fact Types	p. 49
Characteristics	p. 52
Resources	p. 54
Authorship	p. 57
Document Distribution	p. 60
Coverage	p. 60
The Dublin Core	p. 63
Data Stewardship	p. 65
Row Three: The Entity-Relationship Diagram	p. 65
Sample Entity-Relationship Model	p. 66
Entity Classes and Attributes	p. 67
Relationships and Relationship Roles	p. 70
Entity Class Views	p. 82
About Reference Data	p. 86
Row Four: Data Design	p. 87
Relational Database Design	p. 88
Object-Oriented Data Design	p. 97
Row Six: The Production System	p. 115
Chapter 3 Activities, Functions, and Processes	p. 123
Activities and the Architecture Framework	p. 123
Definitions	p. 125
Types of Process Models	p. 127
Row Two: Functions and Business Processes	p. 129
Functions	p. 130
Business Processes	p. 133
Sample Process Model	p. 138
Motivating Business Processes	p. 140
Access Roles	p. 140
Row Three: Processing Data	p. 142
A Data Flow Diagram	p. 144
System Processes and Data Flows	p. 146
Access Roles and System Events	p. 150
Essential System Processes	p. 152
Row Four: Program Modules	p. 157
Basic Module Structure	p. 157
Program Roles	p. 164
Object Modules	p. 171
Row Six: Program Inventory	p. 178
Chapter 4 Locations	p. 183
About Locations	p. 183
Site	p. 185
Geographic Location	p. 189
Row Two: Placing Parties, Business Processes, and Motivation	p. 192
Business Locations	p. 192
Means, End, and Effort	p. 192
Row Three: Data Flow Diagrams	p. 195
Row Four: Placing Data and Programs	p. 199
Row Six: System Inventory	p. 203
Database Instances	p. 203
Servers	p. 205
Chapter 5 People and Organizations	p. 209
The People and Organizations Column	p. 209
About People and Organizations	p. 210
Row Two: The Business Owner's View	p. 218
Access Roles	p. 218
Concepts, Symbols, and Signifiers	p. 221
Activities, Decisions, and Events	p. 224
Means and Ends	p. 225
Row Three: The Architect's View	p. 230
Row Four: The Designer's View	p. 234
Interactive Modules	p. 236
Row Six: Security and Governance	p. 243
Chapter 6 Events and Timing	p. 245
The Events and Timing Column	p. 245
Row Two: Business Event Types	p. 247
External Business Event Types	p. 247
Internal Business Event Types	p. 249
Motivation	p. 252
Row Three: System Events	p. 252
State-Transition Diagram	p. 254
Entity Life History	p. 257
Essential System Processes	p. 263
The Feedback Loop	p. 266
Row Four: Program Events	p. 267
Object Orientation	p. 270
Chapter 7 Motivation	p. 273
The Motivation Column	p. 273
About Motivation	p. 274
Mission and Vision	p. 274
Ends	p. 277
Means	p. 278
Directives	p. 280
Influencers and Assessments	p. 284
Directive Motivation	p. 287
Activities	p. 289
Row Three: The Architect's View	p. 292
About Business Rules	p. 292
Sample Model	p. 294
Domains	p. 307
System Constraints	p. 312
Business Rule Mapping	p. 318
Parties	p. 318
Data Quality	p. 321
Row Four: The Designer's View	p. 322
Sample Database Design	p. 324
Database Constraints	p. 333
Object-Oriented Constraints	p. 333
Links	p. 336
Data Quality	p. 338
Row Six: Measuring Data Quality	p. 338
Glossary	p. 343
References and Further Reading	p. 391
About the Author	p. 395
Index	p. 397

Available:*

Bound With These Titles

On Order

Summary

Summary

Author Notes

Table of Contents