Mapping of Extensible Datasets to Relational Database Schemas

摘要

Data including a text file is received. The text file is arranged in an extensible format and includes a plurality of metadata lines, a header line, and a plurality of content lines. Metadata from the metadata lines is mapped to a plurality of metadata tables in a database that are formed according to a relational database schema using prefix parameters from each metadata line. Content from the content lines is mapped to a plurality of content tables in the database that are formed according to the relational database schema using the header line. A first subset of the content tables have a static structure and a second subset of the content tables have a dynamic structure. Related apparatus, systems, techniques and articles are also described.

主权项

1. A computer implemented method comprising:
receiving data comprising a text file, the text file being arranged in an extensible format and comprising a plurality of metadata lines, a header line, and a plurality of content lines; mapping metadata from the metadata lines to a plurality of metadata tables in a database that are formed according to a relational database schema using prefix parameters from each metadata line; and mapping content from the content lines to a plurality of content tables in the database that are formed according to the relational database schema using the header line, wherein a first subset of the content tables have a static structure and a second subset of the content tables have a dynamic structure.