Data modeling essentials / Graeme C. Simsion and Graham C. Witt.

Format:

Book

Author/Creator:

Simsion, Graeme C.

Contributor:

Witt, Graham C.

Series:

The Morgan Kaufmann Series in Data Management Systems

Language:

English

Subjects (All):

Database design.

Data structures (Computer science).

Physical Description:

1 online resource (561 p.)

Edition:

3rd ed.

Place of Publication:

Amsterdam ; Boston : Morgan Kaufmann Publishers, c2005.

Language Note:

English

Summary:

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 ex

Contents:

Front Cover; Data Modeling Essentials; Copyright Page; Contents; Preface; Part I: The Basics; Chapter 1. What Is Data Modeling?; 1.1 Introduction; 1.2 A Data-Centered Perspective; 1.3 A Simple Example; 1.4 Design, Choice, and Creativity; 1.5 Why Is the Data Model Important?; 1.6 What Makes a Good Data Model?; 1.7 Performance; 1.8 Database Design Stages and Deliverables; 1.9 Where Do Data Models Fit In? 20; 1.10 Who Should Be Involved in Data Modeling?; 1.11 Is Data Modeling Still Relevant?; 1.12 Alternative Approaches to Data Modeling; 1.13 Terminology

1.14 Where to from Here?-An Overview of Part I1.15 Summary; Chapter 2. Basics of Sound Structure; 2.1 Introduction; 2.2 An Informal Example of Normalization; 2.3 Relational Notation; 2.4 A More Complex Example; 2.5 Determining Columns; 2.6 Repeating Groups and First Normal Form; 2.7 Second and Third Normal Forms; 2.8 Definitions and a Few Refinements; 2.9 Choice, Creativity, and Normalization; 2.10 Terminology; 2.11 Summary; Chapter 3. The Entity-Relationship Approach; 3.1 Introduction; 3.2 A Diagrammatic Representation; 3.3 The Top-Down Approach: Entity-Relationship Modeling

3.4 Entity Classes3.5 Relationships; 3.6 Attributes; 3.7 Myths and Folklore; 3.8 Creativity and E-R Modeling; 3.9 Summary; Chapter 4. Subtypes and Supertypes; 4.1 Introduction; 4.2 Different Levels of Generalization; 4.3 Rules versus Stability; 4.4 Using Subtypes and Supertypes; 4.5 Subtypes and Supertypes as Entity Classes; 4.6 Diagramming Conventions; 4.7 Definitions; 4.8 Attributes of Supertypes and Subtypes; 4.9 Nonoverlapping and Exhaustive; 4.10 Overlapping Subtypes and Roles; 4.11 Hierarchy of Subtypes; 4.12 Benefits of Using Subtypes and Supertypes

4.13 When Do We Stop Supertyping and Subtyping?4.14 Generalization of Relationships; 4.15 Theoretical Background; 4.16 Summary; Chapter 5. Attributes and Columns; 5.1 Introduction; 5.2 Attribute Definition; 5.3 Attribute Disaggregation: One Fact per Attribute; 5.4 Types of Attributes; 5.5 Attribute Names; 5.6 Attribute Generalization; 5.7 Summary; Chapter 6. Primary Keys and Identity; 6.1 Basic Requirements and Trade-Offs; 6.2 Basic Technical Criteria; 6.3 Surrogate Keys; 6.4 Structured Keys; 6.5 Multiple Candidate Keys; 6.6 Guidelines for Choosing Keys; 6.7 Partially-Null Keys; 6.8 Summary

Chapter 7. Extensions and Alternatives7.1 Introduction; 7.2 Extensions to the Basic E-R Approach; 7.3 The Chen E-R Approach; 7.4 Using UML Object Class Diagrams; 7.5 Object Role Modeling; 7.6 Summary; Part II: Putting It Together; Chapter 8. Organizing the Data Modeling Task; 8.1 Data Modeling in the Real World; 8.2 Key Issues in Project Organization; 8.3 Roles and Responsibilities; 8.4 Partitioning Large Projects; 8.5 Maintaining the Model; 8.6 Packaging It Up; 8.7 Summary; Chapter 9. The Business Requirements; 9.1 Purpose of the Requirements Phase; 9.2 The Business Case

9.3 Interviews and Workshops

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

1-281-02005-2

9786611020057

0-08-048867-6

OCLC:

437144752