You are previewing Database Modeling and Design, 5th Edition.
O'Reilly logo
Database Modeling and Design, 5th Edition

Book Description

Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?

In the extensively revised fifth edition, you’ll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you’ll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems. 

  • 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