Systems and methods of providing data from a data source to a data sink

• US 7,475,088 B2
• Filed: 08/02/2004
• Issued: 01/06/2009
• Est. Priority Date: 08/04/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Ziegler, Carsten M.
• Primary Examiner(s): MIZRAHI, DIANE D
• Application Number:
  US10/902,918
• Publication Number:
  US 20050065968A1
• Time in Patent Office: 1,618 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206, 707/505, 345/505
• US Class Current: 1/1
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Systems and methods are disclosed for providing data from a data source to a data sink that uses remote function calls and extractors include first meta data provided from the data source to the data sink. On the basis of the meta data, a data request is formulated by the data sink and a corresponding remote function call is made. In response, an extractor structure is filled with data and reduced to a sub-structure that is returned to the data sink.

Claims

1. A method of providing data from a data source to a data sink, the method comprising the steps of:

a) receiving a first request from the data sink, wherein the first request does not specify a specific entity of the data source requested by the data sink;

b) in response to the first request, sending a list of entities of the data source to the data sink;

c) receiving a second request from the data sink, the second request being indicative of at least one of the entities;

d) in response to the second request, sending a first descriptor descriptive of an extractor structure of the at least one entity to the data source;

e) receiving a data request from the data sink, the data request indicative of the at least one entity and comprising a second descriptor descriptive of a sub-structure of the extractor structure of the at least one entity;

f) filling the extractor structure with data from the data source;

g) reducing the extractor structure to the sub-structure;

h) sending the data of the sub-structure to the data sink; and

i) presenting the data received by the data sink.

2. The method of claim 1, wherein the first request comprises a first remote function call for calling a first function providing the list of entities of the data source.

3. The method of claim 1, wherein the second request comprises a second remote function call for calling a second function providing the first descriptor.

4. The method of claim 1, the first descriptor comprising at least the field names of the at least one entity.

5. The method of claim 4, the second descriptor comprising a sub-set of the field names.

6. The method of claim 1, the data request comprising a third remote function call for calling a third function which serves to invoke an extractor for filling the extractor structure with data.

7. The method of claim 1, further comprising providing the sub-structure in the form of a sequential list.

8. The method of claim 1, wherein the stages e) to h) are performed repetitively.

9. The method of claim 1, wherein the stages a) to d) are repeated when the extractor structure of the at least one entity has been modified.

10. The method of claim 1, further comprising the stages of:

modifying an element of the extractor structure; and

time stamping the element.

11. A computer program for providing data from a data source to a data sink, when executed by a processor the computer program cause the processor to execute a method, the method comprising:

a) receiving a first request from the data sink, wherein the first request does not specify a specific entity of the data source requested by the data sink;

b) in response to the first request, sending a list of entities of the data source to the data sink;

c) receiving a second request from the data sink, the second request indicative of at least one of the entities;

d) in response to the second request, sending a first descriptor descriptive of an extractor structure of the at least one entity to the data source;

e) receiving a data request from the data sink, the data request indicative of the at least one entity and comprising a second descriptor being descriptive of a sub-structure of the extractor structure of the at least one entity;

f) filling the extractor structure with data from the data source;

g) reducing the extractor structure to the sub-structure;

h) sending the data of the sub-structure to the data sink; and

i) presenting the data received by the data sink.

12. The computer program of claim 11, the computer instructions causing the processor to execute first, second and third functions, each one of the functions having a remote function call capability, the first function adapted to provide the list of entities, the second function adapted to provide the first descriptor, and the third function adapted to provide the sub-structure.

13. A computer system including a processor and instructions which when executed by the processor cause the processor to execute a method for providing data from a data source to a data sink, the system further comprising:

a data source;

a first data source function receiving a first request from a data sink, wherein the first request does not specify a specific entity of the data source requested by the data sink;

the first data source function sending a list of entities of the data source to the data sink in response to the first request,

receiving a second request from the data sink, the second request indicative of at least one of the entities, and

sending a first descriptor descriptive of an extractor structure of the at least one entity to the data sink in response to the second request; and

a second data source function receiving a data request from the data sink, the data request indicative of the at least one entity and comprising a second descriptor descriptive of a sub-structure of the extractor structure of the at least one entity,

filling the extractor structure with data from the data sink,

reducing the extractor structure to the sub-structure, and

sending the sub-structure to the data sink.

14. The computer system of claim 13, the data source comprising a relational database.

15. The computer system of claim 13, the data source comprising an online transactional processing (OLTP) system.

16. A method of providing data from a data source to a data sink, the method comprising:

a) sending a first request to the data source, wherein the first request does not specify a specific entity of the data source requested by the data sink;

b) receiving a list of entities of the data source in response to the first request;

c) sending a second request to the data source, the second request indicative of at least one of the entities;

d) receiving a first descriptor descriptive of an extractor structure of the at least one entity in response to the second request;

e) sending a data request to the data source, the data request indicative of the at least one entity and comprising a second descriptor descriptive of a sub-structure of the extractor structure of the at least one entity;

f) receiving the data from the data source; and

g) presenting the data received by the data source.

17. The method of claim 16, wherein the data is received in the form of a sequential list.

18. The method of claim 16, further comprising visualizing the extractor structure on a user interface for a user selection of the sub-structure.

19. A computer program for providing data from a data source to a data sink, when executed by a processor the computer program cause the processor to execute a method, the method comprising:

a) sending a first request to the data source, wherein the first request does not specify a specific entity of the data source requested by the data sink;

b) receiving a list of entities of the data source in response to the first request;

c) sending a second request to the data source, the second request indicative of at least one of the entities;

d) receiving a first descriptor descriptive of an extractor structure of the at least one entity in response to the second request;

e) sending a data request to the data source, the data request indicative of the at least one entity and comprising a second descriptor descriptive of a sub-structure of the extractor structure of the at least one entity;

f) receiving the data from the data source; and

g) presenting the data received by the data source.

20. The computer program of claim 19, the computer instructions being adapted to provide a user interface for the visualization of the extractor structure and a user selection of the sub-structure.

21. A computer system including a processor and a computer program which when executed by the procssor cause the processor to execute a method for providing data from a data source to a data sink, the system further comprising:

the data sink;

a data sink application program for sending a first request to a data source, wherein the first request does not specify a specific entity of the data source requested by the data sink,

receiving a list of entities of the data source in response to the first request

sending a second request to the data source, the second request indicative of at least one of the entities,

receiving a first descriptor descriptive of an extractor structure of the at least one entity in response to the second request,

sending a data request to the data source, the data request indicative of the at least one entity and comprising a second descriptor descriptive of a sub-structure of the extractor structure of the at least one entity,

receiving the data from the data source, and presenting the data received from the data source to a user.

22. The computer system of claim 21, further comprising a user interface for visualizing the extractor structure and for enabling a user selection of the sub-structure.