Method for changing database construction information

A computer-readable storage medium which stores a program for implementing a method for modifying database construction information for a database system having a plurality of databases and meta information including database metadata relating to schema definition of the database, wherein the database construction is modified by changing the schema definition, said method comprising the steps of:

• providing job metadata including item mapping for defining correspondence relation between databases and jobs for defining data transformation between databases in said meta information;
• holding modification pattern information comprising a plurality of modification patterns wherein a modification to a system is designated by a variable and said modification pattern information further comprising management information for identifying a location to be influenced by said variable;
• prompting a user to select a variable to designate relevant modification from a plurality of modification patterns;
• detecting modification influence ranges of said schema definition and the data transformation between the databases on the basis of said meta information in accordance with the selected variable and performing modification range detecting operation to output the influence range to said meta information as influence range information;
• and
• executing system construction information modifying operation to generate system construction information to set and execute middleware by modifying the schema definition, data transformation and at-runtime reference information stored in said meta information on the basis of said influence range information and said meta information.

A computer system for modifying database construction information for a database system having a plurality of databases and meta information including database metadata relating to schema definition of the database, wherein the database construction is modified by changing the schema definition, the computer system comprising:

• means for providing job metadata including item mapping for defining correspondence relation between databases, and jobs for defining data transformation between databases;
• means for holding modification pattern information comprising a plurality of modification patterns in storage device wherein a modification to a system is designated by a variable and said modification pattern information further comprising management information for identifying a location to be influenced by said variable;
• means for prompting a user to select a variable to designating relevant modification from a plurality of modification patterns on a display screen;
• means for means for detecting modification influence ranges of said schema definition and the data transformation between the databases on the basis of said meta information in accordance with the selected variable and performing modification range detecting operation to output the detected influence range to said meta information as influence range information;
• and
• means for executing system construction information modifying operation to generate system construction information to set and execute middleware by modifying the schema definition, data transformation and at-runtime reference information stored in said meta information on the basis of said influence range information and said meta information.