公开(公告)号：US10649986B2

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

申请号：US15421036

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F16/00 ,  G06F16/242

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY ORGID command term within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a command term to filter all tables accessed pursuant to execution of the database query by an organization_id parameter corresponding to one of the plurality of distinct customer organizations; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to one or more tables within the multi-tenant database system; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement filters every reference to the one or more tables by the organization_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

公开(公告)号：US20190034321A1

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

申请号：US16133106

申请日：2018-09-17

Applicant: salesforce.com, inc.

Inventor： Jameison Bear Martin ,  Subho Sanjay Chatterjee ,  Patrick James Helland ,  Nathaniel Wyatt ,  Thomas Fanghaenel ,  Terry Chong ,  Robert Frankus ,  Simon Wong

IPC: G06F11/36 ,  G06F17/30 ,  G06F8/60 ,  G06F21/53

Abstract: Systems and methods are provided for creating a sandbox for an original tenant at a point in time, the original tenant having original tenant data stored in an immutable storage associated with an original tenant identifier, the original tenant data as of the sandbox creation point in time being a virtual snapshot of the original tenant data accessible by a sandbox tenant, where the sandbox tenant data can be changed without changing the original tenant data, and the original tenant data can be changed without changing the sandbox tenant data. A sandbox tenant is created by associating a sandbox tenant identifier with the virtual snapshot of the original tenant data and with sandbox tenant data created by the sandbox tenant subsequent to the sandbox creation point in time. In some implementations, the original tenant is an original sandbox tenant, and the sandbox tenant is at least one new sandbox tenant.

公开(公告)号：US20180218044A1

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

申请号：US15421063

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F17/30

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY PARTITION command term within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; maintaining a plurality of tables within the multi-tenant database system to store the customer data, in which one or more of the tables is partitioned into a plurality of table partitions; receiving a database query specifying a command term to restrict a specified table accessed pursuant to execution of the database query by a partition_id parameter; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to the specified table within the multi-tenant database system to be restricted by the partition_id parameter; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement accesses only a sub-portion of the specified table corresponding to exactly one table partition of the specified table having a partition ID matching the partition_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

公开(公告)号：US20170177326A1

公开(公告)日：2017-06-22

申请号：US15453539

申请日：2017-03-08

Applicant: salesforce.com, inc.

Inventor： David Brooks ,  Lewis Wiley Tucker ,  Benji Jasik ,  Timothy Mason ,  Eric David Bezar ,  Simon Wong ,  Douglas Chasman ,  Tien Tzuo ,  Scott Hansma ,  Adam Gross ,  Steven Tamm

IPC: G06F9/44 ,  H04L29/08 ,  G06F9/445 ,  G06F17/30 ,  H04L29/06

Abstract: In accordance with embodiments, there are provided mechanisms and methods for creating, exporting, viewing and testing, and importing custom applications in a multitenant database environment. These mechanisms and methods can enable embodiments to provide a vehicle for sharing applications across organizational boundaries. The ability to share applications across organizational boundaries can enable tenants in a multi-tenant database system, for example, to easily and efficiently import and export, and thus share, applications with other tenants in the multi-tenant environment.

公开(公告)号：US20170003947A1

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

申请号：US15194418

申请日：2016-06-27

Applicant: salesforce.com, inc.

Inventor： David Brooks ,  Lewis Wiley Tucker ,  Benji Jasik ,  Timothy Mason ,  Eric David Bezar ,  Simon Wong ,  Douglas Chasman ,  Tien Tzuo ,  Scott Hansma ,  Adam Gross ,  Steven Tamm

IPC: G06F9/445 ,  G06F3/0482 ,  H04L29/08 ,  G06F17/30

CPC classification number: G06F8/61 ,  G06F3/0482 ,  G06F3/0483 ,  G06F8/60 ,  G06F8/658 ,  G06F15/173 ,  G06F17/30017 ,  G06F17/30165 ,  G06F17/30292 ,  G06F17/303 ,  G06F17/30356 ,  G06F17/30525 ,  G06F17/30575 ,  G06F17/30592 ,  G06F17/30607 ,  G06F17/30887 ,  G06F17/30893 ,  G06F17/30994 ,  H04L12/50 ,  H04L63/1433 ,  H04L67/34

Abstract: In accordance with embodiments, there are provided mechanisms and methods for creating, exporting, viewing and testing, and importing custom applications in a multitenant database environment. These mechanisms and methods can enable embodiments to provide a vehicle for sharing applications across organizational boundaries. The ability to share applications across organizational boundaries can enable tenants in a multi-tenant database system, for example, to easily and efficiently import and export, and thus share, applications with other tenants in the multi-tenant environment.

Abstract translation: 根据实施例，提供了用于在多租户数据库环境中创建，导出，查看和测试以及导入定制应用程序的机制和方法。 这些机制和方法可以使得实施例能够提供跨组织边界共享应用的车辆。 跨组织边界共享应用程序的能力可以使多租户数据库系统中的租户能够轻松有效地导入和导出，从而与多租户环境中的其他租户共享应用程序。

公开(公告)号：US20130238677A1

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

申请号：US13866855

申请日：2013-04-19

Applicant: SALESFORCE.COM, INC.

Inventor： Kedar Doshi ,  Sonali Agrawal ,  Simon Wong ,  Chaitanya Bhatt ,  Sandip Ghosh ,  Gary Baker

IPC: G06F17/30

CPC classification number: G06F16/182 ,  G06F16/122 ,  G06F16/13 ,  G06F16/14 ,  G06F16/1748 ,  G06F16/176

Abstract: In accordance with embodiments, there are provided mechanisms and methods for using a database to access content stored outside of the database. These mechanisms and methods for using a database to access content stored outside of the database can enable embodiments to provide a database system which can be used to access content when the content is incapable of being stored in the database system, or is otherwise not stored in the database system. The ability of embodiments to provide access to such data via the database system can improve the usability of the database system.

Abstract translation: 根据实施例，提供了使用数据库访问存储在数据库外部的内容的机制和方法。 用于使用数据库访问存储在数据库外部的内容的这些机制和方法可以使得实施例能够提供数据库系统，当内容不能存储在数据库系统中时，数据库系统可被用于访问内容，否则不存储在 数据库系统。 实施例通过数据库系统提供对这些数据的访问的能力可以提高数据库系统的可用性。

公开(公告)号：US20130046752A1

公开(公告)日：2013-02-21

申请号：US13656604

申请日：2012-10-19

Applicant: SALESFORCE.COM, INC

Inventor： Craig Weissman ,  Dave Moellenhoff ,  Simon Wong ,  Paul Nakada

IPC: G06F17/30

CPC classification number: G06F21/6218 ,  G06F16/2453 ,  G06F16/2462 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99938 ,  Y10S707/99939

Abstract: More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant's unique tag.

Abstract translation: 使用数据库索引的动态调整更有效地查询多租户数据库。 元数据层将数据项与租户（例如，经由标签）相关联，并且元数据用于通过在查询期间将处理资源传递给仅涉及相关租户的唯一标签的那些数据来优化搜索。

公开(公告)号：US10691437B2

公开(公告)日：2020-06-23

申请号：US15682277

申请日：2017-08-21

Applicant: salesforce.com, inc.

Inventor： David Brooks ,  Lewis Wiley Tucker ,  Benji Jasik ,  Timothy Mason ,  Eric David Bezar ,  Simon Wong ,  Douglas Chasman ,  Tien Tzuo ,  Scott Hansma ,  Adam Gross ,  Steven Tamm

IPC: G06F16/00 ,  G06F8/61 ,  G06F8/658 ,  G06F16/27 ,  G06F16/40 ,  G06F16/176 ,  G06F16/21 ,  G06F16/28 ,  G06F16/958 ,  G06F16/23 ,  G06F16/955 ,  G06F8/60 ,  G06F3/0482 ,  H04L29/08 ,  H04L29/06 ,  G06F15/173 ,  H04L12/50 ,  G06F16/904 ,  G06F16/2457 ,  G06F3/0483

Abstract: A computer implemented method of developing computer applications, the method comprising providing to multiple users access, over a network, to information on a data center, with a subgroup of the users having access to a sub-portion of the information that is different from the sub-portion accessible by the remaining tenants of the subgroup; and communicating wide the data center over the network employing a computer system associated with a user of the sub-group to establish application functionality with the sub-portion that may be accessed, over the network, by additional parties authorized by the user. Also disclosed is a machine-readable medium and a data center, both of which facilitate carrying-out the steps of the method.

公开(公告)号：US10152508B2

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

申请号：US13873146

申请日：2013-04-29

Applicant: salesforce.com, inc

Inventor： Craig Weissman ,  Dave Moellenhoff ,  Simon Wong

IPC: G06F17/30

Abstract: In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and/or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems.

公开(公告)号：US20180218032A1

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

申请号：US15421092

申请日：2017-01-31

Applicant: Salesforce.com, Inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F17/30

CPC classification number: G06F16/2425 ,  G06F16/3341

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing conditional statement execution within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a command term to conditionally execute a sub-portion of the database query when a Boolean evaluation specified with the database query resolves to true and to negate execution of the sub-portion of the database query when the Boolean evaluation resolves to false; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to the sub-portion of the database query to be conditionally executed or negated pursuant to the Boolean evaluation; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement includes a semantic structure to execute the sub-portion of the database query when the Boolean evaluation resolves to true and to omit from execution the sub-portion of the database query when the Boolean evaluation resolves to false; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.