SYSTEMS AND METHODS FOR EFFICIENT DATA TRANSFER

• US 20100082581A1
• Filed: 10/01/2008
• Published: 04/01/2010
• Est. Priority Date: 10/01/2008
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: KREIBE, Martin, Simon, Francis
• Granted Patent: US 8,065,341 B2
• Time in Patent Office: Days
• US Class Current: 707/706
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

Systems and methods are provided for transferring data. In one implementation, a method is provided for transferring data between a sending device (e.g., a server) and a receiving device (e.g., a client). The method may include sending, from the receiving device, a data query to request data from the sending device and receiving, form the sending device, a data result model in response to the data query. The data result model may include a table block. The method may also include analyzing the data result model to regenerate the data for storage at the receiving device. Analyzing the data result model may comprises reading at least one column definition and at least one data row from the table block, the data row including a row flag, a null location list, and a row payload field including the non-null data to be transferred to the receiving device. The method may further include processing each mapped data row to provide the regenerated data for storage at the receiving device.

Claims

1. A method for transferring data, the method comprising:

sending, from a receiving device, a data query to request the data from a sending device;

receiving, from the sending device, a result model in response to the data query, the data result model including a table block;

analyzing the data result model to regenerate the data for storage at the receiving device, wherein analyzing the result model comprises;

reading at least one column definition and at least one data row from the table block, the data row including a row flag, a null location list, and a row payload field including the non-null data to be transferred to the receiving device,

determining the number of columns in the table block from the column definition,

analyzing the row flag to determine whether the data row includes null values and, when the row flag indicates the presence of null values, further analyzing the null location list to determine location information for non-null and null values, and

creating at least one mapped data row by sequentially inserting the non-null data from the row payload field at non-null locations and inserting a null value at each null location determined in the analyzing step; and

processing each mapped data row to provide the regenerated data for storage at the receiving device.

2. The method of claim 1, wherein the number of columns in the table block is expandable to any number.

3. The method of claim 1, wherein the column definition includes predetermined metadata fields and extended metadata fields.

4. The method of claim 1, wherein the data result model further includes a final status block transferred after the table block is completed, and wherein the method further comprises reading, at the receiving device, the final status block and determining the success of the data transferred from the sending device.

5. The method of claim 4, wherein determining the success of the data transfer further comprises reading a user message including a severity flag followed by a message describing the success of the data transfer.

6. The method of claim 1, wherein the receiving device is a universal data connector.

7. The method of claim 1, wherein the determined number of columns in the table block is equal to the combined number of null and non-null data values in the at least one mapped data row.

8. The method of claim 1, wherein the receiving device comprises an applet.

9. A system for transferring data from a sending device to a receiving device, the sending device providing a data result model in response to a data query from the receiving device, the data result model including a table block, wherein the receiving device includes:

means for analyzing the data result model to regenerate the data for storage at the receiving device, the means for analyzing comprising;

means for reading at least one column definition and at least one data row from the table block, the data row including a row flag, a null location list, and a row payload field including the non-null data to be transferred to the receiving device,

means for determining the number of columns in the table block from the column definition,

means for analyzing the row flag to determine whether the data row includes null values and, when the row flag indicates the presence of null values, further analyzing the null location list to determine location information for non-null and null values, and

means for creating at least one mapped data row by sequentially inserting the non-null data from the row payload field at non-null locations and inserting a null value at each null locations determined from the null location list.

10. The system of claim 9, further comprising means for processing each mapped data row to provide the regenerated data for storage at the receiving device.

11. The system of claim 9, wherein the column definition includes predetermined metadata fields and extended metadata fields.

12. The system of claim 9, wherein the data result model further includes a final status block transferred after the table block is completed, and wherein the system further comprises means for reading the final status block and determining the success of the data transferred from the sending device.

13. The system of claim 12, further comprising means for reading a user message including a severity flag followed by a message describing the success of the data transfer.

14. The system of claim 9, wherein the determined number of columns in the table block is equal to the combined number of null and non-null data values in the at least one mapped data row.

15. A computer-readable storage medium comprising instructions, which when executed on a processor, cause the processor to perform a method for transferring data, the method comprising:

sending, from a receiving device, a data query to request data from a sending device;

receiving, from the sending device, a data result model in response to the data query, the data result model including a table block;

analyzing the data result model to regenerate the data for storage at the receiving device, wherein analyzing the result model comprises;

reading at least one column definition and at least one data row from the table block, the data row including a row flag, a null location list, and a row payload field including non-null data to be transferred to the receiving device,

determining the number of columns in the table block from the column definition,

analyzing the row flag to determine whether the data row includes null values and, when the row flag indicates the presence of null values, further analyzing the null location list to determine location information for non-null and null values, and

creating at least one mapped data row by sequentially inserting the non-null data of the row payload field at non-null locations and inserting a null value at each null locations determined from the null location list; and

processing each mapped data row to provide the regenerated data for storage at the receiving device.

16. The computer-readable storage medium of claim 15, wherein the number of columns in the table block is expandable to any number.

17. The computer-readable storage medium of claim 15, wherein the column definition includes predetermined metadata fields and extended metadata fields.

18. The computer-readable storage medium of claim 15, wherein the data result model further includes a final status block transferred after the table block is completed, and wherein the method further comprises reading, at the receiving device, the final status block and determining the success of the data stream transferred from the sending device.

19. The computer-readable storage medium of claim 18, wherein determining the success of the data transfer further comprises reading a user message including a severity flag followed by a message describing the success of the data transfer.

20. The computer-readable storage medium of claim 15, wherein the determined number of columns in the table block is equal to the combined number of null and non-null data values in the at least one mapped data row.