公开(公告)号：US20180329793A1

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

申请号：US15862525

申请日：2018-01-04

Applicant: salesforce.com, inc.

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

IPC: G06F11/30 ,  G06F17/30 ,  G06F11/14

CPC classification number: G06F11/3089 ,  G06F11/14 ,  G06F17/30289 ,  G06F17/30371

Abstract: In a computing environment having multiple application servers each having at least one connection agent and at least one pause agent and a database node, detecting an error condition between a first application server from the multiple application servers and the database node. Indicating that the database node is unavailable to stop attempts to access the database node by a first application server. The attempts to access the database node are paused without an indication of the database node being unavailable to a source of the attempt to access the database node. Checking periodically, with the first application server, availability of the database node. Indicating that the database node is available in response to a pre-selected number of successful attempts to contact the database node with the first application server.

公开(公告)号：US09760594B2

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

申请号：US15046338

申请日：2016-02-17

Applicant: salesforce.com, inc.

Inventor： Hoon Kim ,  Jesse Collins ,  Chirag Rajan

IPC: G06F17/00 ,  G06F17/30

CPC classification number: G06F17/30371 ,  G06F17/30115 ,  G06F17/30327 ,  G06F17/30339 ,  G06F17/30598

Abstract: Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.

公开(公告)号：US20160162536A1

公开(公告)日：2016-06-09

申请号：US15046338

申请日：2016-02-17

Applicant: salesforce.com, inc.

Inventor： Hoon Kim ,  Jesse Collins ,  Chirag Rajan

IPC: G06F17/30

CPC classification number: G06F17/30371 ,  G06F17/30115 ,  G06F17/30327 ,  G06F17/30339 ,  G06F17/30598

Abstract: Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.

Abstract translation: 多租户数据库环境中的统计机制。 在多租户数据库系统中维护主统计信息文件。 主统计信息文件具有与多租户数据库系统中的多个租户对应的统计信息。 生成多租户数据库系统中选定表的统计信息。 所选择的表对应于多租户数据库系统的选定租户。 主统计信息文件根据所选表格的生成统计信息进行更新。

公开(公告)号：US09244995B2

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

申请号：US14275777

申请日：2014-05-12

Applicant: salesforce.com, inc.

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

IPC: G06F17/30

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

公开(公告)号：US20150235144A1

公开(公告)日：2015-08-20

申请号：US14703682

申请日：2015-05-04

Applicant: salesforce.com, inc.

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

IPC: G06N99/00 ,  G06F17/30

CPC classification number: G06N99/005 ,  G06F9/5011 ,  G06F17/30477 ,  G06F2209/5019 ,  H04L29/08072 ,  H04L43/0876 ,  H04L47/125 ,  H04L49/90 ,  H04L67/10 ,  H04L67/1002

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.

Abstract translation: 有效利用系统资源的方法和系统。 接收到对资源的​​访问的多个请求。 每个请求都有相关的功能组。 分析每个请求的一组特征以收集关于多个请求的观察。 基于观察结果生成预测后续请求的结果的功能。 根据该功能分配资源以服务后续请求。

公开(公告)号：US20140164357A1

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

申请号：US14179155

申请日：2014-02-12

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Jaikumar Bathija

IPC: 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.

Abstract translation: 根据实施例，提供了一种用于数据库系统中的查询优化的机制和方法。 用于数据库系统中的查询优化的这些机制和方法可使实施例能够优化引用不同逻辑表的OR表达式过滤器。 实施例优化引用不同逻辑表的OR表达式过滤器的能力可以实现对运行查询的特定租户是动态特定的优化，并且响应于查询请求而提高数据库系统的性能和效率。

公开(公告)号：US11675760B2

公开(公告)日：2023-06-13

申请号：US15419358

申请日：2017-01-30

Applicant: salesforce.com, inc.

Inventor： Arup Kumar Dutta ,  Jesse Collins

IPC: G06F16/22

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.

公开(公告)号：US20220374397A1

公开(公告)日：2022-11-24

申请号：US17326610

申请日：2021-05-21

Applicant: salesforce.com, inc.

Inventor： Mang Fu Matthew Wong ,  Subhash Uppalapati ,  Jesse Wang ,  Sunghyun Song ,  Federico Recio ,  Jesse Collins

IPC: G06F16/21 ,  G06F16/28 ,  G06F16/2455

Abstract: Systems and methods are described for implementing attribute aware, relationship-based access control by receiving a query to access a relational database from a user, determining if a rule of the relational database is applicable to the query, determining one or more relationships associated with the query based at least in part on the rule, and modifying the query by adding an extra join operation to the query based at least in part on the rule and the one or more relationships. Further, when a type of the rule is row level, a where clause filter is added to the modified query to enforce a condition of the rule, and when the type of the rule is field level, a case column is added to the modified query and a select clause is added to the modified query to wrap the query. The modified query is processed to produce a result.

公开(公告)号：US11496555B2

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

申请号：US17070836

申请日：2020-10-14

Applicant: salesforce.com, inc.

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

IPC: G06F15/16 ,  H04L67/1008 ,  H04L49/90 ,  G06N20/00 ,  G06F16/2455 ,  H04L69/329 ,  H04L67/1014 ,  H04L67/1001 ,  G06F9/50 ,  H04L43/0876 ,  H04L47/125 ,  H04L67/10

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.

公开(公告)号：US20210294802A1

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

申请号：US17157842

申请日：2021-01-25

Applicant: salesforce.com, inc.

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

IPC: G06F16/2453

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.