JPH04266138A - Update processing system - Google Patents

Abstract

PURPOSE:To assure the matching properties of a data base without overlooking a necessary table despite a large updated variable by referring to a dictionary. CONSTITUTION:Following are provided: an input means 1 to interactively input a parameter consisting of an updated item name and the values set before and after the updating together with a dictionary storage means 2 which stores the information necessary for control of a relational data base, a dictionary reference means 3 which inputs the information on a table including the updated item name through the means 2 based on the parameter inputted from the means 1, a relational data base storage means 4 which has a data base consisting of the table and the table defining information, a table selection means 5 which selects a table to be updated with reception of the information on the means 3 and inputs the table defining information through the means 4, a record retrieving means 6 which obtains a record to be updated based on the information received from both means 1 and 5, and a record updating means 7 which updates the record obtained by the means 6 into the updated value inputted from the means 1.

Description

[Detailed description of the invention]

0001

[Field of Industrial Application] The present invention relates to an update processing method for interactively updating tables stored in a relational database, and in particular, when data to be updated is stored in multiple tables, data in multiple tables is This invention relates to an update processing method for updating all files at once.

0002

[Prior Art] Conventionally, in the update processing method, a user examines a dictionary that stores information for managing a relational database to find out which tables need to be updated, and then checks all the tables that need to be updated. It was necessary to update the data for each table.

0003

[Problems to be Solved by the Invention] However, in the conventional update processing method described above, the user has to investigate the table that requires updating, and the data is updated for each table. The problem is that the operations become complicated, and especially when there are many tables that require updating, it is easy to overlook tables that require updating.

An object of the present invention is to provide an update processing method that can detect all tables that require updating and perform update processing all at once.

[0005]

[Means for Solving the Problems] The update processing method of the present invention is an update processing method for interactively updating data stored in a relational database, which includes the item name of the item to be updated, the value before the update, and the value after the update. an input means for interactively inputting a parameter made up of values, a dictionary storage means for storing a dictionary made up of information for managing the relational database, and a dictionary storage means stored in the dictionary storage means. a dictionary reference means for inputting table information including the item name of the item to be updated inputted by the input means from a dictionary; and a relational database storage means for storing a relational database constituted by the table and table definition information; table selection means for selecting tables that need to be updated from table information input by the dictionary reference means and inputting table definition information stored in the relational database; record search means for finding records that require updating from the pre-update values input by the input means; and record search means for inputting records based on the table definition information input by the table selection means. The configuration includes record updating means for updating to updated values input by the means.

[0006]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an embodiment of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of the present invention, showing the configuration of a portion that updates a plurality of tables at once.

That is, in this embodiment, an input means 1 for interactively inputting a parameter consisting of an item name of an item to be updated, a value before updating, and a value after updating, and information for managing a relational database are provided. a dictionary storage means 2 for storing a dictionary composed of , and a dictionary reference means 3 for inputting table information including item names of items input by the input means 1 from the dictionary stored in the dictionary storage means 2; , a relational database storage means 4 that stores a relational database composed of tables and table definition information, and a table that needs to be updated from the table information inputted by the dictionary reference means 3, and the table that needs to be updated is stored in the relational database storage means 4. A table selection means 5 for inputting stored table definition information, and a record search for finding records that require updating from the table definition information inputted by the table selection means 5 and the pre-update values inputted by the input means 1. means 6, and record updating means 7 for updating the record found by the record searching means 6 based on the table definition information inputted by the table selection means 5 to the updated value inputted by the inputting means 1. There is.

Table 1 is a table showing dictionaries stored by dictionary storage means, and Table 2 is a table stored in a relational database stored by database storage means. Furthermore, Table 1 and Table 2
shows the state before the batch update process for multiple tables is performed according to this embodiment.

0010

[0011] In the examples of Tables 1 and 2, information regarding five items constituting the employee table and affiliation table is stored in the dictionary, and the employee table stores six records and the employee table stores four records. The affiliation table in which the personnel are stored is stored in the personnel database.

Next, the batch update process for a plurality of tables when changing the affiliation code 002 to 005 for the relational databases shown in Tables 1 and 2 will be explained using the flowchart shown in FIG.

Step S1 shows the processing in the input means 1, step S2 shows the processing in the dictionary reference means 3, steps S3 and S4 show the processing in the table selection means 5, and step 5 shows the processing in the record search means 6. , and steps S6 and S7 indicate processing in the record updating means 7.

First, processing in the input means 1 is started. That is, in step S1, a parameter consisting of an affiliation code which is the item name of the item to be updated, 002 which is the value before updating, and 005 which is the value after updating is input interactively.

In step S2, table information including affiliation codes is input from the dictionary. Referring to Table 1, it can be seen that the tables containing affiliation codes are the employee table and affiliation table stored in the personnel database.

[0016] In step S3, it is determined whether there is any table that requires updating. Since there are employee tables and affiliation tables that require updating in step S2, the process advances to step S4.

[0017] In step S4, table definition information required for the processing from step S5 onwards is input from the relational database. That is, first, the definition information of the employee table stored in the personnel database is input from the relational database.

In step S5, records that require updating are determined from the employee table based on the pre-update values input in step S1. That is, records R12 and R14 whose affiliation code is 002 are found.

[0019] In step S6, records R12 and R14
exists, the process advances to step S7.

In step S7, the affiliation code of record R12 is first changed to 005, which is the updated value input in step S1, based on the employee table definition information input in step S4, and the process proceeds to step S6.

[0021] In step S6, since there is a record R14 that requires updating, the process advances to step S7.

In step S7, the affiliation code of record R14 is changed to 005, which is the updated value input in step S1, based on the table definition information of the employee table input in step S4, and the process proceeds to step S6.

[0023] In step S6, since there is no record that requires updating, the process advances to step S3.

[0024] In step S3, it is determined whether there is any table that requires updating. Since the affiliation table still exists here, the process advances to step S4.

[0025] In step S4, table definition information required for the processing from step S5 onwards is input from the relational database. That is, the definition information of the affiliation table stored in the personnel database is input from the relational database.

In step S5, records that require updating are determined from the affiliation table based on the pre-update values input in step S1. That is, record R22 whose affiliation code is 002 is found.

In step S6, since record R22 exists, the process advances to step S7.

In step S7, the affiliation code of record R22 is changed to 005, which is the updated value input in step S1, based on the definition information of the affiliation table input in step S4, and the process proceeds to step S6.

In step S6, since there is no record that requires updating, the process advances to step S3.

[0030] In step S3, since there are no remaining tables that require updating, the batch update process for multiple tables is ended.

[0031]

[Effects of the Invention] As explained above, the present invention updates multiple tables at once, which simplifies operations for the user, and makes it easier to refer to the dictionary even when there are many tables that require updating. Because this method covers all tables that require updating, no table that requires updating is overlooked, and the consistency of the database can be guaranteed.

[Brief explanation of the drawing]

FIG. 1 is a block diagram of one embodiment of the present invention.

FIG. 2 is a flowchart showing the flow of batch update processing for multiple tables.

[Explanation of symbols]

1 Input means 2 Dictionary storage means 3 Dictionary reference means 4. Relational database storage means 5 Table sorting means 6 Record search means 7 Record update means

Claims (1)

[Claims] [Claim 1] In an update processing method for interactively updating data stored in a relational database, an item name of an item to be updated and a parameter consisting of a value before update and a value after update are interactively updated. an input means for inputting information, a dictionary storage means for storing a dictionary constituted of information for managing the relational database, and a dictionary storage means for storing the information input by the input means from a dictionary stored in the dictionary storage means; dictionary reference means for inputting table information including item names of items; relational database storage means for storing a relational database constituted by the table and table definition information;
table selection means for selecting tables that need to be updated from table information input by the dictionary reference means and inputting table definition information stored in the relational database; a record search means for finding records that require updating from the pre-update values input by the input means; and a record search means that searches for records that require updating from the pre-update values input by the input means; and record updating means for updating the record to the updated value input by the means.