Synopses & Reviews
Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management.
The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field, Data Modeling Essentials, Third Edition is the ideal reference for professionals and students looking for a real-world perspective.
· Thorough coverage of the fundamentals and relevant theory.
· Recognition and support for the creative side of the process.
· Expanded coverage of applied data modeling includes new chapters on logical and physical database design.
· New material describing a powerful technique for model verification.
· Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
· Extensive online component including course notes and other teaching aids (www.mkp.com).
UML diagrams now available! Visit the companion site for more details.
Click here to view a book review by Steve Hoberman!
Review
"The perfect balance of theory and practice, giving the reader both the foundation and the tools to deliver high-quality data models."
-Karen Lopez, Principal, InfoAdvisors, Inc.
"The complete guide to data modeling for the reflective practitioner. Students like this book and so do I -- it is clear and accessible without sacrificing rigor."
-Professor Graeme Shanks, School of Business Systems, Monash University, Australia
"A unique, practical and comprehensive guide, providing an invaluable resource to anyone involved in data modeling from the novice to the expert data modeler."
-Len Silverston, author of The Data Model Resource Book, Volumes 1 and 2.
"Includes an extraordinary amount of good, useful, and well articulated information about the field."
-David Hay, President, Essential Strategies, Inc. and author of Data Model Patterns
Review
"The perfect balance of theory and practice, giving the reader both the foundation and the tools to deliver high-quality data models."
-Karen Lopez, Principal, InfoAdvisors, Inc.
"The complete guide to data modeling for the reflective practitioner. Students like this book and so do I -- it is clear and accessible without sacrificing rigor."
-Professor Graeme Shanks, School of Business Systems, Monash University, Australia
"A unique, practical and comprehensive guide, providing an invaluable resource to anyone involved in data modeling from the novice to the expert data modeler."
-Len Silverston, author of The Data Model Resource Book, Volumes 1 and 2.
"Includes an extraordinary amount of good, useful, and well articulated information about the field."
-David Hay, President, Essential Strategies, Inc. and author of Data Model Patterns
Review
source to anyone involved in data modeling from the novice to the expert data modeler."
-Len Silverston, author of The Data Model Resource Book, Volumes 1 and 2.
"Includes an extraordinary amount of good, useful, and well articulated information about the field."
-David Hay, President, Essential Strategies, Inc. and author of Data Model Patterns
Synopsis
Data Modeling Essentials, Third Edition, covers the basics of data modeling while focusing on developing a facility in techniques, rather than a simple familiarization with "the rules." In order to enable students to apply the basics of data modeling to real models, the book addresses the realities of developing systems in real-world situations by assessing the merits of a variety of possible solutions as well as using language and diagramming methods that represent industry practice.
This revised edition has been given significantly expanded coverage and reorganized for greater reader comprehension even as it retains its distinctive hallmarks of readability and usefulness. Beginning with the basics, the book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management. It includes an entirely new section discussing the development of logical and physical modeling, along with new material describing a powerful technique for model verification. It also provides an excellent resource for additional lectures and exercises.
This text is the ideal reference for data modelers, data architects, database designers, DBAs, and systems analysts, as well as undergraduate and graduate-level students looking for a real-world perspective.
- Thorough coverage of the fundamentals and relevant theory.
- Recognition and support for the creative side of the process.
- Expanded coverage of applied data modeling includes new chapters on logical and physical database design.
- New material describing a powerful technique for model verification.
- Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
Synopsis
y and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field,
Data Modeling Essentials, Third Edition is the ideal reference for professionals and students looking for a real-world perspective.
Features
· Thorough coverage of the fundamentals and relevant theory.
· Recognition and support for the creative side of the process.
· Expanded coverage of applied data modeling includes new chapters on logical and physical database design.
· New material describing a powerful technique for model verification.
· Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
· Extensive online component including course notes and other teaching aids (www.mkp.com).
Synopsis
ng change, and resolving conflict.
· Extensive online component including course notes and other teaching aids (www.mkp.com).
Synopsis
hnique for model verification.
· Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
· Extensive online component including course notes and other teaching aids (www.mkp.com).
Synopsis
Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management.
The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field, Data Modeling Essentials, Third Edition is the ideal reference for professionals and students looking for a real-world perspective.
Features
Thorough coverage of the fundamentals and relevant theory.
Recognition and support for the creative side of the process.
Expanded coverage of applied data modeling includes new chapters on logical and physical database design.
New material describing a powerful technique for model verification.
Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
Extensive online component including course notes and other teaching aids (www.mkp.com).
About the Author
Graeme C. Simsion has over 25 years experience in information systems as a DBA, data modeling consultant, business systems designer, manager, and researcher. He is a regular presenter at industry and academic forums, and is currently a Senior Fellow with the Department of Information Systems at the University of Melbourne.Graham C. Witt is an independent consultant with over 30 years of experience in assisting enterprises to acquire relevant and effective IT solutions. His clients include major banks and other financial institutions; businesses in the insurance, utilities, transport and telecommunications sectors; and a wide variety of government agencies. A former guest lecturer on Database Systems at University of Melbourne, he is a frequent presenter at international data management conferences.
Independent Consultant, Sydney, Australia
Table of Contents
Part I: BasicsChapter 1: What is Data Modeling?
Chapter 2: Basics of Good Structure
Chapter 3: The Entity-Relationship Approach
Chapter 4: Subtypes & Supertypes
Chapter 5: Attributes and Columns
Chapter 6: Primary Keys and Identity
Chapter 7: Extensions and Alternatives
Part II: Putting it Together
Chapter 8: Organizing the Data Modeling Task
Chapter 9: Understanding the Business Requirements
Chapter 10: Conceptual Modeling
Chapter 11: Logical Database Design
Chapter 12: Physical Database Design
Part III: Advanced Topics
Chapter 13: Advanced Normalization
Chapter 14: Modeling Business Rules
Chapter 15: Time-Dependent Data
Chapter 16: Modeling for Data Warehouses and Data Marts
Chapter 17: Enterprise Data Models and Data Management