Database Modeling and Design, 5th Edition

Database Modeling and Design, 5th Edition

by Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish
Released February 2011
Publisher(s): Morgan Kaufmann
ISBN: 9780123820211

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Database Modeling and Design, Fifth Edition, focuses on techniques for database design in relational database systems.

This extensively revised fifth edition features clear explanations, lots of terrific examples and an illustrative case, and practical advice, with design rules that are applicable to any SQL-based system. The common examples are based on real-life experiences and have been thoroughly class-tested.

This book is immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data. It is ideal for a stand-alone data management course focused on logical database design, or a supplement to an introductory text for introductory database management.

  • In-depth detail and plenty of real-world, practical examples throughout
  • Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system
  • Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data

Table of contents

  1. Cover Image
  2. Contents
  3. Title
  4. Series
  5. Copyright
  6. Dedication
  7. Preface
  8. About the Authors
  9. 1. Introduction
    1. Data and Database Management
    2. Database Life Cycle
    3. Conceptual Data Modeling
    4. Summary
    5. Tips and Insights for Database Professionals
    6. Literature Summary
  10. 2. The Entity–Relationship Model
    1. Fundamental ER Constructs
    2. Advanced ER Constructs
    3. Summary
    4. Tips and Insights for Database Professionals
    5. Literature Summary
  11. 3. The Unified Modeling Language
    1. Class Diagrams
    2. Activity Diagrams
    3. Summary
    4. Tips and Insights for Database Professionals
    5. Literature Summary
  12. 4. Requirements Analysis and Conceptual Data Modeling
    1. Introduction
    2. Requirements Analysis
    3. Conceptual Data Modeling
    4. View Integration
    5. Entity Clustering for ER Models
    6. Summary
    7. Tips and Insights for Database Professionals
    8. Literature Summary
  13. 5. Transforming the Conceptual Data Model to SQL
    1. Transformation Rules and SQL Constructs
    2. Transformation Steps
    3. Summary
    4. Tips and Insights for Database Professionals
    5. Literature Summary
  14. 6. Normalization
    1. Fundamentals of Normalization
    2. The Design of Normalized Tables: A Simple Example
    3. Normalization of Candidate Tables Derived from ER Diagrams
    4. Determining the Minimum Set of 3NF Tables
    5. Summary
    6. Tips and Insights for Database Professionals
    7. Literature Summary
  15. 7. An Example of Logical Database Design
    1. Requirements Specification
    2. Logical Design
    3. Summary
    4. Tips and Insights for Database Professionals
  16. 8. Object-Relational Design
    1. Object Orientation
    2. Object-Oriented Databases
    3. Object-Relational Databases
    4. Summary
    5. Tips and Insights for Database Professionals
    6. Literature Summary
  17. 9. XML and Web Databases
    1. XML
    2. XML Design
    3. Web-Based Applications
    4. Summary
    5. Tips and Insights for Database Professionals
    6. Literature Summary
  18. 10. Business Intelligence
    1. Data Warehousing
    2. Online Analytical Processing
    3. Data Mining
    4. Summary
    5. Tips and Insights for Database Professionals
    6. Literature Summary
  19. 11. CASE Tools for Logical Database Design
    1. Introduction to the CASE Tools
    2. Key Capabilities to Watch for
    3. The Basics
    4. Generating a Database from a Design
    5. Database Support
    6. Collaborative Support
    7. Distributed Development
    8. Application Life Cycle Tooling Integration
    9. Design Compliance Checking
    10. Reporting
    11. Modeling a Data Warehouse
    12. Semistructured Data—XML
    13. Summary
    14. Tips and Insights for Database Professionals
    15. Literature Summary
  20. APPENDIX. The Basics of SQL
    1. SQL Names and Operators
    2. Data Definition Language
    3. Data Manipulation Language
  21. References
  22. Exercises
    1. ER and UML Conceptual Data Modeling
    2. Conceptual Data Modeling and Integration
    3. Transformation of the Conceptual Model to SQL
    4. Normalization and Minimum Set of Tables
    5. Logical Database Design (Generic Problem)
    6. Olap
  23. Solutions to Selected Exercises
  24. Glossary
  25. Index
  26. Bonus Chapter Opener
  27. 3. Query Optimization and Plan Selection
    1. 3.1 Query Processing and Optimization
    2. 3.2 Useful Optimization Features in Database Systems
    3. 3.3 Query Cost Evaluation—An Example
    4. 3.4 Query Execution Plan Development
    5. 3.5 Selectivity Factors, Table Size, and Query Cost Estimation
    6. 3.6 Summary
    7. Tips and Insights for Database Professionals
  28. A. A Simple Performance Model for Databases
    1. A.1 I/O Time Cost—Individual Block Access
    2. A.2 I/O Time Cost—Table Scans and Sorts
    3. A.3 Network Time Delays
    4. A.4 CPU Time Delays

Product information

  • Title: Database Modeling and Design, 5th Edition
  • Author(s): Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish
  • Release date: February 2011
  • Publisher(s): Morgan Kaufmann
  • ISBN: 9780123820211