RETRIEVING DATA IN BATCHES FROM A LINE OF BUSINESS SYSTEM

• US 20100257194A1
• Filed: 04/02/2009
• Published: 10/07/2010
• Est. Priority Date: 04/02/2009
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Mohammed, Nazeeruddin, Kapadia, Arshish Cyrus, Sevilmis, Tarkan, Kalyanaraman, Karthik
• Granted Patent: US 8,533,220 B2
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/2455 Query execution

Abstract

A line of business data integration (“LOBI”) stack is provided that is configured to store an abstract representation of a mechanism utilized by a line of business (“LOB”) system to return requested LOB data in batches. When a request is received from a client for the LOB data, the LOBI stack utilizes the abstract representation to retrieve the requested LOB data from the LOB system in batches. In this manner, the batching mechanism utilized by the LOB system is abstracted from the client.

Claims

1. A computer-readable storage medium having computer-executable instructions stored thereon for execution by a computer, the computer-readable instructions comprising:

a program module configured to store an abstract representation of a mechanism utilized by a computing system to return requested data in batches, to receive a request from a client for the data and, in response to receiving the request, to utilize the abstract representation to retrieve the requested data from the computing system in batches and to provide the requested data to the client in response to the request.

2. The computer-readable storage medium of claim 1, wherein the program module comprises a line of business data integration (LOBI) stack.

3. The computer-readable storage medium of claim 2, wherein the computing system comprises a line of business (LOB) system.

4. The computer-readable storage medium of claim 3, wherein the data comprises LOB data.

5. The computer-readable storage medium of claim 4, wherein the abstract representation of a mechanism utilized by the computing system to return requested data in batches comprises metadata defining one or more parameters utilized by the LOB system to return requested LOB data in batches.

6. The computer-readable storage medium of claim 5, wherein the abstract representation of a mechanism utilized by the computing system to return requested data in batches further comprises metadata defining one or more filters utilized by the LOBI stack.

7. The computer-readable medium of claim 6, wherein the abstract representation of a mechanism utilized by the computing system to return requested data in batches further comprises metadata defining a mapping between the filters and the parameters.

8. The computer-readable storage medium of claim 7, wherein utilizing the abstract representation to retrieve the requested data from the computing system in batches comprises retrieving the abstract representation, identifying the parameters based upon the abstract representation, and utilizing the parameters to create a request to the computing system for a first batch of data.

9. The computer-readable storage medium of claim 8, wherein utilizing the abstract representation to retrieve the requested data from the computing system in batches further comprises receiving a response to the request from the computing system, the response comprising a batch of data and one or more return parameters, determining based upon the return parameters whether additional batches are available from the computing system, and if additional batches are available, creating a new request to the computing system for an additional batch of data, the new request comprising a new batching state.

10. The computer-readable storage medium of claim 9, wherein utilizing the abstract representation to retrieve the requested data from the computing system in batches further comprises providing the batch of data to the client, whereby the batching operation of the computing system is abstracted from the client.

11. A method for retrieving data from a computing system 104 in batches, the method comprising:

storing an abstract representation of a mechanism utilized by a computing system to return data in batches;

receiving a request from a client for the data; and

in response to receiving the request, utilizing the abstract representation to retrieve the requested data from the computing system in batches and providing the requested data to the client.

12. The method of claim 11, wherein the storing, receiving, and utilizing operations are performed by a LOBI stack.

13. The method of claim 12, wherein the computing system comprises a LOB system.

14. The method of claim 13, wherein the data comprises LOB data.

15. The method of claim 14, wherein the abstract representation of the mechanism utilized by a computing system to return requested data in batches comprises metadata defining one or more parameters utilized by the LOB system to return requested LOB data in batches.

16. The method of claim 15, wherein the abstract representation of the mechanism utilized by the computing system to return requested data in batches further comprises metadata defining one or more filters utilized by the LOBI stack.

17. The method of claim 16, wherein the abstract representation of the mechanism utilized by the computing system to return requested data in batches further comprises metadata defining a mapping between the filters and the parameters.

18. The method of claim 17, wherein utilizing the abstract representation to retrieve the requested data from the computing system in batches comprises retrieving the abstract representation, identifying the parameters based upon the abstract representation, and utilizing the parameters to create a request to the computing system for a first batch of data.

19. The method of claim 18, wherein utilizing the abstract representation to retrieve the requested data from the computing system in batches further comprises receiving a response to the request from the computing system, the response comprising a batch of data and one or more return parameters, determining based upon the return parameters whether additional batches are available from the computing system, and if additional batches are available, creating a new request to the computing system for an additional batch of data, the new request comprising a new batching state.

20. A system for retrieving data from one or more line of business (LOB) systems in batches, the system comprising:

a line of business data integration (LOBI) stack configured to store an abstract representation of a batching mechanism utilized by a LOB system, the abstract representation comprising one or more parameters utilized by the LOB system to return requested LOB data in batches, one or more filters utilized by the LOBI stack, and metadata defining a mapping between the filters and the parameters, the LOBI stack further configured to receive a request from a client for the LOB data and, in response to receiving the request, to utilize the abstract representation to retrieve the requested LOB data from the LOB system in batches and to provide the requested LOB data to the client in response to the request.