System and method for visualizing data

• US 10,353,909 B2
• Filed: 01/25/2016
• Issued: 07/16/2019
• Est. Priority Date: 01/25/2016
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gibson, Stephen D., Mostafa, Mohammed, Watts, Graham A.
• Primary Examiner(s): Gofman, Alex
• Application Number:
  US15/005,344
• Publication Number:
  US 20170212941A1
• Time in Patent Office: 1,268 Days
• Field of Search: None
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

Techniques are described for selecting, based on a data visualization intent specification and a defined set of data fields associated with a set of data, two or more Meta templates that meet the data visualization intent specification and that support the set of data fields, for determining chart parts that can be used within the selected Meta templates to form chart templates and for determining, based on a set of combination rules and the specification, the chart templates that meet the data visualization intent specification.

Claims

1. A method, comprising:

identifying, via a user interface, a dataset having two or more data fields;

defining, via the user interface, a data visualization intent specification for the dataset, the data visualization intent specification including one or more data visualization intent specification entries, each data visualization intent specification entry including an intent type and data field identifiers identifying a set of two of more data fields selected from the data fields of the dataset, wherein each data visualization intent specification entry defines, via the intent type, a desired type of data analysis in a data visualization of data from the set of two or more data fields identified in the data visualization intent specification entry, the desired type of data analysis selected from a group of data analysis types including a compare type and trend type;

selecting, with one or more processing devices, based on the intent type of the data visualization intent specification entry, Meta templates that meet the intent type of the data visualization intent specification entry and that support the set of two or more data fields;

determining, with the one or more processing devices and for each selected Meta template, chart parts to be assigned to each of the selected Meta templates, the combination of each selected Meta template with the chart parts assigned to that selected Meta template forming a chart template associated with that selected Meta template; and

selecting, with the one or more processing devices and based on a set of combination rules and on the data visualization intent specification, one or more of the chart templates associated with the selected Meta templates.

2. The method of claim 1, wherein each Meta template includes a plurality of template fields and a layout mode, wherein the plurality of template fields includes a plurality of chart part type fields, wherein each of the chart parts includes restrictions limiting the chart parts to certain chart part type fields and wherein the layout mode defines how the chart parts associated with the chart part type fields are laid out in a data visualization corresponding to the selected Meta template.

3. The method of claim 2, wherein the layout mode defines, for each template field, a relationship between the template field and a layout model.

4. The method of claim 1, wherein one or more of the Meta templates is a complex Meta template, wherein each complex Meta template includes one or more Meta templates and a layout mode defining positioning of the included one or more Meta templates.

5. The method of claim 4, wherein the complex Meta templates define combinations of two or more charts associated with the data set.

6. The method of claim 1, wherein one or more of the Meta templates is a complex Meta template, wherein each complex Meta template includes one or more template fields, one or more Meta templates and a layout mode defining positioning of the included one or more template fields and the included one or more Meta templates.

7. The method of claim 1, wherein determining chart parts that can be used with the selected Meta templates includes defining a knowledge base of chart parts that can be used with the Meta templates to produce defined chart templates.

8. The method of claim 7, wherein each chart part includes a definition of types of data to which it can be applied.

9. The method of claim 8, wherein each chart part includes limitations on the Meta templates with which the chart part can be used.

10. The method of claim 1, wherein the set of combination rules includes validation and scoring rules that score and validate combinations of chart parts used to solve a particular problem.

11. The method of claim 1, wherein the set of combination rules includes validation and scoring rules that score and validate combinations of chart parts used to solve a particular problem and wherein selecting chart templates includes generating a fitness score based on the selected chart parts and the set of scoring rules.

12. The method of claim 1, wherein determining chart parts that can be used with the selected Meta templates includes defining a knowledge base of chart parts that can be used with each of the Meta templates to produce chart templates,

wherein the set of combination rules includes validation and scoring rules that score and validate combinations of chart parts used to solve a particular problem, and

wherein selecting chart templates includes generating a fitness score based on the selected chart parts and the set of scoring rules.

13. A computer program product comprising a computer-readable storage medium having program code embodied therewith, the program code executable by a computing device to:

identify, via a user interface, a dataset having two or more data fields;

define, via the user interface, a data visualization intent specification for the dataset, the data visualization intent specification including one or more data visualization intent specification entries, each data visualization intent specification entry including an intent type and data field identifiers identifying a set of two of more data fields selected from the data fields of the dataset, wherein each data visualization intent specification entry defines, via the intent type, a desired type of data analysis in a data visualization of data from the set of two or more data fields identified in the data visualization intent specification entry, the desired type of data analysis selected from a group of data analysis types including a compare type and trend type;

select, based on the intent type of the data visualization intent specification entry, Meta templates that meet the intent type of the data visualization intent specification entry and that support the set of two or more data fields;

determine, for each selected Meta template, chart parts to be assigned to each of the selected Meta templates, the combination of each selected Meta template with the chart parts assigned to that selected Meta template forming a chart template associated with that selected Meta template; and

select, based on a set of combination rules and the data visualization intent specification, one or more of the chart templates associated with the selected Meta templates.

14. The computer program product of claim 13, wherein each Meta template includes a a plurality of template fields and a layout mode, wherein the plurality of template fields includes a plurality of chart part type fields, wherein each chart part includes restrictions limiting the chart parts to certain chart part type fields, and wherein the layout mode defines, for each template field, a relationship between the template field and a layout model.

15. The computer program product of claim 13, wherein one or more of the Meta templates is a complex Meta template, wherein each complex Meta template includes one or more Meta templates and a layout mode defining positioning of the included one or more Meta templates and wherein the complex Meta templates define combinations of two or more charts associated with the data set.

16. The computer program product of claim 13, wherein the program code for determining chart parts includes program code executable by a computing device to:

retrieve chart part information for selected chart parts from a knowledge base of chart parts, wherein the chart part information includes a definition of types of data to which the chart part can be applied and the Meta templates with which the chart part can be used; and

identify candidate chart templates based on the selected Meta templates and their associated chart parts.

17. The computer program product of claim 13, wherein the program code for determining chart parts includes program code executable by a computing device to:

define a knowledge base of chart parts that can be used with each of the Meta templates to produce chart templates,

wherein the set of combination rules includes validation and scoring rules that score and validate combinations of chart parts used to solve a particular problem, and

wherein the program code for selecting chart templates includes program code executable by a computing device to generate a fitness score based on the selected chart parts and the set of scoring rules and to display data from the data set in the chart template associated with the highest fitness score.

18. A computer system comprising:

one or more processors, one or more computer-readable memories, and one or more computer-readable storage mediums;

program instructions, stored on at least one of the one or more storage mediums for execution by at least one of the one or more processors via at least one of the one or more memories, to identify, via a user interface, a dataset having two or more data fields;

program instructions, stored on at least one of the one or more storage mediums for execution by at least one of the one or more processors via at least one of the one or more memories, to define, via the user interface, a data visualization intent specification for the dataset, the data visualization intent specification including one or more data visualization intent specification entries, each data visualization intent specification entry including an intent type and data field identifiers identifying a set of two of more data fields selected from the data fields of the dataset, wherein each data visualization intent specification entry defines, via the intent type, a desired type of data analysis in a data visualization of data from the set of two or more data fields identified in the data visualization intent specification entry, the desired type of data analysis selected from a group of data analysis types including a compare type and trend type;

program instructions, stored on at least one of the one or more storage mediums for execution by at least one of the one or more processors via at least one of the one or more memories, to select, based on the intent type of the data visualization intent specification entry, Meta templates that meet the intent type of the data visualization intent specification entry and that support the set of two or more data fields;

program instructions, stored on at least one of the one or more storage mediums for execution by at least one of the one or more processors via at least one of the one or more memories, to determine, for each selected Meta template, chart parts to be assigned to each of the selected Meta templates, the combination of each selected Meta template with the chart parts assigned to that selected Meta template forming a chart template associated with that selected Meta template; and

program instructions, stored on at least one of the one or more storage mediums for execution by at least one of the one or more processors via at least one of the one or more memories, to select, based on a set of combination rules and the data visualization intent specification, one or more of the chart templates associated with the selected Meta templates.

19. The computer system of claim 18, wherein the program instructions for determining chart parts includes:

program instructions to retrieve chart part information for selected chart parts from a knowledge base of chart parts, wherein the chart part information includes a definition of types of data to which the chart part can be applied and the Meta templates with which the chart part can be used; and

program instructions to identify candidate chart templates based on the selected Meta templates and their associated chart parts.

20. The computer system of claim 18, wherein the set of combination rules includes validation and scoring rules that score and validate combinations of chart parts used to solve a particular problem,

wherein the program instructions for determining chart parts include program instructions to define a knowledge base of chart parts that can be used with each of the Meta templates to produce chart templates, and

wherein the program instructions for selecting chart templates includes:

program instructions to generate a fitness score based on the selected chart parts and the set of scoring rules; and

program instructions to display data from the data set in the chart template associated with the highest fitness score.