Oracle8 Design Using Uml Object Modeling (Oracle Press Series)

Kurzbeschreibung An authorised guide to fully exploiting the object oriented capabilities of Oracle8 as well as covering the areas of database design system requirements such as changes to records, data entry errors and basic transaction history. Amazon.de 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 Autorenkommentar Unique blend of logical + physical database design concepts In writing this book, we had two goals. First, we tried to cover a broad range of data modeling topics from the basics to advanced modeling techniques including recursion and generic modeling. But, this is not just a theoretical book. Equal attention is given to database design issues. We have included the topics of table design, naming conventions, and datatype domains. In addition, the book discusses Oracle8 relational and object-relational design in detail, including sample relational as well as object-relational SQL code for every concept presented. This combination of logical and physical database design topics is what makes the book unique. In our company, Dulcian, Inc., we have designed and implemented many database systems. In Oracle8 Design Using UML Object Modeling, we have distilled our theoretical philosophy of database design as well as including practical information about how we implement these designs in real world systems. Over the last few years, there has been a steady movement towards generic, object-oriented techniques in database design. Simultaneously, the Unified Modeling Language (UML) has emerged as the standard for object-oriented analysis and design. Therefore all modeling examples are shown using both traditional Entity Relationship Diagrams (ERDs) and UML.