公开(公告)号：US10409697B2

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

申请号：US15440810

申请日：2017-02-23

Applicant: salesforce.com, inc.

Inventor： Bohan Chen ,  Donald Tam ,  Jesse Collins ,  Sheng Qiao ,  Ted Liu ,  Youngjin Yu

IPC: G06F11/20 ,  G06F16/27 ,  G06F16/23 ,  G06F11/16

Abstract: An automated self-healing database system is provided that includes a primary database, an application server that writes data to the primary database and reads data from the primary database when it is available, a standby database that is a replica of the primary database, and a self-healing module (SHM). The SHM can automatically detect unavailability of the primary database, and if the standby database is available, the SHM can automatically enable the standby database as readable and writable, assign the standby database the role of primary database at the primary site to start replicating data to other standby databases, and use a pre-established connection between the application server and the standby database to allow the application server to read data from the standby database and to write data to the standby database resulting in the standby database assuming role of the primary database at the primary site.

公开(公告)号：US20180239677A1

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

申请号：US15440810

申请日：2017-02-23

Applicant: salesforce.com, inc.

Inventor： Bohan Chen ,  Donald Tam ,  Jesse Collins ,  Sheng Qiao ,  Ted Liu ,  Youngjin Yu

IPC: G06F11/20 ,  G06F17/30

CPC classification number: G06F11/203 ,  G06F11/1666 ,  G06F11/2094 ,  G06F16/2308 ,  G06F16/27 ,  G06F2201/80 ,  G06F2201/805 ,  G06F2201/82

Abstract: An automated self-healing database system is provided that includes a primary database, an application server that writes data to the primary database and reads data from the primary database when it is available, a standby database that is a replica of the primary database, and a self-healing module (SHM). The SHM can automatically detect unavailability of the primary database, and if the standby database is available, the SHM can automatically enable the standby database as readable and writable, assign the standby database the role of primary database at the primary site to start replicating data to other standby databases, and use a pre-established connection between the application server and the standby database to allow the application server to read data from the standby database and to write data to the standby database resulting in the standby database assuming role of the primary database at the primary site.

公开(公告)号：US20180025174A1

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

申请号：US15295288

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Rohitashva MATHUR ,  Prem Veeramani ,  Jesse Collins

IPC: G06F21/62 ,  G06F17/30

CPC classification number: G06F21/6227 ,  H04L67/02 ,  H04L67/1097

Abstract: In an example, a processing device of a datastore system may be configured to identify one or more grants of permission corresponding to one or more first objects, respectively, wherein the one or more first objects comprise only a subset of objects of a datastore, wherein the one or more grants of permission are by a user of the datastore; generate an access control entry for a second object of the objects using at least one of the identified grants of permission, wherein the second object is not exposed to the user; and in responsive to receipt of a query for data corresponding to the objects, determine whether to grant access to the data based on the generated access control entry.

公开(公告)号：US20140280025A1

公开(公告)日：2014-09-18

申请号：US14222091

申请日：2014-03-21

Applicant: salesforce.com, inc.

Inventor： William Charles Eidson ,  Jesse Collins

IPC: G06F17/30

CPC classification number: G06F17/30466 ,  G06F17/30327 ,  G06F17/30442 ,  G06F17/30463 ,  G06F17/30536

Abstract: Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving at a network interface of a server in a multi-tenant database system an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes at least a first index and a second index. Metadata associated with the data is retrieved, wherein at least a portion of the data is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined by analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. An improved query is then generated using the query syntax, wherein the improved query is based at least in part upon the original query and a result of a join between a first number of rows associated with the first index and a second number of rows associated with the second index.

Abstract translation: 提供了多租户数据库系统查询优化的方法和系统。 一些实施例包括在多租户数据库系统中的服务器的网络接口处接收由与租户相关联的用户发送到多承租人数据库系统的原始查询，其中原始查询与租户可访问的数据相关联， 并且其中所述多租户数据库系统至少包括第一索引和第二索引。 检索与数据相关联的元数据，其中数据的至少一部分存储在多租户数据库系统内的公用表中。 租户选择性查询语法是通过分析从租户的信息生成的元数据中的至少一个或由租户可访问的数据生成的元数据来确定的。 然后使用查询语法生成改进的查询，其中改进的查询至少部分地基于原始查询，以及与第一索引相关联的第一行数和与第一索引相关联的第二行数之间的连接的结果 第二个指标。

公开(公告)号：US20140040235A1

公开(公告)日：2014-02-06

申请号：US14044657

申请日：2013-10-02

Applicant: salesforce.com, inc.

Inventor： Chirag Rajan ,  Jesse Collins ,  Seung-Yeoul Yang ,  Hoon Kim

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30442 ,  G06F17/30477

Abstract: Methods and systems are provided for querying a database. One exemplary method for obtaining data from an on-demand database supporting one or more tenants involves obtaining model database statistics based on expected utilization information for a tenant and providing the model database statistics to the on-demand database. The on-demand database utilizes the model database statistics to generate a query plan and executes the query plan to obtain data from the model database statistics.

Abstract translation: 提供了方法和系统来查询数据库。 从支持一个或多个租户的点播数据库获取数据的一个示例性方法包括基于租户的预期利用信息获取模型数据库统计信息，并将该模型数据库统计信息提供给按需数据库。 按需数据库利用模型数据库统计信息生成查询计划，并执行查询计划以从模型数据库统计信息中获取数据。

公开(公告)号：US10956418B2

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

申请号：US15924023

申请日：2018-03-16

Applicant: salesforce.com, inc.

Inventor： William Charles Eidson ,  Jesse Collins

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/2458

Abstract: Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving at a network interface of a server in a multi-tenant database system an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes at least a first index and a second index. Metadata associated with the data is retrieved, wherein at least a portion of the data is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined by analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. An improved query is then generated using the query syntax, wherein the improved query is based at least in part upon the original query and a result of a join between a first number of rows associated with the first index and a second number of rows associated with the second index.

公开(公告)号：US10922313B2

公开(公告)日：2021-02-16

申请号：US16299035

申请日：2019-03-11

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Craig Weissman

IPC: G06F7/00 ,  G06F16/2453 ,  G06F16/2458

Abstract: Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving, at a network interface of a server computer in a multi-tenant database system, an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes a first two-column custom index. Metadata associated with the data accessible by the tenant is retrieved, using a processor of the server computer, wherein at least a portion of the data accessible by the tenant is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined, using the processor, wherein determining comprises analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. Finally, using the processor, an improved query is generated using the query syntax, wherein the improved query is based at least in part upon the original query and data stored in the first two-column custom index.

公开(公告)号：US10810514B2

公开(公告)日：2020-10-20

申请号：US16259964

申请日：2019-01-28

Applicant: salesforce.com, inc.

Inventor： Andrey Gusev ,  Ronald Yang ,  Scott Hansma ,  Jesse Collins ,  Alan Arbizu

IPC: G06F15/16 ,  G06N20/00 ,  H04L29/08 ,  H04L12/861 ,  G06F16/2455 ,  G06F9/50 ,  H04L12/26 ,  H04L12/803

Abstract: Methods and systems for making effective use of system resources. A plurality of requests for access to a resource are received. Each request has an associated group of features. The group of features for each request is analyzed to collect observations about the plurality of requests. A function to predict an outcome of a subsequent request is generated based on the observations. Resources are allocated to service the subsequent request based on the function.

公开(公告)号：US20200012645A1

公开(公告)日：2020-01-09

申请号：US16299035

申请日：2019-03-11

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Craig Weissman

IPC: G06F16/2453 ,  G06F16/2458

Abstract: Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving, at a network interface of a server computer in a multi-tenant database system, an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes a first two-column custom index. Metadata associated with the data accessible by the tenant is retrieved, using a processor of the server computer, wherein at least a portion of the data accessible by the tenant is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined, using the processor, wherein determining comprises analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. Finally, using the processor, an improved query is generated using the query syntax, wherein the improved query is based at least in part upon the original query and data stored in the first two-column custom index.

公开(公告)号：US20190108248A1

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

申请号：US16166488

申请日：2018-10-22

Applicant: salesforce.com, inc.

Inventor： Chirag Rajan ,  Arup Dutta ,  John O'Brien ,  Jaikumar Bathija ,  Greg Salmon ,  Dan Soble ,  RamaLinga R. Penmetsa ,  Hoon Kim ,  Yanan Jiang ,  Karthik Rajan ,  Jesse Collins

IPC: G06F17/30

Abstract: Methods and systems are described for creating a custom index in a multi-tenant database environment. In one embodiment, a method includes obtaining query for a multi-tenant database that is recommended as a candidate for creating an additional filter, evaluating the query against criteria to determine whether to select the query for creating the additional filter, and creating the additional filter for the query, if the query is selected.