JPH0973466A - Database maintenance method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate maintenance operation by calling and executing a low- retrieval-load database access program corresponding to a table among a plurality of low-retrieval-load database access programs which are previously generated corresponding to respective tables of a relational database. SOLUTION: The necessary low-retrieval-load database access program corresponding to the selected table among the low-retrieval-load database access programs 411-413, 421-423, 431-433, and 441-443 which are previously generated and registered corresponding to the respective tables of the relational database is called and executed. Data regarding the necessary table of the relational data base accessed by the executed low-retrieval-load database access program are displayed on a display means 402, the section of processing to be executed as to maintenance is inputted, and the result of processing based upon a predetermined rule corresponding to the section is displayed on the display means 402.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for confirming, correcting, and creating data contents of a relational database (hereinafter also referred to as "relational database" as appropriate), and more particularly to database maintenance of a relational database system. is there.

[0002]

2. Description of the Related Art A relational database saves data items in a table format, so that the user can easily design the database and the input / output description of data retrieval can be easily performed. , Has become the mainstream database for personal computers.

A typical relational database in the world of general-purpose computers is DB2 developed by IBM Corporation in the United States.

The conventional technique is SQL (Structured Query Languag) for the purpose of improving development productivity.
There is a method for automatically generating a DB2 input / output description by utilizing the versatility of e), which is described in Japanese Patent Laid-Open No. 6-180719.

[0005]

However, in the case of maintaining the contents of the data of the relational database, there are the following problems.

That is, when the content of the data recorded in the relational database is unexpectedly changed by an unauthorized program or the like, the changed data content of the relational database is dumped (stored in a storage medium. The contents that have been changed to a visible medium), check the contents on paper, restore the illegally modified data contents by the program, and dump again to confirm the result of restoring the data. The need arises. This series of checks and corrections on paper is a very time-consuming task.

Further, although the relational database can realize a general-purpose data search, when a program for performing a general-purpose search is executed, an unpredictable search load is applied to the CPU and the storage area. Sometimes the problem arises.

Further, since it is necessary to suspend the operation of the relational database for the purpose of restoring the data, it is necessary to stop the application program that uses the relational database, which hinders the progress of the application.

Therefore, the database maintenance method according to claim 1 of the present application does not cause an unpredictably large search load, and conventionally selects a target for data restoration of a relational database, which is manually performed. It is an object of the present invention to provide a database maintenance method capable of interactively executing a series of maintenance operations such as confirmation, correction, and correction confirmation in front of a computer screen.

The database maintenance method according to claim 1 of the present application is capable of restoring (maintaining) data online without stopping the operation of the target relational database for the purpose of restoring the data. It is also intended to provide a maintenance method.

The database maintenance method according to claim 1 of the present application can easily confirm and correct the data content of the relational database and create test data in the development test, thereby improving the productivity of the development test. It is also an object to provide a database maintenance method that can be improved.

Further, the database maintenance method according to claim 1 of the present application uses an SQL program in SQL (Structured Query Language) which is a language for accessing a relational database used in an existing application program. Therefore, it is also an object of the present invention to provide a database maintenance method capable of realizing the use of system resources such as a CPU and a storage area with minimum appropriate access.

[0013]

In order to achieve the above object, the database maintenance method according to claim 1 of the present application is a method for performing maintenance of a relational database, and a table of the relational database to be maintained is displayed. The step of selecting and executing the required low search load database access program corresponding to the selected table from a plurality of low search load database access programs created and registered in advance corresponding to each table of the relational database And a step of performing.

[0014]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings. FIG. 4 is a block diagram of a database maintenance apparatus in which the database maintenance method according to the embodiment of the present invention is used.

FIG. 5 is a flow chart showing the processing in the database maintenance method of the present application. FIG. 1 is a diagram showing an outline of processing in the database maintenance method of the present application. FIG. 2 is a diagram showing an input / output screen for interactively operating in the database maintenance method of the present application. FIG. 3 is a diagram showing a state in which data contents are displayed on the input / output screen.

Referring to FIG. 4, the database maintenance device includes a CPU 401, a display means 402, an input selection means 403, a storage area 404, a storage means 405 and a storage means 406. The storage unit 406 includes a relational database table 410, a relational database table 420,
It includes a relational database table 430 and a relational database table 440. Although the case where there are four types of relational database tables is shown here, the number of types is not limited to four, and a plurality of types may be used. The storage unit 405 stores the low search load database access programs 411, 412,
And 413, 421, 422, and 423, 4
31, 432 and 433 and 441, 442 and 443.

An embodiment of the present invention will be described with reference to FIGS. 5 and 4. In step 502, the input screen used for maintenance of the relational database is called and displayed on the display means 402. In step 503, the relational database table to be maintained is selected based on the display on the input screen. In step 504, a plurality of low search load database access programs 411, 4 created and registered in advance corresponding to each table of the relational database.
12, 413, 421, 422, 423, 431, 43
From 2, 433, 441, 442, 443, the required low search load database access program corresponding to the selected table is called and executed. For example, when the relational database 420 is selected, the low search load database access program 421 or 42 created and registered corresponding to the relational database 420.
2 or 423 is called and executed. Here, the database access programs 421, 422, 423 are created and registered for each access pattern.
The data relating to the required tables of the relational database accessed by the low search load database access program called and executed in step 505 is displayed by the display means 402.
Is displayed in. In step 506, a category of processing to be executed for maintenance is input, and the result of processing based on a predetermined rule corresponding to the processing category input in step 507 is displayed on the display unit 402.
When an instruction to execute maintenance is input again in step 508, the process proceeds to step 503, and when an instruction to end maintenance is input, the maintenance ends.

An outline of the processing according to the first embodiment of the present application will be described with reference to FIG. First, in step 1, an input screen for interactively operating in maintenance of the relational database is called. This input screen is displayed in the mode shown in FIG. In step 2, the password and table name relating to the relational database to be maintained are input, and the table to be maintained is selected. Here, a database access program created and registered in advance for each table is called. In step 3, the processing classification is input. Here, only the display (SELECT) and the addition (INSERT) of the data contents of the relational database are permitted. In step 4, the content of the data of the relational database selected in step 3 is displayed. The data content of this relational database is displayed in the manner shown in FIG. In the example of FIG. 3, N442I
The display result of the table of the relational database when C12,001 is designated as the condition value by the database access program R1 is shown.

On the screen displayed in step 5, the classification of the process to be executed is input. In step 6, processing for displaying the result is performed based on a rule determined in advance corresponding to the input processing classification.
In step 7, the display contents of step 6 are output to the printer corresponding to the screen when printing is selected in step 5 or the printer designated on the screen. In step 8,
The display content based on the display rule in step 6 is displayed as a result display. In step 9, the screen ending process is performed, and the database maintenance work ends.

As described above, according to the database maintenance method according to claim 1 of the present application, when the contents of the data recorded in the relational database are unexpectedly changed by an unauthorized program, etc. When trying to restore the data contents of a changed relational database, create a conventional program, print the data contents on paper to check the contents, create a change program to change the data, and then change the data contents again. It is possible to provide a database maintenance method capable of interactively executing the troublesome work of confirming the above without causing an unpredictably large search load.

Further, according to the database maintenance method according to claim 1 of the present application, the data of the relational database can be corrected online and in a short time, and the influence on other database users can be minimized. It is possible to provide a database maintenance method capable of

Further, according to the database maintenance method of the first aspect of the present application, in the development test, it is easy to create test data, check the contents of data, correct the data, and check the data change by the program. A database maintenance method that is easy and that can improve the productivity of development tests can be provided.

Further, according to the database maintenance method of the first aspect of the present application, the database access program used in the existing application program can be used, and the optimum access path is guaranteed in the database. Therefore, it is possible to provide a database maintenance method capable of realizing the use of system resources (CPU, storage area), which is a problem in the relational database, to the minimum necessary.

[Brief description of drawings]

FIG. 1 is a flowchart showing an outline of processing in a first embodiment of a database maintenance method of the present application.

FIG. 2 is a diagram showing a screen on which a table selecting unit of the relational database according to the first embodiment is displayed.

FIG. 3 is a diagram showing a screen on which data related to required tables of a relational database accessed by a low search load database access program according to the first embodiment is displayed.

FIG. 4 is a block diagram of a database maintenance device according to the first embodiment.

FIG. 5 is a flowchart showing processing of the database maintenance method according to the first embodiment.

[Explanation of symbols]

405, 406 Storage means 410, 420, 430, 440 Relational database table 411, 412, 413 Relational database table 410
Low search load database access programs 421, 422, 423 created and registered corresponding to the table 420 of the relational database
Low search load database access program 431, 432, 433 created and registered corresponding to the table 430 of the relational database
Low search load database access program 441, 442, 443 created and registered corresponding to the table 440 of the relational database
Low search load database access program created / registered for

Claims (1)

[Claims] 1. A method for performing maintenance of a relational database, comprising the steps of selecting a relational database table to be maintained, and a plurality of low searches previously created and registered corresponding to each relational database table. Calling and executing a required low search load database access program corresponding to the selected table from the load database access program.