Method of Optimizing Data Flow Between a Software Application and a Database Server

Abstract

A method may include receiving a request for a resource on a database server, the request being from a request initiator coupled to a network. Redundant data in the request is identified based on the data optimization rules, where the redundant data is unnecessary for the database server to satisfy the request for the resource. The redundant data is removed from the request based on the data optimization rules to create an optimized request. The optimized request is provided, using the network to the database server.

What is claimed is: 
     
         1 . A method comprising:
 receiving a request for a resource on a database server, the request being from a request initiator coupled to a network;   identifying, based on data optimization rules, redundant data in the request, the redundant data being unnecessary for the database server to satisfy the request for the resource;   removing, based on the data optimization rules, the redundant data from the request to create an optimized request;   providing, using the network, the optimized request to the database server.   
     
     
         2 . The method of  claim 1 , wherein the data optimization rules instruct caching the redundant data to produce a cached portion of the request, the optimized request comprising the cached portion of the request. 
     
     
         3 . The method of  claim 2 , wherein the data optimization rules instruct satisfying at least a portion of the request with the cached portion of the request. 
     
     
         4 . The method of  claim 1 , wherein the data optimization rules instruct compressing the request to produce the optimized request. 
     
     
         5 . The method of  claim 1 , wherein the data optimization rules instruct compressing the request based on one or more of a performance measure of the network and a processing measure of the request initiator. 
     
     
         6 . The method of  claim 1 , wherein the data optimization rules instruct pre-caching the request if the resource has been previously requested by the request initiator. 
     
     
         7 . The method of  claim 1 , wherein the data optimization rules instruct:
 determining if the request corresponds to a duplicate request in a substantially similar time window as the request; and   stopping queries associated with the request if the request correspond to the duplicate request.   
     
     
         8 . The method of  claim 1 , wherein the data optimization rules instruct:
 finding common strings in the request; and   replacing each of the common strings with a replacement identifier, thereby reducing a size of the optimized request.   
     
     
         9 . The method of  claim 1 , wherein the data optimization rules instruct:
 identifying database commands in the request that can be replaced with simpler database commands;   replacing the database commands with the simpler database commands.   
     
     
         10 . The method of  claim 1 , wherein the data optimization rules instruct encrypting the request in an encryption envelope, thereby reducing a size of the optimized request. 
     
     
         11 . The method of  claim 1 , wherein identifying the redundant data comprises gathering the data optimization rules from a rules datastore. 
     
     
         12 . The method of  claim 1 , further comprising:
 receiving, using the network, a response comprising the resource from the database server in response to the optimized request;   optimizing, based on the data optimization rules, the response to produce an optimized response;   providing the optimized response to the request initiator.   
     
     
         13 . The method of  claim 12 , wherein the data optimization rules instruct:
 caching the redundant data to produce a cached portion of the request;   determining, based on the response, if the cached portion of the request has changed;   merging the changed portion of the response with the cached portion of the request.   
     
     
         14 . The method of  claim 12 , wherein the data optimization rules instruct decompressing the response to produce the optimized response. 
     
     
         15 . The method of  claim 1 , wherein the method is performed locally to the request initiator. 
     
     
         16 . The method of  claim 1 , wherein the method is performed remotely to the request initiator. 
     
     
         17 . The method of  claim 1 , wherein the method is performed at a plurality of locations on the network. 
     
     
         18 . The method of  claim 1 , wherein the request initiator is agnostic to the method. 
     
     
         19 . A system comprising:
 a request initiator;   a data accelerator coupled to the request initiator and to a network;   a rules datastore coupled to the data accelerator;   wherein, in operation:
 the request initiator provides a request for a resource on a database server; 
 the data accelerator:
 receives a request for a resource on a database server, the request being from a request initiator coupled to a network; 
 identifies, based on data optimization rules, redundant data in the request, the redundant data being unnecessary for the database server to satisfy the request for the resource; 
 removes, based on the data optimization rules, the redundant data from the request to create an optimized request; 
 provides, using the network, the optimized request to the database server. 
 
   
     
     
         20 . The system of  claim 19 , wherein the data accelerator is one of a plurality of data accelerators for the network. 
     
     
         21 . A system comprising:
 means for receiving a request for a resource on a database server, the request being from a request initiator coupled to a network;   means for identifying, based on data optimization rules, redundant data in the request, the redundant data being unnecessary for the database server to satisfy the request for the resource;   means for removing, based on the data optimization rules, the redundant data from the request to create an optimized request;   means for providing, using the network, the optimized request to the database server.