Retrieving data in batches from a line of business system

• US 8,533,220 B2
• Filed: 04/02/2009
• Issued: 09/10/2013
• Est. Priority Date: 04/02/2009
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Kalyanaraman, Karthik, Kapadia, Arshish Cyrus, Sevilmis, Tarkan, Mohammed, Nazeeruddin
• Primary Examiner(s): Ehichioya, Fred I
• Assistant Examiner(s): BOWEN, RICHARD L
• Application Number:
  US12/416,940
• Publication Number:
  US 20100257194A1
• Time in Patent Office: 1,622 Days
• Field of Search: None
• US Class Current: 707/770
• 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 device having computer-executable instructions stored thereon for execution by an interface computer system, the computer-readable instructions comprising:

a program module configured to;

store an abstract representation of a mechanism that interfaces with a plurality of line of business (LOB) computing systems to return requested data in a plurality of batches, wherein the abstract representation of the mechanism comprises parameter metadata that defines at least one parameter utilized by the at least one of the plurality of LOB computing systems, filter metadata that defines at least one filter, and mapping metadata that defines a mapping between the at least one filter and the least one parameter, and wherein at least two of the plurality of computing systems utilize different interfaces;

receive a request from a client for the data from at least one of the plurality of LOB computing systems;

in response to receiving the request, utilize the abstract representation to identify the at least one parameter and utilize the at least one parameter to create a request to retrieve the requested data from the at least one of the LOB computing systems in the plurality of batches; and

provide the requested data to the client in response to the request, the program module comprising an administrative object model for creating or editing the abstract representation utilized by the plurality of LOB computing systems.

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

3. The computer-readable storage device of claim 2, wherein the at least one filter is utilized by the LOBI stack.

4. The computer-readable storage device of claim 1, wherein the data comprises LOB data.

5. The computer-readable storage device of claim 1, wherein utilizing the abstract representation to identify the at least one parameter and utilize the at least one parameter to create a request to retrieve the requested data from the at least one of the LOB computing systems in the plurality of batches comprises:

retrieving the abstract representation;

identifying the at least one parameter based upon the abstract representation; and

utilizing the at least one parameter to create a request to the computing system for a first batch of data of the plurality of batches.

6. The computer-readable storage device of claim 5, wherein utilizing the abstract representation to identify the at least one parameter and utilize the at least one parameter to create a request to retrieve the requested data from the at least one of the plurality of LOB computing systems in the plurality of batches further comprises:

receiving a response to the request from the at least one of the plurality of LOB computing systems, the response comprising the first batch of data and one or more return parameters;

determining based upon the return parameters whether additional batches of the plurality of batches are available from the at least one of the plurality of LOB computing systems; and

if additional batches are available, creating a new request to the at least one of the plurality of LOB computing systems for an additional batch of data, the new request comprising a batching state received with a previous batch of data.

7. The computer-readable storage device of claim 6, wherein utilizing the abstract representation to retrieve the requested data from the at least one of the plurality of LOB computing systems in the plurality of batches further comprises providing one or more batches of data to the client, whereby the batching operation of the at least one of the plurality of LOB computing systems is abstracted from the client.

8. The computer-readable storage device of claim 1, wherein a first one of the plurality of LOB computing systems is provided by a first vendor and wherein a second one of the plurality of LOB computing systems is provided by a second vendor.

9. A method for retrieving data from an interface computing system in batches, the method comprising:

storing an abstract representation of a mechanism that interfaces with a plurality of line of business (LOB) computing systems to return data in a plurality of batches, wherein the abstract representation of the mechanism comprises parameter metadata that defines at least one parameter utilized by the at least one of the plurality of LOB computing systems, filter metadata that defines at least one filter, and mapping metadata that defines a mapping between the at least one filter and the least one parameter, and wherein at least two of the plurality of LOB computing systems utilize different interfaces, and further wherein the abstract representation is created or edited using an administrative object model associated with the abstract representation;

receiving a request from a client for the data; and

in response to receiving the request, utilizing the abstract representation to identify the at least one parameter and utilize the at least one parameter to create a request to retrieve the requested data from at least one of the plurality of LOB computing systems in the plurality of batches and providing the requested data to the client.

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

11. The method of claim 10, wherein the at least one filter is utilized by the LOBI stack.

12. The method of claim 9, wherein the data comprises LOB data.

13. The method of claim 9, wherein utilizing the abstract representation to identify the at least one parameter and utilize the at least one parameter to create a request to retrieve the requested data from the at least one of the plurality of LOB computing systems in the plurality of batches comprises:

retrieving the abstract representation;

identifying the at least one parameter based upon the abstract representation; and

utilizing the at least one parameter to create a request to the at least one of the plurality of LOB computing systems for a first batch of data of the plurality batches.

14. The method of claim 13, wherein utilizing the abstract representation to identify the at least one parameter and utilize the at least one parameter to create a request to retrieve the requested data from the at least one of the plurality of LOB computing systems in the plurality of batches further comprises:

receiving a response to the request from the computing system, the response comprising the first batch of data and one or more return parameters;

determining based upon the return parameters whether additional batches of the plurality of batches are available from the computing system; and

if additional batches are available, creating a new request to the at least one of the plurality of LOB computing systems for an additional batch of data, the new request comprising a batching state received with a previous batch of data.

15. The method of claim 9, wherein a first one of the plurality of LOB computing systems is provided by a first vendor and wherein a second one of the plurality of LOB computing systems is provided by a second vendor.

16. A system comprising:

one or more processors; and

a memory coupled to the one or more processors, the memory for storing instructions which, when executed by the one or more processors, cause the one or more processors to retrieve data from one or more line of business (LOB) systems in batches, the system further comprising;

a line of business data integration (LOBI) stack comprising an abstract representation of a batching mechanism that interfaces with a plurality of LOB systems, wherein at least two of the plurality of LOB systems utilize different interfaces, and wherein the abstract representation comprises parameter metadata that defines one or more parameters utilized by the plurality of LOB systems to return requested LOB data in a plurality of batches;

one or more filters utilized by the LOBI stack;

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 identify the one or more parameters and utilize the at least one parameter to create a request to retrieve the requested LOB data from at least one of the plurality of LOB systems in the plurality of batches and to provide the requested LOB data to the client in response to the request, wherein the LOBI stack further comprises an administrative object model for creating or editing the abstract representation used by the plurality of LOB systems.

17. The system of claim 16, wherein a first one of the plurality of LOB systems is provided by a first vendor and wherein a second one of the plurality of LOB computing systems is provided by a second vendor.

18. The system of claim 16, wherein utilizing the abstract representation to identify the at least one parameter and utilize the at least one parameter to create a request to retrieve the requested LOB data from the at least one of the LOB systems in the plurality of batches comprises:

retrieving the abstract representation;

identifying the one or more parameters based upon the abstract representation; and

utilizing the one or more parameters to create a request to the computing system for a first batch of LOB data of the plurality of batches.

19. The system of claim 18, wherein utilizing the abstract representation to identify the at least one parameter and utilize the at least one parameter to create a request to retrieve the requested LOB data from the at least one of the LOB systems in the plurality of batches further comprises:

receiving a response to the request from at least one of the plurality of LOB systems, the response comprising the first batch of LOB data and one or more return parameters;

determining, based upon the return parameters, whether additional batches of the plurality of batches are available from the at least one of the plurality of LOB systems; and

if additional batches are available, creating a new request to the at least one of the plurality of LOB systems for an additional batch of LOB data, the new request comprising a batching state received with a previous batch of LOB data.

20. The system of claim 19, wherein providing the requested LOB data to the client comprises providing one or more batches of LOB data to the client, whereby the batching operation of the at least one of the plurality of LOB systems is abstracted from the client.