Dynamic modeling of data in relational databases

A system for processing data, comprising:

• one or more processors configured to execute an application, the application configured to:
• enable access to a data model including one or more tables, wherein the one or more tables comprise a set of scalar fields and a derived field associated with at least one of a summary, a formula, and a lookup, and wherein the derived field comprises identifying information of at least one related field or table in the data model or in a relational database;
• and
• store the scalar fields in the relational database;
• and
• a query builder configured to:
• use the data model to generate a first query for the relational database to obtain data associated with the derived field using one or more joins of one or more of the scalar fields based at least in part on the identifying information;
• and
• enable use of the first query to provide the data to a user during use of the application by the user.

A non-transitory computer-readable storage medium storing instructions that when executed by a computer cause the computer to perform a method for processing data, the method comprising:

• executing an application that accesses a data model including one or more tables, wherein the one or more tables comprise a set of scalar fields and a derived field associated with at least one of a summary, a formula, and a lookup, and wherein the derived field comprises identifying information of at least one related field or table in the data model or in a relational database;
• storing the scalar fields in the relational database;
• using the data model to generate a first query for the relational database to obtain data associated with the derived field using one or more joins of one or more of the scalar fields based at least in part on the identifying information;
• and
• enabling use of the first query to provide the data to a user during use of the application by the user.