Access Data Stored in an Object-Oriented Database from ODBC OLE DB OR JDBC
| Goal | Access data stored in an object-oriented database using JDBC from a Windows or UNIX client. The database is a persistent object-oriented system that has classes and instances. |
| Requirements | - Support one or more of the following standards, allowing applications that comply with these standards to access the data:
- ODBC compliant access from Windows or UNIX
- OLE DB compliant access from Windows
- JDBC compliant access from Windows or UNIX
- Access objects of any class as a table.
- Support dynamic schema.
- 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.
|
| Resolution | With DataDirect OpenAccess SDK, you provide an ODBC, OLE DB, or JDBC interface to a proprietary non-SQL database by implementing a small set of functions. |
| Implementation | See ODBC Access to an Object Wrapper (.pdf) for an example and implementation details. |
| Benefits | - Quickly implement ODBC, OLE DB, or JDBC access to data stored in an object-oriented database from Windows or UNIX client applications.
- Expose object databases through a relational model and provide efficient processing of JOINS, which are required to access multiple levels.
|