You are previewing UML for Database Design.
O'Reilly logo
UML for Database Design

Book Description

The Unified Modeling Language (UML), the standard graphical notation for modeling business and software application needs, has emerged as an effective modeling tool for database design. When used as a common modeling language for the many facets of system development, the UML can serve as a unifying framework that facilitates the integration of database models with the rest of a system design.

This pragmatic guide introduces you to the UML and leads you through the process of UML-based database modeling and design. The book presents the different types of UML diagrams, explaining how they apply to the database world, and shows how data modeling with the UML can be tied into the Rational Unified Process.

UML for Database Design is structured around the database design process: business use case modeling, business object modeling, database requirements definition, analysis and preliminary design, and, finally, detailed design and deployment. For each phase of development the book describes the overall objectives and workflow of that phase, the status of the case study, the relevant UML constructs, and the nuts and bolts of database modeling and design with the UML. Drawing on their extensive industry experience, the authors reveal the trials and tribulations of database development teams, lessons learned, and pointers for success.

Topics covered include:

  • The business use case model

  • Activity and sequence diagrams for modeling database functions and tasks

  • Moving from the business to system model

  • Class diagrams and statecharts

  • Mapping classes to tables

  • Transformation of attributes

  • Rational's UML Profile for Database Design

  • Creating tables from classes

  • DDL scripts, component diagrams, and deployment diagrams

  • Jump starting the database design process

A case study runs throughout the book to illustrate key concepts and techniques, and appendixes containing the actual UML models from this case study are used to catalog the type and extent of models that would be developed for such a system.

Practical, concrete, and based on real-life experience, UML for Database Design brings you exactly the information you need to begin working with the UML and take full advantage of the technology for high-quality database modeling and design.



0201721635B06292001

Table of Contents

  1. Copyright
  2. Foreword
  3. Preface
  4. Introduction
    1. Why Read This Book?
    2. Who Should Read This Book?
    3. How to Read This Book
  5. Database Design from Requirements to Implementation
    1. Database Modeling versus Database Design
    2. Data Modeling Today
    3. UML Diagrams for Database Design
    4. The UML Differs from Traditional Database Modeling
    5. The Case Study
  6. Business Modeling for Database Design
    1. The Workflow
    2. The Case Study Status
    3. The Concepts
    4. The Approach
    5. The Design
    6. Summary
  7. Requirements Definition
    1. The Workflow
    2. The Case Study Status
    3. The Concepts
    4. The Approach
    5. The Design
    6. Summary
  8. Analysis and Preliminary Design
    1. The Workflow
    2. The Case Study Status
    3. The Concepts
    4. The Approach
    5. The Design
    6. Summary
  9. Preparing for Transformation to the Database Design Model
    1. The Workflow
    2. The Case Study Status
    3. The Concepts
    4. The Approach
    5. The Design
    6. Summary
  10. Database Design Models— the UML Profile for Database Design
    1. The Workflow
    2. The Case Study Status
    3. The Concepts
    4. The Approach
    5. The Design
    6. Summary
  11. Implementing the Physical Aspects of the Database
    1. The Workflow
    2. The Case Study Status
    3. The Concepts
    4. The Approach
    5. The Design
    6. Summary
  12. Summary of Using the UML for Database Design
    1. The Workflow
    2. The Case Study Status
    3. The Approach
    4. The Design
    5. Summary
  13. UML Models for EAB Healthcare, Inc.
    1. Organization of This Appendix
    2. The Models and Diagrams
  14. Use Case Descriptions
    1. Use Case Description—OMaR Project
    2. Use Case Description—OMaR Project
    3. Use Case Description—OMaR Project
    4. Use Case Description—OMaR Project
    5. Use Case Description—OMaR Project
    6. Use Case Description—OMaR Project
    7. Use Case Description—OMaR Project
    8. Use Case Description—OMaR Project
    9. Use Case Description—OMaR Project
    10. Use Case Description—OMaR Project
    11. Use Case Description—OMaR Project
    12. Use Case Description—OMaR Project
    13. Use Case Description—OMaR Project
    14. Use Case Description—OMaR Project
    15. Use Case Description—OMaR Project
  15. Glossary
  16. Bibliography