KR0123193B1 - Distribute real time data base output method - Google Patents

Abstract

A method for allowing and prohibiting backup of a database in a distributed real-time system is provided to enhance reliability of a telephone exchange system and improving efficiency of maintenance, in which a plurality of processors are installed. The method comprises the steps of allowing an operation and maintenance processor(OMP; 23) to determine the kinds of command received from the operator; requesting prohibition of the backup by the OPM(23) to a plurality of processors(24) if the received command is the forbidding database backup and performing prohibition of the backup of the OPM(23) after being informed of execution of the prohibition command; requesting allowance of the backup by the OPM(23) to a plurality of processors(24) if the received command is the allowing database backup and performing allowance of the backup of the OPM(23) after being informed of execution of the prohibition of the backup command; transmitting the backup status relative to a plurality of processors(24) to the operator by referring the backup status in the backup status information relation if the backup status output command is received to the OPM(23).

Description

How to Prohibit, Allow, and Output the Status of Databases in Distributed Real-Time Systems

1 is a distributed structure diagram of an electronic exchanger DBMS including the subject matter of the present invention.

2 is a block diagram of a schematic diagram and messages between related blocks to which the present invention is applied.

3 is another overall flow diagram of the present invention.

* Explanation of symbols for main parts of the drawings

11: switching subsystem 12: interconnect network subsystem

13: central control subsystem 21: operator terminal

22: human-machine processor 23: operation and maintenance processor

24: other processor

The present invention relates to a method for prohibiting, allowing and outputting a backup of a database in a distributed real-time system.

In the conventional voice electronic switch system, which is a distributed real-time system, database management system (DBMS) logs and records on disk when applications that perform call processing, operation, maintenance, billing and statistics functions require database backup. The exchange's performance degraded by completely backing up the database and then reporting the processing result.

Therefore, in the ISDN electronic switch system, if the DBMS completes saving the log only in the log storage buffer located in the memory of the processor, it notifies the application requesting the backup. It was made.

Therefore, if the exchanger's performance is increased but the operator fails to perform a function such as system restart, the log that failed to perform backup to the database on disk remains in the log storage buffer and transaction log table. The discrepancy of has occurred.

When such a mismatch occurs, an error exchange data is generated, and the exchange application programs using the data cannot execute normally, thereby decreasing the reliability of the exchange.

Therefore, the present invention devised to solve the above problem prevents database backup before performing a function such as a system restart in order to prevent data inconsistency, and at the same time, logs remaining in the log storage buffer and the transaction log table are deleted. Its purpose is to implement a database backup prohibition function that allows all to back up to a disk database, a database permission function that allows backups again for normal operation of the exchange, and a backup status output function that informs the current database backup status. .

In order to achieve the above object, the present invention includes a Man-Machine Processor (MMP) for mounting a Man-Machine Interface (MMI) block to match the operator; OMP (Operation and Maintenance Processor) for mounting a DBBG (Data Base Backup Group), DBSG, DBTG DBKG (Data Base Kerne Group); In a system having a Data Base Transaction Group (DBTG), a Data Base Supporting Group (DBSG), and a plurality of other processors that implement a Data Base Kernel Group (DBKG), the OMP determines the type of instructions received from the operator. The first step to do; After performing the first step, if the operator command is prohibiting the backup of the database, the OMP requests the prohibition of backup from a plurality of other processors, and then performs a prohibition of backup of the OMP itself after being informed of completion of the backup prohibition of the plurality of other processors. A second step of doing; After performing the first step, if the operator command permits the backup of the database, the OMP requests the backup permission from the plurality of other processors to notify the completion of the backup prohibition of the plurality of other processors. Performing a third step; And after performing the first step, when the operator command outputs a database backup state, the OMP transmits a backup state of the plurality of other processors to the operator by referring to the backup state in a backup state information relation. Characterized in that.

According to the present invention, when an application program performing call processing, operation maintenance, billing, and statistical functions is requested to a DBMS for an electronic switch for an integrated telecommunication network, only the log generated for the backup is stored in a log storage buffer. The performance of the exchange is improved by sending the backup processing results directly to the application. However, since the backup is not completely completed on the disk database, all processors of the system are brought down in this state. System Restart function to reload the corresponding blocks of the processor, Processor Restart function to bring down only one processor and then reload only the blocks of the processor, and to load some blocks from the disk into the processor's memory. Partial Loading function, in processor Block removal, which erases the block in progress, the ability to dump the exchange software blocks from the magnetic tape to the disk, and the function to back up the exchange software blocks from the disk to the magnetic tape. Because there is a high possibility of data inconsistency at the time, to prevent data inconsistency, the database backup prohibition function is prevented to prevent new backup request from each processor, and apply all remaining logs to the log storage buffer and transaction log table. Data consistency can be maintained by performing functions such as a system restart. In addition, after all functions such as system restart are performed, the Exchange application can be operated normally by allowing the database backup to allow the exchange to operate normally. The administrator can refer to the current database backup status. Backup status output function was provided.

Hereinafter, with reference to the accompanying drawings will be described an embodiment according to the present invention;

1 is a structural diagram of a main memory DBMS having an injection structure of an all-electronic exchange system.

The electronic switch has three subsystems: an Access Switching Subsystem (ASS) 11, an Integer Network Subsystem (INS) 12, and a Central Control Subsystem (CCS) 13. The ASS 11 includes access switching processors (ASPs) that perform distributed call processing functions, and the INS 12 includes an INP (interconnection network processor) and a number translation processor (NTP) that perform centralized call processing functions. The CCS 13 includes an Operation and Maintenance Processor (OMP) and a Man-Maching Processor (MMP) that perform centralization functions related to operation and maintenance.

The electronic switchboard DBMS has its functions distributed according to the characteristics of the processors to manage the data distributed among the various processors as described above, and resides in the main memory for real time processing, retrieves and modifies the data, and remote data. It provides processing function, redundant data processing function, data backup function, data recovery function, concurrency control function, transaction management function, data backup prohibition, allow, status output function, and so on.

Of these processors, OMP's DBMS has four blocks: Data Base Backup Group (DBBG), Data Base Supporting Group (DBSG), Data Base Transaction Group (DBTG), and Data Base Kernel Group (DBKG). The remaining processors have three blocks: DBKG, DBSG, and DBTG. Here, the DBBG block requires disk access. Since the disk is mounted in the OMP, the DBBG block exists only in the OMP. Meanwhile, unlike other processors, MMP's DBMS includes four blocks of DBQG (Data Base Query Group), DBSG, DBTG, and DBKG. The reason is that only the MMP can receive input from the operator, which means that the DBQG block that interfaces with the operator terminal and the electronic switch cannot exist in other processors, but only in the MMP.

Looking at the functions of each block in the DBMS, the DBSG performs the functions of requesting the DBKG to handle retrieval and change requests for remote data within the application, and the communication between the DBMSs for remote data processing. It performs the control function, DBKG performs the function to search and change the data in the database according to the retrieval and change of the data that the processing request came in. DBBG actually performs the disk when the data requiring the change is needed for disk backup. The database backup function, the database recovery function upon system restart, data backup prohibition, allow, status output function, and finally DBQG performs on-line query processing.

2 is a structural diagram showing the flow and configuration of messages between related blocks for performing database backup prohibition, permission, and status output processing implemented on a distributed electronic real-time exchanger.

The database backup inhibit function analyzes the command in the MMI (Man-Machine Interface) block 25 mounted on the MMP 22 when the operator inputs a database backup inhibit command from the operator terminal 21. Processing request is made to the DBBG block 26 which can process.

The DBBG 26 notifies the MMI block 25 that the database backup prohibition cannot be performed when the number of logs in the log spool buffer, which stores the logs sent from all processors constituting the exchange, exceeds the threshold. The MMI block 25 outputs the corresponding message to the MMI output window for the operator to see. On the other hand, if the number of logs does not exceed the threshold, DBSG 28 of all processors is required to prohibit the backup of the database and to transfer the logs remaining in the log storage buffer and the transaction log table to DBBG 26.

The DBSG 28 of each processor requests DBKG 29 to put the database backup state into a prohibited state, and if DBKG 29 puts it into a prohibited state, then the database backup request from the application is rejected. do. The DBSG 28 transfers the logs remaining in the log storage buffer and the transaction log table to the DBBG 26 when the backup prohibition state is completed.

Then, the DBBG 26 checks whether all the remaining logs have been transmitted from the DBSG 28 of all the processors, and notifies the MMI block 25 of the reason that the backup prohibition cannot be completed if the log transmission is not completed even by one processor. At the same time, the DBSG 28 is requested to change all the processors whose backup prohibitions are completed to the backup permission state.

However, when the log transfer from the DBSG 28 of all the processors is completed, the backup state of the relation containing the backup state information of each processor is changed to the prohibited state, and then the data is stored in the OMP 23 where the DBBG 26 exists. Ask DBKG 27 to prohibit base backup. When the backup is prohibited, the log of the log spool buffer is applied to the database on disk, and then the MMI block 25 is notified of the completion of the database backup prohibition, and the MMI block 25 outputs a backup prohibition completion message to the MMI output window. .

When the operator inputs a database permission command in the operator terminal 21, the database backup permission function analyzes the command in the MMI block 25 and requests a processing to the DBBG block 26 that can process the command. . DBBG 26 requests database backup permission from DBSG 28 of all processors.

The DBSG 28 requests the DBKG 29 to change the database backup state to the allowed state. If the DBKG 29 changes the backup state to the allowed state, then the database request of the application is allowed. The DBSG 28 notifies the DBBG 26 that the backup permission is completed when the backup permission state is completed.

Then, the DBBG 26 changes the backup state of the backup state information relation to the allowed state and then requests the DBKG 27 to allow the OMP 23 to back up the database. Thus, when the backup permission is completed, the MMI block 25 notifies the database backup permission completion, and the MMI block 25 outputs a backup permission completion message to the MMI output window.

Finally, the database backup status output function sends the current backup status of all processors to the MMI block 25 by referring to the backup status of the backup status information relation. The MMI block 25 sends the MMI output window to the MMI output window. Will print.

3 is a general flow diagram of the backup prohibition, allowance, and status output function of a database in an electronic switchboard DBMS, a distributed real-time system.

The MMI block 21 requests the DBBG block 26 for database backup prohibition, permission, and status output processing (1). DBBG block 26 analyzes the instructions received from MMI block 25 (2). Therefore, it is determined whether or not the database backup is prohibited (33). If the backup is prohibited, the number of logs of the log spool buffer located in the DBBG block 26 is compared with a threshold to determine whether or not the backup is prohibited (34). If the backup prohibition cannot be performed, the backup prohibition failure message is transmitted to the MMI block 25 and the process ends (35). However, if it is possible to perform backup prohibition, the DBSG block 28 of all processors will not be able to transfer the database backup prohibition and the log storage buffer and transaction log table located in the DBSG block 28 to DBBG block 26. Request to send the log (36). Each DBSG block 28 then requests a backup prohibition from the DBKG block 29 for prohibiting the database backup on its processor (37). After the DBKG block 29 performs database backup prohibition (38) and informs the DBSG block 28 of the result (39), the DBSG block 28 sends the log of the log storage buffer and the transaction log table to the DBBG block ( 26) (40). When the transfer is completed, the DBBG block 26 notifies the backup prohibition completion (41). The DBB G block 26 changes the backup state of the processor whose backup prohibition is completed in the backup state information relation to the prohibition state (42), and requests the DBKG 27 to prohibit the database backup of the OMP 23 (43). If .DBKG 27 performs backup prohibition and informs DBBG block 26 of the result (44), DBBG block 26 sends the database backup prohibition complete message to MMI block 21 and terminates (45). .

If the command from the operator is not a database backup prohibition, then it is determined whether the database backup is allowed next (46). If the backup is allowed, the DBBG block 26 requests the DBSG block 28 of all processors to allow the database backup.

Each DBSG block 28 requests the DBKG 29 to perform a backup permission to allow its processor to backup the database (48). The DBKG block 29 performs the database backup permission (49) and informs the DBSG block 28 of the result (50), and the DBSG block 28 informs the DBBG block 26 of the completion of the database backup permission (50). 51). The DBBG block 26 changes the backup state of the processor that has completed the backup permission to the allowed state in the backup state information relation (52), and requests the DBKG block 27 to permit the database backup of the OMP 23 (53). . If the DBKG block 27 performs the database backup permission and notifies the DBBG block 26 of the result (54), the DBBG block 26 sends the database backup permission complete message to the MMI block 25 (55). .

Finally, if the operator command is a database backup status output, the DBBG block 26 refers to the backup status in the backup status information relation (56) and transmits the backup status of each processor to the MMI block 25 (57).

The present invention as described above has the following effects.

First, high performance backup method is adopted to improve exchanger performance. However, this may cause data inconsistency when performing functions such as system restart. Therefore, database backup prohibition function is provided to prevent data inconsistency in advance, so that it always provides accurate data. The reliability of the exchange can be improved by enabling the exchange to be operated with

Second, after confirming that the system restart of the exchange has been completed, the operator should perform the database backup allow function so that the exchange can operate normally, and provide the backup status output function to refer to the current database backup state. The efficiency of maintenance can be improved.

Claims (3)

A Man-Machine Processor (MMP) 22 that implements a Man-Machine Interface (MMI) block that matches the operator; An Operation and Maintenance Processor (OPM) 23 for mounting a Date Base Backup Group (DBBG) and a Date Base Kerne Group (DBKG); In a system having a Date Base Backup Group (DBBG) and a plurality of other processors 24 implementing a Data Base Supporting Group (DBSG), the OMP 23 is configured to determine the type of instructions received from the operator. Step 1 (31, 32, 33, 46); After the first step (31, 32, 33, 46), if the operator command is database backup prohibition, the OMP 23 requests a plurality of other processors 24 to prohibit backup, the plurality of other processors 24 A second step (34 to 45) of performing the backup prohibition of the OMP 23 itself after being informed that the backup prohibition is performed; After performing the first steps 31, 32, 33, and 46, if the operator command permits database backup, the OMP 23 requests the plurality of other processors 24 to allow the backup to allow the plurality of other processors ( A third step (47 to 55) of performing the backup permission of the OMP 23 itself after being notified of completion of the backup prohibition of 24); And after the first step (31, 32, 33, 46), if the operator command is a database backup status output, the OMP 23 refers to the backup status in the backup status information relation to the plurality of other processors ( And a fourth step (56, 57) of transmitting the backup status of the user to the operator. The method of claim 1, wherein the second steps 34 to 45 are performed by comparing the number of logs of the log spool buffer located in the OMP 23 with a threshold to determine whether or not a backup can be prevented. Step 34; After the fifth step 34, if the backup prohibition cannot be performed, the OMP 23 transmits a backup prohibition failure message to the operator and ends the sixth step 35; After performing the fifth step 34, if the backup prohibition is performed, the OMP 23 requests the plurality of other processors 24 to prohibit database backup and log transmission, and receives a request. After performing the backup prohibition, the plurality of other processors 24 transmits a log to the OMP 23 and notifies the OMP 23 of the completion of the backup prohibition, and the OMP 23 receiving the notification is backed up. A seventh step (36) of changing the backup state of the processor for which the backup prohibition is completed in the state information relation to the prohibition state, and transmitting and completing a database backup prohibition completion message to the operator after performing the OMP 23 own backup prohibition 45). A method of allowing a backup prohibition and status output of a database in a distributed real-time system, comprising: The eighth step of claim 1, wherein the third steps 47 to 55 are performed by the OMP 23 requesting the plurality of other processors 24 to allow database backup if the operator request is allowed to backup the database. Step 47; After performing the eighth step 47, the plurality of other processors 24 that have received the backup permission request perform the database backup permission and then notify the OMP 23 of the completion of the backup permission. (48 to 51); And after performing the ninth steps 48 to 51, the OMP 23 notified of the completion of the backup permission is changed from the backup status information relation to the allowed state after changing the backup state of the processor that has completed the backup permission to the allowed state. 10th step (52 to 55), which terminates after performing the database backup permission of the user and sending the database backup permission completion message to the operator, the database prohibits the backup prohibition in the distributed real-time system. And status output method.