JP3274594B2 - Database consistency method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database matching method for matching the contents of a database held by a plurality of local stations with the contents of a database held by a center station which supervises each local station.

[0002]

2. Description of the Related Art In local stations installed in various places,
SDH (Synchronous D) in the local station
monitoring the status of a transmission device such as a transmission device, etc., and storing the status in a database in its own local station, and in a database in a center station that controls each local station, 2. Description of the Related Art A monitoring control system in which the contents are stored and a center station can monitor the entire network has been known.

FIG. 4 is a block diagram showing an example of the configuration of a conventional supervisory control system of this type.
A plurality of local stations 2 controlled by the center station 100
00-1 to 200-N.

The center station 100 includes a monitoring / control main processing unit 1
01, the database management unit 102, and the database 1
3, a transmission / reception processing unit 104, an operation unit 105, a display unit 106, and a database comparison unit 107.

The local station 200-1 includes a monitoring / control main processing unit 201, a database management unit 202, a database 203, a transmission / reception processing unit 204, transmission apparatuses 205A, 205B, and 205C to be monitored. It comprises an operation unit 206 and a display unit 207. still,
Other local stations 200-2 to 200-N are also local stations 2.
It has the same configuration as 00-1.

The database 20 of the local station 200-1
3 stores data 203A, 203B, and 203C related to the transmission devices 205A, 205B, and 205C.

FIG. 5 is a diagram showing an example of data 203A relating to the transmission device 205A stored in the database 203. The device name "A" of the transmission device 205A, the name of the monitoring element related to the transmission device 205A, and the like are shown. , And the status of each monitoring element are stored. In the example of FIG.
Line names L1 to L as the names of monitoring elements related to 05A
i and the name P1 of the panel plate constituting the transmission device 205A
To Pj are stored.

The database 1 in the center station 100
In 03, the contents of the database in each of the local stations 200-1 to 200-N are managed for each local station. In FIG. 4, reference numerals 103-1 to 103-N indicate data managed as the contents of the databases in the local stations 200-1 to 200-N, respectively.

Transmission device 205 in local station 200-1
A to 205C transmit / receive data to / from a transmission device in another local station via a line, and when a failure occurs in a panel board or the like monitored by the local station 201, the monitoring / control main processing unit 201 On the other hand, it outputs failure information including the name of its own device and the name of the element in which the failure has occurred.

For example, if the transmission device 205A cannot receive data via the line with the line name "Li", the transmission device 205A
For example, failure information including the name “A” of its own device and the name “Li” of the element in which the failure has occurred is output.

When the monitoring / control main processing unit 201 receives the above-mentioned fault information, it displays on the display unit 207 that a fault has occurred in the transmission device 205A, and sends the device name “A” to the database management unit 202. ”, Element name“ Li ”
Request to update the status of the monitoring element indicated by "" to "failed". Further, the monitoring / control main processing unit 201
A failure notification is sent to the center station 100 via the transmission / reception processing unit 204 to notify that a failure has occurred in the transmission device 205A of the local station 200-1.

When the database management unit 202 in the local station 200-1 receives the above update request from the monitoring / control main processing unit 201, the database management unit 202 according to the request receives the update request.
03, and then sends the data to the center station 100 via the transmission / reception processing unit 204 to the center station 100 in the data 103-1 of the local station 200-1 stored in the database 103 in the center station 100. A ", element name" L
An update request is sent, requesting that the status of the monitoring element indicated by "i" be updated to "failed".

The administrator of the local station 200-1 is:
When the display unit 207 indicates that a failure has occurred in the transmission device 205A, the user operates the operation unit 206 to request the monitoring / control main processing unit 201 to display the contents of the database 203. In accordance with the contents of the database 203 displayed in 207, a failure location is specified and a recovery operation is performed. However, in some cases, it is not possible to identify a failure point only by the contents of the database 203 displayed on the display unit 207. For example, as described above, even if the contents of the database 203 indicate that a fault has occurred in the line with the element name “Li”, whether the line has a fault or the line in the transmission device 205A It is not possible to specify whether a failure has occurred in the corresponding receiver.

Local station 200-1 to center station 100
The failure notification transmitted to the monitoring / control main processing unit 101 is transmitted via the transmission / reception processing unit 104. Accordingly, the monitoring / control main processing unit 101 displays on the display unit 106 that a failure has occurred in the transmission device 205A of the local station 200-1. Also, the local station 200-1 transmits the information to the center station 1
The update request transmitted to 00 is passed to the database management unit 102 via the transmission / reception processing unit 104. As a result, the database management unit 102
Of the monitoring element indicated by the device name “A” and the element name “Li” in the data 103-1 related to the local station 200-1 stored as “failure”.

When the display unit 106 indicates that the transmission device 205A of the local station 200-1 has failed, the manager of the center station 100 operates the operation unit 105 to execute the monitoring / control main processing. Local station 20 for unit 101
Request to display data for the transmission device 205A in 0-1. Upon receiving this request, the monitoring / control main processing unit 101 reads the requested data from the database 103 using the database management unit 102, and
The read data is displayed on the display unit 106. In the case of this example, the content of the data displayed on the display unit 106 indicates that a fault has occurred in the line with the element name “Li”. It is impossible to specify whether the error has occurred or whether a failure has occurred in the receiving unit corresponding to the line.

Therefore, the administrator of the center station 100 operates the operation unit 105 to provide the monitoring / control main processing unit 101 with another local station 200- connected to the line having the element name "Li". Request that the contents of the k database also be displayed.

Upon receiving this request, the monitoring / control main processing unit 101 reads the data 103-k managed as the contents of the local station 200-k from the database 103 using the database management unit 102, and reads the data. The data 103-k is displayed on the display unit 106. If the display also indicates that a fault has occurred in the line with the element name "Li", it can be determined that the line has failed, and the line has failed. If this is not indicated, it can be determined that a failure has occurred in the receiving unit corresponding to the line in the transmission device 205A.

As described above, the contents of the database 103 in the center station 100 are stored in each of the local stations 200-1 to 200-2.
It is updated each time the database in 00-N is updated. However, the center station 100 and the local stations 200-1 to 200-1
In the event of a communication error between the local stations 200-N and the failure of the center station, each of the local stations 200-1 to 200-N performs
Since the database in the local station is updated, inconsistency occurs between the contents of the database 103 of the center station 100 and the contents of the databases of the local stations 200-1 to 200-N. If this inconsistency is left as it is, the state of the transmission equipment and the state of the line of each local station managed by the database 103 of the center station 100 will be different from the actual state.
At 0, the network cannot be managed.

Therefore, conventionally, when the failure of the center station 100 is recovered and when the center station 100 and each local station 200-1 to 200-2 are restored.
When the communication error between 00-N is recovered, the database matching process described below is performed.

Monitoring / control main processing unit 10 of center station 100
Reference numeral 1 denotes when the failure of the center station 100 is recovered and when the center station 100
At the time of recovery from the communication abnormality between the local stations 200-1 to 200-N, as shown in FIG. 6, a database transmission request is sent to the local stations 200-1 to 200-N via the transmission / reception processing unit 104. It is transmitted (S21).

When the monitoring / control main processing unit 201 in the local station 200-1 receives the database transmission request from the center station 100, as shown in the flowchart of FIG. A request is made to transmit the contents to the center station 100 (S3
1). As a result, the database management unit 202 reads all the contents of the database 203 and transmits the read contents to the center station 100 via the transmission / reception processing unit 204. The other local stations 200-2 to 200-N perform the same processing.

Transmission / reception processing unit 104 in center station 100
Receives the contents of the database sent from each of the local stations 200-1 to 200-N, and passes them to the database comparison unit 107 (S22 in FIG. 6).

The database comparison section 107 stores the contents of the database in each of the local stations 200-1 to 200-N and the contents of the database 103 in the center station 100 sent from each of the local stations 200-1 to 200-N. Are compared, and if there is a mismatch, the contents of the database 103 in the center station 100 are updated so that they match (S23).

[0024]

As described above, conventionally, all of the contents of the database of each local station are sent to the center station, and the contents of the database in the center station are sent to the center station. The corresponding parts of the database are compared with each other, and if there is a mismatch, the contents of the database in the center station are updated so that the two parts match, and the load on the center station becomes high. For this reason, when failure information is sent from the local station, a process (eg, a process of displaying a failed transmission device, a process of displaying data related to a failed transmission device, and the like) for the failure information is promptly performed. You will not be able to do it.

Therefore, an object of the present invention is to reduce the load on the center station at the time of database matching processing.

[0026]

SUMMARY OF THE INVENTION In order to achieve the above object, the present invention provides the contents of a database held by a plurality of local stations and a database held by each of the local stations.
In the database matching method for matching the content of the database of the center station that controls the local station , the content of the local station is stored in the local station. The center station transmits update data to the center station, and the center station updates a database in its own center station according to the update data sent from the local station, and when the center station recovers from a failure, and when the center station and each of the local stations At the time of recovery from the communication abnormality between the local station, the center station reads the contents of the database of each local station stored in the database in the own center station, and transfers the read contents of the database of each local station to the corresponding local station. The local station transmits the contents of the database sent from the center station and the data of the local station. The contents of the database in the local station are compared with the contents of the database transmitted from the center station, and the contents of a part that does not match the contents of the database sent from the center station are transmitted to the center station as update data. The content of the database in the center station is updated based on the update data sent from each of the local stations.

[0027]

Embodiments of the present invention will now be described in detail with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of the present invention, which comprises a center station 1 and a plurality of local stations 2-1 to 2-N controlled by the center station 1.

The center station 1 has a monitoring / control main processing unit 11
, A database management unit 12, a database 13,
It includes a transmission / reception processing unit 14, an operation unit 105, and a display unit 106.

The local station 2-1 includes a monitoring / control main processing unit 21, a database management unit 22, a database 23, a database comparison unit 24, and a transmission / reception processing unit 2.
5, an operation unit 26, a display unit 27, and transmission devices 28A, 28B, and 28C to be monitored.
Note that the other local stations 2-2 to 2-N are also local stations 2-1.
It has the same configuration as

The database 23 of the local station 2-1 stores data 23A, 23B, 23C related to the transmission devices 28A, 28B, 28C. Each data 23
The configuration of A, 23B, and 23C corresponds to the data 20 shown in FIG.
3A, and is composed of a device name, a monitoring target element name, and a status of each monitoring target element.

In the database 13 in the center station 1, the contents of the databases in the local stations 2-1 to 2-N are managed for each local station. In FIG. 1, reference numerals 13-1 to 13-N denote local stations 2-, respectively.
It shows data managed as the contents of the database in 1-2-N.

Center station 1, local stations 2-1 to 2-N
Is the center station 10 shown in the prior art during normal operation.
0, performs the same operation as each of the local stations 200-1 to 200-N, but recovers from the communication abnormality between the center station 1 and each of the local stations 2-1 to 2-N when the failure of the center station 1 is recovered. At times, a database matching process described below is performed.

The monitoring / control main processing unit 11 of the center station 1
When the failure of the center station 1 is recovered and when the communication abnormality between the center station 1 and each of the local stations 2-1 to 2-N is recovered, as shown in the flow chart of FIG. N, and sends data 13-1 to 13-1 managed as the contents of the database of each local 2-1 to 2-N from the database 13 using the database management unit 12 while transmitting the matching instruction.
13-N, and read data 13-1 to 13-13
-N are transmitted to the corresponding local stations 2-1 to 2-N (S1). For example, the data 13-1 managed as the content of the database 23 of the local station 2-1 is transmitted to the local station 2-1 and the data 13-N managed as the content of the local station 2-N is transmitted to the local station 2-1. 2-N.

When the monitoring / control main processing unit 21 in the local station 2-1 receives the matching instruction from the center station 1, the monitoring / control main processing unit 21 shown in FIG.
As shown in the flow chart of FIG.
When the data 13-1 is received, it is passed to the database comparison unit 24 (S11).
Note that the other local stations 2-2 to 2-N are also local stations 2-1.
The same processing is performed.

The database comparison unit 24 stores the data 13-
When 1 is passed, the corresponding parts of the data 13-1 and the contents of the database 23 are compared (S12).

If there is no mismatch (S
13 is NO), information indicating that there is no mismatched part is transmitted to the center station 1 (S15).

If there is a non-coincidence part, the contents of the part of the contents of the database 23 that do not match the data 13-1 sent from the center station 1 are transmitted to the center station 1 as update data. The information for specifying the portion is transmitted to the center station 1 (S14). For example, in a case where the state corresponding to the element name “Lk” in the information 23A regarding the transmission device 28A is “failure” in the database 23 and “normal” in the data 13-1, "Fault" is transmitted as update data, and the station name of the local station 2-1, the device name of the transmission device 28A, and the element name "Lk" are transmitted as information for specifying the update portion.

Monitoring / control main processing unit 11 in center station 1
Receives a response from the local station via the transmission / reception processing unit 14, and determines whether the response is update data or information indicating that there is no mismatching part (S2, S3).

If the information indicates that there is no mismatching part (S3: YES), it waits for a response from another local station (S2).

If the data is information for specifying the update data and the update portion, the contents of the database 13 are updated based on the information (S4). For example, if "failure" is received as update data, and the station name of the local station 2-1, the device name of the transmission device 28A, and the element name "Lk" are received as information for specifying the update portion, the data 1
The status of the element name “Lk” related to the transmission device 28A in 3-1 is updated to “failure”. When the above-described processing is performed on all the local stations 2-1 to 2-N (S5: NO), the center station 1 ends the database matching processing.

[0042]

As described above, according to the present invention, at the time of database matching processing, the contents of the database in the center station are transmitted from the center station to each local station, and the contents of the database of the center station are transmitted to each local station. Is compared with the contents of the local station database.
The load on the center station can be reduced as compared with the prior art in which the contents of the database sent from each local station in the center station are compared with the contents of the database of the center station. Also, each local station only needs to compare the contents of the database in its own local station with the contents of the sent database, and the amount of comparison processing performed by each local station is performed by the center station using conventional technology. Since the processing amount is about 1 / (the number of local stations), the load is not concentrated on a specific local station.

[Brief description of the drawings]

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

FIG. 2 is a flowchart showing a processing example of a center station 1.

FIG. 3 is a flowchart showing a processing example of local stations 2-1 to 2-N.

FIG. 4 is a block diagram for explaining a conventional technique.

FIG. 5 is a diagram showing an example of data contents managed by a database.

FIG. 6 is a flowchart illustrating a processing example of a center station 100;

FIG. 7 is a flowchart showing a processing example of local stations 200-1 to 200-N.

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 center station 11 monitoring / control main processing unit 12 database management unit 13 database 14 transmission / reception processing unit 15 operation unit 16 display unit 2-1 to 2-N local station 21 monitoring / control main processing Unit 22 Database management unit 23 Database 24 Database comparison unit 25 Transmission / reception processing unit 26 Operation unit 27 Display unit 28A, 28B, 28C Transmission device to be monitored

 ──────────────────────────────────────────────────続 き Continuation of front page (56) References JP-A-5-346882 (JP, A) JP-A-4-135261 (JP, A) JP-A-4-1655437 (JP, A) JP-A-2- 14354 (JP, A) JP-A-2-210557 (JP, A) JP-A-3-124244 (JP, U)

Claims (3)

(57) [Claims] 1. The contents of a database possessed by each of a plurality of local stations and a database possessed by each of said local stations.
In the database matching method for matching the contents of the database stored in the center station that controls the local station with the contents of the base station, each of the local stations updates the contents of the database in the local station. Transmitting update data to the center station, the center station updates a database in its own center station according to the update data sent from the local station, When the communication abnormality with the local station is recovered, the center station
The contents of the database of each local station stored in the database in the own center station are read, and the contents of the read database of each local station are transmitted to the corresponding local station. Each of the local stations is transmitted from the center station. The contents of the database received and the contents of the database of the local station are compared, and the contents of the part of the contents of the database in the local station that do not match the contents of the database sent from the center station are used as update data. A database matching method for transmitting to a center station, wherein the center station updates contents of a database in the center station based on update data sent from each of the local stations. 2. The database of each local station includes:
2. The database matching method according to claim 1, wherein the status of the device monitored by the local station is stored. 3. The database according to claim 2, wherein each local station updates the contents of the database in the local station each time the status of a device monitored by the local station changes. Alignment method.