Systems, methods, and apparatuses for populating a table having null values using a predictive query interface

A 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:

• receiving a request at the host organization from a user device to display a tabular dataset;
• retrieving the tabular dataset from a database system executing at the host organization;
• displaying the tabular dataset as output to the user device, the displayed output including a plurality of data values depicted as known values and a plurality of null values depicted as unknown values;
• receiving input from the user device to populate the tabular dataset to a specified fill percentage;
• querying the database system for predicted values to populate a portion of the null values of the tabular dataset, wherein querying the database system comprises issuing a PREDICT command term and passing as a parameter one or more specified columns of the tabular dataset to be predicted;
• receiving a distribution for every one of the plurality of null values within the tabular dataset responsive to querying the indices for the predicted values;
• calculating a credible interval for each distribution received;
• populating the portion of the null values of the tabular dataset with the predicted values until the specified fill percentage is reached;
• and
• displaying the tabular dataset having the predicted values populated therein as updated output to the user device by displaying selected ones of the predicted values that correspond to a calculated credible interval in excess of a minimum threshold.

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

• a processor to execute instructions stored in memory of the system;
• a request interface to receive a request at the host organization from a user device to display a tabular dataset;
• a query interface to retrieve the tabular dataset from a database system executing at the host organization;
• the request interface to further display the tabular dataset as output to the user device, the displayed output including a plurality of data values depicted as known values and a plurality of null values depicted as unknown values;
• the request interface to further receive input from the user device to populate the tabular dataset to a specified fill percentage;
• the query interface to further query the database system for predicted values to populate a portion of the null values of the tabular dataset, wherein querying the database system comprises issuing a PREDICT command term and passing as a parameter one or more specified columns of the tabular dataset to be predicted, wherein the query interface is to receive a distribution for every one of the plurality of null values within the tabular dataset responsive to the query;
• an analysis engine to calculate a credible interval for each distribution received and wherein the analysis engine is to further populate the portion of the null values of the tabular dataset with the predicted values until the specified fill percentage is reached;
• and
• wherein the request interface is to further display the tabular dataset having the predicted values populated therein as updated output to the user device by displaying selected ones of the predicted values that correspond to a calculated credible interval in excess of a minimum threshold.