JPH06214856A - Data backup system - Google Patents

Abstract

PURPOSE:To reduce a data amount and to shorten the processing time of data backup by constituting a data base table by dividing it into an update system table composed of items with high update frequency and a reference system table composed of items with low update frequency. CONSTITUTION:A LAN system is constituted by connecting a backup computer provided with a data base table 101 the same as the data base of a file server computer to this computer. A reference system table 102 is composed of a key item T1 of the data base table 101 and items T2, T4 and T5 with lower update frequency. An update system table 103 is composed of the key item T1 of the data base table 101 and items T3 and T6 with higher update frequency. When there are transfer data, the backup date base is updated by executing matching processing between the T1 of the key item 103 of the update table and the T1 of the key item 101 of the data base table of the backup computer.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data backup system and its system in a database management system using a LAN.

[0002]

2. Description of the Related Art Generally, a data backup function of a database management system using a LAN transfers a whole database or a file recording an operating condition to a backup computer or an external recording device, so that the amount of data is enormous and the processing time is long. It was hanging.

[0003]

In the prior art as described above, the entire database or operation information is backed up, and since the amount of data in each case is enormous, it takes time to process it.

For example, a database system "infomix-informix-on" manufactured by ASCII Co., Ltd.
line ADMINISTRATORS S MANU
In the operation of the recovery system described in "AL96 pages to 101 pages", the unit of backup is the entire database or page, and the backup method of the logical log is reported. However, the backup method for each database table is not mentioned.

An object of the present invention is to provide a data backup system capable of shortening the processing time by transferring only the accessed item of the accessed table to the backup computer at the end of the processing of the application program.

[0006]

In order to achieve the above object, the present invention divides a database table into an update system table composed of items having a high update frequency and a reference system table composed of items having a low update frequency. Data backup reduces the amount of data by using only update type tables,
Reduce data backup processing time.

[0007]

According to the present invention, since the data table to be backed up is defined in advance, the data backup process can be performed in a shorter time than the conventional case in cooperation with the application program.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. FIG. 1 shows a configuration example of an apparatus for carrying out the present invention. In the figure, 001 is a file server computer, and 002 is an application program executed on the file server computer. 003
Is a program that monitors which table in the database is accessed by the application program.
A database management system 4 operates on the file server computer. Reference numeral 005 is a disk device in which a database is stored, and 006 is a communication management program for controlling communication with other computers. 007 is a backup computer connected to the LAN,
008 is a program for updating the database based on the data transferred from the file server computer. Reference numeral 009 is a database management system that manages a backup database, and reference numeral 010 is a communication management program that controls communication with other computers. 01
Reference numeral 1 is a disk device that stores a backup database. A LAN cable 012 connects the file server computer and the backup computer.

FIG. 2 shows the table structure of an embodiment of the present invention. Reference numeral 101 denotes a database table, and the backup computer 007 has the same one. Reference numeral 102 is a reference system table composed of key items (T1) and items with low update frequency (T2, T4, T5) among the items constituting the database table 101, and 103 constitutes the database table 101. Among the items to be set, it is an update system table including a key item (T1) and items with high update frequency (T3, T6).

Next, a processing flow in one embodiment of the data backup system to which the present invention is applied will be described with reference to FIGS. In process 31, the program 001 that monitors the database access of the application program 002 executes (31). The application program 002 is executed (32), and the update program 001 determines whether there is an updated table (3
3). When the table has been updated, the table name is recorded (34) and repeated until the end of the application program 002 (35). If there is a table updated at the end of the application program 002 (3
6) The table data is transferred to the backup computer (37), and if not present, the process ends (38).

FIG. 4 shows a processing flow of the backup computer. It is assumed that the backup computer is also started when the file server computer is started. The communication management program 010 monitors whether data has been transferred from the file server computer (41), and if there is transfer data, the key item of the transfer table (T of 103).
1) and the key item (T1 of 101) of the database table on the backup computer are matched to update the backup database (42). Then, while the file server computer is operating, it is repeated (43).

[0012]

According to the present invention, the data backup process is started at the end of the application program,
The backup of the application program executed up to immediately before the occurrence of the failure can be acquired, and the amount of transferred data is small, so that the processing can be performed in a short time.

[Brief description of drawings]

FIG. 1 is a block diagram of a device constituting an embodiment of the present invention.

FIG. 2 is a configuration diagram of a database table according to an embodiment of the present invention.

FIG. 3 is a data backup processing flowchart of the file server computer according to the first embodiment.

FIG. 4 is a data backup processing flowchart of the backup computer according to the first embodiment.

[Explanation of symbols]

 001 ... File server computer, 002 ... Backup computer, 101 ... Database table, 102 ... Reference system database table, 103 ... Update system database table.

Claims (1)

[Claims] 1. In a LAN system to which a file server computer and a backup computer having the same database table as the database of the file server computer are connected, a reference system table and an update system table are divided according to the update frequency of each item of the database table. , A data backup method characterized by transferring update table data to a backup computer and updating the database.