Business intelligence (BI) query and answering using full text search and keyword semantics

A query management system including instructions stored on a non-transitory computer-readable storage medium, the system comprising:

• a query engine configured to generate a plurality of keyword search queries using one or more keyword tokens, execute the plurality of keyword search queries against a metadata repository, obtain a plurality of search results responsive to the plurality of keyword search queries, generate a plurality of query trees, and from the plurality of query trees, generate a plurality of search query suggestions to retrieve data corresponding to one or more rule compliant data paths defined by the plurality of query trees, and provide query suggestions for display in a user interface;
• a knowledge graph including a plurality of query trees configured to connect a plurality of nodes representing data objects associated with keyword tokens and system data in response to determining compliance with grammar rules and to filter the nodes determined to be noncompliant with the system data;
• and
• a security engine configured to implement security rules to allow or deny presentation of query suggestions to a user of the user interface, the security rules being based on user usage data, knowledge graph rules, and the grammar rules.

A non-transitory recordable storage medium having recorded and stored thereon instructions that, when executed, perform at least actions of:

• receiving a free text input;
• parsing the free text input into one or more keyword tokens;
• generating a plurality of keyword search queries based on the one or more keyword tokens;
• executing the plurality of keyword search queries against a metadata repository;
• obtaining a plurality of search results responsive to the plurality of keyword search queries, the search results including system data, and for each of the plurality of search results:
• retrieving grammar rules associated with the system data, wherein the grammar rules enable identifying at least a partial match between a keyword and a portion of the system data;
• determining security rules based, at least in part, on credentials of a user and a category of one or more portions of the system data;
• applying the grammar rules to determine whether combining content associated with the one or more keyword tokens and the system data associated with one or more of the plurality of search results complies with the grammar rules;
• filtering at least a portion of the content determined to be noncompliant with the grammar rules;
• generating a query tree that connects a first node representing the one or more keyword tokens to a second node representing the system data associated with one or more of the plurality of search results, in response to determining that combining the content and the system data complies with the grammar rules;
• and
• generating a plurality of search query suggestions using the query tree to retrieve data corresponding to one or more data paths compliant with the grammar rules, wherein the data paths are defined in the query tree by one or more connected nodes;
• and
• providing one or more of the plurality of search query suggestions, compliant with the security rules, for display in a user interface adjacent to a plurality of visualizations.