JPH0888687A - Electronic exchange network - Google Patents

Abstract

PURPOSE: To easily and surely restore faults by attaining operation processing in each database built up for each system component of the network. CONSTITUTION: In the case of restoring a database 6, the time range of data processed by electronic exchanges 1, 2 is designated and a data load command is fed to a database management equipment 8 through a terminal equipment 5 and the electronic exchanges 1, 2. The time range of data processing of either of the electronic exchanges 1, 2 is retrieved to generate a retrieval result file and sent to the terminal equipment 5 through the electronic exchanges 2, 1 and stored in the database 6. In this case, data in duplicate as data of the retrieval result file are aborted. The terminal equipment 5 reads the history of access from a log 6a of the database 6 to execute again the operation executed for the time range of designated data retrieval thereby restoring the database 6.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an electronic exchange network in which a plurality of systems including an electronic exchange, a database (storage device) and a terminal device are networked.

[0002]

2. Description of the Related Art Conventionally, in this type of electronic exchange network, the scale thereof has increased and the amount of processed data has also increased. For this reason, there is a demand for high reliability that can withstand long-term operation and reduction of maintenance burden.

In such an electronic exchange network, a plurality of electronic exchanges for exchanging traffic data, quality data, etc., a database (storage device) for accumulating traffic data, quality data, etc., and a terminal device, etc. are provided. The system is networked. The database here is a hard disk drive (HDD)
Is often used. Since this HDD has a movable part and is likely to malfunction during a long period of operation, it needs to be replaced regularly.

For this reason, a redundant structure is employed to ensure reliability. For example, there is mirroring. In this mirroring, two or more storage areas are provided in the database for each system, and the same storage and data processing such as reading are performed for each storage area. That is, the storage contents of all storage areas in which mirroring is performed are the same.

Therefore, if the database (storage device) fails, the system cannot continue to operate. Further, if the database fails, the operation of all systems that refer to the data will stop. Although such a problem can be avoided when building a database for each system, there is a risk that the synchronization of the database due to transaction processing will be lost due to a missed transaction due to an instantaneous increase in traffic or a collision. It becomes difficult to establish the synchronization. For this reason, synchronization is achieved by exchanging data between databases, but it is necessary to perform the same processing in each database. In other words, individual databases cannot be manipulated individually.

[0006]

However, in the above-mentioned electronic exchange network of the conventional example, when data is exchanged between databases, if they are synchronized, it is necessary to perform the same processing between the databases. Therefore, it is not possible to operate the databases individually to perform data processing such as searching, deleting, and accumulating permission or prohibition, and there is a drawback that the database cannot be restored when it fails. It was

The present invention solves the drawbacks of the prior art as described above, and the operation processing can be performed in each database constructed in each system constituting the network, resulting in a failure of the database. The purpose is to provide an electronic exchange network that can be easily and reliably restored in the event of a failure.

[0008]

In order to achieve the above object, the invention according to claim 1 has a plurality of electronic exchanges for exchanging data, and a database connected to each electronic exchange for accumulating processing data. In an electronic exchange network including a terminal device for accessing this database to perform data processing and a data management device for managing the processing data, a plurality of electronic exchanges regularly process data of their own electronic exchange. Processing data sent to the management device and stored in the database, processing data sent from other electronic exchanges is stored in the database connected to the own electronic exchange, and processing data stored in the database of the data management device Requesting the transmission of the data, importing this processed data into the database of the own electronic exchange, and When a failure occurs in the database, the processing data in the database of the data management device is taken in by the electronic exchange, and the operation performed in the past in the database of the electronic exchange is automatically repeated to recover the damaged processing data. It is configured.

According to a second aspect of the present invention, in an electronic exchange network, when data processing is performed on processing data stored in a database of the electronic exchange, when the processing data is stored within a certain period before the present time. Is configured to save the processed data, read the saved data according to a request from another electronic exchange, return the data to the requested electronic exchange, and restore the database between the electronic exchanges.

According to a third aspect of the present invention, in the electronic exchange network, a storage device is provided in the terminal device, the data in the database of the terminal device connected to the data management device or another electronic exchange device is read through the own electronic exchange device, and the own terminal device is read. It is configured to restore the database of the device.

According to a fourth aspect of the present invention, in an electronic exchange network, at least traffic data and quality data are processed as the processing data, and at least data retrieval, deletion and storage permission or prohibition instruction is performed as the data processing. It is configured to do.

[0012]

In the electronic exchange network according to the first and fourth aspects of the present invention having such a configuration, the plurality of electronic exchanges periodically send the processing data of the own electronic exchange to the data management device and store it in the database. Further, processing data sent from another electronic exchange is stored in a database provided in the own electronic exchange, and it is requested that the processing data stored in the database of the data management device be sent out. It is taken into the database of the exchange. Then, when a failure occurs in the database, the processing data in the database of the data management device is taken in by the electronic exchange, and the operation performed in the past in the database of the electronic exchange is automatically repeated to recover the damaged processing data. Is going. Therefore, the operation processing can be surely performed in each database constructed in each system constituting the network. That is, the processing is momentarily increased to prevent a congestion state, a large amount of data is not transferred at one time, an overflow in the database of the terminal device is also prevented, and a failure in the database occurs. Recovery in the event of an occurrence is easy and reliable.

In the electronic exchange network according to the second to fourth aspects, when the processed data is accumulated within a certain period before the present, the accumulated processed data is saved before the data processing. Then, in response to a data read request from another electronic exchange, the saved data is read and returned to the requested electronic exchange to restore the database between the electronic exchanges. Also, the data of the database of the terminal device connected to the data management device or another electronic exchange device is read through the self electronic exchange to restore the database of the self terminal device. Therefore, when data is damaged, it is possible to reliably recover the data within a certain period. Moreover, since the database management device and the database are not required, the device scale is reduced.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an embodiment of an electronic exchange network of the present invention will be described in detail with reference to the drawings. FIG. 1 is a block diagram showing the configuration of a first embodiment of an electronic exchange network of the present invention. In FIG. 1, in this example, electronic exchanges 1, 2 and 3 for exchanging traffic data, quality data and the like with telephone exchange processing and a local area network (LAN) 4 for controlling the electronic exchange 1 are constructed. There is.

On this LAN 4, a terminal device 5 for controlling the electronic exchange 1 and a hard disk (H for storing traffic data, quality data, etc. from the electronic exchange 1) are stored.
A database (storage device) 6 using, for example, DD) and a remote terminal device (workstation) 7 for remotely operating the terminal device 5 are provided. The electronic exchange 2 is connected to a database management device 8 for centrally managing the processing data of the electronic exchanges 1 to 3, and a database 9 for accumulating the data here. Further, the electronic exchange 3 has a terminal device 10 for controlling this device,
A database 11 that stores the data here is connected.

Next, the operation of the first embodiment will be described. The database 6 stores the traffic data, quality data, etc. from the electronic exchange 1. Here, the electronic exchange 2 is set so as not to transfer the data from the electronic exchange 3 to the electronic exchange 1, and further, the electronic exchange 2
Is set not to transfer the data from the electronic exchange 1 to the electronic exchange 3. As a result, the data of the electronic exchanges 1 and 2 are stored in the database 6 connected to the terminal device 5, and the processing data of the electronic exchanges 2 and 3 are stored in the database 11 connected to the terminal device 10. To be done.

After this, the maintainer of the electronic exchanges 1, 3 can operate the respective terminal devices 5, 10 to access the respective databases 6, 11 to change or delete the data. When this data is changed or deleted, the history is accumulated in the log area of the storage device connected to the terminal devices 5 and 10, as will be described in detail below. In this case, the database 11 performed by the terminal device 10
The operation to (1) does not affect the database 6 connected to the terminal device 5 of the electronic exchange 1.

On the other hand, the database 6 carried out by the terminal device 5
The operation for does not affect the database 11 connected to the terminal device 10 of the electronic exchange 3, but the electronic exchange 1
Is connected to a remote terminal device 7 in the LAN 4, and the remote terminal device 7 can also access the database 6 to change or delete data. The history of data modification or deletion in this case is accumulated in the log area.

Next, a case where the data of the terminal device 5 is loaded from the database management device 8 and the database 6 is restored will be described. FIG. 2 is a block diagram for explaining the recovery of this database. In FIG. 2, this example shows the connection configuration of the electronic exchanges 1 and 2 shown in FIG. That is, it has a terminal device 5, databases 6, 9 and a database management device 8. Further, the terminal device 5 is provided with a log 6a which is a storage device.

Next, the procedure of this restoration will be described. First, the maintenance person of the terminal device 5 specifies the time range of the data processed by the electronic exchanges 1 and 2 as the data to be loaded from the database management device 8. This data loading instruction is sent from the terminal device 5 to the database management device 8 through the electronic exchanges 1 and 2. This database management device 8 is one of the designated electronic exchanges 1 and 2,
The specified time range of data processing is searched, and a search result file that is the result of this search is created.

This search result file is sent from the electronic exchange 2 to the terminal device 5 through the electronic exchange 1. The terminal device 5 stores the received search result file in the database 6 connected to the terminal device 5. In this case, the duplicate data in the database 6 connected to the terminal device 5 and the search result file discards the data in the search result file and prevents double registration of the data. The presence of this duplicated data is determined by checking the message ID, which will be described in detail later.

Thereafter, the terminal device 5 reads the access history from the log 6a, and re-executes the operation executed within the designated time range of the data search, whereby the database 6 of the terminal device 5 is restored. For example, the search result files described above are created one by one for every 100 data records. The data of the search result file is sorted in the order of accumulation time and is sent out in the order of accumulation. Then, from the procedure in which the search result file is sent from the electronic exchange 2 to the terminal device 5 through the electronic exchange 1, the terminal device 5 reads the access history from the log 6a and executes the access history within the specified data search time range. The procedure of re-executing the operation is repeated each time.

In this way, the processed data is momentarily increased and is prevented from falling into the congestion state.
A large amount of data is not transferred at one time, and the terminal device 5
The database 6 is also prevented from overflowing.

FIG. 3 is a diagram showing the format of the access history in the log 6a. Here is the change of data,
Only the deletion is processed by the command. The format of the change (MOD) shown in FIG. 3A is the message ID (m
(messageID) is a value unique to the system, and is a number given when the data from the electronic exchange 1 is sent to the terminal device 5. When the maintainer changes the data,
Various search conditions are specified, one of the data to be changed is selected, and an operation such as adding a memo is performed. The data change is such that the same change cannot be made for a plurality of data, one message ID is determined, and this message ID is recorded in the access history.

The date is the date and time when the processing by the command is executed. The field is
This is the ID that was changed in the data, and the data (dat
In a), the changed contents of the field data are recorded. In FIG. 3B, deletion (DE
The contents of the L format are shown, and the date (da)
te) is the date and time when the command was executed. Key (ke
y) and range, when deleting data,
The deletion condition specified by the maintenance person is recorded. When the delete command is read from the access history log, the command processing previously executed by the maintenance person is re-executed as it is for the data up to the date and time recorded in the date.

FIG. 4 is a block diagram for explaining a processing procedure for automatically performing data recovery without intervention of a maintenance person when data is lost due to some cause during normal data storage operation. It is a figure. In FIG. 4, a relatively small-capacity database is connected to the electronic exchange 1, and data to be sent to the terminal device 5 is also stored in the database 6 at the same time. In this case, the missing data is due to the message ID (message
It is determined by the disappearance (missing) of eID).

First, the terminal device 5 requests the electronic exchange 1 to retransmit the data by notifying the message ID (messageID) of the disappeared data. This electronic exchange 1 uses the message ID (mes
The electronic exchange 1 sends out the retrieved data to the terminal device 1.

FIG. 5 is a block diagram showing the structure of a small-scale electronic exchange network according to the second embodiment. In FIG. 5, in this example, electronic exchanges 21 and 22 for exchanging data and a terminal device 2 connected to the electronic exchange 21 are shown.
3 and 3 are provided. Further, a database 24 using a hard disk (HDD) for accumulating traffic data, quality data, etc. from the electronic exchange 21, a spare storage device 25, and a log 26 are provided.
In addition, it has a terminal device 27 connected to the electronic exchange 22, a database 28 using a hard disk (HDD) for storing traffic data, quality data, etc. from the electronic exchange 22, and a log 29.

Next, the operation of the second embodiment will be described. The data processed in the electronic exchanges 21 and 22 are stored in the databases 24 and 28, respectively. When the data in the databases 24 and 28 connected to the terminal devices 23 and 27 are changed or deleted, for example, the data within one week from the latest data is automatically saved in the backup storage device 25. It is like this. The data in the storage device 25 is stored in the terminal devices 23, 27.
When the database 24, 28 is searched, the search is not performed.

Next, a processing procedure for recovery when a failure occurs in the database 24 connected to the terminal device 23 will be described. First, data is read from the terminal device 23 to the terminal device 27. The terminal device 27 searches the database 28 for the requested data and creates a search result file. The terminal device 27 reads the data saved in the storage device 25, and the message I of the data is read.
If D (messageID) does not exist in the search result file, the data is added.

When the message ID (messageID) already exists in the search result file, the operation of replacing the data in the search result file with the saved data is performed. This process is performed on all the saved data. The terminal device 27 sends the search result file to the terminal device 23. The search result file received by the processing of the terminal device 23 is stored in the database 24.

As described above, in the second embodiment, when data is damaged due to system operation stop or HDD database 24, 28 failure, etc., data can be dealt with within a certain period, for example, within one week. Recovery is possible. Further, as compared with the first embodiment shown in FIG. 1, since the database management device 8 and the database 9 are not required, the device scale is reduced.

[0033]

As is apparent from the above description, according to the electronic exchange network according to the first and fourth aspects, when the database has a failure, the data processed in the database of the data management device is transferred to the electronic exchange. Built in each system that configures the network in order to retrieve damaged and processed data by automatically repeating the operations performed in the past in the database of the electronic exchange,
This has an effect that operation processing can be reliably performed in each database, and recovery in the event of a failure in the database can be performed easily and reliably.

According to the electronic exchange network of claims 2 to 4, when the processed data is accumulated within a certain period before the present, the accumulated processed data is saved before the data processing, In response to a data read request from another electronic exchange, the saved data is returned to the electronic exchange,
The database is being restored between electronic exchanges. In addition, the data in the database of the terminal device connected to the data management device or another electronic exchange device is read through the own electronic exchange to restore the database of the own terminal device. It is possible to reliably recover the data inside. Moreover, since the database management device and the database are not required, the device scale can be reduced.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a first embodiment of an electronic exchange network of the present invention.

FIG. 2 is a block diagram for explaining restoration of a database in the embodiment.

FIG. 3 is a diagram showing a format of an access history in a log in the embodiment.

FIG. 4 is a block diagram for explaining a processing procedure for automatically performing data recovery when data loss occurs during a normal data storage operation in the embodiment.

FIG. 5 is a block diagram showing a configuration of a small-scale electronic exchange network which is a second embodiment.

[Explanation of symbols]

 1-3 electronic exchange 4 LAN 5,10,23,27 terminal device 6,9,11,24,28 database 8 database management device 21,22 electronic exchange 25 storage device 26,29 log

Claims (4)

[Claims] 1. A plurality of electronic exchanges for exchanging data,
An electronic exchange network including a database connected to each of the electronic exchanges to store processed data, a terminal device for accessing the database to perform data processing, and a data management device for managing the processed data. , The plurality of electronic exchanges periodically sends the processing data of the own electronic exchange to the data management device and stores it in the database, and the processing data sent from another electronic exchange is connected to the own electronic exchange. Requesting transmission of the processing data stored in the database and stored in the database of the data management device,
This processing data is loaded into the database of the own electronic exchange, and when a failure occurs in the database, the processing data from the database of the data management device is loaded into the electronic exchange and the operations performed in the past in the database of the electronic exchange are automatically performed. An electronic exchange network characterized by repeatedly recovering damaged processing data. 2. When performing the data processing on the processing data stored in the database of the electronic exchange, if the processing data is stored within a certain period before the present, the processing data is saved. 2. The electronic exchange network according to claim 1, wherein the save data is read out at a request from another electronic exchange and is returned to the requested electronic exchange to restore the database between the electronic exchanges. 3. A storage device is provided in the terminal device, and the data of the database of the terminal device connected to the data management device or another electronic exchange device is read through the own electronic exchange to restore the database of the own terminal device. The electronic exchange network according to claim 1, wherein: 4. At least traffic data and quality data are processed as the processing data, and at least data retrieval, deletion, and storage permission or prohibition instructions are performed as the data processing. 1
Alternatively, the electronic exchange network described in 2.