Development and productive use of system with parallel use of production data and zero downtime of software changes

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, within the 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.

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, within the 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.