Object-oriented Oracle

Front Cover
Idea Group Inc (IGI), Jan 1, 2006 - Technology & Engineering - 328 pages
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.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Selected pages

Contents

ObjectRelational Approaches
1
Static Aspects of OOCM
2
Objects and Classes
3
Inheritance Relationships
4
Association Relationships
6
Aggregation Hierarchies
7
Dynamic Aspects of OOCM
12
Generic Methods
13
Implementation of Methods in MutualExclusion Inheritance
126
Implementation of Methods in Partition Inheritance
133
Implementation of Methods in Multiple Inheritance
135
Implementation of Methods in Association Relationships
138
Implementation of Methods in Aggregation Relationships
142
Implementation of Methods in Aggregation Relationships Using the Clustering Technique
145
Implementation of Methods in Aggregation Relationships Using the Nesting Technique
146
Case Study
151

UserDefined Methods
14
New Era of ObjectRelational Approaches
15
OOCM Implemented on Relational Databases
16
Extended Relational Systems
17
ObjectOriented System and RDBMS Coexistence
18
OODBMS and RDBMS Interoperation
19
ObjectRelational Database System
20
Case Study
21
Summary
23
References
24
Chapter Problems
25
Chapter Solutions
27
ObjectOriented Features in Oracle
31
ObjectOriented Features
34
Collection Types
35
Object Identifiers
36
Relationships using Ref
38
Cluster
39
Inheritance Relationships using Under
40
Encapsulation
41
Summary
47
Chapter Problems
48
Chapter Solutions
49
Using ObjectOriented Features
51
Union Inheritance Implementation
52
MutualExclusion Inheritance Implementation
54
Partition Inheritance Implementation
56
Multiple Inheritance Implementation
57
Using Association Relationships
59
Creating an Association Relationship by a PrimaryKey and ForeignKey Relationship
60
Creating an Association Relationship by Object References
62
Foreign Keys vs Object References in an Association Relationship
65
Using Aggregation Relationships
67
Implementing ExistenceDependent Aggregation using the Nesting Technique
70
Implementing ExistenceIndependent Aggregation
73
Case Study
76
Summary
81
Chapter Solutions
83
ObjectOriented Methods
89
Implementation of Encapsulation Using Stored Procedures or Functions and Grant Mechanisms
90
Grant
97
Implementation of Encapsulation using Member Procedures or Functions
98
Case Study
102
Summary
107
References
108
Chapter Solutions
111
Generic Methods
114
Implementation of Methods in Inheritance Hierarchies
115
Implementation of Methods in Union Inheritance
116
Summary
159
Chapter Solutions
163
UserDefined Queries
170
Subclass Query
171
Superclass Query
172
UserDefined Queries in Association Relationships
175
Dereferencing Query
177
UserDefined Queries in Aggregation Hierarchies
178
Part Query
179
Whole Query
181
UserDefined Queries Using Multiple Collection Types
184
NestedTable Collection Type
186
UserDefined Queries with Object References
187
VALUE
188
DEREF
190
Object Table vs Object Attribute
191
Clustering Technique vs IndexOrganization Table
193
Case Study
194
Summary
202
Chapter Solutions
206
University Case Study
210
Problem Solution
217
Faculty_T Class and Part Classes
218
Building_T Class and Part Classes
221
Degree_T Class
224
Person_T Class the Subclasses and the Enrolls_In Table
227
Subject_T Class and Takes Table
240
Sample Database Execution
243
UserDefined Methods Sample
247
Building Case Application
249
Summary
275
Retailer Case Study
276
Problem Solution
282
Company_T Class and the Subclasses
284
Shareholders_T Class and Own_Shares Table
285
Management_T Class and the Subclasses
288
Store_T Class and the Department_T Part Class
290
Employee_T Class and the Subclasses
294
Maker_T Class
300
Item_T Class and Available_In Table
301
Customer_T Class
303
Transaction_T Class
306
Building Tools Using Oracle Developer
307
Creating a Form Using the DataBlock Form
308
Creating a Form Using a Custom Form
315
Summary
323
About the Authors
324
Index
326
Copyright

Other editions - View all

Common terms and phrases

About the author (2006)

Johanna Wenny Rahayu received a Ph.D. in Computer Science from La Trobe University, Australia, in 2000. Her thesis was in the area of object-relational database design and transformation technology. This thesis has been awarded as the 2001 Computer Science Association Australia Best Ph.D. Thesis Award. Dr. Rahayu is currently a Senior Lecturer at La Trobe University. She has published a book and numerous research articles. David Taniar holds Bachelor (Honours), Master, and Ph.D. degrees - all in Computer Science and Information Technology, with a particular speciality in Databases. His research areas now expand to Data Mining and Warehousing. He has published more than 100 research articles appeared in international journals and conference proceedings. Eric Pardede is presently a Ph.D. candidate at La Trobe University, Australia. He received a Master degree in information Technology and Quality Management from La Trobe University, Australia and University of Wollongong, Australia, respectively.

Bibliographic information