Versatile Data Model

摘要

Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for processing a data model, a data file and user input to provide a populated data model, the populated data model including: a data content table having one or more navigation columns and one or more content columns, at least one navigation column including one or more key values of a key node, and at least one content column including data values of a plurality of data values, and a foreign key table having one or more navigation columns and one or more relationship columns, at least one navigation column including one or more key values of a foreign key node, and the one or more relationship columns associating at least one key node of the data content table to a respective foreign key node.

主权项

1. A computer-implemented method for modeling data, the method being executed by one or more processors and comprising:
receiving, by the one or more processors, a data model, the data model comprising a hierarchical tree structure including a plurality of nodes, the plurality of nodes comprising a plurality of data nodes, a plurality of key nodes and one or more foreign key nodes, each foreign key node referencing a respective key node; receiving, by the one or more processors, a data file, the data file comprising a table having a plurality of columns and a plurality of data values; receiving, by the one or more processors, user input, the user input associating nodes of the plurality of nodes with respective columns of the plurality of columns; and processing the data model, the data file and the user input to provide a populated data model, the populated data model comprising:
a data content table having one or more navigation columns and one or more content columns, at least one navigation column comprising one or more key values of a key node, and at least one content column comprising data values of the plurality of data values, anda foreign key table having one or more navigation columns and one or more relationship columns, at least one navigation column comprising one or more key values of a foreign key node, and the one or more relationship columns associating at least one key node of the data content table to a respective foreign key node.