Systems, methods, and apparatuses for implementing a predict 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 at least (i) a PREDICT command term, (ii) one or more specified columns to be predicted, and (iii) one or more column name=value pairs specifying column names to be fixed and the values by which to fix them;
• and
• querying the database using the PREDICT command term and passing the one or more specified columns to be predicted and the one or more column name=value pairs to generate a representation of a joint conditional distribution of the one or more specified columns to be predicted fixed according to the column name=value pairs using the indices stored in the database.

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 database specifying at least (i) a PREDICT command term, (ii) one or more specified columns to be predicted, and (iii) one or more column name=value pairs specifying column names to be fixed and the values by which to fix them;
• and
• a query interface to query the predictive database using the PREDICT command term and passing the one or more specified columns to be predicted and the one or more column name=value pairs to generate a representation of a joint conditional distribution of the one or more specified columns to be predicted fixed according to the column name=value pairs using the indices stored in the database.

A method in a host organization, the method 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 PREDICT command term and with zero columns fixed such that no column IDs are passed with the PREDICT command term;
• and
• querying the database using the PREDICT command term and the one or more specified columns to generate output, wherein the output comprises generated synthetic data having one or more entity rows with predicted values for every column of the dataset using the indices stored in the database.