公开(公告)号：US20150310039A1

公开(公告)日：2015-10-29

申请号：US14796329

申请日：2015-07-10

Applicant: salesforce.com, inc.

Inventor： Alexandre Hersans ,  Simon Y. Wong ,  Shawna Wolverton ,  Junichiro Sekiguchi

IPC: G06F17/30

CPC classification number: G06F17/30241 ,  G06F17/30507 ,  G06F17/30522 ,  G06F17/30554 ,  G06F17/30867

Abstract: Methods and systems are provided for retrieving, from a database containing a list of records, a subset of the list of records located within a user defined distance from a target point, each record in the list of records having a compound geo-location data type including a first data field and a second data field. The method involves generating a circle around the target point; identifying records having a geo-location within the circle; including the identified records in a result set; and presenting the result set to a user on a display screen. The method further includes treating the first data field and the second data field as a single data element.

Abstract translation: 提供了方法和系统，用于从包含记录列表的数据库检索位于与目标点之间的用户定义距离内的记录列表的子集，记录列表中的每个记录具有复合地理位置数据类型 包括第一数据字段和第二数据字段。 该方法包括围绕目标点产生一个圆; 识别在圆内具有地理位置的记录; 包括结果集中确定的记录; 并在显示屏幕上将结果集呈现给用户。 该方法还包括将第一数据字段和第二数据字段作为单个数据元素进行处理。

公开(公告)号：US11640378B2

公开(公告)日：2023-05-02

申请号：US17358573

申请日：2021-06-25

Applicant: salesforce.com, inc.

Inventor： Jan Asita Fernando ,  Samarpan Jain ,  Matthew Davidchuk ,  Valliappan Annamalai Natarajan ,  Alexey Syomichev ,  Cody Marcel ,  Seshank Kalvala ,  Sahil Ramrakhyani ,  Alexandre Hersans

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/24 ,  G06F16/28

Abstract: A method is provided for processing a query. In some embodiments, the method includes creating a historical schema defining an ordered set of fields based on a current schema of an object and a field modification of the current schema. The method includes inserting, based on the field modification, a new field at an end of the historical schema and archiving records into a second storage device. The method includes receiving a query, which includes a command specifying a subset of fields and which indicates a non-current field. The method includes searching in the second storage device for archive records having a second schema including the subset of fields and the non-current field. The first and second schemas follow the field order in accordance with the historical schema. The method further includes accessing the subset of fields and the non-current field in accordance with the command.

公开(公告)号：US11354285B2

公开(公告)日：2022-06-07

申请号：US16848878

申请日：2020-04-15

Applicant: salesforce.com, inc.

Inventor： Chenghung Ker ,  Danil Dvinov ,  Parth Vijay Vaishnav ,  Swaroop Shere ,  Alexandre Hersans

IPC: G06F16/215 ,  G06F21/60 ,  G06F16/28 ,  H04L9/06

Abstract: Provided herein are system, methods and computer program products for identifying duplicate records stored in a database system, comprising: generating a plurality of encrypted match indexes for each of a plurality of records stored in the database system, each of the plurality of encrypted match indexes encrypts a value of each encryption enabled field of a respective one of the plurality of records defined by at least one match rule, creating a cluster of records comprising at least one set containing at least two records of the plurality of records, the at least two records having respective encrypted match indexes corresponding to the at least one match rule, causing identification of duplicate records in the at least one set according to detection of records of the at least one set having respective match indexes matching the at least one match rule, and outputting an indication of the identified duplicate records.

公开(公告)号：US11068448B2

公开(公告)日：2021-07-20

申请号：US16241810

申请日：2019-01-07

Applicant: salesforce.com, inc.

Inventor： Jan Asita Fernando ,  Samarpan Jain ,  Matthew Davidchuk ,  Valliappan Annamalai Natarajan ,  Alexey Syomichev ,  Cody Marcel ,  Seshank Kalvala ,  Sahil Ramrakhyani ,  Alexandre Hersans

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/24 ,  G06F16/28

Abstract: A method is provided for processing a query. In some embodiments, the method includes creating a historical schema defining an ordered set of fields based on a current schema of an object and a field modification of the current schema. The method includes inserting, based on the field modification, a new field at an end of the historical schema and archiving records into a second storage device. The method includes receiving a query, which includes a command specifying a subset of fields and which indicates a non-current field. The method includes searching in the second storage device for archive records having a second schema including the subset of fields and the non-current field. The first and second schemas follow the field order in accordance with the historical schema. The method further includes accessing the subset of fields and the non-current field in accordance with the command.

公开(公告)号：US10482106B2

公开(公告)日：2019-11-19

申请号：US14860460

申请日：2015-09-21

Applicant: salesforce.com, inc.

Inventor： Eugene Oksman ,  Alexandre Hersans

IPC: G06F16/28 ,  G06F16/245 ,  G06F16/33 ,  G06F16/335

Abstract: Categorizing data in an on-demand database environment is provided. The categorized data is accessed to provide results based on statistical likelihood that records provide a desired result of a query. The categorization of the data includes organizing queries based on semantic terms, with categorization based on a multidimensional categorization of data in the database environment. The generating of results includes accessing relationship metadata both for individual records and for categories. Relationships along the same category, or among categories can provide records that may answer the query. The relationships and statistics are updated based on usage of the results data. Records and relationships identified as being used to solve the query, or being a desired solution to the query, can be weighted more heavily, thus increasing the likelihood of providing the most relevant data for subsequent queries.

公开(公告)号：US20190097791A1

公开(公告)日：2019-03-28

申请号：US15716677

申请日：2017-09-27

Applicant: salesforce.com, Inc.

Inventor： Alexandre Hersans ,  John Bracken ,  Assaf Ben Gur ,  Charles Mortimore ,  Swaroop Shere

IPC: H04L9/08 ,  H04L9/14 ,  G06F12/0813 ,  G06F12/123

Abstract: Methods, systems, and devices for distributed caching of encrypted encryption keys are described. Some multi-tenant database systems may support encryption of data records. To efficiently handle multiple encryption keys across multiple application servers, the database system may store the encryption keys in a distributed cache accessible by each of the application servers. To securely cache the encryption keys, the database system may encrypt (e.g., wrap) each data encryption key (DEK) using a second encryption key (e.g., a key encryption key (KEK)). The database system may store the DEKs and KEKs in separate caches to further protect the encryption keys. For example, while the encrypted DEKs may be stored in the distributed cache, the KEKs may be stored locally on application servers. The database system may further support “bring your own key” (BYOK) functionality, where a user may upload a tenant secret or tenant-specific encryption key to the database.

公开(公告)号：US09646169B2

公开(公告)日：2017-05-09

申请号：US14937698

申请日：2015-11-10

Applicant: salesforce.com, inc.

Inventor： Simon Y. Wong ,  Igor Tsyganskiy ,  Patrick John Calahan ,  Alexandre Hersans

IPC: H04L29/06 ,  G06F21/62 ,  G06F17/30

CPC classification number: G06F21/6218 ,  G06F17/30864 ,  H04L63/0281 ,  H04L63/10

Abstract: In accordance with disclosed embodiments, there are provided methods, systems, and apparatuses for implementing cross organizational data sharing including, for example, means for storing customer organization data in a database of the host organization; allocating at least a sub-set of the customer organization data to be shared as shared data; configuring a hub to expose the shared data to a proxy user and configuring the proxy user at the hub with access rights to the shared data; configuring one or more spokes with access rights to the shared data of the hub via the proxy user; receiving a request from one of the hubs for access to the shared data of the customer organization via the proxy user at the hub; and returning a response to the hub having made the request. Other related embodiments are disclosed.