Aggregation of resource requests from multiple individual requestors

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.

Description

RELATED APPLICATION

[0001] This application is a continuation under 37 C.F.R. 1.53(b) of U.S. Pat. No. 5 application Ser. No. 09/711,236, entitled “AGGREGATION OF RESOURCE REQUESTS FROM MULTIPLE INDIVIDUAL REQUESTORS,” filed Nov. 13, 2000, which is incorporated herein by reference.

FIELD OF THE INVENTION

[0002] The present invention relates to computer systems, and in particular to requests for resources managed by a computer system.

BACKGROUND OF THE INVENTION

[0003] Computer systems are used to execute software applications, such as relational databases. A relational database is a large collection of tables of data which users desire to access. A relational database manager is an application that is used to access that data.

[0004] There are an incredible number of other applications, many of which provide information from a central computer or server to users working on client computers attached to the server. These applications may generically be referred to as resource management systems.

[0005] The client computers generate requests for the information from the server. Each such request is communicated to the server, the server processes each individual request, and then hopefully returns the information requested. There is a significant amount of processing or overhead associated with individual requests for information. The communication of each request has associated processing overhead, as well as the processing involved in actually retrieving the information. If there are a large number of independent and individual requests, the resource management system can become a bottleneck, bogged down by the overhead associated with the individual requests.

[0006] In relational database applications, the server runs a database management system. The requests are in the form of queries, such as structured query language (SQL) queries that identify the desired information. To process an SQL query, the database management system parses the query, and runs it through an optimizer in order to determine the most efficient manner in which to execute the query and return the results of the query. This is done for each individual query.

[0007] Some relational database management systems allow the sending of multiple updates, inserts and deletes at the same time, thus saving some of the overhead required when processing individual requests or queries. These are generated from a single source, and are not independent.

[0008] There is a need to reduce the number of individual requests from independent sources. There is a need to reduce the performance bottleneck associated with such individual requests at the resource management system. There is yet a further need to do so in a manner that is independent of the resource management system.

SUMMARY OF THE INVENTION

[0009] 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.

[0010] In one embodiment, multiple independent requesters, such as web browsers or credit card authorization devices are coupled to a server by a network. The network may be the Internet, Ethernet or other type of communication medium, including wireless. 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 identified from the individual requests and used in the aggregated request.

[0011] In a further embodiment, the resource management system receives an aggregated request and accesses the resource, such as a database management system. In such a system, the request may be a parameterized query for information from one or more tables in a database. The database management system returns a set of rows, and the server matches each row of the set with the individual request, and provides the appropriate information back to the individual requesters.

BRIEF DESCRIPTION OF THE DRAWINGS

[0012] FIG. 1 is a block diagram of a system incorporating the resource request aggregator of the present invention.

[0013] FIG. 2 is a block diagram of functional elements of the system of FIG. 1.

[0014] FIG. 3 is a flowchart of an example of the aggregation and processing of multiple requests.

DETAILED DESCRIPTION OF THE INVENTION

[0015] In the following detailed description of exemplary embodiments of the invention, reference is made to the accompanying drawings that form a part hereof, and in which is shown by way of illustration specific exemplary embodiments in which the invention may be practiced. These embodiments are described in sufficient detail to enable those skilled in the art to practice the invention, and it is to be understood that other embodiments may be utilized and that logical, mechanical, electrical and other changes may be made without departing from the spirit or scope of the present invention. The following detailed description is, therefore, not to be taken in a limiting sense, and the scope of the present invention is defined only by the appended claims.

[0016] The detailed description is divided into multiple sections. A first section provides an overview of the invention at a high level. This is followed by a description of components used to implement the invention in one embodiment. Further detail regarding the function of the components is then described. This is followed by a conclusion that describes some potential benefits of the invention.

[0017] A block diagram in FIG. 1 shows a system generally at 100 that includes the present invention, and generally requesters 110, a server 115 and a resource 120. At 110, a plurality of independent requesters or clients 124, 126 and 128 are shown. The requesters may be individual personal computers, virtual machines, credit card authentication devices or other type of machine or software that can generate individual and independent requests. Such requests are individual and independent in that they may or may not be related to one another, but all are not related to a single transaction and formed by an individual requester.

[0018] The requesters are coupled via a network connection 130, such as the Internet, Ethernet, Blue Tooth, or other type of communication medium suitable for communication, to an aggregator 135 in the server 115. The aggregator 135 is coupled to a resource management system 140 that is a part of resource 120. Resource 120, in one embodiment is a database management system, which is used to query and manage other transactions involving a database. It should be noted that the resource 120 may also comprise many different types of applications that receive requests, such as check clearing houses, credit card transaction processing systems, banking systems and others as will be apparent upon reading the detailed description. The requests may be requests for information, such as query requests, or may be requesting an action, such as inserts and updates, or actions with respect to other applications.

[0019] In operation, individual requests are represented at 145 as being generated by the requesters 110, aggregated by the server 115, and passed on to the resource 120 as aggregated requests 150. The resource management system 140 then processes each aggregated request and returns aggregated responses 155, which are separated by the server 115 back into individual requests 160 which are in turn provided back the corresponding requesters.

[0020] The aggregator 135 comprises a communication layer 170 which handles interprocess communication between the requesters and the server, essentially extracting and encoding requests for transmission. An optional business logic layer 180 receives requests processed by the communication layer 170 and may perform conversions of data types, and identify and/or enforce constraints. It may implement other types of functions such as caching and billing. A resource access layer 190 receives requests and responses. It is responsible for aggregation of requests and matching of responses back to the requests.

[0021] In the block diagram of FIG. 2, functions performed by the resource access layer 190 are shown in further detail. Incoming requests 210, 212, 214 and 216 are mapped to a group of methods 220 of the resource access layer. Each method A 224 and method B 226 correspond to a particular class of requests. In one embodiment, a class may be a query based on account name. Other classes may correspond to particular actions to take with respect to a class of devices. In general, a class is a set of requests that can be converted into an aggregate request that resource 120 can handle.

[0022] Methods can be executed asynchronously, with caller placing call and providing callback entry for completion notification. The method has arguments that comprise request parameters, such as account number in an example below, and an output parameter, such as balance in an account.

[0023] Execution of a method is pended until a specified time lapses or a specified number of calls are pending as indicated at threshold 230. As indicated, threshold 230 may be a time period, specified number of calls, and may also be a combination of both, such that if a specified number of calls are not received within a determined time, the method is executed anyway at the end of the time. There may be an independent threshold for each method, or the threshold may be the same for each method, or class of requests. In one embodiment, each method is monitored independently for meeting its threshold.

[0024] When the threshold is met the pending calls are sent for processing to the provider for this method. The provider packages arguments of the pending calls into an aggregated request at a provider 235, and sent at 238 to a resource management system 240 in the format required. Each type of resource management system may have its own custom provider 235 based on the different aggregated request the system can handle. The provider 235 then sends the aggregated request to the resource management system.

[0025] The resource management system 240 then processes the aggregated request in a known manner and provides a response back to the resource access layer at 245. The aggregated response is resolved back to the pending calls and the output parameter at 250. Corresponding methods 260 and 262 are used to complete the calls using callback notification entries.

[0026] The resource management system supports aggregated requests, and the aggregated requests are designed to provide data in the aggregated response that can be matched to the pending call arguments.

[0027] It should be noted that software may be implemented in modules which include a wide variety of functions. The flowchart in FIG. 3 may be implemented in modules, objects, and other forms of programming code, such as subroutines, and stored on a computer readable medium such as magnetic disks, optical media and other forms of storage which can be read or perceived by a machine or computer. Further computer readable media includes signal carriers on which digital data may be carried between devices.

[0028] The flowchart in FIG. 3 is discussed with reference to an example representative of a fictional bank with accounts stored in tables in a database. Overall, multiple requests for balances on different accounts are aggregated and sent to the database. A response is received and sent back to original requesters.

[0029] At 130, individual, independent requests are received.

[0030] Requester 1 sends request for balance on account 111

[0031] Requester 2 sends request for balance on account 222

[0032] Requester 2 sends request for balance on account 333

[0033] Each request results in a call of a method of the class corresponding to the request at 130. In the example, each request is of the same class.

[0034] Server receives request 1 and calls GetAccountBalance method with parameter 111

[0035] Server receives request 2 and calls GetAccountBalance method with parameter 222

[0036] Server receives request 3 and calls GetAccountBalance method with parameter 333

[0037] At 320, the threshold has been monitored as each request is received and method called. The threshold is three in this instance, and is met.

[0038] Pending calls are then scanned and an aggregated query is formulated at 330.

[0039] SELECT ACCOUNTNO, BALANCE FROM ACCOUNT_MASTER WHERE ACCOUNTNO=111 OR ACCOUNTNO=222 OR ACCOUNTNO=333

[0040] The aggregated query is then sent to database management system 340, and a result set, such as a table is received from the database management system at 350. 1 ACCOUNT NO BALANCE 111 $2000 222 $3232 333 $600 

[0041] The result set rows are matched to pending call parameters at 360, and results are sent to corresponding requesters at 370.

[0042] Balance value of GetAccountBalance method with parameter 111 is set to $2000 and call-back is called

[0043] Balance value of GetAccountBalance method with parameter 222 is set to $3232 and call-back is called

[0044] Balance value of GetAccountBalance method with parameter 333 is set to $600 and call-back is called

[0045] Server sends response of $2000 to requester 1

[0046] Server sends response of $3232 to requester 2

[0047] Server sends response of $600 to requester 3

[0048] In one embodiment, the returned table is simple scanned using the original query requests to match the request to the correct information in the table.

CONCLUSION

[0049] Access to resource management systems, such as database servers, is often a performance bottleneck. The invention aggregates individual and independent request for the resource, reducing the load on the resource management system, and improving overall system throughput. In clustered environments the resource access layer may reside on several computers that all access a single resource (database). Having multiple entities accessing the single resource can accentuate the performance bottleneck. The present invention may also improve performance in clustered environments.

[0050] In one embodiment of the present invention, the number of requests between the resource access layer and the resource is reduced. By reducing the number of request, communication overhead and resource management system per request overhead is reduced.

[0051] This application is intended to cover any adaptations or variations of the present invention. It is manifestly intended that this invention be limited only by the claims and equivalents thereof. While some embodiments are described in terms of a database management system, it is recognized that resource requests in many other environments may be aggregated to improve performance.

Claims

1. A server comprising:

a communication layer coupled to a network having multiple requestors generating individual and independent requests for a resource management system; and

a resource access layer coupled to the communication layer that aggregates the requests based on class of request and communicates such aggregated requests to the resource management system.

2. The server of claim 1, wherein the resource access layer receives, from the resource management system, responses to communicated requests including aggregated request results.

3. The server of claim 2, wherein the resource access layer matches responses back to the requests.

4. The server of claim 1, wherein the sorting includes sorting requests for aggregation based on parameters of the individual and independent requests.

5. The server of claim 1, wherein the resource access layer aggregates requests for a predetermined period of time prior to forming an aggregated request.

6. The server of claim 5, wherein the predetermined period of time is modified to improve the speed with which results are received from the resource management system.

7. The server of claim 1, wherein the resource access layer aggregates requests until a certain number of requests have been collected.

8. The server of claim 17, wherein the number of requests is modified to improve the speed with which results are received from the resource management system.

9. The server of claim 1, wherein the requests are queries.

10. The server of claim 1, wherein the requesters are web browsers.

11. The server of claim 1, wherein the requestors are credit card authorization devices.

12. The server of claim 1, where in class of requests include an action class, a data source class, and a data type class.

13. The server of claim 1, wherein some of the individual and independent requests require results that are the same as results required by other independent requests

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

receiving results from a single request aggregated from multiple 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;

matching the results to the independent and individual requests; and

sending corresponding results to the individual requesters.

15. The method of claim 14, further comprising:

formatting the corresponding results in a format displayable in a web browser.

16. The method of claim 14, wherein sending corresponding results to the individual requesters includes sending a response from an action performed by the resource management system.

17. The method of claim 16, wherein the response from an action performed by the resource management system includes a response from an update to the resource management system.

18. A method comprising:

collecting independent requests from multiple individual requestors, wherein at least one of the independent requests is different from the other independent requests;

forming a single aggregated request from the collected request; and

matching aggregated request results to the multiple individual requesters.

19. The method of claim 18, wherein collecting independent requests occurs for a predetermined period of time.

20. The method of claim 18, wherein collecting independent requests occurs until a certain amount of requests are collected.

21. The method of claim 18, wherein forming a single aggregated request includes sorting requests for aggregation based on parameters of the independent requests.

22. A method of handing requests for a resource management system comprising:

aggregating independent and individual requests, wherein at least one of the independent requests is different from the other independent requests;

presenting the aggregated requests as a single request to the resource management system; and

resolving requests results from the resource management system back to the individual requests.