Object-Oriented Oracle (Hardcover)

by Wenny Rahayu (Author) "This book focuses on the implementation of an object-oriented model into object-relational DBMS using OracleTM..." (more)
Key Phrases: new campus location, new emp name, new person address, Idea Group Inc, Methods Declaration, Delete Commercial (more...)

Editorial Reviews

Product Description
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. Exploring object-oriented features and techniques in Oracle DBMS, this book describes the fundamental aspects of data modeling and implementation in Oracle. The implementation of structural aspects of an object model are covered, including object types, collection types, object referencing, nested tables, and inheritance structures, as well as the behavioral aspects that include encapsulated member procedures and functions. The complete cycle of database design using object-oriented concepts, implementation on object-relational Oracle, and data manipulations using member procedures/functions and object-relational queries is also addressed.

About the Author
Johanna Wenny Rahayu is currently an associate professor at the department of computer science and computer engineering La Trobe University, Australia. Her major research is in the area of object-relational databases, web databases and semantic web. She has published more than 70 papers appeared in international journals and conference proceedings. She has edited three books, which form a series in web applications, covering web databases, web information systems and web semantics. Currently, she is involved in a number of large projects in software development in collaboration with several industry partners in Australia.

David Taniar received a PhD degree in databases from Victoria University, Australia, in 1997. He is now a senior lecturer at Monash University, Australia. He has published more than 100 research articles and edited a number of books in the web technology series. He is in the editorial board of a number of international journals, including Data Warehousing and Mining, Business Intelligence and Data Mining, Mobile Information Systems, Mobile Multimedia, Web Information Systems, and Web and Grid Services. He has been elected as a fellow of the Institute for Management of Information Systems (UK).

Eric Pardede received his Master of Information Technology at La Trobe University, Australia, in 2002. At the same university, he is currently a PhD candidate under the supervision of Dr. Wenny Rahayu and Dr. David Taniar. He has been working as a research and teaching assistant at Monash University and La Trobe University. He has published several research articles appeared in international journals and conference proceedings. His research area is in data modelling and query optimization for object-relational databases and XML databases.

Product Details

• Hardcover: 250 pages
• Publisher: IRM Press; illustrated edition edition (August 16, 2005)
• Language: English
• ISBN-10: 1591408105
• ISBN-13: 978-1591408109
• Product Dimensions: 10.1 x 7.2 x 0.9 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #1,978,373 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

1 of 1 people found the following review helpful:

5.0 out of 5 stars A Comprehensive Book on Object Oriented Oracle , January 2, 2006

By	Ismail Khalil Ibrahim "IKI" (Linz, Austria) - See all my reviews

The book contains comprehensive descriptions and examples on the use of Object-Oriented concepts in Oracle Object-Relational database system.
Unlike many existing books in the area which mainly focus on Object-Relational database features independently from the design concepts, this book covers step-by-step mapping of each Object-Oriented design concept into implementation in Oracle Object-Relational database system. This book also contains a lot of sample codes, exercises, and case studies which demonstrate the practical implementation of the mapping process.
Prominent vendors in Relational database management systems such as Oracle have now introduced various features that are based on the Object-Oriented concepts. Because these features are developed on Relational DB, they are now called the new generation of Object-Relational database systems. However, there have been no real effort in ensuring database developers to understand when and where to use these new features, and so most of these useful features have remained unused in the real world. This book is aimed to provide more insight into Object-Oriented Oracle, and especially demonstrating cases where the new OO features in Oracle can be utilized.
Everyone who has any interest in Oracle or databases in general, needs to keep up with the latest development in the area. The underlying model of database systems has changed overtime, from hierarchical, network, and relational models, and now the latest Object-Oriented model. This book is useful for both database developers as well as database teaching instructors who want to gain more understanding about the design and implementation of the latest Object-Oriented model in Oracle database system.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Good book, poor index and TOC, October 7, 2005

By	Tom Bacon (Ashland, OR) - See all my reviews (REAL NAME)

This review is from: Object-Oriented Oracle (Solutions for It Professionals) (Paperback)

My first looks at this book give me this impression:
1) I like the coding conventions (e.g., use of upper/lower case)
2) I like the Case Studies; they implement the concepts well
3) The 2 page index is more topical than keyword (e.g. "XYZ Case study" rather than BFILE).
4) The TOC is more topical than keyword.

Like I said, my first glance, but the topic I read last night illustrated the material well. It's just tough to find any specific topic.
I normally wouldn't enter a review without a more thorough go-through of the book, but there were 0 reviews, so figured something is better than nothing!

4.0 out of 5 stars Explains how to use Object-Relational features of Oracle if you really want to, September 13, 2008

By	P. Cherryl (California) - See all my reviews (REAL NAME)

This review is from: Object-Oriented Oracle (Solutions for It Professionals) (Paperback)

This is a 300 page advanced student course book on using the SQL:1999 (aka. SQL3) object model as implemented by Oracle (including features added in Oracle9i). It starts with a brief introduction to object modeling using some example UML class diagrams, then comments briefly on some of the different approaches to storing objects in the relational databases that dominate the market today. Chapter 2 outlines the object SQL extensions in Oracle: user defined types (ie. classes) with inheritance and access control, collections, refs and clusters. Chapter 3 discusses implementing subtypes, association and aggregation, first using a traditional relational approach, then using types, refs, clusters and nested tables. Chapter 4 addresses data encapsulation, comparing stored procedures and grants in a relational environment versus member methods supported by user defined types. Chapter 5 describes patterns to use for 'generic' methods that insert and delete objects with subtypes, associations and aggregations, and Chapter 6 describes querying the resulting object hierarchies. Chapters 7 and 8 provide a pair of non-trivial example program applications, each with about 20 classes and a total of more than 50 pages of code listings. The first of these has a simple command line interface and the second uses Oracle Forms - there is no mention anywhere of SQLJ or JDBC.

This book is unique in that it focuses on an area of Oracle functionality that is relatively little understood. Object oriented development is popular amongst enterprise developers using Java or C#, but adoption has been slow amongst database developers and DBAs. It doesn't help that leading PL/SQL author Steve Feuerstein describes object oriented development as greatly over-rated. This book teaches neither object-oriented analysis and design nor PL/SQL, but it does address the specific issue of implementing and using an object design using modern SQL, and the authors deserve credit for seeking to teach the next generation of developers and DBAs. Having said that the presentation could be more polished, the formatting and layout of the listings could be improved, and section numbering would help also.