N. America: (800)876-3101 | World: +44 (0) 1-344-386-367

USE CASE: ACCESS DATA STORED IN AN OBJECT-ORIENTED DATABASE FROM ODBC, OLE DB, OR JDBC

Goal

Access data stored in an object-oriented database using ODBC, OLE DB, or 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.
Email Print Share

Download OpenAccess SDK

Related Links

OpenAccess Use Cases