公开(公告)号：US11010427B2

公开(公告)日：2021-05-18

申请号：US15868946

申请日：2018-01-11

Applicant: salesforce.com, inc.

Inventor： Nathanael Black

IPC: G06F16/901 ,  G06F16/29 ,  G06F16/9537

Abstract: Apparatuses, systems, and methods for generating and utilizing custom indexes for a plurality of geo-locations are described. A plurality of indexes are generated, each corresponding to one of a plurality of geo-locations, based on spatial area subdivisions of a space including the plurality of geo-locations. A points of interest (POIs) query is received, wherein results of the query are to be limited by a distance value. One or more geo-locations are identified as POIs within the distance value from a first geo-location of the plurality of geo-locations based on the corresponding indexes of the one or more identified geo-locations.

公开(公告)号：US09558218B2

公开(公告)日：2017-01-31

申请号：US14714968

申请日：2015-05-18

Applicant: salesforce.com, inc.

Inventor： Arup Dutta ,  Simon Wong ,  Dan Soble ,  Nathanael Black ,  Walter Macklem

IPC: G06F17/30

CPC classification number: G06F17/30303 ,  G06F17/30117 ,  G06F17/30165 ,  G06F17/30997

Abstract: An exemplary embodiment of a multi-tenant database system is provided. The system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has database objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has metadata entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

Abstract translation: 提供了多租户数据库系统的示例性实施例。 该系统包括多租户数据库，实体定义表和数据处理引擎。 数据库具有多个租户的数据库对象，包括指定租户的现有对象。 现有对象中的每个条目都有相应的实体标识符。 定义表具有数据库对象的元数据条目，包括现有对象的元数据条目。 该元数据条目具有用于指定承租人的租户标识符，现有对象的实体名称和用于现有对象的旧密钥前缀。 现有对象的每个实体标识符都以旧的密钥前缀开始。 引擎通过更新元数据条目来对现有对象执行数据截断操作，以用新的密钥前缀替换旧的密钥前缀。 这导致由新的密钥前缀和租户标识符标识的更新的对象。

公开(公告)号：US20150254286A1

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

申请号：US14714968

申请日：2015-05-18

Applicant: salesforce.com, inc.

Inventor： Arup Dutta ,  Simon Wong ,  Dan Soble ,  Nathanael Black ,  Walter Macklem

IPC: G06F17/30

CPC classification number: G06F17/30303 ,  G06F17/30117 ,  G06F17/30165 ,  G06F17/30997

Abstract: An exemplary embodiment of a multi-tenant database system is provided. The system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has database objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has metadata entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

Abstract translation: 提供了多租户数据库系统的示例性实施例。 该系统包括多租户数据库，实体定义表和数据处理引擎。 数据库具有多个租户的数据库对象，包括指定租户的现有对象。 现有对象中的每个条目都有相应的实体标识符。 定义表具有数据库对象的元数据条目，包括现有对象的元数据条目。 该元数据条目具有用于指定承租人的租户标识符，现有对象的实体名称和用于现有对象的旧密钥前缀。 现有对象的每个实体标识符都以旧的密钥前缀开始。 引擎通过更新元数据条目来对现有对象执行数据截断操作，以用新的密钥前缀替换旧的密钥前缀。 这导致由新的密钥前缀和租户标识符标识的更新的对象。

公开(公告)号：US20160034526A1

公开(公告)日：2016-02-04

申请号：US14694255

申请日：2015-04-23

Applicant: salesforce.com, inc.

Inventor： Jean-Baptiste Pringuey ,  Nathanael Black

IPC: G06F17/30

Abstract: A system, method and apparatus for providing for searching of relational data via a mobile communications device are provided. Information identifying searchable tables containing fields is received using a metadata application program interface (API). The metadata API provides information about a schema of the fields and a relationship of at least one of the fields to its corresponding object. Information for generating a view of relational data is provided to the mobile communications device. The view is based on at least one of the fields of at least one of the searchable tables, and the relationship between the at least one of the fields and its corresponding object. A set of user inputs is received based on the relationship presented in the view. A query definition corresponding to the set of user inputs for searching the relational data in accordance with the set of user inputs is created and stored.

Abstract translation: 提供了一种用于提供通过移动通信设备搜索关系数据的系统，方法和装置。 使用元数据应用程序接口（API）接收标识包含字段的可搜索表的信息。 元数据API提供关于字段的模式的信息，以及至少一个字段与其对应对象的关系。 用于生成关系数据视图的信息被提供给移动通信设备。 该视图基于至少一个可搜索表的至少一个字段以及至少一个字段与其相应对象之间的关系。 基于视图中呈现的关系接收一组用户输入。 创建并存储与根据用户输入集合搜索关系数据的用户输入集相对应的查询定义。

公开(公告)号：US20150026190A1

公开(公告)日：2015-01-22

申请号：US14334425

申请日：2014-07-17

Applicant: salesforce.com, inc.

Inventor： Nathanael Black

IPC: G06F17/30

CPC classification number: G06F17/30961 ,  G06F17/30241 ,  G06F17/3087

Abstract: Apparatuses, systems, and methods for generating and utilizing custom indexes for a plurality of geo-locations are described. A plurality of indexes are generated, each corresponding to one of a plurality of geo-locations, based on spatial area subdivisions of a space including the plurality of geo-locations. A points of interest (POIs) query is received, wherein results of the query are to be limited by a distance value. One or more geo-locations are identified as POIs within the distance value from a first geo-location of the plurality of geo-locations based on the corresponding indexes of the one or more identified geo-locations.

Abstract translation: 描述用于生成和利用多个地理位置的定制索引的装置，系统和方法。 基于包括多个地理位置的空间的空间区域细分，生成多个索引，每个索引对应于多个地理位置中的一个。 接收到兴趣点（POI））查询，其中查询的结果将被距离值限制。 基于所述一个或多个所识别的地理位置的相应索引，一个或多个地理位置被识别为距离所述多个地理位置的第一地理位置的所述距离值内的POI。

公开(公告)号：US20180137209A1

公开(公告)日：2018-05-17

申请号：US15868946

申请日：2018-01-11

Applicant: salesforce.com, inc

Inventor： Nathanael Black

IPC: G06F17/30

CPC classification number: G06F16/9027 ,  G06F16/29 ,  G06F16/9537

Abstract: Apparatuses, systems, and methods for generating and utilizing custom indexes for a plurality of geo-locations are described. A plurality of indexes are generated, each corresponding to one of a plurality of geo-locations, based on spatial area subdivisions of a space including the plurality of geo-locations. A points of interest (POIs) query is received, wherein results of the query are to be limited by a distance value. One or more geo-locations are identified as POIs within the distance value from a first geo-location of the plurality of geo-locations based on the corresponding indexes of the one or more identified geo-locations.

公开(公告)号：US10423611B2

公开(公告)日：2019-09-24

申请号：US14694255

申请日：2015-04-23

Applicant: salesforce.com, inc.

Inventor： Jean-Baptiste Pringuey ,  Nathanael Black

IPC: G06F16/00 ,  G06F16/242

Abstract: A system, method and apparatus for providing for searching of relational data via a mobile communications device are provided. Information identifying searchable tables containing fields is received using a metadata application program interface (API). The metadata API provides information about a schema of the fields and a relationship of at least one of the fields to its corresponding object. Information for generating a view of relational data is provided to the mobile communications device. The view is based on at least one of the fields of at least one of the searchable tables, and the relationship between the at least one of the fields and its corresponding object. A set of user inputs is received based on the relationship presented in the view. A query definition corresponding to the set of user inputs for searching the relational data in accordance with the set of user inputs is created and stored.

公开(公告)号：US09875321B2

公开(公告)日：2018-01-23

申请号：US14334425

申请日：2014-07-17

Applicant: salesforce.com, inc.

Inventor： Nathanael Black

IPC: G06F17/30

CPC classification number: G06F17/30961 ,  G06F17/30241 ,  G06F17/3087

Abstract: Apparatuses, systems, and methods for generating and utilizing custom indexes for a plurality of geo-locations are described. A plurality of indexes are generated, each corresponding to one of a plurality of geo-locations, based on spatial area subdivisions of a space including the plurality of geo-locations. A points of interest (POIs) query is received, wherein results of the query are to be limited by a distance value. One or more geo-locations are identified as POIs within the distance value from a first geo-location of the plurality of geo-locations based on the corresponding indexes of the one or more identified geo-locations.