Interactive data modeling

A processor readable non-transitory storage media that includes instructions for managing data models, wherein execution of the instructions by one or more processors, performs actions, comprising:

• providing a data source that includes one or more records, wherein one or more portions of the data source are denormalized;
• determining one or more source fields based on the one or more records, wherein the one or more source fields are displayed in a source panel on a user interface (UI);
• displaying a data model that includes at least one source data object that is based on the one or more source fields;
• determining one or more relationships between the one or more source fields based on one or more values in the one or more records, wherein each relationship includes a key field and one or more data fields, and wherein each of the key fields and the one or more data fields for different relationships correspond to different source fields;
• displaying the one or more relationships in a relationship panel;
• and
• in response to providing a relationship between the one or more source fields in the relationship panel, performing further actions, including:
• determining a provided key field and one or more provided data fields based on the provided relationship;
• generating a data object that includes another key field and one or more other data fields, wherein the other key field corresponds to the provided key field and the one or more other data fields correspond to the one or more provided data fields;
• and
• modifying the data model to include the data object and to remove the one or more source fields that correspond to the one or more other data fields, wherein the modified data model is displayed to a user.

A system for managing data models:

• a network computer, comprising:
• a transceiver that communicates over the network;
• a memory that stores at least instructions;
• and
• one or more processors that execute instructions that perform actions, including:
• providing a data source that includes one or more records, wherein one or more portions of the data source are denormalized;
• determining one or more source fields based on the one or more records, wherein the one or more source fields are displayed in a source panel on a user interface (UI);
• displaying a data model that includes at least one source data object that is based on the one or more source fields;
• determining one or more relationships between the one or more source fields based on one or more values in the one or more records, wherein each relationship includes a key field and one or more data fields, and wherein each of the key fields and the one or more data fields for different relationships correspond to different source fields;
• displaying the one or more relationships in a relationship panel;
• and
• in response to providing a relationship between the one or more source fields in the relationship panel, performing further actions, including:
• determining a provided key field and one or more provided data fields based on the provided relationship;
• generating a data object that includes another key field and one or more other data fields, wherein the other key field corresponds to the provided key field and the one or more other data fields correspond to the one or more provided data fields;
• and
• modifying the data model to include the data object and to remove the one or more source fields that correspond to the one or more other data fields, wherein the modified data model is displayed to a user;
• and a client computer, comprising:
• a transceiver that communicates over the network;
• a memory that stores at least instructions;
• and
• one or more processors that execute instructions that perform actions, including:
• displaying the modified data model on a hardware display.

A network computer for managing data models, comprising:

• a transceiver that communicates over the network;
• a memory that stores at least instructions;
• and
• one or more processors that execute instructions that perform actions, including:
• providing a data source that includes one or more records, wherein one or more portions of the data source are denormalized;
• determining one or more source fields based on the one or more records, wherein the one or more source fields are displayed in a source panel on a user interface (UI);
• displaying a data model that includes at least one source data object that is based on the one or more source fields;
• determining one or more relationships between the one or more source fields based on one or more values in the one or more records, wherein each relationship includes a key field and one or more data fields, and wherein each of the key fields and the one or more data fields for different relationships correspond to different source fields;
• displaying the one or more relationships in a relationship panel;
• and
• in response to providing a relationship between the one or more source fields in the relationship panel, performing further actions, including:
• determining a provided key field and one or more provided data fields based on the provided relationship;
• generating a data object that includes another key field and one or more other data fields, wherein the other key field corresponds to the provided key field and the one or more other data fields correspond to the one or more provided data fields;
• and
• modifying the data model to include the data object and to remove the one or more source fields that correspond to the one or more other data fields, wherein the modified data model is displayed to a user.