KR100250663B1 - Database gtm management method of ess - Google Patents

Abstract

PURPOSE: A method for managing a database global transaction of a full electronic telephone exchange is provided to process transactions of many areas as one global transaction in a data management system, so as to widely expand application fields relating to distribution transaction processing and to remove burden of global transaction processing for an application programmer. CONSTITUTION: If a 'start-gtr' is started, after a GTM(Global Transaction Manager) processor is generated, a local GTM transmits a start message of a global transaction to a GTM to designate a transaction start time, a begin flag, and a time-out of the local GTM. The GTM transmits an error message to the local GTM to store the message in a local log buffer. The GTM receiving a global transaction recall request requests a recall to the local GTM with a set abort-flag of the local GTM. The local GTM recovers a local log buffer. If the recall is transmitted to the local GTM, the local GTM checks whether a global transaction is recalled. The local GTM stores log backup data in a backup database, and transmits an 'end-gtr' message to the GTM. The GTM sets up an end flag and transmits an 'ACK' message to the local GTM. If the 'ACK' message is not transmitted, a step of requesting an 'abort-gtr' execution is reperformed. If the 'ACK' message is transmitted, the local GTM updates the 'ACK' message in the backup database.

Description

How to manage database global transactions in the electronic exchange

The present invention relates to a Full Electronic Telephone eXchange, and more particularly, to a database-wide transaction management method of an electronic exchanger that can be applied to a database system based on a distributed real-time structure so that it can be extended to a general distributed real-time database system. It is about.

In general, an electronic switching system includes an Access Switching Subsystem (abbreviated ASS) and an Interconnection Network Subsystem (abbreviated INS) and a Central Control Subsystem. Hereinafter, referred to as CCS), each having a database system for management.

ASS is equipped with subscriber and relay signal service matching (Local Service Interface), time switch, Frame Relay Handler, optical subscriber access device, various signaling devices, packet handler, etc. It performs its own operation and maintenance function, and if necessary, it has a horizontally distributed structure as it increases in units of ASS.

INS connects ASS ₀ and ASSn with each other or between ASS and CCS, and performs the function of generating and distributing the system clock with number translation, route control, space switch network control and network device. The ASS is connected to an external subscriber by using a fiber link or a data link.

CCS is a device that performs overall operation and maintenance of the system, and performs network management, test and measurement, billing statistics, I / O device control, and dialogue with other systems.

As described above, the ASS and the INS are interfaced using an optical fiber element, and the interface with the CCS uses an internal processor communication.

The database management system used in the conventional electronic switchboard has both the characteristics of a real-time database and the characteristics of a distributed database system.

Among them, kernel-level transactions are supported to maintain consistency of redundant and distributed data in the characteristics of distributed database system.

However, there is a problem that only local transactions of different sites are supported at the user level, and global transactions that process such local transactions as one transaction are not supported.

SUMMARY OF THE INVENTION The present invention has been made to solve such a problem, and its purpose is to process local transactions of different sites as a single global transaction at the user level, to simplify such global transactions, and to provide a consistent synchronization technique for processing global transactions. It is to provide a database-wide transaction management method of an electronic switch to provide a.

The present invention for achieving the object relates to a database global transaction management method of the electronic switchboard, when the database management system is driven, generating a global transaction manager processor; When the start GTial is started, the local global transaction manager forwards a message to the global transaction manager indicating the start of the global transaction; The global transaction manager determines a transaction start time, an empty flag, and a timeout time of the local global transaction manager, and forwards the acknowledge message to the local global transaction manager; The local global transaction manager determines whether the Ack message has arrived normally and if so does not time out; If the Ack message arrives normally, the local global transaction manager receives the Ack message and stores the log record in a local log buffer; The global transaction manager, which has been requested to withdraw the global transaction by the Ever GTial execution request, sets an Ever flag of the local global transaction manager; Upon requesting revocation from the local global transaction manager, the local global transaction manager recovers using the local log buffer; Checking to the local global transaction manager for revocation at the global transaction manager level, checking whether the local global transaction manager has been withdrawn; Storing log backup data contents in a backup database by an end digital request; Forwarding the end digital signal to the global transaction manager, the global transaction manager setting an end flag of the local global transaction manager; Ascertaining that it is a local global transaction manager and transmitting an Ack signal to the local global transaction manager; If an ACK signal is not forwarded to the local global transaction manager, re-executing the request for Ever GTial execution; When an ACK signal is sent to the local global transaction manager, the local global transaction manager receives the ACK signal and includes updating the backup database.

1 is a block diagram of a database global transaction management method of an electronic switch according to the present invention;

2 is a detailed flowchart of the present invention for a database global transaction management method of an electronic switchboard.

<Description of the code | symbol about the principal part of drawing>

10: ASS ₀ 12: AP

14: LDB 16: DBMS

20: ASS _n 22: AP

24: LDB 26: DBMS

30: INS 40: CCS

42: AP 44: LDB

46: DBMS 50: Backup DB

Hereinafter, the objects and features of the present invention will be described in more detail with reference to the accompanying drawings so that the objects and features of the present invention can be more clearly understood.

1 is a block diagram of a database global transaction management method of an electronic switch in accordance with the present invention, ASS ₀ (10), Application Programs (hereinafter abbreviated as AP) 12, and a local database ( Local Database (hereinafter abbreviated as LDB) 14, Database Management System (hereinafter abbreviated as DBMS) 16, ASS _n 20, AP 22, LDB 24, the DBMS 26, the INS 30, the CCS 40, the AP 42, the LDB 44, the DBMS 46, and the backup DB 50. As shown in FIG.

ASS ₀ (10) is equipped with subscriber and relay line matching, time switch, various signaling devices, packet handler, etc. to perform most call processing functions and self-operation maintenance functions, and thus has a horizontally distributed structure. Up to 63 ASS ₀ to ASS ₆₂ can be connected to the INS 30, and the transmission medium with the INS 30 is called an optical link, so it is called a data link.

In addition, a digital subscriber interface of the Integrated Services Digital Network, SS NO.7 signaling device, packet processor function, network interworking device function, etc. are provided to enable the exchange function, and an access switching processor (not shown) Access Switching Processor (hereinafter abbreviated as ASP).

Among them, ASP 0 to _n are processors inside ASS ₀ to n, which perform traffic control, SS NO.7 maintenance, ASS maintenance and operation management, and other services, and transmit them to the INS 30 through the optical fiber link. .

Inside ASS ₀ (10) includes AP 12, LDB 14, and DBMS 16. AP 12 is an application that supports global transactions that process local transactions as a single transaction. It is a program that works by interfacing with the DBMS 16 so that the system can be expanded. The DBMS 16 is a database management system, and the LDB 14 which is an S-RAM capable of storing logs internally. The system is interfaced to manage various types of data. The LDB 14 is a local database, which is interfaced with the DBMS 16 to store various types of data and transmits the data to the CCS 40 through the INS 30.

In addition, the ASS _N 20 includes an AP 22, an LDB 24, and a DBMS 26. The AP 22 is an application program that executes a global transaction that processes a local transaction as a single transaction. It is a program that works by interfacing with the DBMS 26 to expand the system by supporting it. The DBMS 26 is a database management system, and an LDB (24) which is an S-RAM capable of storing logs internally. LDB 24 is interfaced with the DBMS 26 to store a variety of data to the CCS 40 through the INS (30).

INS (30) performs a function that was located in the center of the system connecting the _{ASS 0 (10) ~ ASS n} (20) each other or ASS _0~n the CCS (40).

The switch network has a TST switch structure, and the space switch is located in the INS 30, and the time switch is configured in ASS ₀ to n.

Among the call processing functions, it can be equipped with a network synchronizer by performing centralized functions such as number translation, route control function, and space switch connection, and is responsible for generating and distributing a system clock. Processor (hereinafter abbreviated as INP).

The INP is a processor existing in the INS 30 and performing a search and management through a call using a space switch to transmit various information into the CCS 40 through internal processor communication.

The CCS 40 includes an AP 42, an LDB 44, and a DBMS 46. The AP 42 is an application program that supports a global transaction that processes a local transaction as a single transaction. The program is interfaced with the DBMS 46 to extend the DBMS 46, and the DBMS 46 is a database management system, which interfaces with the LDB 44, which is an S-RAM capable of internally storing logs. The LDB 44 is a local database, which is interfaced with the DBMS 46, stores various data, and transmits the data to the backup DB 50 which can be backed up as a whole. Save the memories.

A block diagram of a database global transaction management method of an electronic switchgear according to the present invention configured as described above has been described, and FIG. 2 illustrates a detailed flowchart of the database global transaction management method of an electronic switchgear.

The database management system is divided into operations that are offline and operations that are online. First, three commands for global transactions for processing global transactions are described.

The first command of the global transaction, start-gtr, the gtr-ID time-value, indicates the beginning of a global transaction. The GTID is a transaction from different sites, but a single transaction. Transactions with the same GTID ID are treated as one transaction.Time Bell is a real-time system, so when the transaction processing exceeds the given time, this time constraint is defined by the user as it loses its meaning as a transaction. To do that.

The second command in the global transaction, abort-gtr, is used when a global transaction must be withdrawn while processing a transaction within a site. If a request is made to a site, the local transaction has been withdrawn. It returns to the state before the global transaction was executed.

The third command of the global transaction, end-gtr and gtr-ID, indicates that one part of the global transaction represents the completion of a local transaction. When all arrives, it records the changes in the database.

As described above, the global transaction command is described to process the global transaction. Next, the operation in the offline mode is described. In the preprocessing of the query, data for global transaction processing is constructed, and the global transaction processing command is applied offline. Used within a program, the query is changed to the host language when the database preprocessor is first run to make the application executable.

In addition, the host language is again executable code by the host language compiler, information about the global transaction is collected when preprocessing of the database instructions, and the location and number of sites participating in the global transaction by collecting the table 1 Stored in the relation as

* Information table for the entire global transaction Gtr ID Number of Candidates Registered Global Transaction ID The number of transactions using the same digital ID

* Information table for participating transactions

Gtr ID Local-GTM Address Time-value Global transaction ID Site address of local transaction participating in global transaction Time from transaction start to timeout

The application is written, compiled, and operated on-line. When the database management system is started on-line (step 200), the global processing manager ( Global Transaction Manager (hereinafter abbreviated as GTM) processor is generated (step 201).

Here, the local GTM is the site address for the participating transaction managed by the GTM, and each local GTM determines the time (s-time) at which the transaction started and the time (t-out) at which timeout ends.

When start-gtr is started at the AP of the ASS (step 202), the local GTM sends a message to the GTM indicating the start of the global transaction (step 203).

The GTM establishes the transaction start time, Begin flag, and time out (t-out) time of the local GTM and forwards the ACK message to the local GTM (step 204).

The local GTM determines if the ACK message has arrived normally (step 205) and if it does not arrive, times out (step 206) and ends.

If the ACK message arrives normally, the local GTM receives the ACK message and stores the log record in the local log buffer (step 207).

When withdrawing the global transaction from the AP of the ASS, it requires the execution of abort-gtr (step 208).

The GTM requested to withdraw the global transaction sets the Everflag of the local GTM (step 209).

The local GTM is requested to withdraw first and the local GTM recovers using the local log buffer (step 210).

When each local GTM is passed a revocation at the GTM level (step 211), it is checked whether all local GTMs have been withdrawn (step 212).

When the end-gtr is requested from the AP in the ASS (step 213), the log backup data contents are stored in the backup database by the end-TG request (step 214).

Next, when the AND GTIAL message is delivered to the GTM (step 215), the GTM sets the end flag of the corresponding local GTM (step 216).

Confirm that it is the last local GTM and send an Ack signal to all local GTMs (step 217).

If not in the determination of whether the Ack signal has been delivered to the local GTM (step 218), then execute again (step 208).

If an ACK signal is delivered to the local GTM, the local GTM receives the ACK signal and updates the backup database (step 219).

Therefore, whenever a request for Start GTial and End GTIAL is sent from the local GTM, the GTM checks whether there is a transaction corresponding to the timeout, and if so, requests the participating local GTM to withdraw.

The local GTM is requested to withdraw from the GTM, keeps a log of the data until the end of the global transaction, withdraws itself if there is no request for the end of the global transaction by the timeout, and sends a withdrawal request to the GTM. By returning the log, the GTM periodically monitors the local GTM to avoid inconsistencies in the error of message transmission due to communication failure.

As described above, the present invention described above processes multiple local transactions as one global transaction in the database management system of the electronic switchboard, thereby broadly expanding the application field for distributed transaction processing, and providing application programmers with global transaction processing. This can remove the burden and improve the performance of the database management system.

Claims (1)

In the method of managing a database global transaction of an electronic switchgear having a start digital, an Ever digital, a global transaction manager, a local global transaction manager, and a backup database, Generating the global transaction manager processor when the database management system is driven; When the start digital is started, the local global transaction manager forwards a message to the global transaction manager indicating the start of the global transaction; The global transaction manager determining a transaction start time, an empty flag, a timeout time of the local global transaction manager, and forwarding an acknowledge message to the local global transaction manager; The local global transaction manager determines whether the Ack message has arrived normally, and if it does not arrive, time-out; If the Ack message arrives normally, the local global transaction manager receives an Ack message and stores a log record in a local log buffer; Setting, by the global transaction manager, an Ever flag of the local global transaction manager, the global transaction manager being requested to withdraw the global transaction by the Ever GTial execution request; Upon requesting revocation of the local global transaction manager, the local global transaction manager recovers using a local log buffer; Checking if the local global transaction manager has been withdrawn when forwarding to the local global transaction manager for revocation at the global transaction manager level; Storing log backup data contents in the backup database by the end-tial request; Forwarding the end digital message to the global transaction manager, the global transaction manager setting the end flag of the local global transaction manager; Confirming whether the local global transaction manager is present, and transmitting an ACK signal to the local global transaction manager; Redeploying the step of requesting the execution of the EBT, if an ACK signal is not sent to the local global transaction manager; And if the ACK signal is transmitted to the local global transaction manager, the local global transaction manager receives the ACK signal and updates the backup database.

Images