Managing test data in large scale performance environment
A method of processing a database can include comparing, using a processor, a delta file with a risk assessment criterion, wherein the delta file is generated from a first schema and a second and different schema, assigning a risk level to a change specified within the delta file according to the comparing, and applying the change of the delta file to a test database conforming to the first schema according to the assigned risk level.
1. A system for processing a database, comprising:
a processor configured to initiate executable operations comprising:
comparing a delta file with a risk assessment criterion, wherein the delta file is generated from a first schema and a second and different schema;
assigning a risk level to a change specified within the delta file according to the comparing;
applying the change of the delta file to a database conforming to the first schema according to the assigned risk level; and
implementing the change according to one of a plurality of different implementation procedures correlated with the risk level of the change.
2. The system of claim 1 , wherein the processor is further configured to initiate an executable operation comprising:
applying the change of the delta file to the database responsive to determining that the assigned risk level is low.
3. The system of claim 1 , wherein the processor is further configured to initiate an executable operation comprising:
responsive to determining that the risk level of the change is above a threshold risk level, generating a prompt inquiring whether to apply the change.
4. The system of claim 1 , wherein applying the delta file to the database updates the database to conform to the second schema.
5. The system of claim 1 , wherein the processor is further configured to initiate an executable operation comprising:
translating data of the database affected by the change of the delta file according to a metadata file.
6. The system of claim 5 , wherein the processor is further configured to initiate executable operations comprising:
disabling a requirement of the first schema that applies to the data prior to translation; and
enabling a requirement of the second schema that applies to the data responsive to completion of the translation.
7. A computer program product for processing a database, the computer program product comprising:
a computer readable storage device having stored thereon program code that, when executed, configures a processor to perform executable operations comprising:
comparing a delta file with a risk assessment criterion, wherein the delta file is generated from a first schema and a second and different schema;
assigning a risk level to a change specified within the delta file according to the comparing;
applying the change of the delta file to a database conforming to the first schema according to the assigned risk level, and
implementing the change according to one of a plurality of different implementation procedures correlated with the risk level of the change, wherein
the computer readable storage device does not consistent of a transitory, propagating signal.
8. The computer program product of claim 7 , wherein the computer readable storage medium further stores program code that, when executed, configures a processor to perform an executable operation comprising:
applying the change of the delta file to the database responsive to determining that the assigned risk level is low.
9. The computer program product of claim 7 , wherein the computer readable storage medium further stores program code that, when executed, configures a processor to perform an executable operation comprising:
responsive to determining that the risk level of the change is above a threshold risk level, generating a prompt inquiring whether to apply the change.
10. The computer program product of claim 7 , wherein applying the delta file to the database updates the database to conform to the second schema.
11. The computer program product of claim 7 , wherein the computer readable storage medium further stores program code that, when executed, configures a processor to perform an executable operation comprising:
translating data of the database affected by the change of the delta file according to a metadata file.
12. The computer program product of claim 7 , wherein the computer readable storage medium further stores program code that, when executed, configures a processor to perform executable operations comprising:
disabling a requirement of the first schema that applies to the data prior to translation; and
enabling a requirement of the second schema that applies to the data responsive to completion of the translation.