JP2001142762A - Device for linking data for duplex data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data linking device for a duplex data base, by which data are linked between the data bases of different computer systems. SOLUTION: The device is provided with a stand-by system DB control information obtaining means (main controller A5) for obtaining data base(DB) control information of a stand-by system when an abnormality occurs in a working system, a DB control information converting means (data code converting device A, etc.), for converting DB control information of the working system into the one in the DB control information form of the stand-by system based on stand-by system DB control information which is obtained by the obtaining means, processing succeeding means (state monitor processors A4 and B4) for succeeding a processing being executed by the working system based on working system DB control information which is converted into the one in the stand-by system DB control information form by the converting means and processors (A4 and B4) for monitoring a processing re-succeeding means state where the processing succeeded by the processing succeeding means is re-succeeded by the working system after the recovery of the working system from the abnormality.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data linking device for a duplicated database, and more particularly, to a data transfer device for data linking in the event of an abnormality when an active system and a standby system are duplexed by different computer systems. The present invention relates to a data linking device for a duplicated database that does not need to be developed each time it is constructed and does not require an operator to be present when a failure occurs during data migration.

[0002]

2. Description of the Related Art In a computer system, a redundant standby system (spare system) is prepared in duplicate with respect to a currently operating system (active system), and when an abnormality occurs in the active system, a standby system (standby system) is prepared. In some cases, normal operation is ensured as a whole computer system by immediately switching to the standby system. For this duplication, for example, a computer system of company A (operating system) and a computer system of company B (standby system) having different control information for a database or the like may be constructed via a network.

[0003]

However, the conventional computer system has the following problems. A first problem is that, when an active system and a standby system are constructed by different computer systems, a data migration device (configured by a program) for performing data cooperation is developed each time. The reason is that control information such as a code system and data definition information is different for each computer system (for example, company A and company B).

[0004] The second problem is that since a human system switches to a standby system in the event of a failure, an operator must be present until all the data transfer processing is completed. The reason is that data transfer is not duplicated by automatic switching.

[0005] Therefore, an object of the present invention is to provide a data transfer device for data coordination which does not need to be developed every time the above-described construction is performed when an active system and a standby system are constructed by different computer systems. An object of the present invention is to provide a data linking device for a duplicated database that does not require an operator to be present.

[0006]

According to the present invention, a computer system having a database controlled by different database control information is divided into an operating system and a standby system to be duplicated. A standby database control information acquiring means for acquiring standby database control information when an abnormality occurs in the active system, in a redundant database data linking apparatus for performing data linkage between the active system and the standby system; A database control information format conversion unit for converting the active system database control information into a standby system database control information format based on the standby system database control information acquired by the database control information acquisition unit; Active database control converted to the active database control information format Based on the report, a process inheritance means for inheriting the process being executed by the active system, and a process reinheritance means for inheriting the process inherited by the active system after the active system recovers from an error. It is characterized by.

Further, when an abnormality occurs in the active system, the standby system database control information acquiring means acquires the standby system database control information in accordance with an instruction from the input device.

In this way, when an abnormality occurs, for example, an operator instructs from an input device to obtain standby database control information acquisition means, database control information format conversion means, processing inheritance means, processing reinheritance means. And the data link between the active system and the standby system can be smoothly performed. Therefore, when the active system and the standby system are configured by different computer systems, it is not necessary to develop a data migration device for data cooperation every time the configuration is performed, and there is no need for an operator to be present when a failure occurs during data migration.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below with reference to the illustrated embodiment. [I] Outline of the Present Invention First, the outline of the present invention will be described with reference to the flowchart of FIG. 2 and FIG. 1 of the embodiment. The present invention provides a data linking device for a duplicated database in a computer system capable of automatically recognizing database formats and attributes between databases of different formats on different networks and automatically transferring data after code system conversion and record item editing. Is what you do.

In FIG. 1 and FIG. 2, an instruction from a display / keyboard A1 is transmitted via an input / output device A2 to a main controller A5 which is a "standby database control information acquisition means".
(Step S1), the main controller A5 recognizes the code system, the data definition, and the related definition of the source database 1 via the network 2 and the destination database 3 via the network 4, and stores them in the environment file A6 ( Step S2). Based on the data conversion transfer timer of the environment file A6, under the control of the main controller A5, the data transmitter / receiver A10 starts up and reads the source database 1, and firstly the data code converter which is a "database control information format converter". Input to A9. The data code converter A9 converts the code system of the transmission source database 1 into the code system of the reception destination database 3 (Step S3).

Next, the database after the data code conversion is input to the data format converter A8, which is "database control information format converter". The data format conversion device A8 converts the data definition of the source database 1 into the data definition of the destination database 3 (step S4). Next, the data is input to the database input / output device A7, and data conforming to the code system and data definition of the destination database 3 is stored. Data transmission / reception device A10
Writes the stored data into the destination database 3 based on the instruction from the main control unit A5 (step S5).

In FIG. 1, the status monitoring processor A4, which is a "process inheritance means, process reinheritance means", sends an acknowledgment packet to the status monitoring processor B4 of the standby system B based on the device monitoring information of the main controller A5. (See the symbol U in FIG. 3) via the networks 1 and 5 (step S6).
The status monitoring processor B4, which is a “processing inheritance unit, a process reinheriting unit”, receives a confirmation packet from the status monitoring processor A4 of the active system A and detects an abnormality (step S
7), the virtual address of the active system A is converted to the address translation device A1.
1 (Step S8), and the address translator B11 of the standby system B inherits the virtual address (Step S9).

At the same time, the standby system B starts and executes its own device, and inherits the processing of the active system A (step S1).
0). If the operating system A has recovered normally (step S1
1) Activate the suspended virtual address,
Is temporarily stopped, and the processing of the standby system B is inherited by the active system A (step S12).

In this manner, data conversion and transfer of a database existing between arbitrary networks can be performed without incurring the development of individual data migration devices and manual switching at the time of failure.

[II] Description of Embodiment (1) Configuration of First Embodiment Referring to FIG. 1, the present embodiment is roughly provided with an active system A and a standby system B. The operating system A includes a display / keyboard (DSP / KB) A1, a printer (PRT) A3
, A transmission source database 1 and a network 2.

The standby system B is a display / keyboard B
1, an input / output device B2 including a printer B3, a destination database 3, and a network 4. 5 is working system A
And a network connecting the standby system B to the network.

The outlines of these devices are as follows. The operating system A includes a state monitoring processor A4, a main controller A5, an environment file A6, and a database input / output device A.
7, a data format conversion device A8, a data transmission / reception device A10, and an address conversion device A11.

The status monitoring processing device A4 edits each device status information and instruction information from the main control device A5, transmits the information to the standby main device B, receives the information from the standby main device B, and receives the information from the main control device A5. Send to A5.

The main controller A5 judges the status of each device in its own system (in the operating system A), transmits the status to the status monitoring processor A4, and instructs the start and end of each device based on the environment file information. And the functions of reading the database 1 based on instructions from the input / output device A2 to create the environment file 6, and maintaining the environment file 6.

The environment file A6 holds a code system, database definition information, data conversion definition information, start / end information of each device, virtual address / logical address conversion information, threshold information, and the like. The database input / output device A7 performs reading and writing with the same data attribute as the receiving source database 3. The data format conversion device A8 converts the data definition format of the source database 1 into the data definition format of the destination database 3.

The data code converter A9 converts the code system used in the source database 1 into the code system used in the destination database 3. The data transmission / reception device A10 performs data transmission / reception with the transmission source database 1 and the reception destination database 3.

The address translator A11 converts a virtual address to a logical address and activates / stops the virtual address. An input / output device A2 including a display / keyboard A1 and a printer A3 performs status monitoring information output, database definition input, and environment file maintenance.

The operating system B also has the same configuration as the operating system A.

(2) Operation of First Embodiment Next, the overall operation of the present embodiment will be described in detail with reference to FIGS. FIG. 3 is a conceptual diagram for transmitting / receiving normal / abnormal information between the active system and the standby system as a confirmation packet, FIG. 4 is a block diagram showing a configuration of a main control device, and FIG.
FIG. 3 is a diagram illustrating devices that are activated by each converter activation device.

First, when an automatic reading of the database 1 and the database 3 is instructed from the input / output device A2 (FIG. 1), the instruction information is transmitted to the database via each device monitoring device A51 (FIG. 4) in the main controller A5. Activate the automatic reading device A59 and read the definition information of the database 1 and the database 3;
5A creates a processing procedure based on the code system and database definition information before and after the conversion. The processing procedure and the information before and after the conversion are written in the environment file A6. In addition, by activating the environmental data maintenance device A5B (FIG. 4) from the input / output device A2, the result of automatic database reading can be easily maintained.

Each of the device monitoring devices A51 (FIG. 4) checks the data conversion transfer timer held in the environment file A6, and the code conversion,
The processing procedure such as the conversion of the database definition is read, and each conversion device starting device A57 is started. Based on the activation of each converter activation device A57, the devices newly activated include the address translation device A11, the data transmission / reception device A10, the data code conversion device A9, the data format conversion device A8, and the database shown in FIG. An input / output device A7 and a status information management device A50.

The information held in the environment file A6 is provided to the devices shown in FIG. 5 after the device is started. First, the data transmitting / receiving device A10 (FIG. 1) sequentially receives the data of the database 1 and accumulates the data in the temporary storage file A1, and provides completion information to the status information management device A50 (FIG. 5) when the reception is completed. Status information management device A
Reference numeral 50 indicates completion information to the main controller A5, and the main controller A5
5 changes the next data code converter A9 from waiting to execution to execution, and the data code converter A9 sequentially converts the data in the temporary storage file A1 and writes it to the temporary storage file A91 (FIG. 5). When the code conversion is completed, the completion information is provided to the status information management device A50.

Next, the data format conversion device A8
The code conversion data in the temporary storage file A91 is sequentially attribute-converted and layout-converted, and the temporary storage file A81 is converted.
(FIG. 5). Further, a database input / output device A7
Reads the temporary storage file A81 and writes it in the conversion database A71 (FIG. 5), and provides completion information to the status information management 50 when the processing is completed.

Next, under the instruction of main controller A5 (FIG. 5),
The data transmitting / receiving device A10 transmits the conversion database A71 to the database 3 via the network 4 (FIG. 1), and when the transmission is completed, the status information management device A5.
0 (FIG. 5). If the transmission is abnormal, resend. Each conversion device termination device A58 (FIG. 4) follows the instructions of the input / output device A2, the status monitoring processing device A4, and each device monitoring device A51 based on the environment file information.

The main control unit A5 (FIG. 4) includes a monitoring unit A51, a database automatic reading unit A59, an environment data configuration unit A5A, an environment data maintenance unit A5B, an environment data reading unit A56, and a conversion unit starting unit A57. In addition, it comprises a basic unit status monitoring device A52, a basic unit normal operation determining device A53, a converter status monitoring device A54, and a converter normal operation determining device A55.

Each basic unit status monitoring device A52 monitors the operating system, and each basic unit normal operation determination device A
53 detects an abnormality by comparing with a threshold value set in the environment file A6. Each converter status monitor A
54 monitors each device, database, file, etc., and each conversion device normal operation determination device A55 includes an environment file A6.
Abnormality is detected by comparing with the threshold value set in.

The state monitoring processor A4 (FIG. 3) includes a confirmation packet editing device A41, a confirmation packet transmitting / receiving device A42,
It is composed of a standby system normal operation determination device A43. The confirmation packet editing device A41 converts the normal / abnormal information transmitted from each device monitoring device A51 (FIG. 4) in the main control device A5 into I
Edit into frames based on EEE rules. The confirmation packet transmitting / receiving device A42 (FIG. 3) transmits the normal / abnormal information edited in the frame to the standby system B (FIG. 1).

Standby system normal operation judging device A43 (FIG. 3)
Is normal / normal transmitted from the standby system B via the network 1 (FIG. 1) and the confirmation packet transmitting / receiving device A42 (FIG. 3).
The main controller A compares the frame such as the abnormality information with the threshold value set in the environment file A6 to detect the abnormality.
5 is transmitted. When the partner system is abnormal, the status monitoring processor A4 can start its own system and take over the processing.

(3) Second Embodiment Next, a second embodiment of the present invention will be described with reference to the drawings. In FIG. 1, when the database 1 and the database 3 hold the same code system, the data code converter A9 does not start. When the database 1 and the database 3 have the same data definition information, the data format conversion device A8 does not start. When there is no network 4 or 5, all information between the active system and the standby system is performed via the network 2.

In the above-described embodiment, a case has been described in which a human gives a data link instruction via an input / output device when an abnormality occurs. However, it is a matter of course that the abnormality may be automatically detected.

[0036]

As described above, according to the present invention, the following effects can be obtained. The first effect is that when a redundant computer system having a database controlled by different database control information is constructed, it is not necessary to develop a data transfer device for each system. The reason is that the code system of the source and destination databases, the data definition information, and the like are automatically collected and the conversion procedure is automatically generated.

A second effect is that the attending time of the operator can be reduced by automatically switching the active system to the standby system when a failure occurs. The reason is that normal / abnormal judgment can be made mutually by transmitting and receiving confirmation packets between the active system and the standby system periodically.

A third effect is that the work of the operator can be reduced. The reason is that startup is performed based on the scheduling registered in the environment file.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram of an embodiment of the present invention.

FIG. 2 is a flowchart showing an operation concept of the present invention.

FIG. 3 is a conceptual diagram showing transmission and reception of a confirmation packet between an active system and a standby system in the embodiment.

FIG. 4 is a block diagram showing a configuration of a main control device in the embodiment.

FIG. 5 is a diagram showing devices to be started by each conversion device starting device in the embodiment.

[Explanation of symbols]

 A active system B standby system 1,3 database 2,4,5 network A1, B1 display / keyboard A2, B2 input / output device A3, B3 printer A4, B4 status monitoring processing device A5, B5 main control device A6, B6 environment file A7, B7 Database input / output device A8, B8 Data format converter A9, B9 Data code converter A10, B10 Data transmitter / receiver A11, B11 Address converter

Claims (5)

[Claims] 1. A computer system having a database controlled by different database control information is divided into an active system and a standby system to be duplicated, and when an abnormality occurs, data is linked between the active system and the standby system. In the data linking device of the database, when an abnormality occurs in the active system, a standby system database control information acquiring unit that acquires the database control information of the standby system, and based on the standby system database control information acquired by the standby system database control information acquiring unit. A database control information format converting means for converting the active database control information into a standby database control information format, and a database control information format converting means for converting the active database control information into the standby database control information format based on the active database control information. , The process that the active system inherits the process being executed A data linking device for a duplicated database, comprising: a succession unit; and a process re-inheritance unit that re-inherits a process inherited by the operation system after the operation system recovers from an error. 2. The system according to claim 1, wherein said standby system database control information obtaining means includes means for obtaining standby system database control information in response to an instruction from an input device when an abnormality occurs in the active system. 2. A data linking device for the duplicated database according to 1. 3. The data linking device for a duplex database according to claim 1, wherein the database control information includes a database coding system and data definition information. 4. The data linking device for a duplicated database according to claim 1, wherein the active system and the standby system are operated by a virtual storage system. 5. The communication system according to claim 1, further comprising a confirmation packet exchange means for periodically exchanging confirmation packets for confirming whether the operation is normal or abnormal between the active system and the standby system.
5. The duplex data conversion / transfer device according to claim 4.