公开(公告)号：US20230016877A1

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

申请号：US17936301

申请日：2022-09-28

Applicant: salesforce.com, inc.

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

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

公开(公告)号：US10958505B2

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

申请号：US16532352

申请日：2019-08-05

Applicant: salesforce.com, inc.

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

IPC: G06F11/07 ,  H04L12/24

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.

公开(公告)号：US10901991B2

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

申请号：US15011277

申请日：2016-01-29

Applicant: salesforce.com, inc.

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

IPC: G06F16/2453 ,  G06F16/2458

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.

公开(公告)号：US20190354891A1

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

申请号：US16259964

申请日：2019-01-28

Applicant: salesforce.com, inc.

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

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

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.

公开(公告)号：US20190294512A1

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

申请号：US16440104

申请日：2019-06-13

Applicant: salesforce.com, inc.

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

IPC: G06F11/20 ,  G06F16/23 ,  G06F16/27 ,  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.

公开(公告)号：US10425274B2

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

申请号：US15804254

申请日：2017-11-06

Applicant: salesforce.com, inc.

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

IPC: G06F11/07 ,  H04L12/24

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.

公开(公告)号：US10152511B2

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

申请号：US14028316

申请日：2013-09-16

Applicant: salesforce.com, inc.

Inventor： Chirag Rajan ,  Jesse Collins ,  Jaikumar Bathija ,  Hoon Kim

IPC: G06F17/30

Abstract: In an on demand database system, a query engine applies a custom index for inner queries. The query engine receives a query and determines that the query has an inner query nested within the primary query. The query engine identifies that a custom index exists for a client associated with the query, and applies the custom index to filter results for the query. The custom index includes a subset of information of a table that includes accounts for multiple different clients. By using the custom index, the query engine can filter the results more efficiently that if solely using the multiple client table.

公开(公告)号：US11436223B2

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

申请号：US15419509

申请日：2017-01-30

Applicant: salesforce.com, inc.

Inventor： RamaLinga Raju Penmetsa ,  Prem Veeramani ,  Jeffrey Lallana Freschl ,  Jesse Collins ,  Ganesh Maganti

IPC: G06F16/2453

Abstract: Systems, methods, and computer-readable media for pinning query execution plans are described. A database system may obtain a query, and determine a organization identifier and/or user identifier associated with the query. The database system may identify an optimized plan among a set of query plans that correspond with the query, and may generate a query execution plan based on the query and the optimized plan. The database system may determine a pinned plan that is associated with the optimized plan, and may generate a query execution plan based on the pinned plan when the pinned plan is associated with the optimized plan and corresponds with the organization identifier and/or the user identifier. The database system may generate a query execution plan using optimization functions when the pinned plan is not associated with the pinned plan, or the organization identifier and/or the user identifier. Other embodiments may be described and/or claimed.

公开(公告)号：US11093356B2

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

申请号：US16440104

申请日：2019-06-13

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.

公开(公告)号：US10650028B2

公开(公告)日：2020-05-12

申请号：US15415293

申请日：2017-01-25

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Xuerong Tang

IPC: G06F16/28 ,  G06F16/2452 ,  G06F16/21

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.