公开(公告)号：US20140172889A1

公开(公告)日：2014-06-19

申请号：US14066300

申请日：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 alternative change processes for changes to data objects. A change to a data object is recorded, wherein the change is submitted to a first change process. The first change process is disabled. A second change process is asynchronously executed to process the change to the data object.

Abstract translation: 为数据对象的更改提供了替代变更过程的系统和方法。 记录对数据对象的改变，其中改变被提交到第一改变过程。 第一个更改过程被禁用。 异步执行第二个更改过程来处理对数据对象的更改。

公开(公告)号：US20140172829A1

公开(公告)日：2014-06-19

申请号：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: 为数据对象更改历史提供了系统和方法。 检索第一数据对象和第二数据对象，其中第一数据对象包括标识符，字段名，第一值和第一日期，并且其中第二数据对象包括标识符，字段名称，第二数据对象 价值和第二个日期。 存储历史对象，其中历史对象包括标识符，字段名称，第一值，第一日期和第二日期。 响应于在第一个日期和第二个日期的范围内指定标识符，字段名称和查询日期的查询来输出历史记录对象。

公开(公告)号：US20140258342A1

公开(公告)日：2014-09-11

申请号：US14286925

申请日：2014-05-23

Applicant: salesforce.com, inc.

Inventor： Eric BEZAR ,  Doug CHASMAN ,  Dean JACOBS ,  Simon WONG

IPC: G06F17/30

CPC classification number: G06F16/2282 ,  G06F16/273 ,  G06F16/275 ,  Y10S707/954

Abstract: The efficiency and versatility for the implementation of formulas in an on-demand database is improved. Formulas are categorized. Based at least partly on the categorization, formulas are evaluated synchronously or asynchronously. An asynchronous evaluation may be performed if a certain set of criteria is not satisfied. Asynchronous evaluations may be performed using a queue. During an asynchronous update of an object, a counter field and/or an estimate field may be used respectively for indicating the consistency of values of the object and a time when the values were consistent. The versatility of formulas is enhanced by using a formula to create a default value for a custom field when it is created and to determine whether an action is to be performed, and is enhanced by having an action define when a formula is to be updated.

Abstract translation: 提高了按需数据库中公式实现的效率和多功能性。 公式分类。 至少部分地基于分类，公式被同步或异步地评估。 如果不满足某一组标准，则可以执行异步评估。 可以使用队列执行异步评估。 在对象的异步更新期间，可以分别使用计数器字段和/或估计字段来指示对象的值的一致性和值一致的时间。 通过使用公式在创建自定义字段时创建默认值并确定是否执行操作，并通过在更新公式时定义动作来增强公式的多功能性。

公开(公告)号：US20130042146A1

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

申请号：US13627402

申请日：2012-09-26

Applicant: SALESFORCE.COM, INC.

Inventor： Richard UNGER ,  Simon WONG

IPC: G06F11/28 ,  G06F17/30

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）在测试序列期间针对生产数据库的一个或多个测试查询; 执行数据库事务以将新数据插入到生产数据库中，而不将新数据提交给生产数据库; 记录与所插入的新数据相对应的一个或多个对象的名称，所述一个或多个对象被创建为事务的一部分以将新数据插入到事务实体对象映射内的生产数据库中; 修改由测试序列指定的一个或多个测试查询，以便不再对生产数据库进行查询，替换一个或多个测试查询，引用操作存储器中与存储在生产数据库中的信息分离的操作存储器中的一个或多个对象的名称 ; 以及执行所述一个或多个修改的测试查询。 公开了其他相关实施例。