公开(公告)号：US10922313B2

公开(公告)日：2021-02-16

申请号：US16299035

申请日：2019-03-11

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Craig Weissman

IPC: G06F7/00 ,  G06F16/2453 ,  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 computer 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 a first two-column custom index. Metadata associated with the data accessible by the tenant is retrieved, using a processor of the server computer, wherein at least a portion of the data accessible by the tenant is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined, using the processor, wherein determining comprises analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. Finally, using the processor, an improved query is generated using the query syntax, wherein the improved query is based at least in part upon the original query and data stored in the first two-column custom 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.

公开(公告)号：US10649995B2

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

申请号：US15344340

申请日：2016-11-04

Applicant: Salesforce.com, Inc.

Inventor： Craig Weissman ,  James Taylor

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/24 ,  G06F16/242 ,  G06F16/25 ,  G06F16/2455 ,  G06F16/2457

Abstract: Methods and systems for optimizing queries in a multi-tenant store are described. In one embodiment, such a method includes retrieving data from a multi-tenant database system having a relational data store and a non-relational data store, receiving a request specifying data to be retrieved, retrieving one or more locations of the data to be retrieved, generating a database query based on the request, in which the database query specifies a plurality of data elements to be retrieved, the plurality of data elements including one or more data elements residing within the non-relational data store and one or more other data elements residing within the relational data store, generating an optimized database query having an optimized query syntax that is distinct from a query syntax of the database query, and executing the optimized database query against the multi-tenant database system to retrieve the data.

公开(公告)号：US20200012645A1

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

申请号：US16299035

申请日：2019-03-11

Applicant: salesforce.com, inc.

Inventor： Jesse Collins ,  Craig Weissman

IPC: G06F16/2453 ,  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 computer 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 a first two-column custom index. Metadata associated with the data accessible by the tenant is retrieved, using a processor of the server computer, wherein at least a portion of the data accessible by the tenant is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined, using the processor, wherein determining comprises analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. Finally, using the processor, an improved query is generated using the query syntax, wherein the improved query is based at least in part upon the original query and data stored in the first two-column custom index.

公开(公告)号：US10481903B2

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

申请号：US14861948

申请日：2015-09-22

Applicant: salesforce.com, inc.

Inventor： Craig Weissman

IPC: G06F17/30 ,  G06F17/00 ,  G06F8/71 ,  G06F8/70

Abstract: In accordance with embodiments, there are provided mechanisms and methods for validating a developed application. These mechanisms and methods for providing such validation can enable embodiments to ensure that new versions of developed applications will operate in the same application environment of a previous version. The ability of embodiments to provide such validation may lead to an improved application migration development/runtime framework, etc.

公开(公告)号：US20190026188A1

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

申请号：US15995142

申请日：2018-06-01

Applicant: salesforce.com, inc.

Inventor： Scott Yancey ,  Andrew Smith ,  Andrew Waite ,  Craig Weissman

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1451 ,  G06F16/2365 ,  G06F16/2372 ,  G06F16/273

Abstract: In accordance with embodiments, there are provided techniques for implementing batch processing in a multi-tenant database system. These techniques for implementing batch processing in a multi-tenant database system may enable embodiments to provide great flexibility to a tenant of the architecture to perform desired functions on content of the database while allowing the owner of the architecture schedule the processing of the functions on the content.

公开(公告)号：US20180322153A1

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

申请号：US16032405

申请日：2018-07-11

Applicant: salesforce.com, inc.

Inventor： Craig Weissman ,  Simon Wong

IPC: G06F17/30 ,  G06F21/62

Abstract: Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a custom data column within the object data structure, and this single custom data column may contain different data types for each tenant.

公开(公告)号：US20180052895A1

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

申请号：US15790890

申请日：2017-10-23

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Ryan Choi ,  Craig Weissman ,  Michael P. Polcari ,  David M. Brady

IPC: G06F17/30

CPC classification number: G06F16/2477 ,  G06F16/2465 ,  G06F21/604

Abstract: In accordance with embodiments, there are provided mechanisms and methods for defining custom junction objects in an on-demand database service. These mechanisms and methods for defining custom junction objects in an on-demand database service can enable embodiments to provide for enhanced security and more efficient querying, etc. The ability of embodiments to provide such features may lead to these and other benefits in an on-line environment.

公开(公告)号：US09323804B2

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

申请号：US13865896

申请日：2013-04-18

Applicant: salesforce.com, inc

Inventor： Craig Weissman

IPC: G06F9/44 ,  G06F9/445 ,  G06F17/30 ,  G06F11/36 ,  G06F21/62

CPC classification number: G06F21/6218 ,  G06F8/30 ,  G06F8/60 ,  G06F11/3604 ,  G06F11/3664 ,  G06F17/30386 ,  G06F21/6227

Abstract: In accordance with embodiments, there are provided mechanisms and methods for allowing access to developed applications via a multi-tenant on-demand database service, in a controlled environment. These mechanisms and methods for providing such access can enable embodiments to provide additional control over the development process as well as the access of such developed applications. The ability of embodiments to provide such additional control may lead to an improved application development framework, etc.

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