Object orientation has now invaded traditional relational database-management systems. OracleTM without exception has included object-oriented features in its system. SQL is now richer due to these additional features. However, the object-oriented elements in OracleTM will not be fully utilized without a proper database design. For example, a database application designed using a traditional database modeling, such as entity-relationship (E/R) modeling, will not be able to make use of most object-oriented features in OracleTM. This is simply due to the absence of object-oriented elements in the design. Even with a proper object-oriented design, without careful transformation from design to implementation, many of the object-oriented features will be lost. Object-Oriented OracleTM addresses this need by not only explaining the new object-oriented features in OracleTM, but most importantly how these features can be fully utilized in database applications. We put a heavy emphasize on how an object-oriented conceptual model is implemented in OracleTM. This includes the static aspect of an object-oriented conceptual model, including the inheritance, association, and aggregation relationships, as well as the dynamic aspect covering generic object-oriented methods and user-defined queries Cover Table of Contents Preface Chapter I. Object-Relational Approaches Object-Oriented Conceptual Model Static Aspects of OOCM Objects and Classes Inheritance Relationships Association Relationsh Aggregation Hierarchies Dynamic Aspects of OOCM Generic Methods User-Defined Methods New Era of Object-Relational Approaches OOCM Implemented on Relational Databases Object Wrappers on Relational Systems Extended Relational Systems Object-Oriented System and RDBMS Coexistence OODBMS and RDBMS Interoperation Object-Relational Database System Case Study Summary References Chapter Problems Chapter Solutions Chapter II. Object-Oriented Features in OracleTM Relational-Model Features Object-Oriented Features Object Types and User-Defined Types Collection Types Object Identifiers Relationships using Ref Cluster Inheritance Relationships using Under Encapsulation Summary References Chapter Problems Chapter Solutions Chapter III. Using Object-Oriented Features Using Inheritance Relationships Union Inheritance Implementation Mutual-Exclusion Inheritance Implementation Partition Inheritance Implementation Multiple Inheritance Implementation Using Association Relationships Creating an Association Relationship by a Primary-Key and Foreign-Key Relationship Creating an Association Relationship by Object References Primary Keys: Foreign Keys vs. Object References in an Association Relationship Using Aggregation Relationships Implementing Existence-Dependent Aggregation using the Clustering Technique Implementing Existence-Dependent Aggregation using the Nesting Technique Implementing Existence-Independent Aggregation Case Study Summary References Chapter Problems Chapter Solutions Chapter IV. Object-Oriented Methods Implementation of Encapsulation Using Stored Procedures or Functions and Grant Mechanisms Stored Procedures or Functions Grant Implementation of Encapsulation Using Member Procedures or Functions Case Study Summary References Chapter Problems Chapter Solutions Chapter V. Generic Methods Implementation of Methods in Inheritance Hierarchies Implementation of Methods in Union Inheritance Implementation of Methods in Mutual-Exclusion Inheritance Implementation of Methods in Partition Inheritance Implementation of Methods in Multiple Inheritance Implementation of Methods in Association Relationships Implementation of Methods in Aggregation Relationships Implementation of Methods in Aggregation Relationships Using the Clustering Technique Implementation of Methods in Aggregation Relationships Using the Nesting Technique Case Study Summary Chapter Problems Chapter Solutions Chapter VI. User-Defined Queries User-Defined Queries in Inheritance Hierarchies Subclass Query Superclass Query User-Defined Queries in Association Relationships Referencing Query Dereferencing Query User-Defined Queries in Aggregation Hierarchies Part Query Whole Query User-Defined Queries Using Multiple Collection Types Varray Collection Type Nested-Table Collection Type User-Defined Queries with Object References VALUE DEREF IS DANGLING Object Table vs. Object Attribute Clustering Technique vs. Index-Organization Table Case Study Summary Chapter Problems Chapter Solutions Chapter VII. University Case Study Problem Description Problem Solution Campus_T Table Faculty_T Class and Part Classes Building_T Class and Part Classes Degree_T Class Person_T Class, the Subclasses, and the Enrolls_In Table Subject_T Class and Takes Table Sample Database Execution Generic Methods Sample User-Defined Methods Sample Building Case Application Summary Chapter VIII. Retailer Case Study Problem Description Problem Solution Company_T Class and the Subclasses Shareholders_T Class and Own_Shares Table Management_T Class and the Subclasses Store_T Class and the Department_T Part Class Employee_T Class and the Subclasses Maker_T Class Item_T Class and Available_In Table Customer_T Class Transaction_T Class Building Tools Using OracleTM Developer Creating a Form Using the Data-Block Form Creating a Form Using a Custom Form Summary About the Authors Index
The popularity of object-oriented concepts, design, and programming has stimulated the need for a database system that enables a straightforward process to store and retrieve object instances. Object-Oriented Oracle explores object-oriented features and techniques in Oracle DBMS. This book describes comprehensive and fundamental aspects of object-oriented data modeling and implementation in Oracle. It covers the implementation of structural aspects of an object model, including object types, collection types, object referencing, nested tables, and inheritance structures, as well as the behavioral aspects including encapsulated member procedures and functions. Object-Oriented Oracle discusses the complete cycle of database design using object-oriented concepts, implementation of object-relational Oracle, and data manipulations using member procedures/functions and object-relational queries. Object-Oriented Oracle contains a wealth of information, such as case studies in every chapter, as well as exercises at the end of each chapter which helps readers to absorb the topics better, all reasons this book is a necessary collection addition for academics, researchers, educators, and IT professionals everywhere.
'The book covers comprehensive and fundamental aspects of the implementation of object-oriented modeling in a DBMS that was originated as a pure Relational Database, Oracle'--Provided by publisher.
