JP2001331354A - Data distribution managing method and system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method suitable for avoiding adverse effects on other related DB and a data transition program, when editing of DB structure and data transition program structure. SOLUTION: An editing instruction is inputted to structural information about the data base and structural information about the data transition program between data bases, influences on the structure of other data base and the data transition program between the data bases in the case of editing the structural information according to the instruction are checked, notified and the presence/absence of establishing intention of the editing instruction is inputted. When the establishing intention of the inputted editing instruction exists, the editing instruction is reflected on the structural information and when other editing instruction is inputted, a processing from an editing instruction input processing of the acquired structural information to reflection of the editing instruction on the structural information is repeated. When no other editing instructions are inputted, the edited structural information is reflected on the data base and the data base transition program.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data distribution management method and system for editing structures such as a database (hereinafter abbreviated as DB) and a data migration program between DBs.

[0002]

2. Description of the Related Art In recent years, with the maturation and diversification of consumption, it has become important for companies to provide products and services according to customer needs. In order to provide appropriate services to customers, an increasing number of companies are introducing data integration platforms such as data warehouses with the aim of integrating and utilizing customer information scattered by product or channel.
When integrating and utilizing data using a data warehouse or the like, a data acquisition system DB (source D)
In order to distribute the data from B) to the DB (target DB) of the utilization destination system, it is necessary to extract necessary data, convert the format, process data values, and transfer the data.

[0003] In a company, there are a large number of DBs and data stored therein for each business. When focusing on data in a certain DB, it becomes a source DB, but when focusing on another data in the same DB, it becomes a target DB. The data migration relationship between DBs is many-to-many and bidirectional. In addition, some data may be transferred between DBs in multiple stages, which makes complex data distribution difficult for the entire company.
Has occurred.

In order to manage data distribution in a company, it is necessary to manage the structure of a database for storing data to be distributed and the structure of a data migration program for distributing data.

[0005] For this reason, "Strategy and Design of Data Warehouse" edited by Ramon C. Birkin (Nikkei BP, 19
99) As described on page 226, software is provided for managing and editing input / output data of a data warehouse and its migration structure as metadata, and creating a data migration program between databases in accordance with the edited result.

[0006]

However, the software for managing the migration structure as described above can create and change a data migration program, but the number of data in the company is large and the data distribution is large. When changing the DB structure or the data migration program,
Data may be adversely affected.

For example, when the column name of a table and the data stored therein are changed, and when the data of the column is migrated to another database, the data at the migration destination has a different meaning from conventional data. It will be something. In addition, when a certain column is deleted and the data is migrated and used, the data is lost or the data cannot be migrated.

An object of the present invention is to solve such a problem,
It is another object of the present invention to provide a data distribution management method and system for checking the influence on other structures when creating and editing the B structure information and the structure information of the data migration program between DBs.

[0009]

In order to solve the above-mentioned object, a data distribution management method according to the present invention comprises the steps of: inputting an editing instruction to structural information of a database and structural information of a data migration program between databases; It checks and informs the effect on the structure of other databases and the data migration program between databases when editing the structure information according to the instruction, and inputs whether or not the editing instruction is confirmed. If there is an intention to confirm the input editing instruction, the editing instruction is reflected in the structure information, and if there is another editing instruction input, the processing proceeds from the editing instruction input processing of the acquired structural information to the structural information of the editing instruction. Is repeated, and if there is no other editing instruction input, the edited structure information is reflected in the database and the database migration program.

[0010]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 shows the processing flow of the present embodiment in FIG.
Shows an overall configuration diagram of the system of the present embodiment.

First, an overall configuration diagram of the data distribution management system shown in FIG. 2 will be described.

In the data distribution management system 210, an input device 202, an output device 203, and a storage device 204 are connected to a computer 201. The device configuration for implementing the present invention may be any device that is generally called a computer system. The data distribution management system 210 is connected to a database management system 230 and a data migration program management system 240 via a communication network 220. These management systems may be plural. These are also generally called computer systems.

Hereinafter, the processing flow of the embodiment of the present invention will be described.
Referring to FIG. 1, customer information in a bank will be described as an example of handling data.

<Step 101> Acquisition of DB structure information and data migration program structure information The DB structure information 300 and the data migration program structure information 400 are stored in the database management system 230.
Obtained from the data migration program management system 240.

For example, DB structure information is held as a dictionary of a DB management system in the format described in “Strategy and Design of Data Warehouse” on page 217. Also, the structure information of the data migration program
As parameter information indicating input / output data items of the data migration job, "Strategy and Design of Data Warehouse"
226 is held in a format as described.

Alternatively, the DB management system 23
0. Even if the structure information 300 of the DB and the structure information 400 of the data migration program are acquired indirectly via another system or file instead of acquiring the structure information from the data migration program management system 240, Good.

FIG. 3 shows an example of the acquired DB structure information 300. The DB structure information 300 includes a DB name field 30
1, table name field 302, item name field 3
03, a data type field 304, and a byte number field 305. The DB name field 301 holds a list of names of DBs to be edited, such as “information DB”. The table name field 302 shows a list of names of tables existing in the DB, such as “customer attribute”, “deposit information”, and “customer information”. The item name field 303 is
A list of names of items existing in the table such as “customer number” and “name” is shown. The data type field 304 indicates whether the value of the item is “char (character type)” or “decimal”.
(Numerical type) ”and the number of bytes field 305 indicates the number of bytes of the value stored in the item.
However, in the description of the embodiment of the present invention, the data type field 304 and the byte number field 305 are not particularly used.

According to the DB structure information 300 described above, a DB
It can represent the structure of tables and items stored in.

FIG. 4 shows an example of the acquired structure information 400 of the data migration program. The structure information 400 of the data migration program includes a migration program name field 401, an input DB name field 402, an input table name field 403, an input item name field 404, an output DB name field 405, an output table name field 406, and an output item name field 407. Consists of The migration program name field 401 shows a list of migration programs to be edited, such as “customer information migration job”. Input DB name field 402, input table name field 403,
The input item name field 404 indicates a DB name, a table name, and an item name as the input data of the transfer source by the corresponding data migration program. The output DB name field 405, the output table name field 406, and the output item name field 407 , A DB name, a table name, and an item name as output data of the migration destination by the program after the corresponding data. The DB name, table name, and item name of each input / output are any of the names stored in the fields 301 to 303 of the DB structure information 300.

The structure information 400 of the data migration program described above indicates which DB data has been migrated to which DB data in each data migration program. There are cases where two input data are operated to shift to one output data, and one input data is shifted to two output data, so that the relationship between input and output data is many-to-many.

The DB name, table name, item name of the DB structure information 300 and the migration program name, DB name, table name, and item name of the data migration program structure information 400 need to be uniquely specified. It suffices that there is no duplicate use of the name or that an identification number for uniquely identifying the name is held at the same time.

In general, information for defining the DB structure and the structure of the data migration program includes, in addition to the examples shown in FIGS. Although there is information indicating processing, etc., it is not directly related to the present invention, and is omitted.

<Step 102> Input of editing instruction of DB structure information and data migration program structure information An editing instruction is input to the DB structure information 300 and the data migration program structure information 400 acquired in step 101.

(1) Input of DB Structure Information Edit Instruction FIG. 5 shows an example of a DB structure edit screen 500. An editing screen 500 having a DB structure is displayed on the output device 213, and an editing instruction is input using the input device 212.

The DB structure editing screen 500 includes an editing mode designation area 510, an editing content display area 520, and an editing command instruction area 530.

An edit mode designation area 510 is a DB structure edit mode button 5 for transitioning to a DB structure edit screen.
11, a transition structure edit mode button 512 for transitioning to a data migration program structure edit screen.

The edit content display area 520 displays the edit target D
An edit target DB selection area 521 for designating B;
It comprises a table display area 522 for displaying a table in the editing target DB, and an item display area 523 for displaying items in the table and their attributes. When there are a plurality of tables and items in the DB, a plurality of table display areas 522 and item display areas 523 are displayed.
The information about the table and the item displayed in the table display area 522 and the item display area 523 is described in step 1.
01 is created based on the DB structure information 300 acquired in step S01.

The edit command instruction area 530 includes an edit designation button 531 for instructing edit, and an edit end button 532. By pressing down the edit designation button 531 using the input device 212, editing of the database structure information in the edit content display area 520 is started, and a screen 600 for inputting details of a DB structure edit instruction is displayed.

FIG. 6 shows a DB structure edit detailed setting screen 600.
Here is an example. The DB structure edit setting screen 600 includes an edit target display area 601 for displaying structural information on tables and items to be edited, and a change / additional content input display area 60 for inputting and displaying changes and additional information for the edit target.
2. Add table button 603, Delete table button 6
04, table attribute change button 605, item add button 606, item delete button 607, item attribute change button 6
08, a completion button 609 for completing the editing instruction
Consists of

When newly adding structural information related to a table or an item, a table or the like to be added is selected and input in the edit target display area 601, and a table addition button 603 or an item addition button 606 is pressed and input. I do.

When deleting structural information related to a table or an item, a deletion target is selected and input in the edit target display area 601 and a table deletion button 604 or an item deletion button 607 is pressed and input.

When changing structural information related to a table or an item, a change target is selected and input in the edit target display area 601, and a table attribute change button 605 or an item attribute change button 608 is pressed and input.

Through the above processing, the editing instruction of the DB structure information is input.

(2) Input of editing instruction of data migration program structure information FIG. 7 shows an example of a data migration program structure editing screen 700. Data migration program structure edit screen 700
Is displayed on the display device 213, and an editing instruction is input using the input device 212.

Data editing program structure edit screen 70
0 includes an edit mode designation area 510, an edit content display area 720, and an edit command instruction area 530.

The edit mode designation area 510 and the edit command designation area 530 are shown in the DB structure edit screen 5.
This is a function equivalent to 00. However, the edit designation button 531
When the user presses down the button, the screen transitions to a data migration program structure editing detailed setting screen 800.

The editing content display area 720 includes an input DB
Table display area 721, input item display area 72
2, an output DB / table display area 723, an output item display area 724, and an input / output item correspondence arrow 725. The input / output item correspondence arrow indicates that the transition logic is set between the corresponding input item and output item.

The information on the tables and items displayed in the editing content display area 720 is created based on the data migration program structure information 400 obtained in step 101.

When the edit designation button 531 is
Is depressed and input using the editing content display area 72.
0 starts editing the database structure information
A screen 800 for inputting details of the structure editing instruction is displayed.

FIG. 8 shows an example of the data migration program structure editing detailed setting screen 800.

The data migration program structure edit details setting screen 800 includes an output data display area 801 for displaying the DB name, table name, and item name of output data to be a data migration destination, and migration logic set in the migration destination data 801. Area 802 for displaying a transfer logic setting data area 803 for displaying a list of data items available for setting the transition logic, a transition logic setting operator area 804, a transition logic addition button 805, a transition logic deletion button 806, and a transition logic change Button 807,
It comprises a transfer program addition button 808 and a completion button 809 for completing the editing instruction.

In the example of FIG. 8, “total deposit balance” is displayed as the transfer destination data, and the transition logic “customer information.total deposit balance = deposit information. Ordinary Deposit Balance + Deposit Information. Time Deposit Balance "
Is displayed. This indicates that this migration logic and other migration logic are included in the migration program called “customer information migration job”.

When adding the transfer logic to the transfer program, select the transfer destination data to be added from the transfer destination data display area 801 and select and input the data to be used from the transfer logic available data 803. By inputting an operation between data to be used from the transition logic setting operator area 804, a transition logic to be added is created, and a logic addition button 805 is pressed and input.

When the transfer logic is to be deleted from the transfer program, by selecting the corresponding transfer destination data 801, the logic to be deleted is changed to the transfer logic area 80.
2 is displayed, and a logic delete button 806 is pressed and input.

When the transfer logic is changed for the transfer program, the corresponding logic is selected by selecting the corresponding transfer destination data 801.
2 and select and input the data to be used from the transfer logic available data 803 for the change target logic, and input the operation between the data to be used from the transfer logic setting operator area 804, thereby obtaining the transfer logic. Is corrected, and a change button 807 is pressed and input.

When a new transfer program is to be added, a program addition button 808 is pressed and input, and the name of the new transfer program is input to the program area 721 to be edited. After that, add the transition logic.

Through the processing described above, the editing content of the data migration program structure information is input, and an editing instruction is input by pressing down the completion button 609 or the completion button 809.

In this step, a creation / editing instruction is input based on the existing DB structure information 300 and the data migration program structure information 400 obtained in step 101. However, when a new DB is created, the structure information does not exist. May not. For this reason, in the embodiment of the present invention, the process of step 101 is performed without performing the process of step 101.
2, the processing may be started, and the DB structure information 300 and the data migration program structure information 400 may be newly created and edited. In this case, at the time of initial display of the DB structure edit instruction input screen 500, no structure information is displayed.

<Step 103> Influence check at the time of editing In response to the edit instruction to the DB structure and the data migration program structure information input in step 102, the influence on other DB structures and other data migration programs is checked. .

More specifically, there are two kinds of checks, that is, the effect check at the time of editing the DB structure and the effect check at the time of editing the structure of the data migration program.

(1) Influence check at the time of editing the DB structure At the time of editing the DB structure, it is necessary to check the deletion / change of the table or the deletion / change of the item because it may affect the existing DB structure or data migration program. There is.

(A) Deletion of Table If the deletion of the table is instructed in step 102, the data migration program including the table to be deleted as the input table or the output table loses the input or output data, and the data migration is performed. Therefore, the corresponding data migration program is searched from the data migration program structure information 400. Specifically, the input table name field 40
3. Search for a data migration program that includes the table name instructed to be deleted in the output table name field 405 to check for a data migration program that has an adverse effect.

Further, when the table name instructed to be deleted is included in the input table name field 403, the corresponding output item also has an adverse effect such as data loss due to the inoperability of the migration program.

Also, the operation of a data migration program using the corresponding output item as an input item is adversely affected by data loss of the item. Therefore, by searching for a data migration program that includes the same output item as the corresponding output item in the input item name field 404, a data migration program having an adverse effect is checked.

The above-mentioned adverse effects on the output items of the migration program that cause adverse effects and the adverse effects on the migration programs that use the output items that have experienced adverse effects as input items are repeated.

(B) Change of Table When the change of the table is instructed to be edited in step 102, the data migration program including the table to be changed as an input table or an output table is only a name change. The migration does not stop working. However, the meaning of the stored data may change with the change in the name of the data. Therefore, by searching for a data migration program that includes the table name instructed to be changed in the input table name field 403 and the output table name field 405, a data migration program that may have an adverse effect is checked.

Further, similarly to (a), an adverse effect on an output item of a migration program that may cause an adverse effect and a migration program that uses an output item that may cause an adverse effect as an input item. The adverse effect check may be repeated.

(C) Deletion of Item When the deletion of the item is instructed in step 102, the data migration program including the item to be deleted as an input item or an output item has no input or output data, and the data migration program has no data. Therefore, the relevant data migration program is searched from the data migration program structure information 400 because of the adverse effect that the data migration program does not operate. The following processing is the same as (a) deletion of the table, and a description thereof will be omitted. (D) Change of item When the change of the item is instructed to be edited in step 102, the data transfer program including the item to be changed as an input item or an output item, if only the name change, the data transfer operates. It does not go away.
However, changing the name of the data may change the meaning of the stored data. Further, in the case of data type change or size change, the data type and size of the migration destination do not match, and the migration logic may not operate properly. Therefore, the input table name field 403,
By searching for a data migration program in which the output table name field 405 includes the table name instructed to be changed, a data migration program that may have an adverse effect is checked. The following processing is the same as the change of the table (b), and the description is omitted.

(2) Influence check at the time of editing the data migration program structure When editing the data migration program structure, the addition, deletion, and modification of the data migration logic are checked because they may affect the existing DB structure and data migration program. There is a need to.

(A) Addition of Data Migration Logic When the editing of the addition of the data migration logic is instructed in step 102, an output from another migration logic is set in the output item of the migration logic to be added. In such a case, two data collide in the same output item, so that there is an adverse effect that either data cannot be reflected and held. Therefore, the data migration program editing information 40
By checking whether there is the same output item of the data migration logic instructed to be added to the output item field 407 of 0, the possibility of collision of the migration data is checked. However, this check is unnecessary if the specification allows only one migration logic to be set for one output item on the structure editing instruction input screen 700 of the data migration program in step 102.

The output item of the transfer logic to be added becomes an input item of another transfer program, and the output item of the transfer program is used as an input item of the transfer logic to be added. In other words, a so-called cyclic reference of items may occur. In this case, the value of the item data may not be determined. Therefore, the input item field 40 of the data migration program editing information 400
4 and the correspondence between the output item field 407 and
Check whether the output items of the migration logic are indirectly or directly circularly referenced.

(B) Deletion of Data Migration Logic If an instruction to edit the data migration logic is issued in step 102, the data of the output items of the migration logic will be lost. Therefore, the DB with the corresponding data item
In addition, if there is a data migration program that uses the corresponding data item as an input item, the input value is lost, which adversely affects the operation.

By searching for a data migration program containing an item name corresponding to the input item name field 403, a data migration program having an adverse effect is checked. The following repetition processing is the same as (1) (a) deletion of the table, and therefore the description is omitted.

(C) Change of Data Migration Logic When the change of the data migration logic is instructed to be edited in step 102, the data values and meanings of the corresponding output items may be different. Therefore, in addition to checking the DB having the corresponding data item, if there is a data migration program that uses the corresponding data item as an input item, the input value is lost, which adversely affects the operation.

By searching for a data migration program containing an item name corresponding to the input item name field 403, a data migration program having an adverse effect is checked. The following repetition processing is the same as (b) deletion of the data migration logic, and thus the description is omitted.

<Step 104> Existence of Influence of Notification Target Among the influences on the DB structure and the data migration program structure checked in step 103, it is determined whether or not there is a notification target.

The criterion for judging whether or not to be notified is input by an input device or the like and stored in the storage device 214.

FIG. 9 shows a screen 90 for setting a notification target criterion.
An example of 0 is shown. The notification target criterion setting screen 900 includes an effect notification option 901 on the DB structure, which is a notification target of an adverse effect on the DB data item, an effect notification option 902 on the data migration program, and a setting end button 903.

Turning on the DB structure effect notification option 901 and the data migration program effect notification option 902 sets the effect as a notification target.

<Step 105> Notification of Effect at Editing In step 104, if there is an effect to be notified, a notification to the effect is displayed on the display device 213.

FIG. 10 shows an example of the influence notification screen 1000. Step 1 is displayed in the DB effect display area 1001.
The DB name, the table name, and the item name that may have the influence checked in 03 are displayed. In a data migration program influence display area 1002, a list of data migration programs that may have the influence checked in step 103 is displayed.

Further, when a cyclic reference of an item occurs at the time of adding logic when editing the structure of the data migration program, a notice to that effect is displayed.

<Step 106> Input of Presence or Absence of Intention to Edit The effect notification screen 1000 displayed in step 105
Confirm the contents of the influence and press the edit confirmation button 1003 to enter the edit confirmation intention, or press the edit cancel button 1004 to enter the no edit confirmation intention to avoid the influence. I do.

When the user has input to confirm editing,
The process transitions to Step 107. If no edit confirmation intention is input, the process proceeds to step 108.

<Step 107> Reflecting Edit Contents in DB Structure / Data Migration Program Structure Information If it is determined in step 106 that there is a decision to edit, the DB structure information 300 and the data migration program structure information 400 are sent to step 102 in step 102. Reflects the input editing instruction. For example, if a table is deleted,
The record of the corresponding table of the DB structure information 300 is deleted.

Here, the structure information deleted or modified so as to avoid the influence may be reflected on the DB item and the data migration program which have an effect and are checked in step 103. Specifically, step 10
In step 3, if (1) DB deletion in editing (a) table deletion (c) item deletion, (2) data migration program structure editing (b) deletion of migration logic, and (c) change of migration logic, the affected DB Delete items and affected migration programs. In the case where the change corresponds to (1) DB change (b) table change (d) item change in DB structure editing, the corresponding table or item of the migration program to be affected is changed according to the change.

<Step 108> Presence or absence of another editing instruction input If there is another editing instruction input from the input device 212,
In order to input a new editing instruction on the DB structure editing screen 500 or the table migration structure editing screen 700, the processing transits to step 102 and repeats the processing up to step 107. If there is no other edit instruction input, the user presses down the edit end button 532 on the DB structure edit screen 500 or the table migration structure edit screen 700, and
Transition to step 109.

<Step 109> Reflection of Structure Information in DB and Data Migration Program The DB created and edited in steps 101 to 108 described above.
Structure information 300, data migration program structure information 400
Is directly or indirectly reflected in the DB structure information in the DB management system 230 and the data migration program structure information in the data migration program management system 240.

As described above, according to the present embodiment, the DB
When editing the structure or data migration program structure, other D
It is possible to avoid adverse effects on B and the data migration program.

As described above, in this embodiment, the data distribution management method has been described using customer information in a bank as an example of data. However, it is needless to say that data may be in other industries such as a distribution business other than a bank. Sales information, etc.

Further, although the DB handled in this embodiment exists in one company, the DB is distributed to a plurality of companies such as group companies and between providing companies, and a data migration program is also provided for a plurality of companies. It may be a transition between companies.

Next, the functional configuration required on the computer 211 of the data distribution management system 210 in the system configuration diagram shown in FIG. 2 will be described with reference to FIG.

Computer 2 of data distribution management system 210
11 requires a program unit 1102 for inputting an editing instruction to the DB structure and the data migration program structure information using the input device 212, and a function to switch to another DB or data migration program at the time of editing. A program unit 1103 for checking the effect, a program unit 1105 for notifying the checked effect, a unit 1106 for inputting the presence / absence of the determination intention of the editing instruction, and the editing content stored in the storage device 214 in the case of the determination intention. DB structure information 300 and data migration program structure information 400
1107, a unit 1108 for inputting the presence or absence of another editing instruction, and
0, means 1109 to be reflected in the data migration program management system 240.

These program means can be stored as an application program in a storage medium such as a floppy (registered trademark) disk or a semiconductor memory or in the storage device 212. In FIG. 12, the program means is the storage device 21.
2 shows an example of a configuration in the case where the information is stored in the storage area 2. Details are the same as those of the above-described functional configuration example, and thus description thereof will be omitted. The stored program is installed in the work memory of the data distribution management system 210, and is executed by the CPU to realize the above-described data distribution management method based on the above configuration.

[0086]

As described above in detail, according to the present invention, when editing a DB structure or a data migration program structure,
It is possible to avoid adverse effects on other related DBs and data migration programs.

[Brief description of the drawings]

FIG. 1 is an overall processing flowchart of a data distribution management method according to an embodiment of the present invention.

FIG. 2 is a system configuration diagram showing an embodiment of the present invention.

FIG. 3 is a diagram showing a configuration example of DB structure information according to the embodiment of the present invention.

FIG. 4 is a diagram showing a configuration example of database migration program structure information according to the embodiment of the present invention.

FIG. 5 is a diagram showing an example of a DB structure editing screen according to the embodiment of the present invention.

FIG. 6 is a diagram showing an example of a DB structure editing detailed setting screen according to the embodiment of the present invention.

FIG. 7 is a diagram showing an example of a data migration program structure editing screen according to the embodiment of the present invention.

FIG. 8 is a diagram showing an example of a data migration program structure editing detailed setting screen according to the embodiment of the present invention.

FIG. 9 is a diagram showing an example of a notification target criterion setting screen according to the embodiment of the present invention.

FIG. 10 is a diagram illustrating an example of an influence notification screen according to the embodiment of the present invention.

FIG. 11 is an overall configuration diagram of a data distribution management system according to an embodiment of the present invention.

FIG. 12 is a diagram showing an example of a system configuration having a storage medium storing a data distribution management program according to an embodiment of the present invention.

[Explanation of symbols]

101: DB structure information and data migration program structure information acquisition processing; 102: DB structure information and data migration program structure information editing instruction processing; 103: editing influence check processing; 104: notification target influence presence / absence determination processing; 105: processing for notifying the influence at the time of editing; 106: processing for inputting the presence / absence of the intention to determine the editing instruction; 107: DB for the editing instruction
Reflection processing on structure information / data migration program structure information, 108... Judgment processing of presence / absence of another editing instruction input, 109
... DB for DB structure information and data migration program structure information
-Reflection processing to the data migration program.

Continued on the front page (72) Inventor Makoto Miyata 1099 Ozenji, Aso-ku, Kawasaki-shi, Kanagawa Prefecture F-term in Hitachi, Ltd. System Development Laboratory 5B082 CA10 EA02 GC02

Claims (8)

[Claims] An editing instruction is input to structural information of a database and structural information of a data migration program between the databases, and another database in a case where the structural information is edited according to the input editing instruction; and Checking the effect on the structure of the data migration program between databases, notifying the checked editing effect, and inputting the presence or absence of a decision to confirm the editing instruction based on the notified editing effect, If there is an intention to confirm the instruction, the editing instruction is reflected in the structure information. If there is another editing instruction input, the processing proceeds from the editing instruction input processing of the acquired structure information to the structural information of the editing instruction. Is repeated until there is no other editing instruction input, the edited structural information is transferred to the database and the database migration program. A data distribution management method, wherein the data distribution management method is reflected in the data distribution management method. 2. The database structure information according to claim 1, wherein the editing instruction input of the structure information of the data migration program is performed when the database and the data migration program are existing, Acquiring database structure information and the data migration program structure information from the migration program management system, and inputting an edit instruction to the acquired database structure information and the data migration program structure information. Data distribution management method. 3. The notice of the checked editing effect according to claim 1, wherein, among the checked editing effects, if there is an editing effect to be notified based on a notification target criterion, a notification is made; If there is no effect to be notified among the checked effects at the time of editing, confirm the editing instruction and edit the structure information,
A data distribution management method, characterized in that: 4. The data distribution management method according to claim 1, wherein the effect at the time of editing is an effect on a value of an item in a database and an effect on an operation of a data migration program. 5. The structure information editing according to claim 1, wherein the editing instruction is determined, and the checked and affected DB items and the data migration program are deleted or deleted so as to avoid the influence. A data distribution management method characterized by reflecting the modified structure information. 6. The reflection of the edited structure information in the database and the database migration program according to claim 1 is a reflection of the edited structure information in the database management system and the management system of the data migration program. And a data distribution management method. 7. A means for inputting an edit instruction for structural information of a database and structural information of a data migration program between the databases, and another database for editing the structural information according to the input edit instruction. And a means for checking the effect on the structure of the data migration program between databases, notifying the checked editing effect, and a means for inputting the presence or absence of a decision to confirm the editing instruction based on the notified editing effect. Means for reflecting the editing instruction in the structure information if there is a determination intention of the input editing instruction; and if there is another editing instruction input, from the editing instruction input processing of the acquired structural information. Means for repeating the processing until the editing instruction is reflected on the structure information, and if there is no other editing instruction input, the edited structure information is A data distribution management system comprising a database and means for reflecting the data in a database migration program. 8. A means for inputting an edit instruction for structural information of a database and structural information of a data migration program between the databases, and another database for editing the structural information according to the input edit instruction. And a means for checking the effect on the structure of the data migration program between databases, notifying the checked editing effect, and a means for inputting the presence or absence of a decision to confirm the editing instruction based on the notified editing effect. Means for reflecting the editing instruction in the structure information if there is a determination intention of the input editing instruction; and if there is another editing instruction input, from the editing instruction input processing of the acquired structural information. Means for repeating the processing until the editing instruction is reflected on the structure information, and if there is no other editing instruction input, the edited structure information is A storage medium storing a data distribution management program, comprising: a database and means for reflecting the data in a database migration program.