Development and productive use of system with parallel use of production data and zero downtime of software changes
Methods, systems, and computer-readable storage media for replicating, within a database server, an access schema to provide a clone access schema, during production use of the single system, the access schema providing access to a data schema storing production data, and a configuration schema storing configuration data, providing, within the database server, a clone local repository, a test data schema, and a clone configuration schema, the clone access schema accessing at least a portion of the production data within the data schema through a test union view, and test data within the test data schema through the test union view, and after completion of the test use, switching production use of the system to the clone access schema, the clone configuration schema, and the clone local repository.
1. A computer-implemented method for concurrent production use and test use within a single system comprising an application server, and a database server, the method being executed using one or more processors and comprising:
replicating, during production use of the single system, an access schema within the database server to provide a clone access schema within the database server, the access schema providing access to a data schema storing production data, and a configuration schema storing configuration data;
providing, within the database server, a clone local repository, a test data schema, and a clone configuration schema, the clone access schema comprising a test union view that provides access to the test data schema and production data in the data schema;
during the test use:
accessing at least a portion of the production data within the data schema through the test union view, and writing changes in production data as test data to the test data schema through the test union view, and
accessing production data within the data schema through the access schema and writing changes in production data to the data schema; and
after completion of the test use, switching production use of the system to the clone access schema, the clone configuration schema, and the clone local repository.
2. The method of claim 1 , further comprising, after completion of the test use, dropping the access schema, and the configuration schema from the database server.
3. The method of claim 1 , wherein the test union view comprises a read-only projection view to the data schema, and a read-/write-projection view to the test data schema.
4. The method of claim 1 , wherein the test data schema stores one or more deltas based on an operation executed during the test use on at least a portion of the production data.
5. The method of claim 1 , wherein the changes comprise a process change resulting in one or more changes to configuration data.
6. The method of claim 1 , wherein the changes comprise a software change.
7. The method of claim 6 , further comprising providing a cloned repository schema associated with a central repository storing shared data.
8. A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for concurrent production use and test use within a single system comprising an application server, and a database server, the operations comprising:
replicating, during production use of the single system, an access schema within the database server to provide a clone access schema within the database server, the access schema providing access to a data schema storing production data, and a configuration schema storing configuration data;
providing, within the database server, a clone local repository, a test data schema, and a clone configuration schema, the clone access schema comprising a test union view that provides access to the test data schema and production data in the data schema;
during the test use:
accessing at least a portion of the production data within the data schema through the test union view, and writing changes in production data as test data to the test data schema through the test union view, and
accessing production data within the data schema through the access schema and writing changes in production data to the data schema; and
after completion of the test use, switching production use of the system to the clone access schema, the clone configuration schema, and the clone local repository.
9. The computer-readable storage medium of claim 8 , wherein operations further comprise, after completion of the test use, dropping the access schema, and the configuration schema from the database server.
10. The computer-readable storage medium of claim 8 , wherein the test union view comprises a read-only projection view to the data schema, and a read-/write-projection view to the test data schema.
11. The computer-readable storage medium of claim 8 , wherein the test data schema stores one or more deltas based on an operation executed during the test use on at least a portion of the production data.
12. The computer-readable storage medium of claim 8 , wherein the changes comprise a process change resulting in one or more changes to configuration data.
13. The computer-readable storage medium of claim 8 , wherein the changes comprise a software change.
14. The computer-readable storage medium of claim 13 , wherein operations further comprise providing a cloned repository schema associated with a central repository storing shared data.
15. A system, comprising:
a computing device; and
a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations for concurrent production use and test use within a single system comprising an application server, and a database server, the operations comprising:
replicating, during production use of the single system, an access schema within the database server to provide a clone access schema within the database server, the access schema providing access to a data schema storing production data, and a configuration schema storing configuration data;
providing, within the database server, a clone local repository, a test data schema, and a clone configuration schema, the clone access schema comprising a test union view that provides access to the test data schema and production data in the data schema;
during the test use:
accessing at least a portion of the production data within the data schema through the test union view, and writing changes in production data as test data to the test data schema through the test union view, and
accessing production data within the data schema through the access schema and writing changes in production data to the data schema; and
after completion of the test use, switching production use of the system to the clone access schema, the clone configuration schema, and the clone local repository.
16. The system of claim 15 , wherein operations further comprise, after completion of the test use, dropping the access schema, and the configuration schema from the database server.
17. The system of claim 15 , wherein the test union view comprises a read-only projection view to the data schema, and a read-/write-projection view to the test data schema.
18. The system of claim 15 , wherein the test data schema stores one or more deltas based on an operation executed during the test use on at least a portion of the production data.
19. The system of claim 15 , wherein the changes comprise a process change resulting in one or more changes to configuration data.
20. The system of claim 15 , wherein the changes comprise a software change.