Chapter 6. Oracle Object-Relational Features

Oracle introduced most of its object-relational features in Oracle 8i. Of these features, object types are the most fundamental. Object types are user-defined types that correspond to classes in Java. They allow us to model data in the database the same way we do in our programs, using a set of attributes and methods for each object.

Designing a database to use object techniques is dramatically different from taking a relational approach. The most common technique in object-oriented design is composition, including classes within other classes, like Russian dolls, which is exactly the opposite approach for relational databases. The first step toward normalization is to “un-nest” the data and put aggregate ...

Get Java™ Oracle® Database Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.