Covers all the new object extensions in Oracle8, including user-defined data types, Object IDs, REFs (pointers to rows), object tables and views, and methods to fuse data and behaviors. Includes a detailed explanation of the system development life cycle and the impact that Oracle8's new object extensions bring to bear on system design. Explains how to use leading-edge object-oriented concepts and techniques with Oracle8's new features. Demonstrates how to design Oracle8 database systems that slash maintenance costs and are far easier to modify.
| ||||||||||||
Book Description
Editorial Reviews
Review
High Performance Oracle8 Object-Oriented Design... introduces the many new object-oriented (OO) features in the latest version of the popular commercial database product, Oracle8. The book aggressively addresses the real-world problems of data modeling, and, in particular, how a traditional relational database programmer would decide when and how to actually use the new "object relational database" tools. Written by an experienced database consultant, the book will appeal to persons who have actually experienced the data modeling problems that relational databases cannot easily handle.
In High Performance Oracle8 Object-Oriented Design, Anstey explains that while relational databases work extremely well in many business applications they also suffer from several drawbacks. These shortcomings include the ability to describe the semantics of a customer's business using the set-oriented rules defined by relational systems. For example, relational systems cannot adequately combine the behavior of an entity with data about the entity, nor can they model the recursive nature of complex objects, such as engineering parts lists where "parts" may contain more "parts." Anstey presents the solutions to these problems using a flowing and informal style mixed with many "lessons learned" from his extensive experience working with databases.
High Performance Oracle8 Object-Oriented Design contains numerous diagrams, illustrations, and example snippets of code to illustrate the points in the book. I found this particularly refreshing given the dearth of concrete code in other database books. Anstey very nicely explains each subject, provides a diagram, if appropriate, to illustrate the subject, and then supplies the actual SQL statements that enact the subject. This makes each topic very easy to follow and will appeal to readers who, like me, want to see how something really works.
Chapter 5, "Oracle Reference Pointers and Database Design," provides one of the highlights of the book. In it Anstey describes the use of reference pointers to implement some of the most difficult real-world data modeling scenarios. Anstey again uses extensive examples and code segments to illustrate the possible solutions. Through them, the reader can easily see how to use the new object extensions to a traditional relational database to implement complex objects, recursion, and sequencing.
Despite the clear explanation of each topic, Anstey does not write for a novice database developer. High Performance Oracle8 Object-Oriented Design assumes a working knowledge of databases and especially current commercial relational database technology. The reader does not have to have an extensive knowledge of any particular product (e.g., Oracle7), although it would help. Anstey both explains the new features in Oracle8 as well as emphasizing the important new design issues that come with mixing relational and object paradigms to solve realistic, practical problems.
Anstey covers a wide range of topics, from object extensions to SQL and the emerging SQL3 Standard to planning for the support of class hierarchies and inheritance due in a future incremental release of Oracle8. The book has detailed explanations and examples of how to model relational object systems, to include an entire chapter devoted to the Unified Modeling Language (UML). Anstey also explains how two popular new toolsets, Oracle's Object Database Designer and Logic Works' OR-Compass, support the new object-relational environment. Specifics include:
object tables, object views, and other OO features of Oracle8, variable arrays (VARRAY) and nested tables, nls_date_format settings to address the Year 2000 data conversion problems, conversion of existing LONG data to make use of the new, more efficient Large Object (LOB) data types, and, user-defined Data Types (ADTs) provided with the Objects Option for Oracle8.
I found Oracle8: Object-Oriented Design easy to read and to follow. Anstey colors his book with many anecdotes and real-life experiences. I found these sections particularly enlightening as they add considerable credibility to the advice and guidelines put forward in the book. High Performance Oracle8 Object-Oriented Design will make a useful addition to the library of any current data modeler, database programmer, database administrator, or consultant. -- Jeffrey S. Poulin, Lockheed Martin Federal Systems.
From the Publisher
Oracle is already the world's most popular high-end database management system, selling four times as many units as its nearest competitor. Now, with its new object oriented features, Oracle8 is poised to roll over the database world like a tidal wave. Countless Oracle database designers and analysts will need the clear, complete guidance they'll find in High-Performance Oracle8 Object-Oriented Design.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
5 of 6 people found the following review helpful:
5.0 out of 5 stars
A GOLDMINE FOR EVERYONE INVOLVED IN THE OBJECT TECHNOLOGY,
By pete.cassidy@aris.com (CARROLLTON, TEXAS) - See all my reviews
This review is from: High Performance Oracle8 Object-Oriented Design: Your Complete Guide to Creating Fast, Efficient Database Systems (Paperback)
Mr. Anstey has written a fantastic book. He compares and contrasts traditional RDBMS modeling to OBJECT modeling. This book should be in your library if you can even spell "ORACLE"!He also teaches the reader how to implement Objects using Oracle8 and all of its new features. I particularly enjoyed Chapter 4 that discussed modeling for Oracle's data types. The book is loaded with information tying the two methods together. I am a visual learner, and Mr. Anstey has at least 5 or 6 very detailed drawings to help the user "SEE" and understand what he is discussing. He even has one chapter devoted to tools used to design an Object database. Another powerful chapter is on Data Warehouses. He discusses bitmapped indexes, index-organized tables,the Partition Option, and Star Queries. Mr. Anstey covers all bases, even distributed systems using REPLICATION,the SQL3 Standard, planning your Oracle8 databases to take advantage of the Object features, and the future trends of the Object technology. All in all, a WONDERFUL book written by an author with a great technical sense of both technologies. Both thumbs up Mr. Anstey!
4 of 5 people found the following review helpful:
2.0 out of 5 stars
Unfortunately, I can not recommend this book...,
By A Customer
This review is from: High Performance Oracle8 Object-Oriented Design: Your Complete Guide to Creating Fast, Efficient Database Systems (Paperback)
Although I appreciate the amount of effort required to write a book, I simply can not recommend this one. The book describes unimportant or familiar concepts (like the traditional relational model) in too much detail and new or important concepts (like the Oracle8 object extension syntax) in not enough detail. Many of the diagrams do not appear to relate to the topics being discussed and the examples are too few and far between. I felt that the author used terminology inconsistently or at the very least did not define terms adequately. One might argue that the book is about object-oriented design and not about Oracle `syntax' but if you want to learn about OO check-out books by Booch, Jacobson, Fowler, Rumbaugh, Wirfs-Brock, etc. If you want to learn about Oracle objects try "Oracle8 Design Using UML Object Modeling" by Dorsey et. al.
1 of 1 people found the following review helpful:
5.0 out of 5 stars
Great for the designer who wants to advance to Oracle 8,
By ettlinger.b@nypa.gov (White Plains, New York) - See all my reviews
This review is from: High Performance Oracle8 Object-Oriented Design: Your Complete Guide to Creating Fast, Efficient Database Systems (Paperback)
This was just the book I was looking for! A well written, easy to read, technical book written for Oracle relational technicians and designers who want to advance into the object-relational and object oriented paradigm. Interspersed with elucidating diagrams and SQL syntax, the book gives the reader a high comfort level with the new Oracle 8 constructs such as Varrays, nested tables and methods. The author introduces each contstruct, clearly explains them, and then presents ideas as to how to apply them in business applications. In later chapters, after overall data base design is discussed, chapters are dedicated to method design, a discussion on available design tools, UML, Oracle 8 and data warehousing, SQL3. Once finished, the book leaves the reader with an excellent handle on Oracle 8 and how to design data bases in that environment.
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
