Sandboxing Databases
A sandbox database is created. The sandbox database is typically a temporary database. For example, the sandbox database may be a test database for evaluating a new version of software. Creating the sandbox database comprises creating a sandbox cache in the sandbox database and copying metadata from a main database to the sandbox database. The sandbox cache is used to store record(s) that are accessed during the use of the sandbox database. The metadata is used to reference the record(s). This allows for a simpler process for creating a temporary database to be used for testing software.
1 . A system comprising:
a microprocessor; and
a computer readable medium, coupled with the microprocessor and comprising microprocessor readable and executable instructions that, when executed by the microprocessor, cause the microprocessor to:
create a first sandbox database, wherein creating the first sandbox database comprises:
creating a first sandbox cache in the first sandbox database; and
copying metadata from a main database to the first sandbox database.
2 . The system of claim 1 , wherein the microprocessor readable and executable instructions further cause the microprocessor to:
copy records associated with the metadata, wherein the copied records are stored in the first sandbox cache and wherein the copied records are stored in the first sandbox cache based on one of:
a rule associated with the creating of the first sandbox database;
based on a read request using the metadata; and
based on a write request using the metadata.
3 . The system of claim 1 , wherein the metadata is a first subset of metadata from the main database.
4 . The system of claim 1 , wherein the first sandbox database comprises a plurality of sandbox databases and wherein the first sandbox database is one of the plurality of sandbox databases.
5 . The system of claim 4 , wherein the first sandbox database of the plurality of sandbox databases uses a first subset of metadata from the main database, wherein a second sandbox database of the plurality of sandbox databases uses a second subset of metadata from the main database, and wherein the first subset of metadata and the second subset of metadata are different.
6 . The system of claim 1 , wherein the first sandbox cache stores any changes to records in the first sandbox cache and wherein the changes to the records stored in the first sandbox cache are used to synchronize the changes in the records back to the main database.
7 . The system of claim 1 , wherein records are sent from the main database in at least one of the following ways:
based on a request from the sandbox database that uses a metadata pull;
based on a request from the sandbox database that uses a metadata push;
based on a request from the main database that uses a metadata pull; and
based on a request from the main database that uses a metadata push.
8 . The system of claim 1 , wherein the microprocessor readable and executable instructions further comprise:
receiving an input identifying a number of nodes in the first sandbox; and
creating the number of nodes in the first sandbox, wherein the number of nodes in the first sandbox is different from a number of nodes in the main database.
9 . A method comprising:
creating, by a microprocessor, a first sandbox database, wherein creating the first sandbox database comprises:
creating, by the microprocessor, a first sandbox cache in the first sandbox database; and
copying, by the microprocessor, metadata from a main database to the first sandbox database.
10 . The method of claim 9 , further comprising:
copying records associated with the metadata, wherein the copied records are stored in the first sandbox cache and wherein the copied records are stored in the first sandbox cache based on one of:
a rule associated with the creating of the first sandbox database;
based on a read request using the metadata; and
based on a write request using the metadata.
11 . The method of claim 9 , wherein the metadata is a first subset of metadata from the main database.
12 . The method of claim 9 , wherein the first sandbox database comprises a plurality of sandbox databases and wherein the first sandbox database is one of the plurality of sandbox databases.
13 . The method of claim 12 , wherein the first sandbox database of the plurality of sandbox databases uses a first subset of metadata from the main database, wherein a second sandbox database of the plurality of sandbox databases uses a second subset of metadata from the main database, and wherein the first subset of metadata and the second subset of metadata are different.
14 . The method of claim 9 , wherein the first sandbox cache stores any changes to records in the first sandbox cache and wherein the changes to the records stored in the first sandbox cache are used to synchronize the changes in the records back to the main database.
15 . The method of claim 9 , wherein records are sent from the main database in at least one of the following ways:
based on a request from the sandbox database that uses a metadata pull;
based on a request from the sandbox database that uses a metadata push;
based on a request from the main database that uses a metadata pull; and
based on a request from the main database that uses a metadata push.
16 . The method of claim 9 , wherein the microprocessor readable and executable instructions further comprise:
receiving an input identifying a number of nodes in the first sandbox; and
creating the number of nodes in the first sandbox, wherein the number of nodes in the first sandbox is different from a number of nodes in the main database.
17 . A non-transient computer readable medium having stored thereon instructions that cause a microprocessor to execute a method, the method comprising instructions to:
create a first sandbox database, wherein creating the first sandbox database comprises:
creating a first sandbox cache in the first sandbox database; and
copying metadata from a main database to the first sandbox database.
18 . The non-transient computer readable medium of claim 17 , the instructions further cause the microprocessor to:
copy records associated with the metadata, wherein the copied records are stored in the first sandbox cache and wherein the copied records are stored in the first sandbox cache based on one of:
a rule associated with the creating of the first sandbox database;
based on a read request using the metadata; and
based on a write request using the metadata.
19 . The non-transient computer readable medium of claim 17 , wherein first sandbox database comprises a plurality of sandbox databases and wherein the first sandbox database is one of the plurality of sandbox databases.
20 . The non-transient computer readable medium of claim 17 , wherein the microprocessor readable and executable instructions further comprise:
receiving an input identifying a number of nodes in the first sandbox; and
creating the number of nodes in the first sandbox, wherein the number of nodes in the first sandbox is different from a number of nodes in the main database.