Oracle8 Design Using UML Object Modeling
brings traditional relational database design into the new world of objects and UML notation. With numerous real-world examples that use ERD and UML diagrams, the authors show you how to "think in objects" to create simpler and more maintainable Oracle databases.
After an introduction to database history, the authors dig right in with support for objects in Oracle 8i. They look at database basics, including normalization. (This section is thick with theory, though the rest of the book is very accessible.) Then traditional ERD notation is examined, along with the advantages of using UML for designing with objects.
Next the book looks at modeling classes, including primary and foreign keys, naming conventions, domains for data validation, and value list classes (for lookup values). Subsequent sections introduce object-oriented design concepts such as cardinality, composition, and inheritance, all illustrated with both ERD and UML notation. (Sample PL/SQL code for both Oracle 7 and the new version 8i is also provided.) More advanced sections show you how to model recursive structures, trees, and lists. The book closes with some excellent ideas on how to track historical information and database denormalization, as well as a short section on using Oracle's Object Database Designer tool.
With its mix of practical advice and object design expertise, Oracle8 Design Using UML Object Modeling lets relational database developers add objects to any programming project. --Richard Dragan
From the Back Cover
A complete conceptual and practical guide to building Oracle8 databases.
Think about database development in a new way and build powerful relational and object-relational databases with Oracle8! With this unique guide you'll learn to use Oracle8's technology to create flexible databases that will meet the demands of today's business environment-and tomorrow's.
Inside Oracle8 Design Using UML Object Modeling, you'll find coverage of both concepts and practical techniques. The authors demonstrate the benefits of using the Unified Modeling Language's (UML) richer and more precise way of creating sound data models. Rather than the traditional break between logical and physical models-which can lead to numerous implementation problems-the authors propose the creation of a unified model that evolves as the software-development life cycle progresses. With this book, you will:
Design flexible databases that support a broad range of requirements Build a database step-by-step with efficiently running structures Learn advanced modeling structures, such as entity/object subsets; dependent, recursive, and cyclical structures; denormalization; and generic modeling Create standards for database design, from naming conventions and UID specifications to domains of datatypes Design databases that easily respond to changes in system requirements, often with no developer intervention Construct databases that combine the best aspects of traditional relational design with the cutting-edge capabilities of objects using this guide from two well-respected Oracle experts