Business Objects Software Limited

International Business Machines Corporation

Alexander MacAulay

Julian Gosper

Flavia Silvana Moser

Saeed Jahankhani

Peter Currie Boyle

Ahmet Yoldemir

A question library aids in intuitive analysis of stored data. The question library comprises: 1) a plurality of text questions, 2) a numerical representation (e.g., a vector) of each text question, and 3) a corresponding query in a query language. A numerical vector is generated for a question posed to a database. If a matching library question (based upon vector similarity) is not found, the user receives the original answer. If a matching library question based upon vector similarity is found, the user receives the answer to that library question (with potential modifications). Embodiments may determine similarity by calculating Pearson's coefficient, Spearman's rho, or Kendall's tau. Embodiments may parse the first query to identify constituent elements (measures, dimensions, filters). These entities are extracted and compared to elements of the second question matched within the library, to allow modification of the library query to align with the initial query.

Question library for data analytics interface

A system includes reception of an input string of words, determination, for each subset of consecutive one or more words in the input string, of one or more phrase types based on the subset, on a dictionary describing a plurality of entities, each of the plurality of entities associated with an entity type, and on a grammar describing a plurality of phrase types, each of the plurality of phrase types associated with one or more conditions, and determination of a plurality of candidate queries based on the determined phrase types.

Natural language query system

A raw dataset including measures and dimensions is processed, by a preprocessing module, using an algorithm that produces a preprocessed dataset such that at least one type of statistical analysis of the preprocessed dataset yields equal results to the same type of statistical analysis of the raw dataset. The preprocessed dataset is then analyzed by a statistical analysis module to identify subsets of the preprocessed dataset that include a non-random structure or pattern. The analysis of the preprocessed dataset includes the at least one type of statistical analysis that produces the same results for both the preprocessed and raw datasets. The identified subsets are then ranked by a statistical ranker based on the analysis of the preprocessed dataset and a subset is selected for visualization based on the rankings. A visualization module then generates a visualization of the selected identified subset that highlights a non-random structure of the selected subset.

Multivariate insight discovery approach

An expert system is used to recommend a customized solution for a customer. The expert system includes a set of scenarios each of which includes default facts and is associated with a detailed rule base that when applied in isolation to the default facts fully determines a prototype solution. A particular scenario is selected from the set based at least on user input. A customized solution is generated by applying the detailed rule base associated with the particular scenario to facts based at least on the user input and any default facts of the particular scenario that complement and do not conflict with the facts that are based at least on the user input. The customized solution is iteratively refined.

Growing community of inventors

Vancouver, Canada

Alexander MacAulay