公开(公告)号：US11916918B2

公开(公告)日：2024-02-27

申请号：US16848644

申请日：2020-04-14

Applicant: salesforce.com, inc.

Inventor： Yucheng Wang ,  Saravanan Adaikkalavan ,  Hao Wu ,  Hugh Cockburn ,  Colin Frank ,  Kaysha Chandran ,  William Charles Eidson ,  Timothy Peng

IPC: G06F3/0482 ,  H04L9/40 ,  G06F16/23 ,  H04L67/306 ,  G06F16/25

CPC classification number: H04L63/105 ,  G06F3/0482 ,  G06F16/2379 ,  G06F16/252 ,  H04L63/102 ,  H04L67/306

Abstract: Disclosed are some implementations of systems, apparatus, methods and computer program products for executing process flows. A request to initiate execution of a flow is processed, where the request is received from a first user. The flow includes a plurality of flow elements, where each of the flow elements represents a corresponding set of computer-readable instructions. Execution of the flow is initiated and an operation mode assigned to one of the flow elements is determined. A set of computer-readable instructions corresponding to the flow element is executed according to the operation mode such that an identity of the first user is recorded in association with an operation on a database record, wherein permissions allocated in a user profile to the first user do not provide the first user permission to cause the operation on the database record. Output indicating a result of executing the set of computer-readable instructions according to the operation mode is provided for presentation via a graphical user interface (GUI).

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

公开(公告)号：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.

公开(公告)号：US10713251B2

公开(公告)日：2020-07-14

申请号：US14953794

申请日：2015-11-30

Applicant: salesforce.com, inc.

Inventor： Craig Weissman ,  William Charles Eidson ,  Erik Forsberg ,  Deepak Kothule

IPC: G06F16/2455 ,  G06F16/21 ,  G06F16/22 ,  G06F16/27 ,  G06F16/245 ,  G06F16/248 ,  G06F16/2457 ,  G06F16/23

Abstract: Mechanisms and methods for pushing data to a plurality of devices of a plurality of organizations are provided. Queries are handled in bulk for a group of users of an organization or the entire organization, and limited results are sent to a middle tier server between the database system and the user devices. These mechanisms and methods for pushing data to a plurality of devices enable an efficient and transparent transfer of data to user devices. This efficient and transparent transfer of data can enable mobile devices of many organizations to seamlessly have the data that is required to perform business.

公开(公告)号：US20210320927A1

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

申请号：US16848644

申请日：2020-04-14

Applicant: salesforce.com, inc.

Inventor： Yucheng Wang ,  Saravanan Adaikkalavan ,  Hao Wu ,  Hugh Cockburn ,  Colin Frank ,  Kaysha Chandran ,  William Charles Eidson ,  Timothy Peng

IPC: H04L29/06 ,  G06F16/25 ,  G06F16/23 ,  H04L29/08 ,  G06F3/0482

Abstract: Disclosed are some implementations of systems, apparatus, methods and computer program products for executing process flows. A request to initiate execution of a flow is processed, where the request is received from a first user. The flow includes a plurality of flow elements, where each of the flow elements represents a corresponding set of computer-readable instructions. Execution of the flow is initiated and an operation mode assigned to one of the flow elements is determined. A set of computer-readable instructions corresponding to the flow element is executed according to the operation mode such that an identity of the first user is recorded in association with an operation on a database record, wherein permissions allocated in a user profile to the first user do not provide the first user permission to cause the operation on the database record. Output indicating a result of executing the set of computer-readable instructions according to the operation mode is provided for presentation via a graphical user interface (GUI).

公开(公告)号：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.

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

公开(公告)号：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.

公开(公告)号：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.

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