JPH0512089A - Backup automatic control system of distributed data base file - Google Patents

Abstract

PURPOSE:To shorten and automate the working hour related to the backup work of a distributed data base file in order to automate the backup of the distributed data base file. CONSTITUTION:A used file extracting means 300 of a backup program 9 extracts a physical file 1 used by a data accumulating program 8 from a data base control file 2. A scheduled media extracting means 301 extracts a magnetic tape media 4 scheduled by a backup media scheduled by a backup media schedule program 7 from a backup media control file 5. A backup means 302 dynamically corresponds to the physical file 1 extracted by the used file extracting means 300 and the magnetic tape media 4 extracted to the scheduled media extracting means 301 and the physical file 1 gains the backup by the magnetic tape media 4.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a backup automatic control system for distributed database files, and more particularly to a backup automatic control system for dynamically associating a physical file with a magnetic tape medium for backup.

[0002]

2. Description of the Related Art Conventionally, in this type of automatic backup control system for distributed database files, a physical file and a magnetic tape for backup have a fixed one-to-one correspondence to determine a magnetic tape for backup. , Manually backed up used physical files.

[0003]

In the conventional backup automatic control system for distributed database files, the physical files and the magnetic tape devices are made to correspond one to one,
When securing a physical file that the application program for data storage dynamically stores during operation,
To back up the secured physical file, the application program for data storage determines the physical file during operation. Therefore, the application program for data storage may determine the magnetic tape medium for backup before operation. However, there is a problem in that it is impossible to prepare a magnetic tape medium for backup in advance.

In addition, since a physical file is randomly secured by an application for data storage, a magnetic tape medium corresponding to the physical file must be randomly extracted. There was a problem that the preparatory work by was difficult.

Further, in the case of automating these operations, there is no choice but to unconditionally back up the physical file, and when the distributed database file has a large capacity, the backup operation requires a long time. there were.

An object of the present invention is to dynamically backup a physical file used by a data storage application program and a magnetic tape medium prepared for backup in advance in order to automate backup of a distributed database file. It is an object of the present invention to provide a distributed database file backup automatic control system that can reduce the work time and perform automation related to the backup work of the distributed database file by supporting the backup.

[0007]

In order to achieve the above object, the present invention comprises a distributed database file, a backup medium and a distributed database backup system, and the distributed database file comprises a physical file and a database management file. The backup medium comprises a magnetic tape medium and a backup medium management file, the distributed database backup system comprises a backup medium schedule program, a data storage program, a backup program and a medium management table output program, and a backup medium schedule. The program is composed of a medium schedule means, the data storage program is composed of an unused file securing means and a data storage means, and the backup program is composed of a used file extracting means and a space. Constituted by Joule already medium extracting means and the backup means, which is constituted of the medium management table output program medium correspondence table output means.

[0008]

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

FIG. 1 is a block diagram showing an automatic backup control system for distributed database files according to an embodiment of the present invention. This backup automatic control system is composed of a distributed database file 3, a backup medium 6, and a distributed database backup system 11.

The distributed database file 3 is composed of a plurality of physical files 1 and a database management file 2 for managing the status of each physical file 1.

The backup medium 6 is composed of a plurality of magnetic tape media 4 and a backup medium management file 5 for managing the state of the magnetic tape media 4.

Distributed database backup system 1
1 is the magnetic tape medium 4 used for backup
Backup media schedule program 7 that schedules the data in advance and outputs the media preparation table 12, and a data storage program 8 that reserves the unused physical file 1 from the distributed database file 3 and stores the data
And the magnetic tape medium 4 scheduled by the backup medium schedule program 7 and the physical file 1 secured by the data storage program 8.
And a media management table 13 that outputs a media correspondence table 13 that indicates the correspondence between the physical file 1 and the magnetic tape medium 4 that are dynamically associated by the backup program 9. And a table output program 10.

FIG. 2 is a block diagram showing in detail the configuration of the distributed database backup system shown in FIG.

The backup medium schedule program 7 is composed of a medium scheduling means 100, the data storage program 8 is composed of an unused file securing means 200 and a data storage means 201, and the backup program 9 is used. The medium management table output program 10 includes a completed file extraction unit 300, a scheduled medium extraction unit 301, and a backup unit 302. The medium management table output program 10 includes a medium correspondence table output unit 400.

Next, the operation of the distributed database file backup automatic control system according to an embodiment of the present invention will be described with reference to FIGS.

The medium scheduling means 100 of the backup medium schedule program 7 extracts from the backup medium management file 5 the number of magnetic tape mediums 4 whose medium state is unused and is scheduled to be used, and shifts the medium state to scheduled. Then, the schedule numbers are sequentially assigned, and the medium preparation table 12 is output as a list of the scheduled magnetic tape media 4.

The unused file reserving means 200 of the data storage program 8 extracts from the database management file 2 the required number of physical files 1 whose file state is unused, and transitions the file state to the reserved state. Further, the data storage unit 201 stores the data to be stored in the business in the physical file 1 which has been transferred to the secured state by the unused file securing unit 200.

The used file extracting means 300 of the backup program 9 extracts the physical file 1 used by the data storage program 8 from the database management file 2. Scheduled medium extraction means 301
Extracts the magnetic tape medium 4 scheduled by the backup medium schedule program 7 from the backup medium management file 5. Backup means 3
02 is the physical file 1 extracted by the used file extracting means 300 and the scheduled medium extracting means 301.
The magnetic tape medium 4 thus extracted is dynamically associated with the physical file 1 to obtain a backup by the magnetic tape medium 4. Further, the file state of the corresponding physical file 1 of the database management file 2 is changed to the backed up state, and the medium state of the corresponding magnetic tape medium 4 of the backup medium management file 5 is changed to the in-use state, and at the same time, Record the physical file name of the backup.

The medium correspondence table output means 400 of the medium management output program 10 extracts the magnetic tape medium 4 whose medium state is in use from the backup medium management file 5.
A list of the extracted magnetic tape media 4 and the names of the physical files whose backups have been acquired is created, and a media correspondence table is output.

[0020]

As described above, according to the present invention, in a backup automatic control method for a distributed database file composed of a plurality of physical files, a medium scheduling means, an unused file securing means, a data accumulating means, a used file are used. Extraction means, scheduled medium extraction means,
Since the backup means and the medium correspondence table output means are provided, the sequentiality of the magnetic tape medium to be backed up can be maintained even if the physical file is secured at the time of data storage, and the backup medium will be used. Since you can schedule in advance, you can prepare the magnetic tape media to be used based on the media preparation table even before the data storage business execution, and prepare the prepared magnetic tape media in advance. By mounting it on the device, the effect that the backup can be automated can be obtained.

[Brief description of drawings]

FIG. 1 is a block diagram showing an automatic backup control system for distributed database files according to an embodiment of the present invention.

FIG. 2 is a block diagram showing in detail the configuration of the distributed database backup system in FIG.

[Explanation of symbols]

1 Physical file 2 Database management file 3 distributed database files 4 Magnetic tape media 5 Backup medium management file 6 backup media 7 Backup medium schedule program 8 Data storage program 9 Backup program 10 Media management table output program 11 Distributed database backup system 12 Media preparation table 13 Media correspondence table 100 medium scheduling means 200 Unused file securing means 201 Data storage means 300 Used File Extraction Means 301 Scheduled medium extraction means 302 Backup means 400 Media correspondence table output means

Claims (3)

[Claims] 1. An automatic backup control system for a distributed database file, which comprises a distributed database file, a backup medium, and a distributed database backup system. 2. A distributed database file comprises a physical file and a database management file, a backup medium comprises a magnetic tape medium and a backup medium management file, and a distributed database backup system comprises a backup medium schedule program and a data storage program. 2. The automatic backup control system for distributed database files according to claim 1, which comprises a backup program and a medium management table output program. 3. The backup medium schedule program comprises medium scheduling means, the data storage program comprises unused file securing means and data storage means, and the backup program comprises used file extracting means and scheduled medium extracting means. 3. The automatic backup control system for a distributed database file according to claim 2, further comprising a backup means, and the medium management table output program is constituted by a medium correspondence table output means.