JPH10214211A - Device and method for reorganizing database - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce labor required for reorganizing and to improve efficiency in processing by successively and automatically performing reorganizing concerning the data table of reorganizing execution object. SOLUTION: A database system 1 loads a reorganizing job program 17 on a database management control part 12 as configuration for putting various data tables formed on a database 11 into optimum storage state. By previously setting a maintenance script corresponding to the data table of reorganizing execution object into a maintenance script file, a reorganizing job is executed by successively and automatically activating the maintenance script corresponding to the data table of reorganizing execution object as needed. Besides, even when the reorganizing job is finished in the middle after the lapse of maintenance limit time, the job can be executed the next time from that finished part. Therefore, it is not necessary for an operator to grasp both the reorganizing completed data table and the non-completed data table, either.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database reorganization technique for arranging various data tables formed on a database used in a computer system or the like in an optimal storage state.

[0002]

2. Description of the Related Art In a database used in a computer system or the like, the order of storage is gradually disturbed by updating, adding and deleting data tables. Then, the used storage capacity increases and the performance of the system deteriorates. For this reason, it has sometimes been necessary to reorganize the database to organize the data tables into optimal storage states.

[0003] In the prior art, in order to reorganize such a database, a maintenance script indicating a procedure for reorganizing the data table for each data table in the database is created, and an operator uses a computer system to perform the maintenance. This was done by starting the scripts sequentially. By the way, the reorganization of the database as described above is limited to a time zone when the database is not used. For this reason, when there are a plurality of data tables to be reorganized, reorganization of all data tables may not be completed within the time limit.
In such a case, it is necessary to record the information in a memo or the like so that the operator can distinguish between the data table for which reorganization has been completed and the data table for which reorganization has not been completed, and perform reorganization from the next time. I needed to.

[0004]

As described above, in the conventional database reorganization technique, an operator must sequentially start a maintenance script for a data table to be reorganized by using a computer system, which is troublesome. It was hanging. Moreover, if the reorganization of all the data tables to be reorganized is not completed within the time limit, the operator must be able to distinguish between the data tables that have been reorganized and those that have not been completed. There was also trouble that did not become.

Therefore, according to the present invention, the data tables to be reorganized can be sequentially and automatically reorganized, and the reorganization of all the data tables to be reorganized has not been completed within the time limit. In this case, it is an object of the present invention to provide a database reorganization apparatus and a reorganization method that can automatically perform reorganization from the next time, and can reduce labor required for reorganization and improve processing efficiency. .

[0006]

A database reorganization apparatus according to the present invention includes a maintenance script file for storing a plurality of maintenance scripts created for each data table on a database, and a maintenance script file for each of the maintenance scripts stored in the maintenance script file. A script management file that stores the last run data,
A time limit setting means for setting a time limit for a process of reorganizing a data table on the database; an execution order determining means for determining an execution order of the maintenance script in an ascending order of the last execution data stored in the script management file; Reorganization processing means for executing the corresponding maintenance script of the maintenance script file within the time limit set by the time limit setting means in accordance with the order determined by the execution order determining means to reorganize the data table; A last execution time updating means for updating last execution time data in the script management file of the maintenance script which has been executed by the composition processing means.

In this apparatus, the script management file stores priority data for setting a priority together with the last execution data for each maintenance script, and the execution order determining means stores the last execution data stored in the script management file. It is convenient to determine the execution order of the maintenance scripts in the order of older and higher priority data. It is also convenient to provide a means for outputting error log data when an error occurs as a result of executing the maintenance script by the reorganization processing means.

On the other hand, in the database reorganization method of the present invention, the maintenance script file and the script management file are provided, and the execution order of the maintenance script is determined in the order of the oldest data at the time of the last execution stored in the script management file. The data table is reorganized by executing the corresponding maintenance script in the maintenance script file within the predetermined time limit according to the above, and the last execution data in the script management file of the maintenance script that has been executed is updated. It is like that.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram of a database system 1, and a database 11 formed by a hard disk or the like storing various data tables.
And a database management control unit 12 formed by a CPU or the like for adding, deleting, and updating data tables to the database 11.

The database system 1 includes a storage unit 13 such as a ROM and a RAM for storing data other than a data table, and a clock unit 1 for measuring the current date and time.
4. A communication control unit 15 for controlling data communication with an external monitoring base connected online via a communication line, a computer system 2 using this database system 1 is connected, and a data input from an input device 21 such as a keyboard is performed. An interface unit 16 for taking in and transmitting data to be output to an output device 22 such as a display or a printer is provided.

[0011] The database system 1
As a configuration for reorganizing a database for organizing various data tables formed on the database 11 into an optimal storage state, a reorganization business program 17 is installed in the database management control unit 12. 2, the maintenance script file 31, the script management file 32, the output order file 33, the maintenance time limit memory 34, the error log file 35, the execution order counter 36, and the execution number memory 37 are stored in the storage unit 13, as shown in FIG. Are formed.

The maintenance script file 31
Is a file that stores a plurality of maintenance scripts created for each data table on the database 1 together with a script name for specifying the script and a priority order of the script relative to other scripts. For the maintenance script file 31, the maintenance script for the data table to be reorganized is previously written by the computer system 2 connected via the interface unit 16 or the monitoring base connected via the communication control unit 15. It is set by adding or deleting it together with the script name and priority data. Incidentally, the priorities are set to consecutive numbers and are set so as not to overlap.

The script management file 32 is a file for storing the data of the last execution date, which is the last execution data, and the data of the priority for each maintenance script stored in the maintenance script file 31. The execution order file 33 is a file for storing a script name in the execution order of each maintenance script stored in the maintenance script file 31.

The maintenance time limit memory 34 includes:
This memory stores the time at which the reorganization of the data table must be completed, and constitutes time limit setting means. In the maintenance time limit memory 34, a time limit determined in advance based on the operation time of the system or the like is set from the computer system 2 or the monitoring base.

The error log file 35 is a file for storing error log data generated when a data table reorganization operation is executed, and is cleared by a command from the computer system 2 or a monitoring base. The execution order counter 36 counts the order n of the maintenance script that executes the table reorganization, and the execution number memory 37 stores the total number N of the maintenance scripts that execute the table reorganization.

The database system 1
The database management control unit 12 starts the reorganization business program 17 in response to a start command from the computer system 2 or the monitoring base. Thereby, the database management control unit 12 first, as shown in FIG.
(Step) The script management file 32 as 1
Start update processing of.

That is, the script name of the script management file 32 is compared with the script name of the maintenance script file 31. If there is a script name that exists in the maintenance script file 31 but does not exist in the script management file 32, the script name is replaced with the script name. If a script name exists in the script management file 32 but does not exist in the maintenance script file 31, the record of the script name is deleted from the script management file 32. Next, the priority corresponding to each script name in the script management file 32 is matched with the priority corresponding to each script name in the maintenance script file 31. Finally, the last execution date corresponding to the script name newly added to the script management file 32 is set in the clock unit 1.
4 is the current date read out.

When the update processing of the script management file 32 is completed, the process of creating the execution order file 33 is started as ST2 (execution order determining means). That is, the records in the script management file 32 are rearranged in the order of the last execution date. At this time, records having the same final execution date are arranged in the order of higher priority (smallest numerical value). Thereafter, the script names are read out in the order of the latest execution date, the script names are stored in the execution order file 33 in that order, and the execution order file 33 is created. At this time, execution order file 3
The number N of the script names stored in No. 3 is set in the execution number memory 37.

When the process of creating the execution order file 33 is completed, the table reorganization execution process specifically shown in FIG. 4 is started as ST3. First, after once resetting the execution order counter 36, the count is incremented by [1] in ST31. Next, in ST32, it is determined whether or not the count value n of the execution order counter 36 has exceeded the data N of the execution number memory 37. If not exceeded, the clock unit 14 is set as ST33.
Then, it is determined whether or not the current time being counted has exceeded the time limit set in the maintenance time limit memory 34. If the time limit has not elapsed, the process goes to ST34 to execute the execution order n from the execution order file 33.
If the maintenance script with this script name is read from the maintenance script file 31 after reading the script name of the order, the maintenance script is started and the corresponding data table is reorganized (reorganization processing means). .

Thereafter, when this maintenance script is completed, it is checked in step ST35 whether this maintenance script has been completed with an error that the reorganization has not been completed or has been completed normally. If the operation has been completed normally, the current date measured by the clock unit 14 is read out as ST36, and this date is used as the last execution date of the maintenance script and the corresponding script name in the script management file 32 is set. Update the last execution date data (final execution time updating means).

On the other hand, if the error has ended, the maintenance script adds data such as the script name and the current date read from the clock unit 14 to the error log file 35 as error log data in step ST37. Thereafter, returning to ST31, if the execution order counter 36 is counted up by [1], ST32
The subsequent processing is repeated.

In this way, if the count value n of the execution order counter 36 exceeds the data N of the execution number memory 37 in ST32, or if the current time exceeds the time limit set in the maintenance time limit memory 34 in ST33. Then, the table reorganization execution processing ends. At this time, ST38
If the error log data is stored in the error log file 35, the error log data is transmitted to the monitoring base via the communication control unit 15, and then the table reorganization execution processing ends.

As described above, in the present embodiment, for example, when the computer system 2 is operated to give a command to start the database reorganization operation to the database system 1, of the various data tables constructed in the database 11, the maintenance is performed. A reorganization process is started for the data table to be reorganized and whose maintenance script is stored in the script file 31. In this case, the order in which the reorganization processing is executed is set in the order of the longest elapsed date since the previous reorganization processing was executed.
If the elapsed date is the same, the priority is set in descending order of priority.

When the maintenance script for one data table ends normally and the reorganization of this data table is completed, the last execution date corresponding to the script name of the maintenance script in the maintenance management file 32 is updated to the current date. Is done. If the maintenance script ends in error and reorganization of this data table is not completed, the last execution date corresponding to the script name of the maintenance script in the maintenance management file 32 is not updated, and the error log data is changed to the error log. It is stored in the file 35.

In this way, the reorganization process for each data table to be reorganized is sequentially executed in the set order. If the reorganization processing for all the data tables to be reorganized is completed before the maintenance restriction time preset in the maintenance restriction time memory 34 is reached, or if the maintenance restriction time is reached, this processing is performed. finish. At this time, if there is an error-terminated maintenance script, the error log data in the error log file 35 is transmitted to the monitoring site, and the contents of the error are notified.

The data table to be reorganized, which has not been executed because the time limit has elapsed, is as follows:
Since the last execution date of the maintenance script is older than the last execution date for the executed data table of the reorganization execution, the maintenance script is preferentially executed next time.

For example, assuming that the database system 1 is incorporated into a store processor of a point-of-sale (POS) system constructed in a store or the like, the database 11 stores the product number, product name, unit price, etc. of each product. A product information table for storing information, a customer information table for storing customer information such as the name, address, and telephone number of each customer are stored. In these data tables, records are frequently added, deleted, and updated, and the order of storage is likely to be disordered. Therefore, a maintenance script is created as a table to be reorganized and set in the maintenance script file 31. By doing so, the reorganization processing of these data tables is periodically executed.

In this case, if the store opening time is set in advance as the maintenance time limit, the reorganization of the data table will not be continued after the store is opened, and the POS terminal business after the store is opened will be hindered. I won't come.

As described above, according to the present embodiment, the maintenance script for the data table to be reorganized is set in the maintenance script file 31 in advance, so that the data table to be reorganized can be executed when necessary. , The maintenance script for the data table is automatically started and the reorganization operation is executed, so that the labor required for reorganizing the data table can be greatly reduced.

Further, even if the reorganization operation is completed halfway because the maintenance time limit has elapsed, the next operation can be executed from the next time, so that the operator can distinguish the data table for which reorganization has been completed and the data table which has not been completed. There is no need to grasp it separately, and the labor can be reduced from this point. As a result, the reorganization of a plurality of data tables can be executed continuously, so that the processing efficiency of the reorganization process is improved.

Further, by adding a maintenance script to the maintenance script file 31, a data table to be reorganized can be added. By deleting the maintenance script from the maintenance script file 31, a data table to be reorganized can be deleted. . Therefore, the maintenance script is added from the monitoring base connected via the communication control unit 15,
By enabling deletion, it is possible to add or delete a data table to be reorganized from a remote monitoring site.

The present invention is not limited to the above embodiment. For example, in the above-described embodiment, a case has been described in which the reorganization work is started by a start command from the computer system 2 or the monitoring base, but may be started automatically at a preset cycle.

In the above-described embodiment, the re-organization of the newly added maintenance script is defined as the start of the reorganization operation, and the re-organization of the data table by the maintenance script is based on the re-organization of the data table by the already set maintenance script. Although it is executed later, it may be executed first by setting the oldest final execution date.

In the above embodiment, the error log data is sent to the monitoring base, but may be sent to the output device 22 of the computer system 2. In addition, it is needless to say that various modifications can be made without departing from the gist of the present invention, such as adding the time to the date as the final execution time data.

[0035]

As described in detail above, according to the present invention,
Reorganization can be performed automatically and sequentially on the data tables to be reorganized, and if all the data tables to be reorganized have not been reorganized within the time limit, the next Reorganization can be performed from the continuation. As a result, the labor required for reorganization can be reduced and the processing efficiency can be improved.

[Brief description of the drawings]

FIG. 1 is a main block diagram of a database system according to an embodiment of the present invention.

FIG. 2 is a view showing a main memory area formed in a storage unit in FIG. 1;

FIG. 3 is a flowchart showing a procedure of a reorganization business program executed by a database management control unit in FIG. 1;

FIG. 4 is a flowchart specifically showing a table reorganization process in FIG. 3;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Database system 2 ... Computer system 11 ... Database 12 ... Database management control part 13 ... Storage part 14 ... Clock part 15 ... Communication control part 16 ... Interface part 17 ... Reorganization business program 31 ... Maintenance script file 32 ... Script management file 33: execution order file 34: maintenance limit time memory 35: error log file

Claims (4)

[Claims] 1. A database system equipped with a database storing various data tables, wherein a maintenance script file storing a plurality of maintenance scripts created for each data table on the database is stored in the maintenance script file. A script management file for storing last execution time data for each maintenance script; a time limit setting means for setting a time limit for a process of reorganizing a data table on the database; and a last execution time stored in the script management file. Execution order determining means for determining the execution order of the maintenance script in the order of older data; and performing the maintenance within the time limit set by the time limit setting means in accordance with the order determined by the execution order determining means. Reorganization processing means for executing a corresponding maintenance script of the maintenance script file to reorganize the data table; and updating last execution data in the script management file of the maintenance script which has been executed by the reorganization processing means. A database reorganization apparatus comprising: a last-execution update unit. 2. The script management file stores priority data for setting a priority together with final execution time data for each maintenance script, and the execution order determining means stores the last execution time data stored in the script management file. 2. The database reorganization apparatus according to claim 1, wherein the means is for deciding an execution order of the maintenance script in an order of older data and higher priority data. 3. The database reorganization apparatus according to claim 1, further comprising means for outputting error log data when an error occurs as a result of executing the maintenance script by said reorganization processing means. 4. A database system equipped with a database storing various data tables, wherein a maintenance script file storing a plurality of maintenance scripts created for each data table on the database is stored in the maintenance script file. A script management file for storing the last execution data is provided for each maintenance script, and the execution order of the maintenance scripts is determined in the order of oldest last execution data stored in the script management file, and a predetermined limit is determined according to the order. Execute the corresponding maintenance script of the maintenance script file within the time range to reorganize the data table, and execute the script management of the maintenance script that has been executed. Database reorganization method is characterized in that so as to update the final runtime data in file.