SYSTEM AND METHOD FOR RELATIONAL TO OBJECT MAPPING

A relational to object mapping system and method permit the transfer and translation of data between a database server having a relational database and an object-oriented apparatus. The object code, such as C++, is translated by a generator object into suitable relational database statements, such as structured query language (SQL). The SQL statement is passed to a query object which executes the statement. In executing the SQL statement, the query object accesses an environment object which supplies the query object with appropriate connection objects for establishing a link between the query object and the database server. The database server supplies the requested data from the relational database to the query object which then stores the data in a storage buffer. The object-oriented apparatus can then access the data from the storage buffer. The query object may activate a transaction object for processing the data before the data is accessed by the object-oriented apparatus.