Systems, methods, and apparatuses for implementing a similar command with a predictive query interface

Non-transitory computer readable storage medium having instructions stored thereon that, when executed by a processor in a host organization, the instructions cause the host organization to perform operations comprising:

• generating indices from a dataset of columns and rows, the indices representing probabilistic relationships between the rows and the columns of the dataset;
• storing the indices within a database of the host organization;
• exposing the database of the host organization via a request interface;
• receiving, at the request interface, a query for the database specifying a SIMILAR command term, a specified row as a parameter for the SIMILAR command term, and a specified column as a parameter for the SIMILAR command term;
• querying the database using the SIMILAR command term and passing the specified row and the specified column to generate a predictive record set;
• and
• returning the predictive record set responsive to the query, the predictive record set having a plurality of elements therein, each of the returned elements of the predictive record set including (i) a row identifier which corresponds to a row of the dataset assessed to be similar, according to a latent structure, to the specified row passed with the SIMILAR command term based on the specified column and (ii) a confidence indicator which indicates a likelihood of a latent relationship between the specified row passed with the SIMILAR command and the row identifier returned for the respective element.

A system to operate within a host organization, the system comprising:

• a processor to execute instructions stored in memory of the system;
• an analysis engine to generate indices from a dataset of columns and rows, the indices representing probabilistic relationships between the rows and the columns of the dataset;
• a predictive database to store the indices;
• a request interface to expose the predictive database;
• the request interface to receive a query for the predictive database specifying a SIMILAR command term, a specified row as a parameter for the SIMILAR command term, and a specified column as a parameter for the SIMILAR command term;
• a query interface to query the predictive database using the SIMILAR command term and passing the specified row and the specified column to generate a predictive record set;
• and
• the request interface to further return the predictive record set responsive to the query, the predictive record set having a plurality of elements therein, each of the returned elements of the predictive record set including (i) a row identifier which corresponds to a row of the dataset assessed to be similar, according to a latent structure, to the specified row passed with the SIMILAR command term based on the specified column and (ii) a confidence indicator which indicates a likelihood of a latent relationship between the specified row passed with the SIMILAR command and the row identifier returned for the respective element.