Query optimization with deferred update and autonomous sources

An apparatus for executing an object-oriented query, comprising:

• a computer having a data storage device connected thereto, wherein the data storage device stores a database;
• and
• one or more computer programs, performed by the computer, for transforming the object-oriented query into subqueries, wherein at least one subquery is directed against a database, wherein the subquery that is directed against the database comprises an object-oriented subquery, and wherein one subquery is directed against an object cache;
• transforming the object-oriented subquery to a database query;
• executing each subquery that is directed against the database to retrieve data from the database into the object cache;
• executing the subquery that is directed against the object cache to retrieve data from the query ;
• and updating data in the object cache, wherein the updated data incorporates updates to the object cache and to the database.

An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing an object-oriented query to retrieve data from a database stored on a data storage device connected to the computer, the method comprising the steps of:

• transforming the object-oriented query into subqueries, wherein at least one subquery is directed against a database, wherein the subquery that is directed against the database is an object-oriented subquery, and wherein one subquery is directed against an object cache;
• transforming the object-oriented subquery to a database query;
• executing each subquery that is directed against the database to retrieve data from the database into the object cache;
• executing the subquery that is directed against the object cache to retrieve data from the query;
• and
• updating data in the object cache, wherein the updated data incorporates updates to the object cache and to the database.