公开(公告)号：US10762085B2

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

申请号：US15295256

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Awais Tariq ,  Rohitashva Mathur ,  Arup Dutta ,  Prem Veeramani ,  Jesse Collins

IPC: G06F7/00 ,  G06F16/2453 ,  G06F16/21 ,  G06F16/22 ,  G06F16/2457 ,  G06F17/00

Abstract: Automated query tuning. A database query to be executed against a database is received. The database query is analyzed to determine one or more potential indexes to be evaluated. The one or more potential indexes are evaluated to determine if an optimization utilizing a selected potential index provides improved performance over performing the database query without the selected potential index. The one or more potential indexes are scored based on results of the evaluating. A recommendation of one or more of the potential indexes is provided to a source of the database query.

公开(公告)号：US10372934B2

公开(公告)日：2019-08-06

申请号：US15295288

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Rohitashva Mathur ,  Prem Veeramani ,  Jesse Collins

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

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.

公开(公告)号：US10262027B2

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

申请号：US14802144

申请日：2015-07-17

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Jaikumar Bathija

IPC: G06F7/00 ,  G06F17/30

Abstract: In a method, system, and computer-readable medium having instructions for executing a query in a database system, a query request is received with a query predicate to filter data returned in response to the query request and the query predicate has a formula, the query request is transformed to a transformed query request by preprocessing the formula in the query predicate, and the query request is optimized using the transformed query request.

公开(公告)号：US10192169B2

公开(公告)日：2019-01-29

申请号：US14703682

申请日：2015-05-04

Applicant: salesforce.com, inc.

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

IPC: G06F15/16 ,  G06N99/00 ,  G06F17/30 ,  H04L29/08

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.

公开(公告)号：US20180276276A1

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

申请号：US15924023

申请日：2018-03-16

Applicant: salesforce.com, inc.

Inventor： William Charles Eidson ,  Jesse Collins

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/2246 ,  G06F16/2453 ,  G06F16/24542 ,  G06F16/2462

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.

公开(公告)号：US20160234305A1

公开(公告)日：2016-08-11

申请号：US15004523

申请日：2016-01-22

Applicant: salesforce.com, inc.

Inventor： Greg Salmon ,  Chris Hopkins ,  Anant Verma ,  Jesse Collins ,  Craig Weissman

IPC: H04L29/08

CPC classification number: H04L67/1095 ,  G06F17/30174 ,  G06F17/30575 ,  H04L67/1097

Abstract: In accordance with embodiments, there are provided mechanisms and methods for synchronizing a server and an on-demand database service. These mechanisms and methods for synchronizing a server and an on-demand database service can enable embodiments to synchronize a larger amount of data. The ability of embodiments to provide such feature can enable more effective synchronization of a user-level sharing entity database with a multi-user on-demand database service.

Abstract translation: 根据实施例，提供了用于同步服务器和按需数据库服务的机制和方法。 用于同步服务器和按需数据库服务的这些机制和方法可以使实施例能够同步较大量的数据。 实施例提供这种特征的能力可以使得用户级共享实体数据库与多用户点播数据库服务的更有效同步。

公开(公告)号：US09405797B2

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

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

公开(公告)号：US20150324421A1

公开(公告)日：2015-11-12

申请号：US14802144

申请日：2015-07-17

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Jaikumar Bathija

IPC: G06F17/30

CPC classification number: G06F17/30398 ,  G06F17/30333 ,  G06F17/30389 ,  G06F17/30442 ,  G06F17/30448 ,  G06F17/30463 ,  G06F17/30622 ,  G06F17/30867

Abstract: In a method, system, and computer-readable medium having instructions for executing a query in a database system, a query request is received with a query predicate to filter data returned in response to the query request and the query predicate has a formula, the query request is transformed to a transformed query request by preprocessing the formula in the query predicate, and the query request is optimized using the transformed query request.

Abstract translation: 在具有用于在数据库系统中执行查询的指令的方法，系统和计算机可读介质中，使用查询谓词接收查询请求以过滤响应于查询请求返回的数据，并且查询谓词具有公式， 通过对查询谓词中的公式进行预处理，将查询请求转换为变换查询请求，并使用转换查询请求优化查询请求。

公开(公告)号：US11232102B2

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

申请号：US15295319

申请日：2016-10-17

Applicant: salesforce.com, inc.

Inventor： Awais Tariq ,  Rohitashva Mathur ,  Arup Dutta ,  Prem Veeramani ,  Jesse Collins

IPC: G06F16/2453 ,  G06F16/21

Abstract: A database query is received at a first time when a database is in a first state. The database query is analyzed to determine whether it has one or more characteristics that fall within a historical top range of database queries. If the database query falls within the historical top range of database queries the query is stored for later query tuning activity. The query is executed against the database in the first state. Query tuning recommendations are generated for stored database queries that fall within the historical top range of database queries. A subsequent request is received at a second time when a database is in a second state. The subsequent database query is executed with at least one of the query tuning recommendations against the database in the second state.

公开(公告)号：US20210319024A1

公开(公告)日：2021-10-14

申请号：US17209021

申请日：2021-03-22

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.