Systems, methods, and apparatuses for populating a table having null values using a predictive query interface
First Claim
1. A method in a host organization having at least a processor and a memory therein to execute instructions, the method 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.
0 Assignments
0 Petitions
Accused Products
Abstract
Disclosed herein are systems and methods for populating a table having null values using a predictive query interface including means for receiving a tabular dataset from a user as input, the tabular dataset having data values organized as columns and rows; identifying a plurality of null values within the tabular dataset, the null values being dispersed across multiple rows and multiple columns of the tabular dataset; generating indices from the tabular dataset of columns and rows, the indices representing probabilistic relationships between the rows and the columns of the tabular dataset; displaying the tabular dataset as output to the user, the displayed output including the data values depicted as known values and the null values depicted as unknown values; receiving input from the user to populate at least a portion of the unknown values within the displayed tabular dataset with predicted values; querying the indices for the predicted values; and displaying the predicted values as updated output to the user. Other related embodiments are further disclosed.
-
Citations
19 Claims
-
1. A method in a host organization having at least a processor and a memory therein to execute instructions, the method 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. 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. - View Dependent Claims (17)
-
-
18. 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. - View Dependent Claims (19)
-
Specification