公开(公告)号：US10713230B2

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

申请号：US16032405

申请日：2018-07-11

Applicant: salesforce.com, inc.

Inventor： Craig Weissman ,  Simon Wong

IPC: G06F7/00 ,  G06F16/22 ,  G06F16/28 ,  G06Q10/06 ,  G06F16/2458 ,  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.

公开(公告)号：US20200159514A1

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

申请号：US16689960

申请日：2019-11-20

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: G06F8/61 ,  G06F16/21 ,  G06F8/658 ,  H04L29/06 ,  G06F16/40 ,  G06F16/955 ,  G06F3/0482 ,  G06F16/28 ,  G06F16/23 ,  G06F8/60 ,  H04L29/08 ,  G06F16/176 ,  G06F16/27 ,  G06F16/958 ,  G06F15/173 ,  G06F16/904 ,  G06F16/2457 ,  H04L12/50 ,  G06F3/0483

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.

公开(公告)号：US10235148B2

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

申请号：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: G06F8/60 ,  G06F8/61 ,  G06F17/30 ,  H04L29/08 ,  G06F8/658 ,  G06F3/0482 ,  H04L29/06 ,  G06F15/173 ,  H04L12/50 ,  G06F3/0483

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.

公开(公告)号：US20180218030A1

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

申请号：US15421036

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Gary Baker

IPC: G06F17/30

CPC classification number: G06F16/2425

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.

公开(公告)号：US20180074806A1

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

申请号：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: G06F9/445 ,  H04L29/08 ,  G06F17/30 ,  G06F9/44 ,  G06F3/0482 ,  G06F15/173 ,  H04L12/50

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.

公开(公告)号：US09740466B2

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

申请号：US13874337

申请日：2013-04-30

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: G06F17/30 ,  G06F9/445 ,  G06F9/44 ,  G06F3/0482 ,  H04L29/08 ,  G06F15/173 ,  H04L12/50

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

公开(公告)号：US20150254286A1

公开(公告)日：2015-09-10

申请号：US14714968

申请日：2015-05-18

Applicant: salesforce.com, inc.

Inventor： Arup Dutta ,  Simon Wong ,  Dan Soble ,  Nathanael Black ,  Walter Macklem

IPC: G06F17/30

CPC classification number: G06F17/30303 ,  G06F17/30117 ,  G06F17/30165 ,  G06F17/30997

Abstract: An exemplary embodiment of a multi-tenant database system is provided. The system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has database objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has metadata entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

Abstract translation: 提供了多租户数据库系统的示例性实施例。 该系统包括多租户数据库，实体定义表和数据处理引擎。 数据库具有多个租户的数据库对象，包括指定租户的现有对象。 现有对象中的每个条目都有相应的实体标识符。 定义表具有数据库对象的元数据条目，包括现有对象的元数据条目。 该元数据条目具有用于指定承租人的租户标识符，现有对象的实体名称和用于现有对象的旧密钥前缀。 现有对象的每个实体标识符都以旧的密钥前缀开始。 引擎通过更新元数据条目来对现有对象执行数据截断操作，以用新的密钥前缀替换旧的密钥前缀。 这导致由新的密钥前缀和租户标识符标识的更新的对象。

公开(公告)号：US20150234877A1

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

申请号：US14705877

申请日：2015-05-06

Applicant: salesforce.com, inc.

Inventor： Craig Weissman ,  Simon Wong

IPC: G06F17/30

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.

Abstract translation: 用于托管变量模式数据的系统和方法，例如固定物理数据库模式中的动态表和列。 标准对象，如表格，供多租户或多租户数据库系统中的组织使用。 每个组织可以添加或定义自定义字段以包含在标准对象中。 多个租户的自定义字段存储在对象数据结构中的自定义数据列中，并且此单个自定义数据列可能为每个租户包含不同的数据类型。

公开(公告)号：US20140136500A1

公开(公告)日：2014-05-15

申请号：US14158732

申请日：2014-01-17

Applicant: salesforce.com, inc.

Inventor： Simon Wong ,  Walter Macklem ,  Mark Fischer ,  Orjan Kjellberg ,  Olivier Pin ,  Sonali Agrawal ,  Ron Pragides ,  Etienne Giraudy

IPC: G06F17/30

CPC classification number: G06F16/219 ,  G06F16/289

Abstract: In accordance with embodiments, there are provided mechanisms and methods for versioning content in a database system using content type specific objects. These mechanisms and methods for versioning content in a database system using content type specific objects can enable embodiments to provide a database system which stores information associated with multiple versions of content. The ability of embodiments to provide a database system which supports content versioning can enable an efficient and comprehensive storage of content types having different features by the database system.

Abstract translation: 根据实施例，提供了使用内容类型特定对象在数据库系统中对内容进行版本化的机制和方法。 用于使用内容类型特定对象对数据库系统中的内容进行版本化的这些机制和方法可使实施例能够提供存储与多个内容版本相关联的信息的数据库系统。 实施例提供支持内容版本化的数据库系统的能力可以实现数据库系统具有不同特征的内容类型的有效和全面的存储。

公开(公告)号：US20130247028A1

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

申请号：US13874330

申请日：2013-04-30

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

CPC classification number: G06F8/61 ,  G06F3/0482 ,  G06F3/0483 ,  G06F8/60 ,  G06F8/658 ,  G06F15/173 ,  G06F16/176 ,  G06F16/211 ,  G06F16/214 ,  G06F16/2329 ,  G06F16/24573 ,  G06F16/27 ,  G06F16/283 ,  G06F16/289 ,  G06F16/40 ,  G06F16/904 ,  G06F16/9566 ,  G06F16/972 ,  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: 根据实施例，提供了用于在多租户数据库环境中创建，导出，查看和测试以及导入定制应用程序的机制和方法。 这些机制和方法可以使得实施例能够提供跨组织边界共享应用的车辆。 跨组织边界共享应用程序的能力可以使多租户数据库系统中的租户能够轻松有效地导入和导出，从而与多租户环境中的其他租户共享应用程序。