公开(公告)号：US10963541B2

公开(公告)日：2021-03-30

申请号：US15249026

申请日：2016-08-26

Applicant: salesforce.com, inc.

Inventor： Beau David Cronin ,  Fritz Heinrich Obermeyer ,  Cap Christian Petschulat ,  Eric Michael Jonas ,  Jonathan Glidden

IPC: G06F17/30 ,  G06Q30/02 ,  G06F3/0484 ,  G06F17/24 ,  G06N7/00 ,  G06N99/00

Abstract: Disclosed herein are systems and methods for implementing a RELATED 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 RELATED command term and a specified column as a parameter for the RELATED command term; querying the database using the RELATED command term and passing 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 including a column identifier and a confidence indicator for the specified column passed with the RELATED command term, wherein the confidence indicator indicates whether a latent relationship exists between the specified column passed with the RELATED command and the column identifier returned for the respective element. Other related embodiments are further disclosed.

公开(公告)号：US09454767B2

公开(公告)日：2016-09-27

申请号：US14014236

申请日：2013-08-29

Applicant: salesforce.com, inc.

Inventor： Beau David Cronin ,  Fritz Heinrich Obermeyer ,  Cap Christian Petschulat ,  Eric Michael Jonas ,  Jonathan Glidden

IPC: G06F17/30 ,  G06Q30/02 ,  G06F3/0484 ,  G06F17/24

CPC classification number: G06F17/30321 ,  G06F3/04842 ,  G06F3/04847 ,  G06F17/246 ,  G06F17/30286 ,  G06F17/30339 ,  G06F17/30345 ,  G06F17/30424 ,  G06F17/30442 ,  G06F17/30477 ,  G06F17/30483 ,  G06F17/3053 ,  G06F17/30539 ,  G06F17/30545 ,  G06F17/30554 ,  G06F17/30598 ,  G06F17/30619 ,  G06N7/005 ,  G06N99/005 ,  G06Q30/0201 ,  G06Q30/0202

Abstract: Disclosed herein are systems and methods for implementing a RELATED 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 RELATED command term and a specified column as a parameter for the RELATED command term; querying the database using the RELATED command term and passing 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 including a column identifier and a confidence indicator for the specified column passed with the RELATED command term, wherein the confidence indicator indicates whether a latent relationship exists between the specified column passed with the RELATED command and the column identifier returned for the respective element. Other related embodiments are further disclosed.

Abstract translation: 本文公开了用于实现具有预测性查询界面的相关命令的系统和方法，包括用于从列和行的数据集生成索引的指示，所述索引表示数据集的行和列之间的概率关系; 将索引存储在主机组织的数据库内; 通过请求界面暴露主机组织的数据库; 在请求界面处接收指定相关命令项和指定列作为相关命令项的参数的数据库查询; 使用RELATED命令项查询数据库，并传递指定的列以生成预测记录集; 并且响应于所述查询返回所述预测记录集，所述预测记录集在其中具有多个元素，所述返回元素中的每一个包括与所述相关命令项一起传递的所述指定列的列标识符和置信度指标，其中所述置信指标 指示在与相关命令之间传递的指定列与为各个元素返回的列标识符之间是否存在潜在关系。 进一步公开了其他相关实施例。