Abstract: A process receives an object-based query and creates a logical tree that contains nodes representing operations that are required for the query to be completed. Operations that can be performed by an RDBMS are transmitted to the RDBMS as an SQL query. The RDBMS executes the SQL query and returns data to the process. The process places the data into appropriate fields of one or more objects, and stores the resulting objects in a memory, such as an object cache. The process executes the remaining node operations (that could not be performed by the RDBMS) in conjunction with the objects stored in the object cache, and forwards the results to a user program.

Abstract: An object-relational mapping tool that can process views is provided. In processing views, the object-relational mapping tool identifies the dependency relationship between the various views and tables and allows the programmer to customize the mapping that will occur by selectively determining which tables and views get mapped. This customization allows the mapping tool to map an individual table or view or to map (1) all tables and views, (2) all tables only, and (3) tables and views for which there are no dependencies. Also, the mapping tool allows the programmer to view and set the updatability of a particular view or table.