# US 2020/0401580 A1 · Interaction between visualizations and other data controls in an information system by matching attributes in different datasets

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

- Number: US 2020/0401580 A1
- Document ID: US20200401580A1
- Status: Published application
- Kind: A1
- Application number: 16/446,943
- Filed: 2019-06-20
- Published: 2020-12-24
- Earliest claimed: 2019-06-20
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Gregory FITZPATRICK; Enam KHAN; Alban Pui Man TSUI; John KELLETT; Ramon Leonard Hendrik PISTERS; Colin Anthony MCLAY
- Web page: https://patentgrep.com/patent/US20200401580A1

## CPC

- G06F 16/248: Presentation of query results
- G06F 16/24578: {using ranking}
- G06F 16/288: {Entity relationship models}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A computer-implemented method includes analyzing a first dataset to extract metadata that corresponds to a first visualization; analyzing a second dataset to extract metadata; comparing the metadata of the datasets; deriving based on the comparing, a level of correlation between attributes of the datasets; establishing a score for each of the levels of correlation; determining that a first attribute of the first dataset and a first attribute of the second dataset are a match in response to the establishing of a score for the level of correlation of the first attributes of the datasets; determining that the datasets are related in response to the determining that the first attributes of the datasets are a match; and directing the displaying of a second visualization, the second visualization being a visual representation that includes data from the second dataset.

## Claims

### Claim 1

A computer-implemented method comprising:
analyzing, by a computer device, a first dataset to extract metadata of the first dataset, the first dataset corresponding to a first visualization;
analyzing, by the computer device, a second dataset to extract metadata of the second dataset;
comparing, by the computer device, the metadata of the first dataset to the metadata of the second dataset;
deriving, by the computer device, and based on the comparing, a level of correlation between attributes of the first dataset and attributes of the second dataset;
establishing, by the computer device, a score for each of the levels of correlation;
determining, by the computer device, that a first attribute of the first dataset and a first attribute of the second dataset are a match in response to the establishing of a score for the level of correlation of the first attribute of the first dataset and a first attribute of the second dataset;
determining, by the computer device, that the first dataset and the second dataset are related in response to the determining that the first attribute of the first dataset and the first attribute of the second dataset are a match; and
directing, by the computer device, the displaying of a second visualization, the second visualization being a visual representation that includes data from the second dataset.

### Claim 2 (depends on 1)

The computer-implemented method of claim 1, further comprising receiving, by the computer device, a selection by a user of the first attribute from the first visualization, the first visualization being a visual representation of data from the first dataset.

### Claim 3 (depends on 2)

The computer-implemented method of claim 2, wherein the directing comprises directing, by the computer device, the displaying of the second visualization on an electronic display device on which the first visualization was displayed.

### Claim 4 (depends on 1)

The computer-implemented method of claim 1, wherein the score of a first one of the levels of correlation is based on first criteria, the score of a second one of the levels of correlation is based on second criteria, and the first criteria and the second criteria are different.

### Claim 5 (depends on 1)

The computer-implemented method of claim 1, wherein the establishing of the scores is based on predetermined criteria.

### Claim 6 (depends on 1)

The computer-implemented method of claim 1, wherein the determining that the first attribute of the first dataset and the first attribute of the second dataset are a match is based on the score of the level of correlation of the first attribute of the first dataset and the first attribute of the second dataset being greater than a threshold score.

### Claim 7 (depends on 1)

The computer-implemented method of claim 1, wherein the comparing comprises fuzzy string matching of a name of the first attribute of the first dataset and a name of the first attribute of the second dataset.

### Claim 8 (depends on 1)

The computer-implemented method of claim 1, wherein the comparing comprises comparing a number of distinct values of the first attribute of the first dataset and a number of distinct values of the first attribute of the second dataset.

### Claim 9 (depends on 1)

The computer-implemented method of claim 1, further comprising
analyzing, by the computer device, a third dataset to extract metadata of the third dataset;
comparing, by the computer device, the metadata of the second dataset to the metadata of the third dataset;
deriving, by the computer device, and based on the comparing of the metadata of the second dataset to the metadata of the third dataset, a level of correlation between the attributes of the second dataset and attributes of the third dataset;
establishing, by the computer device, a score for each of the levels of correlation between the attributes of the second dataset and the attributes of the third dataset;
determining, by the computer device, that a second attribute of the second dataset and a first attribute of the third dataset are a match in response to the establishing of a score for a level of correlation of the second attribute of the second dataset and a first attribute of the second dataset; and
determining, by the computer device, that the second dataset and the third dataset are related in response to the determining that the second attribute of the second dataset and the first attribute of the third dataset are a match.

### Claim 10 (depends on 9)

The computer-implemented method of claim 9, further comprising directing, by the computer device, the displaying of a third visualization, the third visualization being a visual representation including data from the third dataset.

### Claim 11 (depends on 1)

The computer-implemented method of claim 1, wherein the computer device includes software provided as a service in a cloud computing environment.

### Claim 12

A computer program product, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computing device to cause the computing device to:
analyze a first dataset to extract metadata of the first dataset, the first dataset corresponding to a first visualization;
analyze a second dataset to extract metadata of the second dataset;
compare the metadata of the first dataset to the metadata of the second dataset;
derive, based on the comparing, a level of correlation between attributes of the first dataset and attributes of the second dataset;
establish a score for each of the levels of correlation;
determine that a first attribute of the first dataset and a first attribute of the second dataset are a match in response to the establishing of a score for the level of correlation of the first attribute of the first dataset and a first attribute of the second dataset; and
determine that the first dataset and the second dataset are related in response to the determining that the first attribute of the first dataset and the first attribute of the second dataset are a match.

### Claim 13 (depends on 12)

The computer program product of claim 12, further comprising program instructions executable by the computing device to cause the computing device to direct the displaying of a second visualization, the second visualization being a visual representation of data from the second dataset.

### Claim 14 (depends on 12)

The computer program product of claim 12, further comprising program instructions executable by the computing device to cause the computing device to:
analyze a third dataset to extract metadata of the third dataset;
compare the metadata of the second dataset to the metadata of the third dataset;
derive, based on the comparing of the metadata of the second dataset to the metadata of the third dataset, a level of correlation between the attributes of the second dataset and attributes of the third dataset;
establish a score for each of the levels of correlation between the attributes of the second dataset and the attributes of the third dataset;
determine that a second attribute of the second dataset and a first attribute of the third dataset are a match in response to the establishing of a score for the level of correlation of the second attribute of the second dataset and a first attribute of the second dataset; and
determine that the second dataset and the third dataset are related in response to the determining that the second attribute of the second dataset and the first attribute of the third dataset are a match.

### Claim 15 (depends on 14)

The computer program product of claim 14, further comprising program instructions executable by the computing device to cause the computing device to:
determine that the first dataset and the third dataset are related in response to the determining that the second attribute of the second dataset and the first attribute of the third dataset are a match.

### Claim 16 (depends on 15)

The computer program product of claim 15, wherein the first attribute of the second dataset and the second attribute of the second dataset are different.

### Claim 17

A system comprising:
a processor, a computer readable memory, and a computer readable storage medium;
program instructions to analyze a first dataset to extract metadata of the first dataset;
program instructions to analyze a second dataset to extract metadata of the second dataset;
program instructions to compare the metadata of the first dataset to the metadata of the second dataset;
program instructions to derive, based on the comparing, a level of correlation between attributes of the first dataset and attributes of the second dataset;
program instructions to establish a score for each of the levels of correlation;
program instructions to determine that a first attribute of the first dataset and a first attribute of the second dataset are a match in response to the establishing of a score for the level of correlation of the first attribute of the first dataset and a first attribute of the second dataset; and
program instructions to determine that the first dataset and the second dataset are related in response to the determining that the first attribute of the first dataset and the first attribute of the second dataset are a match,
wherein the program instructions are stored on the computer readable storage medium for execution by the processor via the computer readable memory.

### Claim 18 (depends on 17)

The system of claim 17, wherein the first dataset corresponds to a first visualization displayed on an electronic display device.

### Claim 19 (depends on 18)

The system of claim 18, further comprising:
program instructions to direct the displaying of a second visualization, the second visualization being a visual representation of data from the second dataset.

### Claim 20 (depends on 17)

The system of claim 17, further comprising program instructions that allow a user to manually override the determination that the first dataset and the second dataset are related.
