US Patent:
20140280193, Sep 18, 2014
Inventors:
Beau David Cronin - Oakland CA, US
Fritz Heinrich Obermeyer - San Francisco CA, US
Eric Michael Jonas - San Francisco CA, US
Jonathan Glidden - San Francisco CA, US
Assignee:
SALESFORCE.COM, INC. - San Francisco CA
International Classification:
G06F 17/30
Abstract:
Disclosed herein are systems and methods for implementing a SIMILAR 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 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. Other related embodiments are further disclosed.