| CPC G06F 40/18 (2020.01) | 9 Claims |
|
1. A system comprising:
a memory storing processor-executable program code;
a processing unit to execute the processor-executable program code to cause the system to:
identify a respective column name of each of a plurality of columns of a table comprising a plurality of rows including a header row comprising a plurality of column names;
automatically determine a hierarchical schema of the table by:
for each column name of the header row:
determine whether the column name of the header row includes a delimiter; and
in response to determination that the column name of the header row includes a delimiter, define a node of the hierarchical schema associated with a portion of the column name following the delimiter, the node being a child node of a parent node associated with a portion of the column name preceding the delimiter;
in response to determination that the column name of the header row does not include a delimiter, create a node associated with the column name at a highest hierarchical level of the schema;
for each row of the table:
determine a value associated with each of the plurality of columns;
create an instance of the hierarchical schema; and
populate the instance with the determined values; and
output the instances.
|