Storing Metadata in a Table-based Format from Metadata in a Serial Format
In one embodiment, a method receives a document including metadata in a serial format and parses the document to determine components in the metadata, a nested structure of the components, and an order of the components in the data. The metadata is stored in a table format where columns of the table define the nested structure of the components and the order of the components in the data. A query is received for the data. The method determines components from the metadata stored in the table format from the columns that satisfy the query where the components are determined based on the nested structure of the determined components and the order of the determined components from information in the columns of the table. A result for the query is output including the determined components based on the nested structure of the determined components and the order of the determined components.
1 . A method comprising:
receiving, by a computing device, a document including metadata in a serial format;
parsing, by the computing device, the document to determine components in the metadata, a nested structure of the components, and an order of the components in the data;
storing, by the computing device, the metadata in a table format, wherein columns of the table define the nested structure of the components and the order of the components in the data;
receiving, by the computing device, a query for the data;
determining, by the computing device, components from the metadata stored in the table format from the columns of the table that satisfy the query, wherein the components are determined based on the nested structure of the determined components and the order of the determined components from information in the columns of the table; and
outputting, by the computing device, a result for the query, the result including the determined components based on the nested structure of the determined components and the order of the determined components.
2 . The method of claim 1 , wherein determining the components comprises executing a procedure to determine tables in the data, wherein the tables are in a nested structure.
3 . The method of claim 2 , wherein a layer depth of tables that are determined are based on a layer restriction on a number of nested layers to determine.
4 . The method of claim 1 , wherein determining the components comprises executing a procedure to determine components for a table in an order.
5 . The method of claim 4 , wherein the components comprise tables and columns in the order.
6 . The method of claim 1 , further comprising:
adding a component to the data, wherein the added component changes at least one of the nested structure of the components and the order of the components in the data; and
adjusting the metadata in the table format such that the columns of the table represent the changes to the at least one of the nested structure of the components and the order of the components in the data.
7 . The method of claim 1 , further comprising:
deleting a component to the data, wherein the deleted component changes at least one of the nested structure of the components and the order of the components in the data; and
adjusting the metadata in the table format such that the columns of the table represent the changes to the at least one of the nested structure of the components and the order of the components in the data.
8 . The method of claim 1 , wherein the columns comprises a parent table identifier column that identifies a parent of a component, a previous component identifier column that identifies a previous component in the order for the component, a previous component type that identifies a type of the previous component, a next component identifier column that identifies a next component in the order for the component, a next component type that identifies a type of the next component.
9 . The method of claim 1 , wherein the nested structure includes a table that includes sub-tables and columns.
10 . A non-transitory computer-readable storage medium containing instructions, that when executed, control a computer system to be configured for:
receiving a document including metadata in a serial format;
parsing the document to determine components in the metadata, a nested structure of the components, and an order of the components in the data;
storing the metadata in a table format, wherein columns of the table define the nested structure of the components and the order of the components in the data;
receiving a query for the data;
determining components from the metadata stored in the table format from the columns of the table that satisfy the query, wherein the components are determined based on the nested structure of the determined components and the order of the determined components from information in the columns of the table; and
outputting a result for the query, the result including the determined components based on the nested structure of the determined components and the order of the determined components.
11 . The non-transitory computer-readable storage medium of claim 10 , wherein determining the components comprises executing a procedure to determine tables in the data, wherein the tables are in a nested structure.
12 . The non-transitory computer-readable storage medium of claim 11 , wherein a layer depth of tables that are determined are based on a layer restriction on a number of nested layers to determine.
13 . The non-transitory computer-readable storage medium of claim 10 , wherein determining the components comprises executing a procedure to determine components for a table in an order.
14 . The non-transitory computer-readable storage medium of claim 13 , wherein the components comprise tables and columns in the order.
15 . The non-transitory computer-readable storage medium of claim 10 , further configured for:
adding a component to the data, wherein the added component changes at least one of the nested structure of the components and the order of the components in the data; and
adjusting the metadata in the table format such that the columns of the table represent the changes to the at least one of the nested structure of the components and the order of the components in the data.
16 . The non-transitory computer-readable storage medium of claim 10 , further configured for:
deleting a component to the data, wherein the deleted component changes at least one of the nested structure of the components and the order of the components in the data; and
adjusting the metadata in the table format such that the columns of the table represent the changes to the at least one of the nested structure of the components and the order of the components in the data.
17 . The non-transitory computer-readable storage medium of claim 10 , wherein the columns comprises a parent table identifier column that identifies a parent of a component, a previous component identifier column that identifies a previous component in the order for the component, a previous component type that identifies a type of the previous component, a next component identifier column that identifies a next component in the order for the component, a next component type that identifies a type of the next component.
18 . The non-transitory computer-readable storage medium of claim 10 , wherein the nested structure includes a table that includes sub-tables and columns.
19 . An apparatus comprising:
one or more computer processors; and
a non-transitory computer-readable storage medium comprising instructions, that when executed, control the one or more computer processors to be configured for:
receiving a document including metadata in a serial format;
parsing the document to determine components in the metadata, a nested structure of the components, and an order of the components in the data;
storing the metadata in a table format, wherein columns of the table define the nested structure of the components and the order of the components in the data;
receiving a query for the data;
determining components from the metadata stored in the table format from the columns of the table that satisfy the query, wherein the components are determined based on the nested structure of the determined components and the order of the determined components from information in the columns of the table; and
outputting a result for the query, the result including the determined components based on the nested structure of the determined components and the order of the determined components.
20 . The apparatus of claim 19 , wherein the columns comprises a parent table identifier column that identifies a parent of a component, a previous component identifier column that identifies a previous component in the order for the component, a previous component type that identifies a type of the previous component, a next component identifier column that identifies a next component in the order for the component, a next component type that identifies a type of the next component.