Interaction between visualizations and other data controls in an information system by matching attributes in different datasets

Patent metadata

Field	Value
Publication number	US-11269905-B2
Application number	US-201916446943-A
Country	US
Kind code	B2
Filing date	Jun 20, 2019
Priority date	Jun 20, 2019
Publication date	Mar 8, 2022
Grant date	Mar 8, 2022

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.

First claim

What is claimed is:

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 presented to a user on an electronic display device, wherein the metadata of the first dataset includes a range of characteristics for attributes of the first dataset;
analyzing, by the computer device, a second dataset to extract metadata of the second dataset, wherein the metadata of the second dataset includes a range of characteristics for attributes of the second dataset, wherein the computer device is configured to access the first and second dataset from both a same storage location and a different storage location, and wherein the computer device is configured to access the first and second dataset both with a same format and a different format;
comparing, using a heuristic method, 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
providing to the user, by the computer device, a second visualization on the electronic display device, the second visualization being a visual representation that includes data from the second dataset, responsive to the determining that the first dataset and the second dataset are related.

2. 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.

3. The computer-implemented method of claim 2 , wherein the providing comprises directing, by the computer device, the displaying of the second visualization on the electronic display device on which the first visualization was displayed, wherein both the first visualization and second visualization are concurrently displayed on the electronic display within an interactive user interface.

4. 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.

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

6. 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.

7. The computer-implemented method of claim 1 , wherein the heuristic method 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.

8. 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.

9. The computer-implemented method of claim 1 , further comprising
analyzing, by the computer device, a third dataset to extract metadata of the third dataset wherein the metadata of the third dataset includes a range of characteristics for attributes of the third dataset, wherein the computer device is configured to access the first, second and third dataset from a combination of a same storage location and a different storage location, and wherein the computer device is configured to access the first, second and third dataset with any combination of a same format and a different format;
comparing using a heuristic method, 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.

10. The computer-implemented method of claim 9 , further comprising providing to the user, by the computer device, a third visualization on the electronic display device, the third visualization being a visual representation including data from the third dataset, responsive to the determining that the second dataset and the third dataset are related.

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

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 presented to a user on an electronic display device;
analyze a second dataset to extract metadata of the second dataset, wherein the program instructions are configured to access the first and second dataset from both a same storage location and a different storage location, and wherein the program instructions are configured to access the first and second dataset both with a same format and a different format;
compare, using a heuristic method, the metadata of the first dataset to the metadata of the second dataset, wherein the comparing includes performing 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;
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;
determine that the first dataset and the secon

Assignees

• IBM

Inventors

• Fitzpatrick Gregory
• Khan Enam
• Tsui Alban Pui Man
• Kellett John
• Pisters Ramon Leonard Hendrik
• Mclay Colin Anthony

Classifications

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F16/288 Primary

  Entity relationship models · CPC title

• G06F16/24578

  using ranking · CPC title