Systems and methods for efficient data transfer

• US 8,583,704 B2
• Filed: 10/14/2011
• Issued: 11/12/2013
• Est. Priority Date: 10/01/2008
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kreibe, Martin, Simon, Francis
• Primary Examiner(s): Troung, Cam
• Application Number:
  US13/274,169
• Publication Number:
  US 20120059856A1
• Time in Patent Office: 760 Days
• Field of Search: 707/803, 707/809, 707/102
• US Class Current: 707/803
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

A system and method for transferring data are provided. The method comprises: 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 in accordance with the table block; and providing 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 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 the analyzing of the data 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 a presence of the null values, further analyzing the null location list to determine location information for the non-null data and the 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 the null values at null locations determined in the analyzing of the row flag, the number of columns in the table block being equal to the combined number of the null values and the non-null data in the at least one mapped data row; and

processing the at least one 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 after the table block, and wherein the method further comprises:

determining based on the final status block whether the table block received by the receiving device is complete.

5. The method of claim 4, wherein determining whether the table block received by the receiving device is complete further comprises reading a user message in the final status block including a severity flag and a message in the final status block describing that the table block is complete.

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

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

8. 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 system comprising:

a processor; and

a memory for storing program instructions which, when executed, cause the receiving device to;

analyze the data result model to regenerate data for storage at the receiving device;

read 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;

determine the number of columns in the table block from the column definition;

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

create at least one mapped data row by sequentially inserting the non-null data from the row payload field at non-null locations and inserting the null values at null locations determined from the null location list, the number of columns in the table block being equal to the combined number of the null values and the non-null data in the at least one mapped data row; and

process the at least one mapped data row to provide the regenerated data for storage at the receiving device.

9. The system of claim 8, wherein the memory comprises instructions which, when executed, further cause the receiving device to process the at least one mapped data row to provide the regenerated data for storage at the receiving device.

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

11. The system of claim 8, wherein the data result model further includes a final status block after the table block, and wherein the memory comprises instructions which, when executed, further cause the receiving device to:

determine based on the final status block whether the table block received by the receiving device is complete.

12. The system of claim 11, wherein the memory comprises instructions which, when executed, further cause the receiving device to read a user message in the final status block including a severity flag and a message in the final status block describing that the table block is complete.

13. A non-transitory 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 the analyzing of the data 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 a presence of the null values, further analyzing the null location list to determine location information for the non-null data and the 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 the null values at null locations determined from the null location list, the number of columns in the table block being equal to the combined number of the null values and the non-null data in the at least one mapped data row; and

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

14. The non-transitory computer-readable storage medium of claim 13, wherein the number of columns in the table block is expandable to any number.

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

16. The non-transitory computer-readable storage medium of claim 13, wherein the data result model further includes a final status block after the table block, and wherein the method further comprises:

determining based on the final status block whether the table block received by the receiving device is complete.

17. The non-transitory computer-readable storage medium of claim 16, wherein determining whether the table block is complete further comprises reading a user message in the final status block including a severity flag and a message in the final status block describing that the table block is complete.