Developing High Quality Data Models

Matthew West

• Publisher: Morgan Kaufmann
• Year: 2011
• Print ISBN:
  9780123751065
• eBook ISBN:
  9780123751072
• Topic: Informatique
• Subtopic: Bases de données

Developing High Quality Data Models provides an introduction to the key principles of data modeling. It explains the purpose of data models in both developing an Enterprise Architecture and in supporting Information Quality; common problems in data model development; and how to develop high quality data models, in particular conceptual, integration, and enterprise data models. The book is organized into four parts. Part 1 provides an overview of data models and data modeling including the basics of data model notation; types and uses of data models; and the place of data models in enterprise architecture. Part 2 introduces some general principles for data models, including principles for developing ontologically based data models; and applications of the principles for attributes, relationship types, and entity types. Part 3 presents an ontological framework for developing consistent data models. Part 4 provides the full data model that has been in development throughout the book. The model was created using Jotne EPM Technologys EDMVisualExpress data modeling tool. This book was designed for all types of modelers: from those who understand data modeling basics but are just starting to learn about data modeling in practice, through to experienced data modelers seeking to expand their knowledge and skills and solve some of the more challenging problems of data modeling. - Uses a number of common data model patterns to explain how to develop data models over a wide scope in a way that is consistent and of high quality - Offers generic data model templates that are reusable in many applications and are fundamental for developing more specific templates - Develops ideas for creating consistent approaches to high quality data models

Table of contents

• Cover Image
• Table of Contents
• Front-matter
• Copyright
• Preface
• Part 1 Motivations and Notations
• 1. Introduction
• 2. Entity Relationship Model Basics
• 3. Some Types and Uses of Data Models
• 4. Data Models and Enterprise Architecture
• 5. Some Observations on Data Models and Data Modeling
• Part 2 General Principles for Data Models
• 6. Some General Principles for Conceptual, Integration, and Enterprise Data Models
• 7. Applying the Principles for Attributes
• 8. General Principles for Relationships
• 9. General Principles for Entity Types
• Part 3 An Ontological Framework for Consistent Data Models
• 10. Motivation and Overview for an Ontological Framework
• 11. Spatio-Temporal Extents
• 12. Classes
• 13. Intentionally Constructed Objects
• 14. Systems and System Components
• Chapter 15. Requirements Specification
• Chapter 16. Concluding Remarks
• Part 4 The HQDM Framework Schema
• 17. HQDM_Framework
• 17.1. Thing and Abstract Object
• 17.2. Class and Class of Class
• 17.3. Relationship and Class of Relationship
• 17.4. Spatio-Temporal Extent and Class of Spatio-Temporal Extent
• 17.5. Event, Class of Event, and Point in Time
• 17.6. State and Individual
• 17.7. Physical Object
• 17.8. Ordinary Physical Object
• 17.9. Kind of Individual and Subtypes
• 17.10. Kind of System and System Component
• 17.11. Period of Time and Possible Worlds
• 17.12. Physical Properties and Physical Quantities
• 17.13. Association
• 17.14. Activity
• 17.15. Participant
• 17.16. Role, Class of Activity, and Class of Association
• 17.17. System
• 17.18. System Component
• 17.19. Installed Object
• 17.20. Biological Object
• 17.21. Ordinary Biological Object
• 17.22. Biological System
• 17.23. Person
• 17.24. Biological System Component
• 17.25. Intentionally Constructed Object
• 17.26. Functional Object
• 17.27. Ordinary Functional Object
• 17.28. Functional System
• 17.29. Socially Constructed Object
• 17.30. Party
• 17.31. Organization and Language Community
• 17.32. Employment
• 17.33. Organization Component and Position
• 17.34. Money
• 17.35. Ownership
• 17.36. Transfer of Ownership
• 17.37. Socially Constructed Activity
• 17.38. Class of Socially Constructed Activity
• 17.39. Agreement
• 17.40. Contract
• 17.41. Offer and Acceptance of Offer
• 17.42. Sale of Goods
• 17.43. Sales Product, Product Brand, and Sales Product Version
• 17.44. Offering
• 17.45. Sign and Pattern
• 17.46. Requirement and Requirement Specification
• Appendix. A Mapping Between the HQDM Schema and ISO 15926-2
• Index