Providing suggestions based on user context while exploring a dataset

A system comprising:

• a client computing device implementing a user interface of a software application implementing a plurality of business processes, the user interface being configured to receive, from a user, a textual input;
• and
• an online analytical processing system including a database system configured to at least:
• receive, from the user interface, the textual input;
• determine a query context for the textual input, the query context being determined from the textual input, characteristics of the user, and data being displayed at the user interface, the query context enabling identification of at least one measure, at least one dimension, and/or at least one filter associated with at least one data set being searched via the online analytical processing system including the database system;
• compute, based on the query context, a plurality of ranked numerical scores, each of the ranked numerical scores determined based on a combination of a first score, a second score, and a third score, the first score being computed based on usage metrics representative of usage by a user of the at least one data set, the second score being computed based on data set statistics representative of statistics about the at least one data set, and the third score being computed based on rules associated with the query context including at least one rule regarding the characteristics of the user and at least one association rule defining how elements of a query are combined;
• determine, using the plurality of ranked numerical scores, a plurality of candidate query suggestions, wherein to determine the plurality of candidate query suggestions, the system is further configured to at least modify the query context by at least modifying the at least one measure, the at least one dimension, and/or the at least one filter;
• order the plurality of candidate query suggestions according to the plurality of ranked numerical scores;
• generate at least one query suggestion from the ordered plurality of candidate query suggestions;
• and
• cause the at least one query suggestion to be displayed at the user interface.

A non-transitory recordable storage medium including computer program instructions which, when executed by one or more processors, result in operations comprising at least:

• receiving, at an online analytical processing system including a database system, a textual input from a user interface of a software application implementing a plurality of business processes;
• determining a query context for the textual input, the query context being determined from the textual input, characteristics of a user, and data being displayed at the user interface, the query context enabling identification of at least one measure, at least one dimension, and/or at least one filter associated with at least one data set being searched via the online analytical processing system including the database system;
• computing, based on the query context, a plurality of ranked numerical scores, each of the ranked numerical scores determined based on a combination of a first score, a second score, and a third score, the first score being computed based on usage metrics representative of usage by a user of the at least one data set, the second score being computed based on data set statistics representative of statistics about the at least one data set, and the third score being computed based on rules associated with the query context including at least one rule regarding the characteristics of the user and at least one association rule defining how elements of a query are combined;
• determining, using the plurality of ranked numerical scores, a plurality of candidate query suggestions, wherein the determining of the plurality of candidate query suggestions includes modifying the query context by modifying the at least one measure, the at least one dimension, and/or the at least one filter;
• ordering the plurality of candidate query suggestions according to the plurality of ranked numerical scores;
• generating at least one query suggestion from the ordered plurality of candidate query suggestions;
• and
• causing the at least one query suggestion to be displayed at the user interface.