JPH0997201A - Backup preparation system for data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a backup preparation system for data base with which a high-speed backup preparing processing is enabled without being affected by the scale of update frequency of a data base. SOLUTION: This system is provided with a backup preparing device 15 for performing the backup processing of the data base and generating the progress condition report of backup processing, a data base reference /update processor 14 for performing the reference/update processing of the data base and outputting addition/update information expressing the contents of data addition or update performed to the data base, a backup preparation condition reporting device 16 for judging whether the completely backed-up data are added/updated based on the progress condition report and addition/update information of backup, and an addition/update reflecting device 17 for performing the addition/ update processing of data to the backup data based on the addition/update information when the completely backed-up data are added/updated.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database backup creation system, and more particularly to a database backup creation system that enables efficient backup processing during update processing.

[0002]

2. Description of the Related Art Conventionally, this type of database backup creation system is an information system for performing database processing, which enables online database reference / update processing even during database backup creation processing. It is provided to improve the availability of the database. For example, an example of a conventional database backup creation system is disclosed in JP-A-2-211.
It is disclosed in Japanese Patent No. 557.

The database backup method disclosed in the above publication includes a database, an old backup volume for which the database was backed up in advance, a new backup volume for newly backing up, and a database update information logging file. In addition to the above, an online processing business program, an update information logging program for accumulating database update information in an update information logging file, and a backup program for backing up the database are provided.

Each time a record in the database is updated, the information logging file stores the update time, the record number, and the updated data content as update information. The backup process is executed by inputting the update information logging file and the old backup volume to the new backup volume. In the backup program, update information with the same record number is 1
When it appears more than once, it is controlled to match only the first time. For this reason, the update information logging file is sorted in descending order of update time and in ascending order of record numbers, and then the old backup volume and update information are matched, and when the same record data exists in both, When the same record does not exist for the update information data, the backup processing is executed by outputting the data of the old backup volume to the new backup volume.

At this time, since the backup program does not access the database, the backup program and the online processing business program can be executed in parallel. Further, by stopping the output to the new backup volume when the update time of the update information logging file reaches an arbitrary value, it is possible to create a backup of the database during the online processing operation at an arbitrary time.

[0006]

In the conventional database backup creation system described above, firstly, the sorting process must be performed on all the records of the update information logging file after the previous backup process. If it is applied to a database with a large scale or a high update frequency, the backup processing time will be significantly slowed down.

Secondly, since the backup process is performed based on the data of the old backup volume created in advance, when the database storage state is changed, such as when the database is extended due to insufficient database capacity or the like. Had a drawback that backup processing could not be performed unless business was stopped.

The present invention solves the above-mentioned conventional drawbacks and provides a database backup creation system capable of performing high-speed backup creation processing without being affected by the size of the database or the update frequency in the database backup processing during update processing. The purpose is to do. Another object of the present invention is to provide a backup creation system capable of performing backup processing without stopping operations even when the storage state of a database is changed.

[0009]

In order to achieve the above object, a database backup creating system of the present invention performs a backup process of a database and a backup creating unit for generating a progress status notification of the backup process, and a database. Reference / update processing of the database is performed according to an instruction from the application processing program, and when the data added to or updated in the database is added, additional update information indicating the addition or update of the data is output. Whether additional updates have been made to the backup processed data based on the database reference / update processing means, the progress notification input from the backup creation means, and the additional update information input from the database reference / update processing means Back up to judge When the creation status notifying means and the backup creation status notifying means determine that the backup-processed data has been additionally updated, the additional data update processing of the backup data is performed based on the additional update information. And an additional update reflecting means for performing.

In another aspect, the backup creation status notifying means notifies the database reference / update processing means of outputting the additional update information at the start of backup processing by the backup creating means. When the backup processing by the backup creating means is completed, the database reference / update processing means is notified of the acquisition end instructing the end of the output of the additional update information.

In still another aspect, the backup creating means creates the backup notification of the progress status every time the database reference / update processing means notifies the backup creation status notifying means of the additional update information. The status notification means is notified.

[0012] In another preferred aspect, the database reference / update processing means is configured to notify the backup creation status notifying means and the database when the acquisition start notification is notified when the database is additionally updated. The additional update information is output, and when the acquisition start notification is not notified, the additional update information is output only to the database.

In another preferred aspect, the backup creation status notifying means compares the progress status notification with the additional update information to determine whether additional update has been made to the backup-processed data. However, when it is determined that the backup-processed data has been additionally updated, the additional update reflecting means is activated to notify the additional update information.

In the present invention, the backup creation status notification device is notified of the progress status of the progress of the backup processing and the update information made to the database during the backup processing. The backup creation status notification device compares the additional update information and the backup progress status each time the additional update information is notified, and if the database device is updated with respect to the part for which backup data has been created Start the update reflection device. The additional update reflecting device performs the additional update to the backup device according to the notification of the additional update information from the backup creation status notifying device.

[0015]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a block diagram showing the configuration of a database backup creation system according to an embodiment of the present invention.

Referring to FIG. 1, the database backup creation system of this embodiment is a database device 1.
1, a backup device 12, a database application processing program 13, and a database reference / update processing device 1
4, a backup creation device 15, a backup creation status notification device 16, and an additional update reflection device 17.

Here, the backup device 12 stores the backup data from the database device 11.
The database application processing program 13 instructs the database reference / update processing device 14 to perform processing on the database device 11. Database reference / update processor 1
Reference numeral 4 executes reference / update processing of the database device 12 based on an instruction from the database application processing program 13.

The backup creating device 15 also executes backup processing by writing the backup data read from the database device 12 to the backup device 12. Backup creation status notification device 16
Instructs the additional update reflection device 17 to perform additional update for the backup device 12 based on the backup creation progress status from the backup creation device 15 and the additional update information from the database reference / update processing device 14. And
The additional update reflection device 17 performs additional update of the backup data of the backup device 12 according to an instruction from the backup creation status notification device 16.

The backup data creation processing of the database device 11 by the backup creation system configured as described above will be described below with reference to the flowcharts of FIGS. 2 and 3.

The backup data creation process of the database device 11 is started by activating the backup creation device 15. Here, the process of the backup creation device 15 is shown in FIG.
The processing of No. 6 is shown in FIG. The activated backup creation device 15 activates the backup creation status notification device 16 (step 201). The backup creation status notification device 16 notifies the database reference / update processing device 14 of the acquisition start notification S1 of the additional update information (step 301).

The database reference / update processor 14 is
When the acquisition start notification S1 of the additional update information is received, the data of the database device 11 is acquired according to the data processing instruction from the database application processing program 13 until the acquisition completion notification S2 of the additional update information is received later from the backup creation status notification device 16. When additionally updating, the update contents are output to the database device 11, and
The operation of notifying the backup creation status notification device 16 of the updated content of the database device 11 as the additional update information S3 is started. As a result, the backup creation status notification device 16 becomes able to acquire the update information added to the database device 11 after the acquisition start of the additional update information S3 is notified. The above operation is the preparation stage in the backup creation process.

Next, the backup creation device 15 creates the backup data of the database device 11 on the backup device 12 by reading the data of the database device 11 and writing the read data to the backup device 12. (Step 20
2).

Since the data reading and writing operations are sequentially performed on the data in the database device 11, it takes a certain time from the start and end of the data reading and writing. Therefore, among the data created in the backup device 12, there is a time lag between the first written data and the last written data.

When the database application processing program 13 is executed during the backup processing, the database reference / update processing device 14 updates any data in the database device 11 according to a data processing instruction from the database application processing program 13. To do.

At this time, if the data updated by the database reference / update processing device 14 according to the instruction of the database application processing program 13 is a part of the data that has not been backed up to the backup device 12 at that time. Since the updated data is written in the backup device 12 by the subsequent backup data creation process, the data created in the backup device 12 has the same contents as the data in the database device 11.

However, the database reference / update processor 1 is instructed by the database application processing program 13.
If the data updated by 4 is a portion of the data that has been backed up to the backup device 12 at that time, the contents of the data created in the backup device 12 and the data in the database device 11 are different. Become.

In this embodiment, the backup creating device 15
However, when performing the backup data creation process, the progress status S indicating how far the backup data creation process has progressed
4 is notified to the backup creation status notification device 16 and a backup data creation process is performed (step 203). For example, when the backup process is performed in the order of records, the record number is used as the progress status S4.

At this time, when the database application processing program 13 is executed, when the data processing instruction is transmitted from the database application processing program 13 to the database reference / update processing device 14, the database reference / update processing device 14 is operated by the database reference / update processing device 14. The data processing of the device 11 is performed, and the update content for the database device 11 is notified to the backup creation status notification device 16 as additional update information S3. As the additional update information S3,
For example, the record number and its update content are notified.

The backup creation status notification device 16 adds additional update information S3 from the database reference / update processing device 14 every time the database device 11 is updated.
And the progress status S4 of the backup creation processing from the backup creation processing device 15. When notified of the additional update information (step 302), the backup creation status notification device 16 compares the progress status S4 of the backup data creation processing with the additional update information S3 (step 3).
03), it is determined whether or not the database device 11 has been updated for the portion for which backup data has been created at that time (step 304).

When the portion for which the backup data has been created is updated, the additional update reflecting device 17 is activated to perform the additional update to the backup device 12 (step 305), and the data and the database of the backup device 12 are updated. The data of the device 11 is always the same.

When the backup data creation process from the database device 11 to the backup device 12 is completed (step 204), the backup creation device 15 notifies the backup creation status notification device 16 of the completion of the backup creation process. Notify (step 2)
05).

When the backup creation status notification device 16 receives a notification from the backup creation device 15 that the backup creation process has been completed (step 306), the backup creation status notification device 16 issues a notification of the completion of acquisition of additional update information to the database reference / update processing device 14. (Step 307). The database reference / update processor 14 stops the notification operation of the additional update information after receiving the acquisition end notification of the additional update information. next,
The backup creation status notification device 16 stops its activity. When the backup creation status notification device 16 stops,
The backup creation device 15 itself also stops. This completes a series of backup processing operations.

Although the present invention has been described above with reference to the preferred embodiments, the present invention is not necessarily limited to the above embodiments.

[0034]

As described above, according to the database backup creation system of the present invention, the additional update information reflected in the backup means is limited to only the update information generated during the backup processing, and it is possible to perform the same operation as before. Since the sorting process for all the records of the update information logging file is unnecessary, the processing time required for backup creation can be greatly reduced. Therefore, when it is applied to a large-scale or frequently updated database, the problem that the backup processing time is significantly delayed can be solved.

Further, since the backup data is acquired from the database at the time of creating the backup, it is possible to perform the backup process without stopping the operation even when the storage state of the database is changed.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a database backup creation system device according to an embodiment of the present invention.

FIG. 2 is a flowchart illustrating processing of the backup creating apparatus according to the above embodiment.

FIG. 3 is a flowchart illustrating processing of the backup creation status notification device according to the above embodiment.

[Explanation of symbols]

 11 database device 12 backup device 13 database application processing program 14 database reference / update processing device 15 backup creation device 16 backup creation status notification device 17 additional update reflection device S1 additional update information acquisition start notification S3 additional update information S4 backup creation progress status notification

Claims (5)

[Claims] 1. A backup creating means for performing a backup process of a database, generating a progress notification of the backup process, and a reference / update process for the database according to an instruction from a database application process program, and for the database. Database reference / update processing means for outputting additional update information indicating the addition or update content of the data when the data is added or updated, and the progress notification and the database input from the backup creating means. Backup creation status notifying means for judging whether or not additional updates have been made to the backup processed data based on the additional update information input from the reference / update processing means; For the data Backup update system for a database, comprising: an additional update reflection means for performing additional update processing of data on backup data based on the additional update information when it is determined that additional update has been performed. 2. The backup creation status notifying means,
At the start of backup processing by the backup creating means, with respect to the database reference / update processing means,
An acquisition start notification is issued to instruct the output of the additional update information, and at the end of the backup process by the backup creating means, an acquisition end notification is issued to the database reference / update processing means to instruct the output end of the additional update information. The backup creation system for a database according to claim 1, wherein the backup creation system is performed. 3. The backup creation means notifies the backup creation status notification means of the progress status every time the database reference / update processing means notifies the backup creation status notification means of the additional update information. The backup creation system for a database according to claim 1, wherein the backup is created. 4. The database reference / update processing means outputs the additional update information to the backup creation status notifying means and the database when the acquisition start notification is notified when performing the additional update of the database. However, when the acquisition start notification is not notified,
3. The database backup creation system according to claim 2, wherein the additional update information is output only to the database. 5. The backup creation status notifying means,
By comparing the progress notification and the additional update information, it is determined whether the additional data has been updated for backup processing, and it is determined that the additional data has been updated for backup processing. The backup creation system for a database according to claim 1, wherein the additional update reflection means is activated and the additional update information is notified in the case of doing so.