# US 2022/0035774 A1 · Interactive data modeling

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2022/0035774 A1
- Document ID: US20220035774A1
- Status: Published application
- Kind: A1
- Application number: 16/944,043
- Filed: 2020-07-30
- Published: 2022-02-03
- Earliest claimed: 2020-07-30
- Assignees: Tableau Software, Inc.
- Applicants: Tableau Software, LLC
- Inventors: Michael John Arvold; Ross Thomas Bunker; Daniel Phillip Cory; Daniel William DeKlotz; Vivek Anup Maharajh; Britta Claire Nielsen; Douglas Alan Thomae
- Web page: https://patentgrep.com/patent/US20220035774A1

## CPC

- G06F 16/212: {with details for data modelling support}
- G06F 16/215: Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
- G06F 16/2423: {Interactive query statement specification based on a database schema}
- G06F 16/24578: {using ranking}
- G06F 16/211: {Schema design and management}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Embodiments are directed to managing data models. A data source that includes records may be provided. Source fields may be determined based on the records and the source fields may be displayed in a source panel. A data model that includes a source data object may be displayed. Relationships between the source fields may be determined based on values in the records. In response to providing a relationship between the source fields, a data object that includes a key field and one or more data fields that correspond to the relationship may be generated. The data model may be modified to include the data object and to remove the source fields that correspond to the data fields.

## Claims

### Claim 1

A method for managing data models using one or more processors that execute instructions to perform 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.

### Claim 2 (depends on 1)

The method of claim 1, wherein determining the one or more relationships, further comprises:
employing one or more evaluators to identify one or more redundant fields in the one or more records; and
determining a portion of the one or more relationships based on the one or more redundant fields.

### Claim 3 (depends on 1)

The method of claim 1, further comprising:
determining one or more conflicts in the data model or the modified data model based on one or more of the selected key fields or the one or more selected data fields being included in a data object in the data model or in the modified data model; and
modifying an appearance of the data model or the modified data model to indicate the presence of the one or more conflicts.

### Claim 4 (depends on 1)

The method of claim 1, wherein determining the one or more relationships, further comprises:
associating a confidence score with each of the one or more relationships, wherein the confidence score is determined based on a strength of the one or more relationships;
employing the confidence score to rank order the one or more relationships; and
omitting a portion of the one or more relationships from the relationship panel, wherein the score associated with of the omitted portion of the one or more relationships is less than a threshold value.

### Claim 5 (depends on 1)

The method of claim 1, further comprises, determining the one or more records based on sampling the data source, wherein the one or more records are representative of the data source.

### Claim 6

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.

### Claim 7 (depends on 6)

The media of claim 6, wherein determining the one or more relationships, further comprises:
employing one or more evaluators to identify one or more redundant fields in the one or more records; and
determining a portion of the one or more relationships based on the one or more redundant fields.

### Claim 8 (depends on 6)

The media of claim 6, further comprising:
determining one or more conflicts in the data model or the modified data model based on one or more of the selected key fields or the one or more selected data fields being included in a data object in the data model or in the modified data model; and
modifying an appearance of the data model or the modified data model to indicate the presence of the one or more conflicts.

### Claim 9 (depends on 6)

The media of claim 6, wherein determining the one or more relationships, further comprises:
associating a confidence score with each of the one or more relationships, wherein the confidence score is determined based on a strength of the one or more relationships;
employing the confidence score to rank order the one or more relationships; and
omitting a portion of the one or more relationships from the relationship panel, wherein the score associated with of the omitted portion of the one or more relationships is less than a threshold value.

### Claim 10 (depends on 6)

The media of claim 6, further comprises, determining the one or more records based on sampling the data source, wherein the one or more records are representative of the data source.

### Claim 11

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.

### Claim 12 (depends on 11)

The system of claim 11, wherein determining the one or more relationships, further comprises:
employing one or more evaluators to identify one or more redundant fields in the one or more records; and
determining a portion of the one or more relationships based on the one or more redundant fields.

### Claim 13 (depends on 11)

The system of claim 11, further comprising:
determining one or more conflicts in the data model or the modified data model based on one or more of the selected key fields or the one or more selected data fields being included in a data object in the data model or in the modified data model; and
modifying an appearance of the data model or the modified data model to indicate the presence of the one or more conflicts.

### Claim 14 (depends on 11)

The system of claim 11, wherein determining the one or more relationships, further comprises:
associating a confidence score with each of the one or more relationships, wherein the confidence score is determined based on a strength of the one or more relationships;
employing the confidence score to rank order the one or more relationships; and
omitting a portion of the one or more relationships from the relationship panel, wherein the score associated with of the omitted portion of the one or more relationships is less than a threshold value.

### Claim 15 (depends on 11)

The system of claim 11, further comprises, determining the one or more records based on sampling the data source, wherein the one or more records are representative of the data source.

### Claim 16

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.

### Claim 17 (depends on 16)

The network computer of claim 16, wherein determining the one or more relationships, further comprises:
employing one or more evaluators to identify one or more redundant fields in the one or more records; and
determining a portion of the one or more relationships based on the one or more redundant fields.

### Claim 18 (depends on 16)

The network computer of claim 16, further comprising:
determining one or more conflicts in the data model or the modified data model based on one or more of the selected key fields or the one or more selected data fields being included in a data object in the data model or in the modified data model; and
modifying an appearance of the data model or the modified data model to indicate the presence of the one or more conflicts.

### Claim 19 (depends on 16)

The network computer of claim 16, wherein determining the one or more relationships, further comprises:
associating a confidence score with each of the one or more relationships, wherein the confidence score is determined based on a strength of the one or more relationships;
employing the confidence score to rank order the one or more relationships; and
omitting a portion of the one or more relationships from the relationship panel, wherein the score associated with of the omitted portion of the one or more relationships is less than a threshold value.

### Claim 20 (depends on 16)

The network computer of claim 16, further comprises, determining the one or more records based on sampling the data source, wherein the one or more records are representative of the data source.
