IP Library › Granted Patent US 9,195,691
Granted Patent B2
US 9,195,691 · App. 13/553,333 · Granted Nov 24, 2015

Managing test data in large scale performance environment

Inventors: Margaret A. Eker (Austin, TX); Nnaemeka I. Emejulu (Austin, TX); Karthikeyan Ramamoorthy (Austin, TX)
Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
G06F17/30297
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,195,691
App. No.
13/553,333
Granted
Nov 24, 2015
Kind
B2
Abstract

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.

Claims (26)

1. A method of processing a database, the method comprising:

generating a delta file from a first schema and a second and different schema;

applying the delta file, using a processor, to the database, wherein the database conforms to the first schema, wherein applying the delta file to the database updates the database to conform to the second schema;

translating data of the database in accordance with a metadata file; and

assigning each of a plurality of changes specified in the delta file to one of a plurality of risk levels according to a comparison of the change with risk assessment criteria; and

implementing each change of the delta file according to one of a plurality of different implementation procedures correlated with the risk level of the change.

2. The method of claim 1 , further comprising:

assigning a change specified in the delta file to one of a plurality of risk levels according to a comparison of the change with a risk assessment criterion.

3. The method of claim 2 , further comprising:

automatically performing the applying the delta file and the translating the data without user intervention responsive to determining that the change is assigned a risk level below a threshold risk level.

4. The method of claim 1 , further 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.

5. A method of processing a database, the method comprising:

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;

applying the change of the delta file to a database conforming to the first schema according to the assigned risk level, wherein applying the change to the database updates the database to conform to the second schema; and

implementing the change according to one of a plurality of different implementation procedures correlated with the risk level of the change.

6. The method of claim 5 , further comprising:

applying the change of the delta file to the database responsive to determining that the assigned risk level is low.

7. The method of claim 5 , further 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.

8. The method of claim 5 , further comprising:

translating data of the database affected by the change of the delta file according to a metadata file.

9. The method of claim 8 , further 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.

Continuity (2)
Continuation 13434106 · Mar 29, 2012
Related Publication 20130262399A1 · Oct 3, 2013