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