The UML started out as a business process modelling language before migrating to software design. In UML For Database Design
the authors show how it can be used to bring all interested parties into the design process, with emphasis on integrating database design into the overall system design process.
The book is built around a fictitious case study of the development of EAB Health Care's new automated on-line medical record system. This enables the authors to work through various design scenarios as the teams involved gain more understanding of their customer's requirements and the various ways in which these can be implemented between the software and database designs.
The first half of the book is the actual analysis, design and implementation of the featured system. It's pitched at high-level technical managers. The latter half contains two appendices: the UML diagrams from the Business Use Case Models and the User Case Descriptions.
Despite emphasising that systems are about practical ways to improve some aspect of a business UML For Database Design points towards increased efficiency using UML as the common language to integrate system analysis, design and implementation. The use of real world problems and examples in the fictitious system development is a little disingenuous, and while the authors make their case for using UML to model all facets of complex systems--especially those with a regulatory requirement--it may not be enough to win over database managers defending their turf. --Steve Patient
From the Back Cover
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.