Object-Oriented Oracle [Hardcover]

Wenny Rahayu (Author)

Book Description

Publication Date: August 16, 2005

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.

Editorial Reviews

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 (August 16, 2005)
• Language: English
• ISBN-10: 1591408105
• ISBN-13: 978-1591408109
• Product Dimensions: 10.4 x 7.3 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 Best Sellers Rank: #2,972,866 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

2 of 2 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

This review is from: Object-Oriented Oracle (Hardcover)

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 (Miami, FL) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

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.