Aggregation of resource requests from multiple individual requestors

• US 6,785,675 B1
• Filed: 11/13/2000
• Issued: 08/31/2004
• Est. Priority Date: 11/13/2000
• Status: Expired due to Fees

• Current Assignee: Convey Compliance Systems, LLC
• Original Assignee: Convey Development, Inc.
• Inventors: Poteryakhin, Viktor, Graves, John
• Primary Examiner(s): Homere, Jean R.
• Assistant Examiner(s): PHAM, KHANH B
• Application Number:
  US09/711,236
• Time in Patent Office: 1,387 Days
• Field of Search: 707/3, 707/4, 707/5, 707/2, 707/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

Independent and individual requests are aggregated and presented as a single request to a resource management system. The response from the resource management system is subsequently resolved back to the individual requests. The requesters generate multiple independent requests. The server receives such requests and sorts them into classes of requests, which are capable of being aggregated and processed as a single request by a resource management system. Parameters are pulled from the individual requests and used in the aggregated request.

Claims

1. A method of handling multiple requests for a resource management system, the method comprising:

collecting independent requests for the resource management system from multiple individual requesters, wherein some of the independent requests require results that are different than results required by other independent requests;

forming a single aggregated request from the collected requests;

sending the aggregated request to the resource management system;

receiving aggregated request results from the resource management system;

matching the aggregated request results to the independent and individual requests; and

sending corresponding independent request results to the individual requestors such that the single aggregated request satisfies all the collected requests in a single transaction with the resource management system.

2. The method of claim 1 wherein collecting independent requests occurs for a predetermined period of time prior to forming the single aggregated request.

3. The method of claim 2 wherein the predetermined period of time is modified to improve the speed with which results are received from the resource management system.

4. The method of claim 1 wherein collecting independent requests occurs until a predetermined number of requests have been collected.

5. The method of claim 4 wherein the number of requests is modified to improve the speed with which results are received from the resource management system.

6. The method of claim 1 wherein the requests are queries.

7. A computer readable medium having instructions to cause a computer to implement a method of handling multiple requests for a resource management system, the method comprising:

collecting independent requests for the resource management system from multiple individual requesters, wherein some of the independent requests require results that are different than results required by other independent requests;

forming a single aggregated request from the collected requests;

sending the aggregated request to the resource management system;

receiving aggregated request results from the resource management system;

matching the aggregated request results to the independent and individual requests; and

sending corresponding independent request results to the individual requesters such that the single aggregated request satisfies all the collected requests in a single transaction with the resource management system.

8. The computer readable medium of claim 7 wherein collecting independent requests occurs for a predetermined period of time prior to forming the single aggregated request, collecting independent requests occurs until a predetermined number of requests have been collected, or a combination thereof.

9. A server that handles multiple requests for a resource management system, the server comprising:

a module that collects independent requests for the resource management system from multiple individual requestors, wherein some of the independent requests require results that are different than results required by other independent requests;

a module that forms a single aggregated request from the collected requests such that the single aggregated request satisfies all the collected independent requests in a single transaction with the resource management system;

a module that sends the aggregated request to the resource management system;

a module that receives results from the resource management system;

a module that matches the results to the independent and individual requests; and

a module that sends corresponding results to the individual requesters.

10. A method of handling multiple requests for a resource management system, the method comprising:

collecting independent requests for the resource management system from multiple individual requesters, wherein some of the independent requests require results that are different than results required by other independent requests;

identifying requests from selected classes of requests;

extracting data request parameters from the independent requests from a class; and

forming a single aggregated request from requests in the class based on the parameters such that the single aggregated request satisfies all the collected requests in the class in a single transaction with the resource management system.

11. A computer readable medium having instructions for causing a computer to implement a method of handling multiple requests for a resource management system, the method comprising:

collecting independent requests for the resource management system from multiple individual requestors, wherein some of the independent requests require results that are different than results required by other independent requests;

identifying requests from selected classes of requests;

extracting data request parameters from the independent requests from a class; and

forming a single aggregated request from requests in the class based on the parameters such that the single aggregated request satisfies all the collected requests in the class in a single transaction with the resource management system.

12. A method of handling multiple queries for a database management system, the method comprising:

collecting independent queries for the database management system from multiple individual users, wherein some of the independent queries require results that are different than results required by other independent requests;

forming a single aggregated query from the collected queries;

sending the aggregated query to the database management system;

receiving a set of rows from the database management system;

matching rows in the set of rows to the independent and individual queries; and

sending information from the corresponding rows to the individual requestors responsive to the queries such that the single aggregated query satisfies all the collected queries in a single transaction with the database management system.

13. The method of claim 12 wherein forming an aggregated query comprises:

identifying queries from selected classes of queries;

extracting data request parameters from the independent queries from a class; and

forming a single aggregated query from queries in the class based on the parameters.

14. The method of claim 13, wherein extracting data request parameters includes extracting a resource management system identifier and resource management system indexing parameters.

15. The method of claim 14, wherein the resource management system is a relational database management system (RDBMS) and the resource management system indexing parameters are structured query language (SQL) commands and identifiers.

16. A method of handling multiple queries for a database management system, the method comprising:

collecting independent queries for a resource management system from multiple individual users, wherein some independent requests require results that are different than results required by other independent requests;

identifying queries from selected classes of queries;

extracting data request parameters from the independent queries from a class; and

forming a single aggregated query from queries in the class based on the parameters such that the single aggregated query satisfies all the collected queries in the class in a single transaction with the database management system.

17. A method of handling multiple requests for a resource management system, the method comprising:

collecting multiple independent requests for the resource management system from multiple individual requestors;

extracting request parameters from the collected independent requests;

enforcing one or more constraints on the extracted request parameters;

returning constraint errors to the requestor;

aggregating request parameters according to an extracted parameter classification;

sending the aggregated request parameters to the resource management system;

receiving results from the resource management system;

matching the results to the independent and individual requests; and

sending corresponding results to the individual requesters.