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.
Contents
- Foreword
- Preface
- 1: Introduction
- Why Read This Book?
- Who Should Read This Book?
- How To Read This Book?
- 2: Database Design From Requirements to
Implementation
- Database Modeling vs
- Database Design
- Data Modeling Today
- UML Diagrams for Database Design
- UML Differs From Traditional Database Modeling
- The Case Study
- 3: Business Modeling for Database Design
- The Workflow
- The Case Study Status
- The Concepts
- The Approach
- The Design
- 4: Requirements Definition
- The Workflow
- The Case Study Status
- The Concepts
- The Approach
- The Design
- 5: Analysis and Preliminary Design
- The Workflow
- The Case Study Status
- The Concepts
- The Approach
- The Design
- 6: Preparing For Transformation to the Database
Design Model
- The Workflow
- The Case Study Status
- The Concepts
- The Approach
- The Design
- 7: Database Design Models-UML Profile for Database
Design
- The Workflow
- The Case Study Status
- The Concepts
- The Approach
- The Design
- 8: Implementing the Physical Aspects of the
Database
- The Workflow
- The Case Study Status
- The Concepts
- The Approach
- The Design
- 9: Summary of Using the UML for Database
Design
- The Workflow
- The Case Study Status
- The Approach
- The Design
- Glossary
- Appendix A: The Models
- Organization
- The Business Use Case Models
- The Business Object Models
- The Traditional Conceptual Data Models
- The System Use Case Models
- The Design Models
- The Database Design Models
- Appendix B: The Use Case Descriptions
- Index