SYSTEMS AND METHODS FOR EFFICIENT DATA TRANSFER

• US 20120059856A1
• Filed: 10/14/2011
• Published: 03/08/2012
• 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,583,704 B2
• Time in Patent Office: Days
• US Class Current: 707/793
• 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-20. -20. (canceled)

21. 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 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 a null value at each null location determined in the analyzing of the row flag; and

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

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

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

24. The method of claim 21, 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.

25. The method of claim 24, 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.

26. The method of claim 21, wherein the receiving device is a universal data connector.

27. The method of claim 21, 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.

28. The method of claim 21, wherein the receiving device comprises an applet.

29. 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, and

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 a null value at each null location determined from the null location list.

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

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

32. The system of claim 29, 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.

33. The system of claim 32, 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.

34. The system of claim 29, 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.

35. 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 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 a null value at each null location determined from the null location list; and

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

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

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

38. The computer-readable storage medium of claim 35, 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.

39. The computer-readable storage medium of claim 38, 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.

40. The computer-readable storage medium of claim 35, 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.