METHODS AND APPARATUS FOR EFFICIENTLY SPLITTING QUERY EXECUTION ACROSS CLIENT AND SERVER IN AN OBJECT-RELATIONAL MAPPING

摘要

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.