Database Design for Smarties - 1st Edition - ISBN: 9781558605152, 9780080503738

Database Design for Smarties

1st Edition

Using UML for Data Modeling

Authors: Robert Muller
Paperback ISBN: 9781558605152
eBook ISBN: 9780080503738
Imprint: Morgan Kaufmann
Published Date: 22nd February 1999
Page Count: 464

Institutional Access

Table of Contents

Contents Preface Chapter 1: The Database Life Cycle Information Requirements Analysis Data Modeling Database Design and Optimization Database Quality, Reviews, and Testing Database Certification Database Maintenance and Enhancement Chapter 2: System Architecture and Design System Architectures The Three-Schema Architecture The Multitier Architectures System Architecture Summary Data Architectures Relational Databases Object-Oriented Databases Object-Relational Databases Summary Chapter 3: Gathering Requirements Ambiguity and Persistence Ambiguity Observing and Asking the Right Questions Persisting Getting Your Priorities Straight Understanding Requirements Categorizing Requirements Relating Requirements Prioritizing Requirements Deciding the Style of Database Summary Chapter 4: Modeling Requirements with Use Cases All the World's


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.

Key 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.


No. of pages:
© Morgan Kaufmann 1999
Morgan Kaufmann
eBook ISBN:
Paperback ISBN:

About the Authors

Robert Muller Author

Robert Muller is a Partner and Founder of Poesys Associates, and a project management consultant specializing in object-oriented, rapid application development, and client/server technology. Previously, he was Product Development Manager and Technical Documentation Manager for Blyth Software, Inc. and Manager of Client/Server Technology at Symantec’s TimeLine division. He is the author of The Oracle Developer/2000 Handbook, has taught a Developer/2000 course and C++ courses for UC Extension, and is co-author of Object-Oriented Software Testing: A Hierarchical Approach.