US 12,292,863 B2
Metadata-based generic parsing
Roberto Usberti Filho, Ladenburg (DE); Nishant Gopinath, Wayne, PA (US); and Vladimir Wasiutinski, Dresden (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jan. 12, 2022, as Appl. No. 17/574,430.
Prior Publication US 2023/0222104 A1, Jul. 13, 2023
Int. Cl. G06F 16/21 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/212 (2019.01) [G06F 16/288 (2019.01)] 19 Claims
OG exemplary drawing
 
1. A method comprising:
receiving a data object comprising a plurality of members organized according to a first structure, each member having data and associated metadata;
referencing logic to generate a schema representing the first structure;
storing the schema in a non-transitory computer readable storage medium;
referencing the logic and the schema to parse the data into a relational database table different from the first structure; and
ingesting the data to the relational database table in the non-transitory computer readable storage medium;
wherein generating the schema comprises generating statements to generate table and column names based on member names of the object data during a runtime, and
wherein ingesting the data comprises reading the metadata to address data values from the data object to trigger writes to the relational database table during the runtime,
wherein scalar elements in the data object are stored in a master relational table and associated with an identification stamp comprising a unique identification of the data object, and wherein vector or array elements of the data object are stored in one or more secondary relational tables having a plurality of rows associated with the master relational table by the identification stamp as a foreign key containing an index as a primary key paired with an attribute identifier for each particular vector or array member, wherein different vector or array elements are stored in different secondary relational tables.