KR20010039125A - Synchronization system of remote database by transaction transmission - Google Patents

Abstract

PURPOSE: A distributed database synchronization system is provided to synchronize the information shared by systems with independent databases, specially by transmitting or receiving transactions generated or updated in local databases of each computer. CONSTITUTION: The system comprises a plurality of computers(100), a local database(200) and a transaction management system(300). The computers(100) are geographically distributed but connected via a network. The transactions, generated at the local database(200), are transmitted to the transaction management system(300) to synchronize the database among the computers(100). The computer(100) includes a transaction storage module(101), a communication processor(102), a log management module(103), and a script write-out module(104). The transaction storage module(101) stores the transaction data, generated in the database, at a transaction file by referring to the data in a configuration file. The communication processor(102) communicate the transaction file with the transaction management system(300).

Description

Synchronization system of remote database by transaction transmission

The present invention relates to a system for synchronizing distributed databases through transactional transmission that enables geographically distributed and synchronized information shared between systems with independent databases to transactional transmission.

Conventionally, as a database synchronization method in a geographically dispersed computing environment, a file system is used for data management of a database system, and each application programmer uses the data definition language as a data definition language. It is defined as).

Therefore, there is a problem that duplicated declarations are made in various systems for data having the same function and characteristics, and thus, a problem of not getting complete data without wasting time and redundancy required to define each data has occurred. In addition, since the amount of system data is rapidly increased due to an increase in demand for communication technology and an increase in demand for providing various services, a lot of overload occurs.

Also, considering a relational database, multiple computers each store and manage the same relation in the same local database, with the same name and attributes.

Because the accuracy of the data stored in each computer's database in such a computing environment is an issue, it is important to ensure that the data referenced by each computer matches and is up-to-date with data stored on other computers on the network. Can be.

If the data referenced by a computer's process does not reflect recent changes, then the results of subsequent processing are unreliable, and these problems occur in real time as data related to financial problems (financial institutions, etc.). In the case where reference is made (creation, deletion, change) of data, the severity and importance increase.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems. In the distributed computing environment, the information shared between systems having independent databases is transmitted and received in real time to a database of a networked computer system in real time. If the same data exists in the database and needs to refer to the change in real time, it is distributed through transaction transmission to improve the accuracy and reliability of the data by reflecting the final information in real time. Its purpose is to provide a synchronization system for the database.

1 is a block diagram of a synchronization system of a distributed database through transaction transmission according to the present invention.

Fig. 2 is a detailed block diagram of each computer and transaction management system in Fig. 1;

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

100 ... Computer 200 ... Database

300 ... Transaction Management System 101 ... Transaction Storage Module

102,301 ... Communication Processor 103,304 ... Log Management Module

Scripting Module 105 Database Management System

302 ... Transaction analysis module 303 ... Transmission result confirmation module

305 ... retransmission section 102a, 301c ... transmission module

102b, 301d ... Transmission result Receiving module 102c, 301a ... Receiving module

102d, 301b ... Receive Result Sending Module 305a ... Result Processing Module

305b ... resend module 305c ... resend module

The synchronization system of the distributed database through the transaction transmission according to the present invention for achieving the above object,

When a new data transaction occurs in a relation that requires synchronization from a geographically dispersed database, the transaction is saved and transmitted to the network so that the result of receiving the transaction through the network can be reflected in the database. A plurality of computers (Remote Computer);

And a transaction management system for receiving the computer information and the transaction transmitted from the computer and transmitting a new transaction to manage information on the database.

Each computer includes a transaction storage module that stores transaction information generated in a database in a transaction file, a communication processor that transmits and receives a transaction with the transaction management system, and transmits and receives a result of the transaction, and various types of transmission and reception of the communication processor. Log management module that stores the work results in a log file, a script writing module for writing a script to reflect the received transaction to the database and supporting the reflected in the database, and from the script writing module It includes a database management system that reflects the written script to the database and manages the database.

Here, the communication processor of each computer includes a transmitting module for transmitting a transaction to a transaction management system, a transmission result receiving module for receiving the transaction transmission result, a receiving module for receiving a transaction for another computer from the transaction management system; And a reception result transmission module for transmitting the reception result.

On the other hand, the transaction management system, a communication processor for receiving and transmitting a transaction generated in each computer and transmitting the transmission and reception results, and a transaction analysis module for analyzing a transaction received by the communication processor and selecting a target computer to transmit it And a transmission result confirming module for receiving a transaction transmission result from the communication processor and confirming transmission and selecting information to be reprocessed, a transaction log module for storing transaction related logs, and storing a transaction to be resent in a transaction file. And a resending unit that reads the information to be resent and retransmits it to the target computer.

Here, the communication processor of the transaction management system includes a reception module for receiving a transaction from each computer, a reception result transmission module for transmitting the reception result, a transmission module for transmitting a transaction, and a transmission result for receiving a transaction transmission result Characterized by including a receiving module,

The resending unit transmits a result processing module for storing a transaction to be retransmitted in a transaction file, a retransmission support module for retransmitting by reading information to be retransmitted from the transaction file, and a transaction file read by the retransmission support module to a computer. Characterized in that it comprises a retransmission module.

Referring to the accompanying drawings, a database synchronization system using a transaction of the present invention configured as described above is as follows.

1 is a block diagram of a synchronization system of a distributed database through transaction transmission according to the present invention, and FIG. 2 is a detailed block diagram of a computer and a transaction management system in FIG.

First, referring to FIG. 1, a plurality of geographically dispersed computers 100 are interconnected to a network, and a unit of work generated in a local database 200 of each computer 100, that is, a transaction connected on a network. By transmitting to the management system 300, the database is synchronized with other computers.

Referring to FIG. 2, each computer 100 refers to a transaction storage module 101 for storing transaction information generated in the database 200 in a transaction file F2 with reference to information stored in the configuration file F1, and transaction management. A communication processor 102 comprising modules 102a, 102b, 102c, and 102d that transmits and receives transaction information with the system 300 and responds to the results of the transmission and reception, and logs the operation results of the transmitted and received transactions. Log management module 103 to store in the file (F3), and the database management system (DBMS) 105 to create a script using the received transaction information to be reflected in the database (DB; Database) (200) It consists of a script writing module 104 to pass on.

In the configuration file F1 of each computer 100, information on the type of transaction to be transmitted and the relation information is registered.

The transaction management system 300 transmits and receives transaction information, and transmits and receives the received transaction information to the communication processor 301 including modules 301a, 301b, 301c, and 301d that respond to the transmission and reception results. A transaction analysis module 302 for analyzing and selecting a target computer to transmit a transaction from the configuration file F4 to the communication processor 301, a transmission result checking module 303 for confirming a transmission result of the transaction, and A transaction log module 304 for storing transaction related logs in a log file (F5), and a module (305a) for selecting information to be reprocessed after receiving the transaction transmission result, storing the transaction in a transaction file (F6), and then resending ( It consists of a retransmission section 305 consisting of (305b) (305c).

Here, the configuration file F4 records relation information in the computer and local database necessary for selecting a transaction transmission target and information related to retransmission.

The transaction refers to any transaction that affects the contents of the data file, that is, all operations such as goods receipt and release, sale, return, deposit and withdrawal, correction, and loss, or unit operations to be processed by the computer. The transaction files F2 and F6 are files that are represented and stored using a language defined to reflect the unit work in the database.

The log files (F3) and (F5) are records of transaction transmission and reception results as contents, and the logs are records of system processing and activities over time. Or to cause, identify, and restore the log file.

Hereinafter, a database synchronization system through transaction transmission in the distributed computing environment of the present invention will be described with reference to the accompanying drawings.

First, referring to FIG. 1, each geographically dispersed computer 100 is interconnected on a network to store a unit of work generated in its local database 200, that is, a transaction, in a transaction file. .

In this context, a transaction refers to a unit of work that handles all transactions that affect the contents of a data file: incoming and outgoing, sales and returns, deposits, withdrawals, corrections, or losses. These operations are usually simple and have a long processing time. It is short and entered in standard form.

Transaction files are files that store data such as transactions that change relatively well when processing data.

In this case, when a transaction is stored in the transaction file, the communication processor transmits a real time transaction to the transaction management system 300 connected on the network, receives the transaction transmission result, and records the result in a log.

Then, the transaction management system (TMS) 300 which receives a transaction from any computer 100 responds to the reception result, analyzes the received transaction using a configuration file, and then executes the transaction. Select the computers to which you want to send.

Here, the configuration file records computer information necessary for selecting a transaction transmission target, relation information in a local database, and information related to retransmission.

If the target computer is selected, the transaction is sent to the target computer. If there is a response to the transmission, the result is stored in a log file. If there is no response, the transaction is stored in the transaction file. Resend after generating a log related to retransmission.

The target computers 100 that have received the transaction transmitted from the transaction management system 300 respond to the received message, record the contents in a log file, write a script to reflect the received transaction, and then write a database ( Reflect the results).

As such, the transaction management system 300, which transmits and receives transactions occurring between systems having geographically dispersed and independent databases in real time to other computers on the network, manages each computer information and database information, thereby providing data between computer systems. If you need to share the data in real time, you will implement accurate synchronization of the database.

For this purpose, it will be described in detail with reference to FIG.

When a transaction occurs that creates, deletes, or changes new data in a relation that requires synchronization in any computer 100, the transaction store module (TSM) 101 is transferred to the configuration file F1. Reads information of transaction type and relation to send and stores the transaction information in transaction file (F2).

In this case, when transmitting a transaction, the communication processor 102 of the computer 100 checks the state of the transaction file F2 and then inputs information on a transaction to be transmitted through the network. And transmit the result of the transmission from the transaction management system 300 to the log management module 103 and record the result in the log file F3.

That is, the transaction transfer module (TTM) 102a of the communication processor 102 checks the status of the transaction file and transmits the transaction to the transaction management system 300 when information about the transaction is input. The transmission result receiving module (TTRM) 102b receives the transmission result of the transaction from the transaction management system 300.

Then, the transmission result receiving module 102b of the communication processor 102 receives the transaction transmission result and then informs the transmission module 102a of the transaction transmission result, and transmits the transaction transmission result to the log management module 103.

Then, the log management module (TLM) 103 logs the transaction transmission results in a log file F3 in order to log various work results in a log.

On the other hand, when receiving a transaction, the communication processor 301 of the transaction management system 300 receives a transaction from the communication processor 102 of the computer 100 and transmits it to the transaction analysis module 302, and the transaction Answer the received result of the computer 100.

That is, the receiving module 301a of the communication processor 301 receives the transaction transmitted from the transmitting module 102a of the computer 100 and transmits the result to the receiving result transmitting module 301b, and receives the receiving result transmitting module ( 301b) transmits and transmits to the transmission result receiving module 102b of the corresponding computer 100 in response to the reception result.

The Transaction Analysis Module (TAM) 302 selects target computers to be analyzed, extracted, and transmitted by the configuration file F4 by name and computer information of a relation that should reflect the received transaction. .

Here, the configuration file F4 records relation information and retransmission information in the computer and local database necessary for selecting a transaction transmission target.

When the target computer to which the transaction is to be transmitted is selected, the transaction analysis module 302 transfers the transaction information and the corresponding computer information to the communication processor 301.

At this time, the communication processor 301 of the transaction management system 300 transmits the transaction information to the computer using the transaction information and the corresponding computer information transmitted from the transaction analysis module 302 in transmitting a transaction, The transmission result is received.

That is, the transmission module (TTM) 301c of the communication processor 301 transmits transaction information to the communication processor 102 of the computer 100 using the corresponding computer information, and transmits the result to a transmission result receiving module (TTRM) ( 301d).

When the transmission result reception module 301d of the communication processor 301 receives the transmission result and transmits the result to the transmission result confirmation module 303, a transmission result confirmation module (TTCM) 303 ) Confirms transmission.

At this time, if the transmission result of the confirmation result of the transmission result confirming module 303 is successful, the relevant information is passed to the log management module (TLM) 304 and the contents thereof are recorded in the log file F5.

However, if the transaction transmission fails as a result of the confirmation of the transmission result confirming module 303, the relevant information is transferred to the transaction log module 304, the contents thereof are recorded in the log file F5, and the retransmission unit 305 is provided for retransmission. Run it.

The retransmission unit 305 stores the transaction file F6 to be retransmitted and then retransmits the transaction information to the computer that failed.

If the result processing module (RPM) 305a of the retransmission unit 305 stores the transaction to be retransmitted in the transaction file F6, the transaction is transmitted in the re-transfer support module (RTSM) 305b. If there is information to be retransmitted while checking the information of the file F5, the retransmission information is read and transmitted to the retransmission module 305c, and the log related to the retransmission is transferred to the log management module 304 to the log file F5. Let it be recorded.

Then, the Re-Transfer Module (RTM) 305c reads the information necessary for retransmitting the transaction from the configuration file F4, and transmits the communication processor of the computer 100 through the transmission module 301c. 102, and if the transmission is not performed again, the above operation is repeated.

On the other hand, the communication processor 102 of the computer 100 receives a transaction from the communication processor 301 of the transaction management system 300 in response to receiving the transaction, and responds to the reception result, the log file (F3) Will be recorded.

That is, the receiving module (TRM) 102c of the communication processor 102 receives a transaction transmitted from the transmitting module (TTM) 301c of the transaction management system 300 and receives the result thereof. And the reception result transmission module 102d transmits the reception result to the transmission result reception module 301d and notifies the result.

In addition, the receiving module 102c transmits the contents of the transaction reception result to the log management module 103 and records the result in the log file F3, and writes the script writing module MSM to reflect the received transaction in the database. ; Make Script Module) 104 to write the script.

The script created by the script creation module 104 is transferred to a database management system (DBMS) 105, and the database management system 105 reflects the data on the received transaction in the database 200. To be possible.

Here, it is assumed that the database management system 105 used by each computer 100 is the same.

As such, the transaction management system 300 implements synchronization using transaction transmission / reception to process data, not data actually stored in the database, so as to manage each computer information and transaction information about the database of the computer in real time.

Therefore, when a transaction that generates, deletes, or changes new data in a relation requiring synchronization in each computer 100 occurs, the transaction management system 300 generates and deletes data in real time to different computers. Or, by transmitting changed data, the data stored in the distributed database is reflected as the latest or last, so that the data referenced by each computer will always match the data stored in other computers on the network.

As described above, the present invention ensures the accuracy of data by sending and receiving transactions and always refers to the final data information when data must be shared between geographically dispersed systems in real time, thereby improving reliability of the database. In addition, it has the effect of resolving the identification of data to be shared in real time and synchronization of the system for transaction transmission and reception.

Claims (4)

A plurality of computers that store and transmit new data when a transaction occurs in a relation in its local database in a geographically distributed computing environment, and receive and reflect the transaction in a database for database synchronization; Receives the transaction sent from the computer for synchronization of the distributed local database, extracts computer information and relation information that should reflect the received transaction, selects the computer to which the transaction is sent, and transmits the received transaction. A system for synchronizing distributed databases through transaction transmission, comprising a transaction management system. The method of claim 1, Each of the computers includes a transaction storage module that stores transaction information generated in a database in a transaction file, a communication processor that transmits and receives a transaction and responds to a result of transmission and reception, and various operation results according to transmission and reception of the communication processor in a log file. It includes a log management module for storing, a script writing module for writing a script to reflect the received transaction in the database, and a database management system for reflecting the script created from the script writing module to the database and manages the database. A distributed database synchronization system through transaction transmission. The method of claim 1, The transaction management system includes a communication processor for receiving and transmitting a transaction generated in each computer and responding to the result of transmission and reception, a transaction analysis module for analyzing a transaction received by the communication processor and selecting a target computer to transmit the transaction; After receiving a transaction transmission result from the communication processor to confirm whether the transmission result transmission module, a transaction log module for storing the transaction-related log, and receives the information from the transmission result confirmation module and stores the transaction to be retransmitted A distributed database synchronization system through transaction transmission, comprising: a retransmission unit for retransmitting information to be retransmitted to a target computer. The method of claim 3, wherein The resending unit, a result processing module for storing a transaction to be resent in a transaction file when the transaction transmission fails, and a retransmission to transfer the transaction information to be retransmitted in the stored transaction file and to record a log related to the retransmission And a retransmission module for reading the computer information and relation information necessary for retransmission and retransmitting the transaction information.