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

摘要

Disclosed herein are systems and methods for implementing a PREDICT command with a predictive query interface including means for 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 a 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. Other related embodiments are further disclosed.

主权项

1. A computer implemented method in a host organization, the method comprising:
generating, by using a computer system, 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 corresponding values by which to fix the column names; 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, wherein querying the database using the PREDICT command term comprises passing a JavaScript Object Notation (JSON) structured query to the database, the JSON structured query having a query syntax of: the PREDICT command term as a required term; required specification of the one or more specified columns to be predicted; the required specification of the column names to be fixed and the values by which to fix the column names as the one or more column name=value pairs restricting output of the query to a predictive record set having returned elements that are probabilistically related to the one or more columns to be fixed and the corresponding values by which to fix the column names as specified via the one or more column name=value pairs; and an optional specification of one or more tables, datasets, data sources, and indices to be queried.