Oracle8 Design Using UML Object Modeling Book

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 DraganRead More