Systems and methods for efficient data transfer

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.

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.

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.