Method and apparatus for processing data using multi-tier caching
AssigneeSagent Technology, Inc.
InventorsVladimir Gorelik, Glenn A. Shapland, Craig R. Powers
Life of this patent
Estimating the term…
Abstract
A method and apparatus for processing data using multi-tier caching are described. In one embodiment, the method includes receiving a user request containing one or more data parameters and searching cache memories of multiple tiers until finding a parameterized result set associated with the data parameters. The multiple tiers correspond to stages in the transformation of data retrieved from one or more data sources according to the user request. Once the parameterized result set associated with the data parameters is found, it is used to create a final result set.
Claims23
A method for processing data using multi-tier caching, the method comprising:
- receiving a first user request to process data, the first user request including at least one data parameter and being indicative of a plurality of tiers to be used in processing the data;
- searching cache memories of the plurality of tiers until finding a cache memory that stores a parameterized result set associated with the at least one data parameter;
- and
- processing the parameterized result set to create a final result set.
A method for processing data using multi-tier caching, the method comprising:
- receiving a user request to process data, the user request including at least one data parameter and being indicative of a plurality of tiers to be used in processing the data;
- determining that the at least one data parameter is not stored in any cache of the plurality of tiers, each of the plurality of tiers having a corresponding cache and performing a task selected from a group consisting of data retrieval, data transformation and data presentation;
- processing the user request at each of the plurality of tiers using the at least one data parameter to create a plurality of result sets, each result set corresponding to a distinct one of the plurality of tiers;
- storing the result set with the at least one data parameter in a corresponding cache for use in processing of subsequent user requests;
- and
- displaying a final result set to the user.
An apparatus for processing data using multi-tier caching, the method comprising:
- means for receiving a first user request to process data, the user request including at least one data parameter and being indicative of a plurality of tiers to be used in processing the data;
- means for searching cache memories of a plurality of tiers until finding a cache memory that stores a parameterized result set associated with the at least one data parameter;
- and
- means for creating a final result set based upon the parameterized result set.
A system for processing data using multi-tier caching, the system comprising:
- a data flow service to receive a user request including at least one data parameter, to determine that a first-tier cache associated with the data flow service does not store a data flow result set with the at least one data parameter, to obtain an initial result set from a database management system, to generate a data flow result set based upon the at least one data parameter, and to store the data flow result set with the at least one data parameter in the first-tier cache for use in processing of subsequent user requests;
- a web server, coupled to the data flow service, to determine that a second-tier cache associated with the web server service does not store a web server result set with the at least one data parameter, to generate a web server result set based upon the data flow result set, and to store the web server result set with the at least one data parameter in the second-tier cache for use in processing of subsequent user requests;
- and
- a client, coupled to the web server over a network, to issue the user request with the at least one data parameter, to determine that a third-tier cache associated with the client does not store a final result set with the at least one data parameter, to create a final result set using the web server result set, and to store the final result set with the at least one data parameter in the third-tier cache for use in processing of subsequent user requests.
A computer readable medium comprising instructions, which when executed on a processor, cause the processor to perform a method for processing data using multi-tier caching, the method comprising:
- receiving a first user request to process data, the first user request including at least one data parameter and being indicative of a plurality of tiers to be used in processing the data;
- searching cache memories of a plurality of tiers until finding a cache memory that stores a parameterized result set associated with the at least one data parameter;
- and
- processing the parameterized result set to create a final result set.
A computer readable medium comprising instructions, which when executed on a processor, cause the processor to perform a method for processing data using multi-tier caching, the method comprising:
- receiving a user request to process data, the user request including at least one data parameter and being indicative of a plurality of tiers to be used in processing the data;
- determining that the at least one data parameter is not stored in any cache of the plurality of tiers, each of the plurality of tiers having a corresponding cache and performing a task selected from a group consisting of data retrieval, data transformation and data presentation;
- processing the user request at each of the plurality of tiers using the at least one data parameter to create a plurality of result sets, each result set corresponding to a distinct one of the plurality of tiers;
- storing the result set with the at least one data parameter in a corresponding cache for use in processing of subsequent user requests;
- and displaying a final result set to the user.
Dependencies are inferred from the claim text.