ODBC Access to an Object Wrapper – Requirements for Accessing Data Stored in an Object-Oriented Database

View PDF

Immediate requirements are to access data stored in an object-oriented database using ODBC, OLE DB, and/or JDBC from a PC or a UNIX client. The database is a persistent object-oriented system that has classes and instances.

Following are some of the requirements:

• Access objects of any class as a table - The table view will show the attributes of the specified class and all its parents.
• Support dynamic schema - The classes in the database change from one installation to another and maybe over time (similar to how Oracle database can support different schema for different applications).
• Support one or more of the following standards:
• ODBC compliant access from Windows or UNIX - Allows standard ODBC compliant applications to access the data.
• OLE DB compliant access from Windows – Allows standard OLE DB compliant applications to access the data.
• JDBC compliant access from Windows or UNIX - Allows standard ODBC compliant applications to access the data.
• Client/server - Process database access on the database server platform.
• Use object-oriented database system access mechanisms - Support optimized execution of joins by using the pointer references inherent in OODBMS.