US 12,141,138 B1
Data access layer for translating between a data structure used by a first software program and a proxy table used by a second software program
Yongqiao Xiao, Cary, NC (US); and Patrick Nathan Koch, Morrisville, NC (US)
Assigned to SAS INSTITUTE INC., Cary, NC (US)
Filed by SAS Institute Inc., Cary, NC (US)
Filed on Mar. 8, 2024, as Appl. No. 18/599,342.
Claims priority of provisional application 63/546,206, filed on Oct. 28, 2023.
Claims priority of provisional application 63/539,756, filed on Sep. 21, 2023.
Int. Cl. G06F 16/2452 (2019.01); G06F 8/41 (2018.01)
CPC G06F 16/2452 (2019.01) [G06F 8/457 (2013.01)] 30 Claims
OG exemplary drawing
 
1. A computing device, comprising:
one or more processors; and
one or more memories including program code that is executable by the one or more processors to:
receive information about a data structure generated by a first software program and stored in a memory of the one or more memories, the data structure including a plurality of data entries, wherein the information about the data structure indicates a first set of properties for each data entry of the plurality of data entries, the first software program being stored in the one or more memories;
generate a proxy data table that includes a plurality of columns, each column having an associated second set of properties, the proxy data table being usable as a proxy for the data structure by a second software program, the second software program being stored in the one or more memories;
use a data access layer to generate a mapping that correlates the second set of properties of the plurality of columns of the proxy data table to the first set of properties of the plurality of data entries of the data structure, the data access layer being a third software program stored in the one or more memories;
receive an input to the second software program from the first software program indicating an operation to be performed by the second software program on the data structure;
in response to receiving the input:
instruct the second software program to perform the operation to generate a result, wherein:
the second software program is configured to issue read commands corresponding to the plurality of columns to the data access layer for performing the operation on the proxy data table; and
the data access layer is configured to obtain the plurality of data entries and provide the plurality of data entries to the second software program as responses to the read commands, wherein:
the data access layer is further configured to determine which of the plurality of data entries to provide in response to each of the read commands by performing a translation between the plurality of data entries and the plurality of columns based on the mapping; and
output, by the second software program, the result to the first software program.