Converting structured data into database entries
Systems and methods for converting structured data into database entries include receiving data values and metadata elements that form a data structure for the data values. The data values are converted into entries in database tables that are related according to the data structure formed by the metadata elements. The database table entries may be used to generate a webpage configured to report a metric of the data values.
1. A computerized method of converting structured data into entries in a database comprising:
providing a webpage having a first input feature configured to add or remove attribute data values and a second input feature configured to add or remove elements to construct a metadata structure for the attribute data values, the webpage being configured to convert the attribute data values and metadata structure into Extensible Markup Language (XML) format for a single structured data file;
receiving the single structured data file;
converting the single structured data file into a plurality of database tables for a database, the conversion of the single structured data file comprising:
generating a metadata database table, each entry of the metadata database table based on an element of the elements of the constructed metadata structure of the single structured data file;
generating, for each entry of the metadata database table, a separate database table, each of the separate database tables being related according to constructed metadata structure for the attribute data values, at least one separate database table references another separate database table;
retrieving one or more attribute data values from the plurality of database tables based on a defined application context for generating a reporting or data analysis webpage;
generating the reporting or data analysis webpage based on the retrieved one or more attribute data values and the defined application context; and
providing the reporting or data analysis webpage to report a metric based on the retrieved one or more attribute data values.
2. The method of claim 1 , further comprising:
parsing the single structured data file to identify an element of the elements of the constructed metadata structure.
3. The method of claim 2 , further comprising:
using a Simple Application Programming Interface for XML (SAX) parser to parse the single structured data file.
4. The method of claim 1 , wherein the webpage having the first input feature and the second input feature and the reporting or data analysis webpage are provided by the same online service.
5. The method of claim 1 , further comprising:
preventing creating of an entry for an attribute data value in the database tables based on a determination that an account has insufficient permissions to add attribute data values to the database.
6. The method of claim 1 , further comprising:
storing the retrieved attribute data values in a cache memory associated with the application context; and
using the stored attribute data values to generate the reporting or data analysis webpage.
7. The method of claim 6 , further comprising:
refreshing the attribute data values stored in the cache memory responsive to an action request of the application context; and
using the refreshed attribute data values to update the reporting or data analysis webpage.