Automated management of natural language queries in enterprise business intelligence analytics

Patent metadata

Field	Value
Publication number	US-9984116-B2
Application number	US-201514839701-A
Country	US
Kind code	B2
Filing date	Aug 28, 2015
Priority date	Aug 28, 2015
Publication date	May 29, 2018
Grant date	May 29, 2018

Abstract

Systems and methods may automate management of natural language queries of enterprise data. In one example, a method includes performing natural language processing and semantic processing on a natural language query to identify data sets relevant to the natural language query. The method further includes grouping the data sets into one or more query domains based at least in part on one or more relationships among the data sets. The method further includes prioritizing the query domain sets. The method further includes loading one or more of the query domain sets in an order based on the prioritizing of the query domain sets.

First claim

What is claimed is:

1. A method comprising:
performing, with one or more processing devices, natural language processing and semantic processing on a natural language query to identify data sets relevant to the natural language query;
grouping, with the one or more processing devices, the data sets into one or more query domains based at least in part on one or more relationships among the data sets, wherein each query domain includes a data set comprising a fact table that has one-to-many cardinality with a plurality of other data sets and no many-to-one cardinality with any data set, and one or more data sets each having a direct many-to-one cardinality relationship with the fact table;
prioritizing, with the one or more processing devices, the one or more query domains; and
loading, with the one or more processing devices, the one or more query domains in an order based on the prioritizing of the query domains.

2. The method of claim 1 , further comprising filtering the one or more of the query domains into a plurality of filtered query domain sets prior to the prioritizing of the one or more query domains.

3. The method of claim 2 , further comprising evaluating sizes of the one or more query domains, wherein the filtering the one or more of the query domains is based at least in part on the evaluated sizes of the one or more query domains.

4. The method of claim 1 , further comprising presenting, in a user interface, one or more user menus for user-enabled filtering of the one or more query domains.

5. The method of claim 1 , further comprising presenting, in a user interface, an indication of a size of the one or more query domains based on the natural language query.

6. The method of claim 1 , further comprising presenting, in a user interface, an indication of a size of the one or more query domains based on filters applied to the natural language query.

7. The method of claim 1 , further comprising presenting, in a user interface, an indication of a load time of the one or more query domains based on the natural language query.

8. The method of claim 1 , further comprising presenting, in a user interface, an indication of a load time of the one or more query domains based on filters applied to the natural language query.

9. The method of claim 1 , wherein the grouping the data sets into the one or more query domains comprises:
identifying two or more data sets with lexical or ontological correlation with parsed query terms from the natural language query.

10. A computer program product comprising a computer-readable storage medium having program code embodied therewith, the program code executable by a computing device to:
perform natural language processing and semantic processing on a natural language query to identify data sets relevant to the natural language query;
group the data sets into one or more query domains based at least in part on one or more relationships among the data sets, wherein each query domain includes a data set comprising a fact table that has one-to-many cardinality with a plurality of other data sets and no many-to-one cardinality with any data set, and one or more data sets each having a direct many-to-one cardinality relationship with the fact table;
prioritize the one or more query domains; and
load, with the one or more processing devices, the one or more query domains in an order based on the prioritizing of the query domains.

11. The computer program product of claim 10 , wherein the program code is further executable by the computing device to evaluate sizes of the one or more query domains, wherein the filtering the one or more of the query domains is based at least in part on the evaluated sizes of the one or more query domains.

12. The computer program product of claim 10 , wherein the program code is further executable by the computing device to filter the one or more of the query domains into a plurality of filtered query domain sets prior to the prioritizing of the one or more query domains.

13. The computer program product of claim 10 , wherein the program code is further executable by the computing device to present, in a user interface, one or more user menus for user-enabled filtering of the one or more query domains.

14. A computer system comprising:
one or more hardware processors, one or more computer-readable memories, and one or more computer-readable, tangible storage devices;
program instructions, stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, to perform natural language processing and semantic processing on a natural language query to identify data sets relevant to the natural language query;
program instructions, stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, group the data sets into one or more query domains based at least in part on one or more relationships among the data sets, wherein each query domain includes a data set comprising a fact table that has one-to-many cardinality with a plurality of other data sets and no many-to-one cardinality with any data set, and one or more data sets each having a direct many-to-one cardinality relationship with the fact table;
program instructions, stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, to prioritize the one or more query domains; and
program instructions, stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, to load the one or more query domains in an order based on the prioritizing of the query domains.

15. The computer system of claim 14 , further comprising program instructions to evaluate sizes of the one or more query domains, wherein the filtering the one or more of the query domains is based at least in part on the evaluated sizes of the one or more query domains.

16. The computer system of claim 14 , further comprising program instructions to filter the one or more of the query domains into a plurality of filtered query domain sets prior to the prioritizing of the one or more query domains.

17. The computer system of claim 14 , further comprising program instructions to present, in a user interface, one or more user menus for user-enabled filtering of the one or more query domains.

Assignees

• IBM

Inventors

• Rais Ghasem Mohsen
• Truong Kenny
• Vierich Ralf

Classifications

• G06F40/30

  Semantic analysis · CPC title

• G06F16/243

  Natural language query formulation · CPC title

• G06F16/24522 Primary

  Translation of natural language queries to structured queries · CPC title

• G06F17/3043 Primary

  Physics · mapped topic

• G06F17/2785

  Physics · mapped topic