Methods and procedures to provide complete test copy environment of hosted applications

• US 7,634,505 B2
• Filed: 12/19/2006
• Issued: 12/15/2009
• Est. Priority Date: 12/19/2006
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Soble, Daniel, Chasman, Douglas
• Primary Examiner(s): Woo; Isaac M
• Application Number:
  US11/612,709
• Publication Number:
  US 20080147753A1
• Time in Patent Office: 1,092 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206
• US Class Current: 1/1
• CPC Class Codes: G06F 11/2094 Redundant storage or storage space G06F11/2056 takes precedence
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

Systems and methods that create a duplicate database instance on which database testing may be performed. The techniques for creating a test database instance enable database testing to proceed without impacting other organization'"'"'s access to their data in the database or corrupting an organization'"'"'s data. The ability to allow one organization (“org”) to test their portion of a database without interrupting other organizations from using their portions of the database enables a database system to support more than one organization as tenants.

Claims

1. A method of creating a test database instance from a database instance, the method comprising:

receiving a request to create a test database instance for a first database instance on a source system, the request received from a requestor at a first organization and the request identifying a portion of the first database instance that the requestor at the first organization is permitted to access;

processing the request by copying the portion of the first database instance to a target system so as to form the test database instance on the target system, the copy process proceeding substantially contemporaneous with, and substantially without interference with, processing at least one other request to access other portion(s) of the first database instance received from other requestor(s) at other organization(s);

directing subsequent requests from requestor(s) at the first organization to the test database instance instead of the first database instance, thereby enabling testing;

receiving a second request from the requestor at the first organization to create a second test database instance for the first database instance;

processing the second request while continuing to allow access to the first test database instance by copying the portion of the first database instance that the requestor at the first organization is permitted to access to the target system so as to form a second test database instance on the target system; and

thereafter

directing subsequent requests from requestor(s) at the first organization to the second test database instance in place of the first test database instance.

2. The method of claim 1, wherein processing the request by copying the portion of the first database instance to a target system so as to form the test database instance on the target system includes:

copying, by one or more tasks executing on the target system, at least one of set-up data and instance data over a database link between the source system and the target system.

3. The method of claim 1, wherein the target system is the same as the source system.

4. The method of claim 3, further comprising:

rewriting an identifier of an organization associated with the portion of the first database instance so that the test database instance can reside in the same database as the first database instance.

5. The method of claim 1, wherein receiving a request to create a test database instance for a first database instance on a source system includes:

placing the request in a queue in the source system, wherein a process on the target system identifies the request as a pending copy request by polling the queue.

6. The method of claim 1, further comprising:

providing a user configurable time window during which processing occurs.

7. The method of claim 1, further comprising:

deleting the first test database instance.

8. The method of claim 1, wherein the first database instance comprises multiple database tables, and processing the request by copying the portion of the first database instance to a target system so as to form the test database instance on the target system includes:

copying table-by-table asynchronously.

9. The method of claim 8, wherein copying table-by-table asynchronously includes:

copying at least two database tables concurrently using at least two copy process threads.

10. The method of claim 9, further comprising:

configuring a number of tables that are concurrently copied according to a user request.

11. The method of claim 1, wherein processing the request by copying the portion of the first database instance to a target system so as to form the test database instance on the target system includes:

setting tokens representing copy milestones, and resuming interrupted copy processing at a point determined by accessing the tokens.

12. A machine-readable medium carrying one or more sequences of instructions for creating a test database instance from a database instance in a multi-tenant database system, which instructions, when executed by one or more processors, cause the one or more processors to carry out the steps of:

receiving a request to create a test database instance for a first database instance on a source system, the request received from a requestor at a first organization and the request identifying a portion of the first database instance that the requestor at the first organization is permitted to access;

processing the request by copying the portion of the first database instance to a target system so as to form the test database instance on the target system, the copy process proceeding substantially contemporaneous with, and substantially without interference with, processing at least one other request to access other portion(s) of the first database instance received from other requestor(s) at other organization(s);

directing subsequent requests from requestor(s) at the first organization to the test database instance instead of the first database instance, thereby enabling testing;

receiving a second request from the requestor at the first organization to create a second test database instance for the first database instance;

processing the second request while continuing to allow access to the first test database instance by copying the portion of the first database instance that the requestor at the first organization is permitted to access to the target system so as to form a second test database instance on the target system; and

thereafter

directing subsequent requests from requestor(s) at the first organization to the second test database instance in place of the first test database instance.

13. The machine-readable medium as recited in claim 12, wherein the instructions for carrying out the step of processing the request by copying the portion of the first database instance to a target system so as to form the test database instance on the target system include instructions for carrying out the step of:

copying, by one or more tasks executing on the target system, at least one of set-up data and instance data over a database link between the source system and the target system.

14. The machine-readable medium as recited in claim 12, further comprising instructions for carrying out the step of:

rewriting an identifier of an organization associated with the portion of the first database instance so that the test database instance can reside in the same database as the first database instance.

15. The machine-readable medium as recited in claim 12, wherein the instructions for carrying out the step of receiving a request to create a test database instance for a first database instance on a source system include instructions for carrying out the step of:

placing the request in a queue in the source system, wherein a process on the target system identifies the request as a pending copy request by polling the queue.

16. The machine-readable medium as recited in claim 12, further comprising instructions for carrying out the step of:

providing a user configurable time window during which processing occurs.

17. An apparatus for creating a test database instance from a database instance in a multi-tenant database, the apparatus comprising:

a processor; and

one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of;

receiving a request to create a test database instance for a first database instance on a source system, the request received from a requestor at a first organization and the request identifying a portion of the first database instance that the requestor at the first organization is permitted to access;

processing the request by copying the portion of the first database instance to a target system so as to form the test database instance on the target system, the copy process proceeding substantially contemporaneous with, and substantially without interference with, processing at least one other request to access other portion(s) of the first database instance received from other requestor(s) at other organization(s);

directing subsequent requests from requestor(s) at the first organization to the test database instance instead of the first database instance, thereby enabling testing;

receiving a second request from the requestor at the first organization to create a second test database instance for the first database instance;

processing the second request while continuing to allow access to the first test database instance by copying the portion of the first database instance that the requestor at the first organization is permitted to access to the target system so as to form a second test database instance on the target system; and

thereafter

directing subsequent requests from requestor(s) at the first organization to the second test database instance in place of the first test database instance.

18. A method for transmitting code for creating a test database instance from a database instance in a multi-tenant database system on a transmission medium, the method comprising:

transmitting code for receiving a request to create a test database instance for a first database instance on a source system, the request received from a requestor at a first organization and the request identifying a portion of the first database instance that the requestor at the first organization is permitted to access;

transmitting code for processing the request by copying the portion of the first database instance to a target system so as to form the test database instance on the target system, the copy process proceeding substantially contemporaneous with, and substantially without interference with, processing at least one other request to access other portion(s) of the first database instance received from other requestor(s) at other organization(s);

transmitting code for directing subsequent requests from requestor(s) at the first organization to the test database instance instead of the first database instance, thereby enabling testing;

transmitting code for receiving a second request from the requestor at the first organization to create a second test database instance for the first database instance;

transmitting code for processing the second request while continuing to allow access to the first test database instance by copying the portion of the first database instance that the requestor at the first organization is permitted to access to the target system so as to form a second test database instance on the target system; and

thereafter

transmitting code for directing subsequent requests from requestor(s) at the first organization to the second test database instance in place of the first test database instance.