公开(公告)号：US09535941B2

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

申请号：US14066356

申请日：2013-10-29

Applicant: salesforce.com, inc.

Inventor： Abraham Adam ,  Alex Gitelman ,  Daphne A. Kao ,  Simon Wong ,  Harish Bellamane ,  Michael Tang ,  Stefan Eberl ,  Twisha Mehta ,  Venkatachalam Muthukrishnan

IPC: G06F17/30

CPC classification number: G06F17/30345 ,  G06F17/30309 ,  G06F17/30477 ,  G06F17/30548

Abstract: Systems and methods are provided for data object change history. A first data object and a second data object are retrieved, wherein the first data object includes an identifier, a field name, a first value, and a first date, and wherein the second data object includes the identifier, the field name, a second value, and a second date. A history object is stored, wherein the history object comprises the identifier, the field name, the first value, the first date, and the second date. The history object is output in response to a query which specifies the identifier, the field name, and a query date within a range of the first date and the second date.

Abstract translation: 为数据对象更改历史提供了系统和方法。 检索第一数据对象和第二数据对象，其中所述第一数据对象包括标识符，字段名称，第一值和第一日期，并且其中所述第二数据对象包括所述标识符，所述字段名称，第二数据对象 价值和第二个日期。 存储历史对象，其中历史对象包括标识符，字段名称，第一值，第一日期和第二日期。 响应于在第一个日期和第二个日期的范围内指定标识符，字段名称和查询日期的查询来输出历史记录对象。

公开(公告)号：US20130246472A1

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

申请号：US13886223

申请日：2013-05-02

Applicant: SALESFORCE.COM, INC

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

IPC: G06F21/62

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

Abstract: The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization.

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

公开(公告)号：US20180218031A1

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

申请号：US15421076

申请日：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 dynamic macros within a multi-tenant aware structured query language operable 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 dynamic macro function call to be executed at runtime and replaced with a string within a new structured query language statement to be executed against the multi-tenant database system; parsing the database query to identify the dynamic macro function call specified; parsing the database query to identify a functional expression to be evaluated at runtime as passed with the dynamic macro function call specified; 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 the string in place of the dynamic macro function call or a functional call executable by the multi-tenant database system at runtime to be resolved to the string by the multi-tenant database during execution of the new structured query language statement; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

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

公开(公告)号：US09558218B2

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

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

公开(公告)号：US09378227B2

公开(公告)日：2016-06-28

申请号：US14160537

申请日：2014-01-21

Applicant: salesforce.com, Inc.

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

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

公开(公告)号：US09367431B2

公开(公告)日：2016-06-14

申请号：US13627402

申请日：2012-09-26

Applicant: Salesforce.com, Inc.

Inventor： Richard Unger ,  Simon Wong

IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30 ,  G06F11/36

CPC classification number: G06F11/3672

Abstract: In accordance with disclosed embodiments, there are provided methods, systems, and apparatuses for creating a data silo and testing with a data silo including, for example, initiating a test sequence against a production database within the host organization, in which the test sequence specifies: a) new data for insertion into the production database during the test sequence, and b) one or more test queries against the production database during the test sequence; performing a database transaction to insert the new data into the production database without committing the new data to the production database; recording names of one or more objects corresponding to the inserted new data, the one or more objects created as part of the transaction to insert the new data into the production database within a transaction entity object map; modifying the one or more test queries specified by the test sequence to no longer query against the production database by substituting the one or more test queries with references to the names of the one or more objects in operating memory separate from information stored within the production database; and executing the one or more modified test queries. Other related embodiments are disclosed.

Abstract translation: 根据所公开的实施例，提供了用于创建数据仓库和使用数据仓库进行测试的方法，系统和装置，包括例如针对主机组织内的生产数据库发起测试序列，其中测试序列指定 ：a）在测试序列期间插入生产数据库的新数据，以及b）在测试序列期间针对生产数据库的一个或多个测试查询; 执行数据库事务以将新数据插入到生产数据库中，而不将新数据提交给生产数据库; 记录与所插入的新数据相对应的一个或多个对象的名称，所述一个或多个对象被创建为事务的一部分以将新数据插入到事务实体对象映射内的生产数据库中; 修改由测试序列指定的一个或多个测试查询，以不再针对生产数据库查询，替换一个或多个测试查询，引用操作存储器中与存储在生产数据库中的信息分离的操作存储器中的一个或多个对象的名称 ; 并执行一个或多个修改的测试查询。 公开了其他相关实施例。

公开(公告)号：US20130246450A1

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

申请号：US13873146

申请日：2013-04-29

Applicant: SALESFORCE.COM, INC

Inventor： Craig Weissman ,  Dave Moellenhoff ,  Simon Wong

IPC: G06F17/30

CPC classification number: G06F17/30442 ,  G06F17/30528 ,  G06F17/30536

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.