Database Design for Smarties: Using UML for Data Modeling

Craft the Right Design Using UML

Whether building a relational, object-relational, or object-oriented database, database developers are increasingly relying on an object-oriented design approach as the best way to meet user needs and performance criteria. This book teaches you how to use the Unified Modeling Language-the official standard of the Object Management Group-to develop and implement the best possible design for your database.

Inside, the author leads you step by step through the design process, from requirements analysis to schema generation. You'll learn to express stakeholder needs in UML use cases and actor diagrams, to translate UML entities into database components, and to transform the resulting design into relational, object-relational, and object-oriented schemas for all major DBMS products.

Features

• Teaches you everything you need to know to design, build, and test databases using an OO model.
• Shows you how to use UML, the accepted standard for database design according to OO principles.
• Explains how to transform your design into a conceptual schema for relational, object-relational, and object-oriented DBMSs.
• Offers practical examples of design for Oracle, SQL Server, Sybase, Informix, Object Design, POET, and other database management systems.
• Focuses heavily on re-using design patterns for maximum productivity and teaches you how to certify completed designs for re-use.

Authors:

Robert J. Muller, Ph.D., has been designing databases since 1980, in the process gaining extensive experience in relational, object-relational, and object-oriented systems. He is the author of books on object-oriented software testing, project management, and the Oracle DBMS, including The Oracle Developer/2000 Handbook and Oracle 7: The Complete Reference.

Table of Contents:
Contents
Preface
Chapter 1: The Database Life Cycle
Chapter 2: System Architecture and Design
Chapter 3: Gathering Requirements
Chapter 4: Modeling Requirements with Use Cases
Chapter 5: Testing the System
Chapter 6: Building Entity-Relationship Models
Chapter 7: Building Class Models in UML
Chapter 8: Patterns of Data Modeling
Chapter 9: Measures for Success
Chapter 10: Choosing Your Parents
Chapter 11: Designing a Relational Database Schema
Chapter 12: Designing an Object-Relational Database Schema
Chapter 13: Designing an Object-Oriented Database Schema
Sherlock Holmes Story References
Bibliography
Index

Related Titles:

Database
Database