Method and apparatus for efficient SQL processing in an n-tier architecture

A computer program product that includes a computer usable storage medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by the processor, causes a process to be performed, the process comprising:

• receiving the data request for data of a particular type from a data request generator;
• determining whether a partial database in a local database cache of a client computing system contains the data, the local database cache communicatively coupled to the data request generator, wherein the act of determining whether the partial database contains the data is performed by a processor;
• routing the data request to a peer database cache of a first peer client computing system of the client computing system based at least in part on a result from the act of determining, wherein the first peer client computing system of the client computing system is on a same tier with the client computing system in an n-tier computer architecture;
• and
• tracking the data stored in the peer database cache or in the partial database and storing a response to the data request to a location in the peer database cache or in the partial database based on a result of an act of comparing a statistic for the data request to a predetermined statistic.

A system for responding to a data request in an n-tier computer network environment, comprising:

• means for receiving the data request for data of a particular type from a data request generator;
• a processor configured for determining whether a partial database in a local database cache of a client computing system contains the data, the local database cache communicatively coupled to the data request generator;
• means for routing the data request to a peer database cache of a first peer client computing system of the client computing system based at least in part on a result from the act of determining, wherein the first peer client computing system of the client computing system is on a same tier with the client computing system in an n-tier computer architecture;
• and
• means for tracking the data stored in the peer database cache or in the partial database and storing a response to the data request to a location in the peer database cache or in the partial database based on a result of an act of comparing a statistic for the data request to a predetermined statistic.

A method for responding to a data request in a computer network environment, comprising:

• receiving the data request for data;
• determining whether a partial database in a local database cache of a client computing system contains the data, wherein the act of determining whether the partial database contains the data is performed by a processor;
• selecting a first peer client computing system of the client computing system to which the data request is to be routed, the first peer client computing system selected based at least in part on information indicating a success of the first peer client computing system in responding to a previous data request;
• routing the data request to the first peer client computing system, wherein the first peer client computing system of the client computing system is on a same tier with the client computing system in an n-tier computer architecture;
• and
• tracking the data stored in the first peer client database cache or in the partial database and storing a response to the data request to a location in the peer database cache or in the partial database based on a result of an act of comparing a statistic for the data request to a predetermined statistic.

A computer program product that includes a computer storage medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by the processor, causes a process to be performed, the process comprising:

• receiving a data request for a data;
• determining whether a partial database in a local database cache of a client computing system contains the data, wherein the act of determining whether the partial database contains the data is performed by a processor;
• selecting a first peer client computing system of the client computing system to which the data request is to be routed, the first peer client computing system selected based at least in part on information indicating a success of the first peer client computing system in responding to a previous data request, wherein the first peer client computing system of the client is on a same tier with the client computing system in an n-tier computer architecture;
• routing the data request to the first peer client computing system;
• and
• tracking the data stored in the peer database cache or in the partial database and storing a response to the data request to a location in the peer database cache or in the partial database based on a result of an act of comparing a statistic for the data request to a predetermined statistic.

A system for responding to a data request in a computer network environment, comprising:

• means for receiving the data request for a data;
• a processor configured for determining whether a partial database in a local database cache of a client computing system contains the data;
• means for selecting a first peer client computing system of the client to which the data request is to be routed, the first peer client computing system selected based at least in part on information indicating a success of the first peer client computing system in responding to a previous data request, wherein the first peer client computing system of the client is on a same tier with the client computing system in an n-tier computer architecture;
• means for routing the data request to the first peer client computing system;
• and
• means for tracking the data stored in the peer database cache or in the partial database and storing a response to the data request to a location in the peer database cache or in the partial database based on a result of an act of comparing a statistic for the data request to a predetermined statistic.

A computer implemented method for responding to a data request in an n-tier computer network environment, comprising:

• receiving the data request for data of a particular type from a data request generator;
• determining whether a partial database in a local database cache of a client computing system contains the data, the local database cache communicatively coupled to the data request generator, wherein the act of determinmg whether the partial database contains the data is performed by a processor;
• routing the data request to a peer database cache of a first peer client computing system of the client computing system based at least in part on a result from the act of determining, wherein the first peer client computing system of the client is on a same tier with the client computing system in an n-tier computer architecture;
• saving a response to the data request to a location in the database cache, wherein an act of saving the response to the data request comprises:
• calculating a statistic for the data request, wherein the statistic comprises a response time for the data request or a frequency of the data request;
• comparing the statistic for the data request to a predetermined statistic;
• and
• saving the response to the location in the database cache based at least in part upon a result of an act of comparing the statistic the statistic for the data request to the predetermined statistic;
• and
• tracking data stored in the peer database cache and storing information on the data stored in the peer database cache in the client computing system.

A system for responding to a data request in an n-tier computer network environment, comprising:

• means for receiving the data request for data of a particular type from a data request generator;
• a processor configured for determining whether a partial database in a local database cache of a client computing system contains the data, the local database cache communicatively coupled to the data request generator;
• means for routing the data request to a peer database cache of a first peer client computing system of the client computing system based at least in part on a result from the act of determining, wherein the first peer client computing system of the
• client is on a same tier with the client computing system in an n-tier computer architecture;
• means for saving a response to the data request to a location in the database cache, wherein the means for saving the response to the data request comprises:
• means for calculating a statistic for the data request, wherein the statistic comprises a response time for the data request or a frequency of the data request;
• means for comparing the statistic for the data request to a predetermined statistic;
• and
• means for saving the response to the location in the database cache based at least in part upon a result of an act of comparing the statistic the statistic for the data request to the predetermined statistic;
• and
• means for tracking data stored in the peer database cache and storing information on the data stored in the peer database cache in the client computing system.

A computer program product that includes a computer usable storage medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by the processor, causes a process to be performed for responding to a data request in an n-tier computer network environment, the process comprising:

• receiving the data request for data of a particular type from a data request generator;
• determining whether a partial database in a local database cache of a client computing system contains the data, the local database cache communicatively coupled to the data request generator, wherein the act of determining whether the partial database contains the data is performed by a processor;
• routing the data request to a peer database cache of a first peer client computing system of the client computing system based at least in part on a result from the act of determining, wherein the first peer client computing system of the client is on a same tier with the client computing system in an n-tier computer architecture;
• saving a response to the data request to a location in the database cache, wherein an act of saving the response to the data request comprises:
• calculating a statistic for the data request, wherein the statistic comprises a response time for the data request or a frequency of the data request;
• comparing the statistic for the data request to a predetermined statistic;
• and
• saving the response to the location in the database cache based at least in part upon a result of an act of comparing the statistic the statistic for the data request to the predetermined statistic;
• and
• tracking data stored in the peer database cache and storing information on the data stored in the peer database cache in the client computing system.