公开(公告)号：US20210211491A1

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

申请号：US17070836

申请日：2020-10-14

Applicant: salesforce.com, inc.

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

IPC: H04L29/08 ,  H04L12/861 ,  G06N20/00 ,  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.

公开(公告)号：US10545962B2

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

申请号：US15415186

申请日：2017-01-25

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Xuerong Tang ,  Scott Hansma

IPC: G06F7/00 ,  G06F17/30 ,  G06F16/2455 ,  G06F16/28

Abstract: In an example, a database system may be configured to validate relational database instructions using a plurality of validators. In some examples, validation may be pre-production for relational database instructions based on simulated user inputs and/or file, such as plan files (e.g., PL/SQL (procedural language/structured query language) files). In some examples, validation may be in production for relational database instructions based on system views of a database engine.

公开(公告)号：US10452630B2

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

申请号：US15295305

申请日：2016-10-17

Applicant: salesforce.com, inc.

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

IPC: G06F16/22 ,  G06F16/245 ,  G06F16/9535 ,  G06F16/2453

Abstract: Reverse database query mapping. A database query to be executed on a computing platform against a database managed by the computing platform is received. Query mapping information is stored in a memory system accessible to the one or more processors. A source query corresponding to a query identifier is retrieved in response to statistical analysis. One or more potential indexes are generated for use with the source query, wherein at least one of the one or more potential indexes can function to improve performance of the source query.

公开(公告)号：US20180331887A1

公开(公告)日：2018-11-15

申请号：US15804254

申请日：2017-11-06

Applicant: salesforce.com, inc.

Inventor： Olumayokun Obembe ,  Chen Liu ,  Ping-Hsiu Hsieh ,  Ashwini Bijwe ,  Vijayanth Devadhar ,  Mikhail Chainani ,  Sridevi Gopola Krishnan ,  Alan Arbizu ,  Jesse Collins

IPC: H04L12/24 ,  G06F11/07

CPC classification number: H04L41/0654 ,  G06F11/0709 ,  G06F11/0757 ,  G06F11/0793

Abstract: Techniques and architectures to provide multiple application servers each having at least one connection agent and at least one enabler agent and at least one database organized as multiple nodes. An error condition between a first connection agent and a first database node is detected. The first connection agent indicates that the first database node is unavailable to stop attempts to access the first database node by a first application server. A first enabler agent periodically checks availability of the first database node. The first database node is indicated as available in response to a pre-selected number of successful attempts to contact the first database node with the first enabler agent. The first database node is accessed with the application server in response to the indication that the first database node is available.

公开(公告)号：US20180218020A1

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

申请号：US15419358

申请日：2017-01-30

Applicant: salesforce.com, inc.

Inventor： Arup Kumar Dutta ,  Jesse Collins

IPC: G06F17/30

CPC classification number: G06F16/22

Abstract: Techniques are disclosed relating to creating an index for a database system. In one embodiment, a database system stores data within a plurality of fields in a data table, a subset of the data being associated with a particular one of the plurality of fields. The database system receives a request to index the data table based on the particular field and analyzes the subset of the data. In response to determining, based on the analyzing, that one or more duplicate values are present in the subset of data, the database system sets, in an index table having the particular field, an indication identifying which entries of the index table have a duplicate value for the particular field, and returns a response to the request that specifies the one or more duplicate values. In some embodiments, the response includes a user interface displaying one or more duplicates values.

公开(公告)号：US09965511B2

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

申请号：US14179155

申请日：2014-02-12

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Jaikumar Bathija

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30445 ,  G06F17/30448

Abstract: In accordance with embodiments, there are provided mechanisms and methods for query optimization in a database system. These mechanisms and methods for query optimization in a database system can enable embodiments to optimize OR expression filters referencing different logical tables. The ability of embodiments to optimize OR expression filters referencing different logical tables can enable optimization that is dynamic and specific to the particular tenant for whom the query is run and improve the performance and efficiency of the database system in response to query requests.

公开(公告)号：US09946751B2

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

申请号：US15212115

申请日：2016-07-15

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.

公开(公告)号：US09854039B2

公开(公告)日：2017-12-26

申请号：US15004523

申请日：2016-01-22

Applicant: salesforce.com, inc.

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

IPC: G06F17/30 ,  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.

公开(公告)号：US20170017690A1

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

申请号：US15212115

申请日：2016-07-15

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

公开(公告)号：US20160147835A1

公开(公告)日：2016-05-26

申请号：US15011277

申请日：2016-01-29

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

IPC: G06F17/30

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

Abstract: Techniques and structures for tuning database queries. Actual statistics associated with data stored are retrieved from at least one memory device. The data is associated with one or more tenants of the multi-tenant database system. The actual statistics include at least one type of statistic maintained for the data. A subset of the actual statistics is selected based on a data trait targeted for optimization. A statistical value is calculated for each actual statistic from the subset of actual statistics across one or more tenants having the data trait targeted for optimization. An optimal query plan is determined based on the original query and the calculated statistical values.

Abstract translation: 调整数据库查询的技术和结构。 从至少一个存储设备检索与存储的数据相关联的实际统计。 数据与多租户数据库系统的一个或多个租户相关联。 实际统计数据包括为数据维护的至少一种类型的统计信息。 基于针对优化的数据特征选择实际统计的子集。 针对具有针对优化的数据特征的一个或多个承租人从实际统计子集中的每个实际统计量计算统计值。 基于原始查询和计算的统计值确定最优查询计划。