JP2003084995A - Online database information processing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To smoothly transfer data without limiting a system under online operation and applying an excessive load in transferring the data between systems. SOLUTION: When the time series data are transferred from a main system 1 under the online operation to a standby sub-system 2, the time series data of time series alarm database 101 are batch-copied and registered in time series database 201, and when the online operation by the sub-system 2 is started, and if there are unregistered data from a queue table 103 to the time series alarm database 101 from the start of the sub-system 2 to the start of the online operation, or if a new time series data is registered in the queue table 103 during the period, the unregistered data or the new data are reflected to the queue table 203.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information processing system, and more particularly to a free-run dual system, which includes a main system and a sub system that operate equally to each other.
Suitable for exchanging time series data between both systems 24
The present invention relates to an online database information processing system with an hourly backup function.

[0002]

2. Description of the Related Art Conventionally, an online database information processing system for an electric power system has a main system and a sub system as a free-run dual system.
When the main system is an online operating system and the secondary system is a standby system, the main system that is operating online stores time series data and temporarily stores it in the queue table. A configuration is adopted in which the series data is sequentially stored in the time series database and the data stored in the time series database of the operating main system is taken over by the subsystem when the standby subsystem is activated. The time-series data includes state change data indicating an alarm such as occurrence of a change in equipment state due to external factors and control data indicating the control contents such as switching on / off of a switch. In the conventional online database information processing system, when the time-series data is taken over from the main system to the sub system, the sub system generated a request to transition to the standby system operation mode and then started to operate in the standby system operation mode. Under the condition, the processing of transferring the time series data stored in the time series alarm database of the main system to the time series alarm database of the sub system is performed. In this case, from the time when the sub system issues a transition request to the standby system operation mode until the operation of the standby system operation mode starts, the main system changes from the time series database registration queue table to the time series alarm database. If there is an unregistered record (time-series data) or a new time-series data registration request occurs and new time-series data is registered in the queue table of the main system, the data will be lost. Alternatively, the method of writing from the main system to both the main / sub system is adopted. If the data is lost, it is necessary to restart the sub-system and reconciliation. Further, when writing from the main system to both the main / sub system, an extra load is applied to the main system, which is an online system. Therefore, the missing data makes it difficult to analyze the situation using the control message and the state change at the time of trouble occurrence.

Note that, as a system related to this type of system, for example, Japanese Patent Laid-Open No. 7-306795 (hereinafter referred to as prior art A) and Japanese Patent Laid-Open No. 11-26532.
Japanese Patent Laid-Open No. 2 (hereinafter referred to as Prior Art B), Japanese Patent Laid-Open No. 5-
89072 (hereinafter, referred to as a prior art C) and JP-A-8-202571 (hereinafter, referred to as a prior art D) are listed.

[0004]

Among the conventional techniques, the conventional technique A employs a data format composed of a general-purpose common language, and requires differential comparison analysis processing of the general-purpose common language and requires a machine for comparison processing. Either a new unit is required, or a load of comparison processing is newly generated on the main system, which imposes an extra burden on the language analysis.

In the prior art B, it is necessary to prepare a separate machine for managing transactions, monitor online access to related records during matching processing of subsystems, and access at the time of requesting access to the corresponding record. It is necessary to set restrictions.

In the prior art C, in order to reflect the data newly generated during the matching processing of the sub system in the sub system, it is unavoidable to create the difference file for the data generated in the main system. , Will put an extra burden on the main system.

On the other hand, in the prior art D, when matching the data between the active system and the standby system, the active system checks whether the matching is completed, and copies the management table for matching and The process of extracting the matching data and reflecting the data in the standby system is performed, which imposes an extra burden on the executing system for matching.

[0008] An object of the present invention is, when data is handed over between systems, that data can be taken over smoothly without imposing a restriction or extra load on the system which is operating online. To provide an online database information processing system.

[0009]

In order to solve the above problems, the present invention includes a main system and a sub system as a free-run dual system, and one of the main system and the sub system is an online operating system. When the system is set as the system and the other system is set as the standby system, the system that is operating online captures the time-series data and temporarily stores it in the queue table.
The time-series data stored in the queue table is sequentially stored in the time-series database, and when the standby system starts up, the data stored in the time-series database of the operating system is collectively copied to obtain the time-series of the own system. Store it in the database, then start online operation,
When there is unregistered data from the queue table of the operating system to the time-series database between the time when the standby system starts and the time when it starts online operation, or in the queue table of the operating system. When new data is registered, the online database information processing system is configured so that the unregistered data or the new data is reflected in the queue table of the system in which the online operation is started.

In constructing the online database information processing system, the system operating online is the primary system, the standby system is the secondary system, and the data of the primary system can be reflected in the secondary system.

In configuring each of the online data information processing systems, when the unregistered data or new data is reflected in the queue table of another system, the unregistered data or new data is queued in another system. Can be stored in a table.

According to the above-mentioned means, when the data is taken over from the online operating system to the standby system, the data stored in the time series database of the operating system is collectively copied to the standby system. Stored in the series database, and when the standby system starts online operation, the queue table from the active system to the time series database between the time the standby system starts and the time online starts When there is unregistered data in the system or when new data is registered in the queue table of the system that is running, the unregistered data or new data is reflected in the queue table of the system that started online operation. , When transferring data, put restrictions on the system that is operating online Without having to or multiplied by the extra load, it is possible to take over smoothly the data to the standby system from the system in the online operation.

[0013]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram of an online database information processing system showing an embodiment of the present invention. In FIG. 1, the online database information processing system is configured as an online database information processing system for a power system with a 24-hour operation backup function, and this system includes a main system 1 and a sub system 2 that operate as a free-run dual system. It is equipped with. The main system 1 and the sub system 2 are configured to operate in the same manner as each other. In the present embodiment, the main system 1 of the main system 1 and the sub system 2 is an online operating system, and the sub system 2 Is used as a standby system. The main system 1 is a time series alarm database 10
1, a queue table registration processing unit 102, a queue table 103, a time series database registration processing unit 104, a time series alarm database reference processing unit 105, a communication control processing unit 112, and the like.
Is a time series alarm database 201, a queue table registration processing unit 202, a queue table 203, a time series database registration processing unit 204, an operation mode control unit 21.
0, a queue table data takeover processing unit 211, a communication control processing unit 212, a time-series alarm database batch takeover processing unit 213, and the like. Although the main system 1 and the sub system 2 have the same functions (elements), in the present embodiment, the main system 1 is used as an online operating system and the main system 1 is used as a standby system. Therefore, the main system 1 particularly shows the elements when operating as an active system, and the sub system 2 shows the elements when operating as a standby system.

The queue table registration processor 102 of the main system 1 and the queue table registration processor 20 of the subsystem 2
When the time-series alarm data registration request 121 is issued, the data No. 2 captures the time-series data and temporarily stores them in the queue tables 103 and 203, respectively. Each of the queue tables 103 and 203 has a cyclic structure.
The time series data stored in 03 is sequentially stored in the time series data alarm databases 101 and 201 by the processing of the time series database registration processing units 104 and 204.
In this case, the time-series alarm databases 101, 201
When there is unregistered data in the, the first record (first pointer) and the last record (final pointer) of the unregistered data are recorded. Since the first record is recorded as the read pointer and the last record is recorded as the write pointer, all the time series data (records) in the queue tables 103 and 203 are recorded in the time series alarm database 10.
When all are registered in Nos. 1 and 201, the number of the first record and the number of the last record are the same number.

The time series data stored in the queue table 103 and the time series alarm database 101 are processed by the communication control processing unit 112, and the time series data stored in the queue table 203 and the time series alarm database 201 are processed by the communication control processing unit. Processing is performed by 212, and data is exchanged between the communication control processing unit 112 and the communication control processing unit 212.

[0016] For example, when the operation mode control unit 210 of the secondary system 2 issues a takeover request because the standby secondary system 2 is activated while the primary system 1 is operating,
The time series data stored in the time series alarm database 101 is collectively copied and stored in the time series alarm database 201. After that, when the subsystem 2 starts online operation, when there is unregistered data from the queue table 103 to the time-series alarm database 101 between the time the subsystem 2 is activated and the time when the subsystem 2 starts online operation, Or queue table 1
When new data is registered in 03, unregistered data or new data in the queue table 103 is reflected in the queue table 203. That is, the time series data from the first pointer to the last pointer of the queue table 103 is extracted as unregistered data, and the extracted time series data is registered in the queue table 203. If there is a record (time series data) with the same key at the time of this registration, this record is registered redundantly.

Further, a time series alarm data reference request 122
When occurs, the time series alarm database reference processing unit 105 extracts a record (time series data) for the request key from the time series alarm database 101. In this case, for duplicate key records,
Only the number of duplicate records is extracted.

Next, a process for starting the sub system 2 while the main system 1 is operating and handing over the time series data from the main system 1 to the sub system 2 will be described with reference to the flowchart of FIG.

First, while the main system 1 is operating online (step S10), the time-series alarm data registration request 1
21 and the time-series alarm data reference request 122 are being processed, and in this state, the subsystem 2 is stopped (standby).
The sub-system 2 issues a request for transition to the standby system operation mode that operates as a free-run dual system (step S20).

When a request for transition to the standby system operation mode is generated, the processing relating to the time-series alarm database takeover request is activated by the subsystem 2 itself or the separately prepared operation mode monitoring system (step S21), and the subsystem 2 time series is executed. The handover process from the main system 1 is started for the alarm database 201.

First, the subsystem 2 acquires the head pointer of the queue table 103 via the communication control processing unit 212 and the communication control processing unit 112 by the processing of the queue table data takeover processing unit 211 (step S2).
2). After that, by the processing of the time-series alarm database batch takeover processing unit 213, the communication control processing unit 212,
The registered time series data of the time series alarm database 101 is collectively copied via the communication control processing unit 112, and the copied time series data is set to the time series alarm database 2.
01 is registered (step S23). After that, the sub system 2 starts the online operation in the standby system operation mode (step S24).

At this point, the main system 1 and the sub system 2
Starts operation as a free-run dual system.
Therefore, from this point in time, when the time series alarm data registration request 121 is issued from each system, the time series data is stored in the queue table 103 of the main system 1 and the queue table 203 of the sub system 2, respectively.
Time series data is registered. Even if the subsystem 2 does not start the operation in the standby operation mode, the subsystem 2 requests the time series alarm data registration request 121 in the subsystem 2.
In response to, the time series database registration processing unit 204 may execute the processing to sequentially register the time series data stored in the queue table 203 in the time series alarm database 201.

Next, by the processing of the queue table data takeover processing unit 211, the final pointer of the queue table 103 is obtained via the communication control processing unit 212 and the communication control processing unit 112 (step S25).

That is, since the head pointer registered in the queue table 103 is registered as the read pointer and the last pointer is registered as the write pointer, it is determined whether the head pointer and the last pointer have the same value. For processing. If the values of the first pointer and the last pointer are not the same, the transition request to the standby system operation mode is generated between the start of the subsystem 2 and the start of the online operation. From the queue table 103 to the start of the online operation as the standby system operation mode, there is a record (time series data) that has not been registered in the time series alarm database 101 from the queue table 103, or new time series alarm data. It can be said that either or both of the registration request 120 is generated and new time series data is registered in the queue table 103.

In other words, when the values of the first pointer and the last pointer of the queue table 103 are not the same,
For the time-series data existing between the first pointer and the last pointer, the time-series data in the time-series alarm database 101 is collectively copied to obtain the time-series alarm database 2.
Time series alarm database 2 when stored in 01
01 may not have been reflected.

Therefore, when the values of the start pointer and the end pointer of the queue table 103 are not the same, the time series data existing between the start pointer and the end pointer of the queue table 103 are set to the queue table 203.
A registration process for reflecting the above is performed (step S26). Immediately after this reflection, the time series database registration processing unit 204 is activated, and the time series data reflected in the queue table 203 is converted to the time series alarm database 201.
Register with. By performing such processing, time series data is handed over between the main system 1 and the sub system 2.

The time-series alarm database 101
The time-series data in the above are collectively copied and registered in the time-series alarm database 201, and the queue table 1
When the time series data existing from the first pointer to the last pointer of 03 is reflected in the queue table 203,
Time series data is redundantly registered, or the order of registered time series data is the main system 2 and the sub system 2.
There may be a discrepancy. However, when referring to the time series data in the time series alarm database 101 or 201 in response to the time series alarm data reference request 122, it is possible to uniquely identify the time information recorded in the record stored in each database. There is no problem if you do not extract the duplicate records at the time of reference by using the key.

According to this embodiment, when the secondary system 2 is activated as an online operating system while the main system 1 is operating, the time-series data in the time-series alarm database 101 is collectively copied to make a time-series alarm database 201. When the subsystem 2 starts to operate as an online operating system, the queue table 103 stores the time-series alarm database 101 until the subsystem 2 starts to operate online. When there is unregistered data in the queue table 103 or when new data is registered in the queue table 103, the unregistered data or the new data is reflected in the queue table 203. The main system 1 when taking over time series data Or added management, there is no need to put an extra load for the takeover, it is possible to accurately reflect the time-series data of the main system 1 to the secondary system 2.

[0029]

As described above, according to the present invention,
When handing over data, it is possible to smoothly take over the data from the online operating system to the standby system without imposing a restriction or extra load on the online operating system.

[Brief description of drawings]

FIG. 1 is a block configuration diagram of an online database information processing system showing an embodiment of the present invention.

FIG. 2 is a flow chart for explaining the operation of the system shown in FIG.

[Explanation of symbols]

1 Main system 2 Sub system 101 Time series alarm database 102 queue table registration processing unit 103 queue table 104 Time Series Database Registration Processing Unit 105 Time Series Alarm Database Reference Processing Unit 112 Communication control processing unit 201 Time series alarm database 202 Queue table registration processing unit 203 queue table 210 Operation mode controller 211 Queue table data transfer processing unit 212 communication control processing unit 213 Time-series alarm database batch transfer processing unit

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Atsuhiko Hirota             5-2-1 Omika-cho, Hitachi City, Ibaraki Prefecture             Information Control Systems Division, Hitachi, Ltd.             Within (72) Inventor Masahiro Yumi             5-2-1 Omika-cho, Hitachi City, Ibaraki Prefecture             Inside the Hitachi Information Control System (72) Inventor Kazuya Seki             5-2-1 Omika-cho, Hitachi City, Ibaraki Prefecture             Inside the Hitachi Information Control System F-term (reference) 5B018 GA04 HA05 MA12                 5B034 BB02 CC01 DD05                 5B045 BB28 JJ23 JJ26 JJ44                 5B082 DC04 DE03

Claims (3)

[Claims] 1. When a main system and a sub system are provided as a free-run dual system, and one of the main system and the sub system is an online operation system and the other system is a standby system, The system running online captures time series data and temporarily stores it in a queue table.
The time-series data stored in the queue table is sequentially stored in the time-series database, and when the standby system starts up, the data stored in the time-series database of the operating system is collectively copied to obtain the time-series of the own system. Store it in the database, then start online operation,
When there is unregistered data from the queue table of the operating system to the time-series database between the time when the standby system starts and the time when it starts online operation, or in the queue table of the operating system. An online database information processing system in which, when new data is registered, the unregistered data or new data is reflected in the queue table of the system in which online operation has started. 2. When a main system and a sub system are provided as a free-run dual system, the main system is an online operating system, and the sub system is a standby system, the main system in online operation is: The time series data is fetched and temporarily stored in the queue table, the time series data stored in the queue table is sequentially stored in the time series database, and is stored in the time series database of the main system when the sub system is activated. The copied data is copied in a batch and stored in the time-series database of the secondary system, after which the on-line operation is started, and from the time when the secondary system starts up until the online operation starts, from the queue table of the main system, When there is unregistered data in the time series database or An online database information processing system in which, when new data is registered in the queue table of the system, the unregistered data or new data is reflected in the queue table of the sub system. 3. The online database information processing system according to claim 1, wherein when the unregistered data or new data is reflected in a queue table of another system, the unregistered data or new data is replaced with another data. An online database information processing system characterized by being stored in a queue table of the above system.