US20190138535A1 - Real-time integrated replication system between databases - Google Patents
Real-time integrated replication system between databases Download PDFInfo
- Publication number
- US20190138535A1 US20190138535A1 US15/770,214 US201715770214A US2019138535A1 US 20190138535 A1 US20190138535 A1 US 20190138535A1 US 201715770214 A US201715770214 A US 201715770214A US 2019138535 A1 US2019138535 A1 US 2019138535A1
- Authority
- US
- United States
- Prior art keywords
- replication
- data
- module
- transaction
- integrated
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/273—Asynchronous replication or reconciliation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/178—Techniques for file synchronisation in file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
Definitions
- the present invention relates to an integrated replication system and, more particularly, to a real-time integrated replication system between heterogeneous databases for switching, transfer and integration between various databases, and to research result of “s/w technical development for real-time data extraction, cleaning and replication between various heterogeneous databases.
- An object of the present invention is to overcome a limit that the replication solution of a database does not support the real-time replication of a heterogeneous database and to provide a system capable of maintaining the continuity of business by replicating data in real time.
- Another object of the present invention is to provide a system capable of minimizing a load of a database server and a network through a technology for guaranteeing the consistency of replicated data and a changed data replication technology.
- Yet another object of the present invention is to provide a system capable of enhancing the availability of data by enabling the real-time verification of the consistency of data and real-time correction of data.
- An integrated replication system may include a reader configured to collect information including a transaction or QSL information indicative of data changes of a source system, a storage module configured to store the information collected by the reader, a replication module configured to replicate change data of the source system to the target system through a first replication method or a second replication method, and a selection module configured to control the replication module in order to selectively apply any one of the first replication method and the second replication method according to a predetermined criterion.
- the replication module includes a first replication module configured to execute the first replication method and a second replication module configured to execute the second replication method.
- the first replication module may extract data of the source system for each transaction and replicate change data of the source system to the target system when Commit is executed for the source system so that a transaction is completed.
- the second replication module may extract data of the source system for each SQL, may capture and extract the data of the source system for each SQL, may transmit a corresponding log to the target system, and may replicate change data of the source system to the target system when Commit is executed.
- the selection module may first execute the first replication module, and may change a replication method by selecting and executing the second replication module if a predetermined criterion is satisfied.
- the selection module may include a transaction determination module configured to determine whether an amount of transaction data transmitted from the source system to the target system exceeds a predetermined amount of data by comparing the amount of transaction data with the predetermined amount of data and a control module configured to drive the second replication module in order to select the second replication method if, as a result of the determination of the transaction determination module, the amount of transaction data exceeds the predetermined amount of data.
- a transaction determination module configured to determine whether an amount of transaction data transmitted from the source system to the target system exceeds a predetermined amount of data by comparing the amount of transaction data with the predetermined amount of data
- a control module configured to drive the second replication module in order to select the second replication method if, as a result of the determination of the transaction determination module, the amount of transaction data exceeds the predetermined amount of data.
- control module may stop the driving of the first replication module in order to change the replication method from the first replication method to the second replication method when driving the second replication module.
- control module controls the replication module so that an identifier is attached to the transaction in order to distinguish between transactions.
- the deletion module searches for a final identifier which belongs to identifiers attached after the transaction and which is lastly attached, and deletes subsequent data.
- An advantage of the present invention is to overcome a limit that the replication solution of a database does not support the real-time replication of a heterogeneous database and to provide a system capable of maintaining the continuity of business by replicating data in real time.
- Another advantage of the present invention is to provide a system capable of minimizing a load of a database server and a network through a technology for guaranteeing the consistency of replicated data and a changed data replication technology.
- Yet another advantage of the present invention is to provide a system capable of enhancing the availability of data by enabling the real-time verification of the consistency of data and real-time correction of data.
- Another advantage of the present invention is to replicate change data correctly, by deleting data after a specific point of time when a change of the replication method is generated.
- FIG. 1 is a diagram for illustrating an integrated replication system according to an embodiment of the present invention.
- FIG. 2 is a block diagram for specifically illustrating the integrated replication system of FIG. 1 .
- FIG. 3 is a block diagram for specifically illustrating a selection module of FIG. 2 .
- FIG. 4 is a diagram for illustrating a first replication method of the integrated replication system according to an embodiment of the present invention.
- FIG. 5 is a diagram for illustrating a second replication method of the integrated replication system according to an embodiment of the present invention.
- FIGS. 6 and 7 are diagrams for illustrating an integrated replication method according to an embodiment of the present invention.
- FIG. 8 is a diagram for illustrating an integrated replication method when a replication method according to an embodiment of the present invention.
- FIG. 9 is a flowchart illustrating an integrated replication method when a replication method is changed according to an embodiment of the present invention.
- FIG. 1 is a diagram for illustrating an integrated replication system according to an embodiment of the present invention, and schematically shows a replication environment according to an embodiment of the present invention.
- the integrated replication system 300 is connected to a source system 100 and a target system 200 over a network 400 , and performs the replication of data from the source system 100 to the target system 200 .
- the network 400 may include a communication link known to a person having ordinary skill in the art, such as the Internet or a computer network.
- the network may include a telephone or a cable service, a wired or satellite service, etc.
- the source system 100 and the target system 200 configure and store data according to a database management system (DMBS).
- DMBS database management system
- the integrated replication system 300 captures a change of data in the source system 100 , selects a first replication method or a second replication method for the change, and transmits the data to the target system 200 through the selected replication method, so the data of the source system 100 and the data of the target system 200 are synchronized.
- the integrated replication system 300 may provide a load balancing function based on the hardware and software elements of various computing apparatus or system. Furthermore, the integrated replication system 300 may provide a broadcast or integration function in which a local copy is synchronized with the central copy of a database and vice versa.
- the integrated replication system 300 is described in detail below.
- FIG. 2 is a block diagram for specifically illustrating the integrated replication system of FIG. 1 .
- the integrated replication system 300 includes a reader 310 , a replication module 320 , a selection module 330 , a storage module 340 , and a deletion module 350 .
- the replication module 320 includes a first replication module 321 and a second replication module 323 .
- the reader 310 may analyze log files of the source system 100 .
- the reader 310 may collect a transaction or QSL information indicative of data changes of the source system 100 , and enables the collected information to be stored in the storage module 340 .
- the replication module 320 replicates change data of the source system 100 to the target system 200 through a specific method (e.g., a first replication method or a second replication method).
- a specific method e.g., a first replication method or a second replication method.
- the first replication module 321 may extract data of the source system 100 for each transaction. For example, when Commit that instructs the source system 100 so that a transaction is completed is executed, the first replication module 321 replicates change data of the source system 100 to the target system 200 .
- the first replication module 321 transmits a corresponding committed log to the target system 200 so that change data corresponding to the committed log is applied and replicated to the target system 200 .
- the first replication module 321 extracts the change data and transmits a corresponding committed log to the target system 200 so that the change data is applied, that is, replicated to the target system 200 .
- the first replication module 321 has an advantage in that unnecessary rollback data transmission is not generated, but when a large amount of transactions is generated, a second method may be selected under a specific condition by taking into consideration an increase of an instant load and reflection time.
- the second replication module 323 may extract data of the source system 100 for each SQL. For example, data of the source system 100 is captured and extracted for each SQL, and a corresponding log is transmitted to the target system 200 .
- the second replication module 323 applies the change data of the source system 100 to the target system 200 , that is, the change data is replicated to the target system 200 .
- the second replication module 323 transmits the log of data extracted for each SQL to the target system 200 . Thereafter, when Commit is executed, the second replication module 323 applies change data corresponding to the committed log to the target system 200 so that the change data is replicated to the target system 200 .
- the selection module 330 may select and execute one of the first replication module 321 and the second replication module 323 in order to selectively apply the first replication method and the second replication method situationally according to a predetermined criterion.
- the selection module 330 may be configured to basically execute the first replication module 321 first and to select and execute the second replication module 323 if a predetermined criterion is satisfied.
- the deletion module 350 searches for the final identifier attached to the end of one transaction and deletes subsequent data.
- replication is performed by the second replication method, data is extracted for each SQL and a corresponding data log is transmitted to the target system 200 . Accordingly, if a change into the first replication method of transmitting data for each transaction is generated, the deletion module 350 searches for the final identifier ID_ 2 and deletes subsequent data.
- FIG. 3 is a block diagram for specifically illustrating a selection module of FIG. 2 .
- the selection module 330 includes a transaction determination module 331 and a control module 333 .
- the transaction determination module 331 determines whether the amount of transaction data transmitted from the source system 100 to the target system 200 exceeds a predetermined amount of data by comparing the amount of transaction data with the predetermined amount of data.
- control module 333 drives the second replication module 323 in order to select the second replication method.
- control module 333 changes a replication method from the first replication method to the second replication method, thereby stopping the driving of the first replication module 321 and activating the second replication module 323 .
- FIG. 4 is a diagram for illustrating the first replication method of the integrated replication system according to an embodiment of the present invention.
- the first replication method is executed by the first replication module 321 of the integrated replication system 300 shown in FIG. 2 .
- the first replication module 321 may extract data of the source system 100 for each transaction. For example, when Commit that instructs the source system 100 so that a transaction is completed is executed, the first replication module 321 replicates the change data of the source system 100 to the target system 200 .
- the first replication module 321 transmits a committed log to the target system 200 so that change data corresponding to the committed log is applied and replicated to the target system 200 .
- the first replication module 321 extracts the change data and transmits a corresponding committed log to the target system 200 so that the change data is applied, that is, replicated to the target system 200 .
- FIG. 5 is a diagram for illustrating the second replication method of the integrated replication system according to an embodiment of the present invention.
- the second replication method is executed by the second replication module 323 of the integrated replication system 300 shown in FIG. 2 .
- the second replication module 323 may extract data of the source system 100 for each SQL. For example, data of the source system 100 is captured and extracted for each SQL, and a corresponding log is transmitted to the target system 200 .
- the second replication module 323 applies, that is, replicates the change data of the source system 100 to the target system 200 .
- the second replication module 323 transmits the log of data extracted for each SQL to the target system 200 . Thereafter, when Commit is executed, the second replication module 323 applies change data corresponding to the committed log to the target system 200 so that the change data is replicated.
- FIGS. 6 and 7 are diagrams for illustrating an integrated replication method according to an embodiment of the present invention.
- the integrated replication method may be performed by the integrated replication system 300 of FIG. 1 .
- the integrated replication system 300 selects the first replication method by driving the first replication module 321 through the selection module 330 (S 10 ).
- the integrated replication system 300 records transaction data on a log (S 20 ) and determines whether a Commit command has been executed (S 30 ).
- the extracted committed log is transmitted to the target system 200 and data corresponding to the committed log is applied, that is, replicated to the target system (S 40 ).
- the selection module 330 compares the amount of transaction data, transmitted from the source system 100 to the target system 200 , with a predetermined amount of data. When the amount of transaction data exceeds the predetermined amount of data, the selection module 330 detects such an excess (S 50 ), and drives the second replication module 323 in order to select the second replication method (S 60 ).
- FIG. 7 is a flowchart in which the second replication module 323 operates to select the second replication method.
- the integrated replication system 300 captures and extracts data for each SQL (S 100 ).
- the log of the data extracted for each SQL is transmitted to the target system 200 (S 200 ).
- the integrated replication system 300 may selectively apply the first replication method and the second replication method situationally according to a predetermined criterion. Accordingly, there is an effect in that one of the first replication method and the second replication method can be selectively used depending on a business characteristic of a user.
- FIG. 8 is a diagram for illustrating an integrated replication method when a replication method according to an embodiment of the present invention.
- FIG. 8 shows a data deletion area when a change into the first replication method is generated while the second replication method is executed.
- identifiers ID_1 and ID_2 are attached to the ends of transactions T1 and T2, respectively. Accordingly, the transactions can be identified based on the identifiers ID_1 and ID_2.
- replication is performed by the second replication method, data is extracted for each SQL and a corresponding data log is transmitted to the target system 200 . Accordingly, when a change into the first replication method of transmitting data for each transaction is generated, the final identifier ID_2 is searched for and subsequent data is deleted.
- FIG. 9 is a flowchart illustrating an integrated replication method when a replication method is changed according to an embodiment of the present invention.
- the selection module 330 selects the first replication method (S 1000 )
- the final identifier ID_2 is searched for as described with reference to FIG. 8 (S 2000 ).
- a limit that the replication solution of a database does not support the real-time replication of a heterogeneous database can be overcome. Accordingly, there is an effect in that there can be provided a system capable of maintaining the continuity of business by replicating data in real time.
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Quality & Reliability (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
- The present invention relates to an integrated replication system and, more particularly, to a real-time integrated replication system between heterogeneous databases for switching, transfer and integration between various databases, and to research result of “s/w technical development for real-time data extraction, cleaning and replication between various heterogeneous databases.
- As typical and atypical databases are recently diversified, an information management environment becomes more complicated. An environment in which data must be comprehensively managed in various IT environments is encountered.
- In an environment including almost infinite data scattered in various forms with the advent of the big data era, companies have had an essential object of obtaining valuable information through meaningful data by performing leaning company-wide data integration for a business success.
- Furthermore, recently, as data continues to explosively increase within a company and real-time-based services continue to increase, many companies try to maintain always flexible IT infrastructure.
- Furthermore, with the sudden development of the cloud and big data industry, there is an increasing need for an integration management system for listing, moving and analyzing rapidly increasing data.
- An object of the present invention is to overcome a limit that the replication solution of a database does not support the real-time replication of a heterogeneous database and to provide a system capable of maintaining the continuity of business by replicating data in real time.
- Another object of the present invention is to provide a system capable of minimizing a load of a database server and a network through a technology for guaranteeing the consistency of replicated data and a changed data replication technology.
- Yet another object of the present invention is to provide a system capable of enhancing the availability of data by enabling the real-time verification of the consistency of data and real-time correction of data.
- An integrated replication system according to an embodiment of the present invention may include a reader configured to collect information including a transaction or QSL information indicative of data changes of a source system, a storage module configured to store the information collected by the reader, a replication module configured to replicate change data of the source system to the target system through a first replication method or a second replication method, and a selection module configured to control the replication module in order to selectively apply any one of the first replication method and the second replication method according to a predetermined criterion.
- Furthermore, the replication module includes a first replication module configured to execute the first replication method and a second replication module configured to execute the second replication method. The first replication module may extract data of the source system for each transaction and replicate change data of the source system to the target system when Commit is executed for the source system so that a transaction is completed.
- The second replication module may extract data of the source system for each SQL, may capture and extract the data of the source system for each SQL, may transmit a corresponding log to the target system, and may replicate change data of the source system to the target system when Commit is executed.
- Furthermore, the selection module may first execute the first replication module, and may change a replication method by selecting and executing the second replication module if a predetermined criterion is satisfied.
- Furthermore, the selection module may include a transaction determination module configured to determine whether an amount of transaction data transmitted from the source system to the target system exceeds a predetermined amount of data by comparing the amount of transaction data with the predetermined amount of data and a control module configured to drive the second replication module in order to select the second replication method if, as a result of the determination of the transaction determination module, the amount of transaction data exceeds the predetermined amount of data.
- Furthermore, the control module may stop the driving of the first replication module in order to change the replication method from the first replication method to the second replication method when driving the second replication module.
- Furthermore, when a transaction is completed by a Commit, the control module controls the replication module so that an identifier is attached to the transaction in order to distinguish between transactions.
- Furthermore, when a change into the first replication method is generated, the deletion module searches for a final identifier which belongs to identifiers attached after the transaction and which is lastly attached, and deletes subsequent data.
- An advantage of the present invention is to overcome a limit that the replication solution of a database does not support the real-time replication of a heterogeneous database and to provide a system capable of maintaining the continuity of business by replicating data in real time.
- Another advantage of the present invention is to provide a system capable of minimizing a load of a database server and a network through a technology for guaranteeing the consistency of replicated data and a changed data replication technology.
- Yet another advantage of the present invention is to provide a system capable of enhancing the availability of data by enabling the real-time verification of the consistency of data and real-time correction of data.
- Another advantage of the present invention is to replicate change data correctly, by deleting data after a specific point of time when a change of the replication method is generated.
-
FIG. 1 is a diagram for illustrating an integrated replication system according to an embodiment of the present invention. -
FIG. 2 is a block diagram for specifically illustrating the integrated replication system ofFIG. 1 . -
FIG. 3 is a block diagram for specifically illustrating a selection module ofFIG. 2 . -
FIG. 4 is a diagram for illustrating a first replication method of the integrated replication system according to an embodiment of the present invention. -
FIG. 5 is a diagram for illustrating a second replication method of the integrated replication system according to an embodiment of the present invention. -
FIGS. 6 and 7 are diagrams for illustrating an integrated replication method according to an embodiment of the present invention. -
FIG. 8 is a diagram for illustrating an integrated replication method when a replication method according to an embodiment of the present invention. -
FIG. 9 is a flowchart illustrating an integrated replication method when a replication method is changed according to an embodiment of the present invention. - Detailed example embodiments are disclosed herein. However, specific structural and functional details disclosed herein are merely representative for purposes of describing example embodiments. Example embodiments may, however, be embodied in many alternate forms and should not be construed as limited to only the embodiments set forth herein.
- Accordingly, while example embodiments are capable of various modifications and alternative forms, embodiments thereof are shown by way of example in the drawings and will herein be described in detail. It should be understood, however, that there is no intent to limit example embodiments to the particular forms disclosed, but to the contrary, example embodiments are to cover all modifications, equivalents, and alternatives falling within the scope of example embodiments. Like numbers refer to like elements throughout the description of the figures.
- It will be understood that, although the terms first, second, etc. may be used herein to describe various elements, these elements should not be limited by these terms. These terms are only used to distinguish one element from another. For example, a first element could be termed a second element, and, similarly, a second element could be termed a first element, without departing from the scope of example embodiments.
- It will be understood that when an element is referred to as being “connected” or “coupled” to another element, it may be directly connected or coupled to the other element or intervening elements may be present.
- In contrast, when an element is referred to as being “directly connected” or “directly coupled” to another element, there are no intervening elements present. Other words used to describe the relationship between elements should be interpreted in a like fashion (e.g., “between” versus “directly between”, “adjacent” versus “directly adjacent”, etc.).
- The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used herein, the singular forms are intended to include the plural forms as well, unless the context clearly indicates otherwise.
- It will be further understood that the terms “comprises” and/or “comprising,” or “includes” and/or “including” when used in this specification, specify the presence of stated features, integers, steps, operations, elements, components and/or groups thereof, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
- Unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs.
- It will be further understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and/or the present application, and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
- Hereinafter, the inventive concept will be described in detail by explaining embodiments of the inventive concept with reference to the attached drawings. Like reference numerals in the drawings denote like elements.
-
FIG. 1 is a diagram for illustrating an integrated replication system according to an embodiment of the present invention, and schematically shows a replication environment according to an embodiment of the present invention. - The integrated
replication system 300 is connected to asource system 100 and atarget system 200 over anetwork 400, and performs the replication of data from thesource system 100 to thetarget system 200. - The
network 400 may include a communication link known to a person having ordinary skill in the art, such as the Internet or a computer network. The network may include a telephone or a cable service, a wired or satellite service, etc. - The
source system 100 and thetarget system 200 configure and store data according to a database management system (DMBS). - The integrated
replication system 300 captures a change of data in thesource system 100, selects a first replication method or a second replication method for the change, and transmits the data to thetarget system 200 through the selected replication method, so the data of thesource system 100 and the data of thetarget system 200 are synchronized. - The integrated
replication system 300 may provide a load balancing function based on the hardware and software elements of various computing apparatus or system. Furthermore, the integratedreplication system 300 may provide a broadcast or integration function in which a local copy is synchronized with the central copy of a database and vice versa. - The integrated
replication system 300 is described in detail below. -
FIG. 2 is a block diagram for specifically illustrating the integrated replication system ofFIG. 1 . Theintegrated replication system 300 includes areader 310, areplication module 320, aselection module 330, astorage module 340, and adeletion module 350. Thereplication module 320 includes afirst replication module 321 and asecond replication module 323. - The
reader 310 may analyze log files of thesource system 100. For example, thereader 310 may collect a transaction or QSL information indicative of data changes of thesource system 100, and enables the collected information to be stored in thestorage module 340. - The
replication module 320 replicates change data of thesource system 100 to thetarget system 200 through a specific method (e.g., a first replication method or a second replication method). - The
first replication module 321 may extract data of thesource system 100 for each transaction. For example, when Commit that instructs thesource system 100 so that a transaction is completed is executed, thefirst replication module 321 replicates change data of thesource system 100 to thetarget system 200. - For example, when Commit is executed, the
first replication module 321 transmits a corresponding committed log to thetarget system 200 so that change data corresponding to the committed log is applied and replicated to thetarget system 200. - That is, when change data is captured through Commit for each transaction and the Commit is executed, the
first replication module 321 extracts the change data and transmits a corresponding committed log to thetarget system 200 so that the change data is applied, that is, replicated to thetarget system 200. - The
first replication module 321 has an advantage in that unnecessary rollback data transmission is not generated, but when a large amount of transactions is generated, a second method may be selected under a specific condition by taking into consideration an increase of an instant load and reflection time. - The
second replication module 323 may extract data of thesource system 100 for each SQL. For example, data of thesource system 100 is captured and extracted for each SQL, and a corresponding log is transmitted to thetarget system 200. - Thereafter, when Commit is executed, the
second replication module 323 applies the change data of thesource system 100 to thetarget system 200, that is, the change data is replicated to thetarget system 200. - Although Commit is not executed, the
second replication module 323 transmits the log of data extracted for each SQL to thetarget system 200. Thereafter, when Commit is executed, thesecond replication module 323 applies change data corresponding to the committed log to thetarget system 200 so that the change data is replicated to thetarget system 200. - The
selection module 330 may select and execute one of thefirst replication module 321 and thesecond replication module 323 in order to selectively apply the first replication method and the second replication method situationally according to a predetermined criterion. - The
selection module 330 may be configured to basically execute thefirst replication module 321 first and to select and execute thesecond replication module 323 if a predetermined criterion is satisfied. - For example, when a change into the first replication method is generated while the second replication method is executed by the
second replication module 323, thedeletion module 350 searches for the final identifier attached to the end of one transaction and deletes subsequent data. - If replication is performed by the second replication method, data is extracted for each SQL and a corresponding data log is transmitted to the
target system 200. Accordingly, if a change into the first replication method of transmitting data for each transaction is generated, thedeletion module 350 searches for the final identifier ID_2 and deletes subsequent data. -
FIG. 3 is a block diagram for specifically illustrating a selection module ofFIG. 2 . Theselection module 330 includes atransaction determination module 331 and acontrol module 333. - The
transaction determination module 331 determines whether the amount of transaction data transmitted from thesource system 100 to thetarget system 200 exceeds a predetermined amount of data by comparing the amount of transaction data with the predetermined amount of data. - If, as a result of the determination, it is determined that the amount of transaction data exceeds the predetermined amount of data, the
control module 333 drives thesecond replication module 323 in order to select the second replication method. - That is, the
control module 333 changes a replication method from the first replication method to the second replication method, thereby stopping the driving of thefirst replication module 321 and activating thesecond replication module 323. -
FIG. 4 is a diagram for illustrating the first replication method of the integrated replication system according to an embodiment of the present invention. The first replication method is executed by thefirst replication module 321 of theintegrated replication system 300 shown inFIG. 2 . - The
first replication module 321 may extract data of thesource system 100 for each transaction. For example, when Commit that instructs thesource system 100 so that a transaction is completed is executed, thefirst replication module 321 replicates the change data of thesource system 100 to thetarget system 200. - For example, when Commit is executed, the
first replication module 321 transmits a committed log to thetarget system 200 so that change data corresponding to the committed log is applied and replicated to thetarget system 200. - That is, when change data is captured for each transaction through Commit and the Commit is executed, the
first replication module 321 extracts the change data and transmits a corresponding committed log to thetarget system 200 so that the change data is applied, that is, replicated to thetarget system 200. -
FIG. 5 is a diagram for illustrating the second replication method of the integrated replication system according to an embodiment of the present invention. The second replication method is executed by thesecond replication module 323 of theintegrated replication system 300 shown inFIG. 2 . - The
second replication module 323 may extract data of thesource system 100 for each SQL. For example, data of thesource system 100 is captured and extracted for each SQL, and a corresponding log is transmitted to thetarget system 200. - Thereafter, when Commit is executed, the
second replication module 323 applies, that is, replicates the change data of thesource system 100 to thetarget system 200. - Although Commit is not executed, the
second replication module 323 transmits the log of data extracted for each SQL to thetarget system 200. Thereafter, when Commit is executed, thesecond replication module 323 applies change data corresponding to the committed log to thetarget system 200 so that the change data is replicated. -
FIGS. 6 and 7 are diagrams for illustrating an integrated replication method according to an embodiment of the present invention. The integrated replication method may be performed by theintegrated replication system 300 ofFIG. 1 . - Referring to
FIG. 6 , theintegrated replication system 300 selects the first replication method by driving thefirst replication module 321 through the selection module 330 (S10). - Next, the
integrated replication system 300 records transaction data on a log (S20) and determines whether a Commit command has been executed (S30). - When the Commit is executed, the extracted committed log is transmitted to the
target system 200 and data corresponding to the committed log is applied, that is, replicated to the target system (S40). - Thereafter, the
selection module 330 compares the amount of transaction data, transmitted from thesource system 100 to thetarget system 200, with a predetermined amount of data. When the amount of transaction data exceeds the predetermined amount of data, theselection module 330 detects such an excess (S50), and drives thesecond replication module 323 in order to select the second replication method (S60). -
FIG. 7 is a flowchart in which thesecond replication module 323 operates to select the second replication method. - Referring to
FIG. 7 , theintegrated replication system 300 captures and extracts data for each SQL (S100). The log of the data extracted for each SQL is transmitted to the target system 200 (S200). - Thereafter, whether Commit is executed is determined (S300). If it is determined that Commit has been executed, data corresponding to the committed log is applied, that is, replicated to the target system 200 (S400).
- The
integrated replication system 300 according to an embodiment of the present invention may selectively apply the first replication method and the second replication method situationally according to a predetermined criterion. Accordingly, there is an effect in that one of the first replication method and the second replication method can be selectively used depending on a business characteristic of a user. -
FIG. 8 is a diagram for illustrating an integrated replication method when a replication method according to an embodiment of the present invention. -
FIG. 8 shows a data deletion area when a change into the first replication method is generated while the second replication method is executed. - When transactions T1 and T2 are completed by Commits Commit_1 and Commit_2, identifiers ID_1 and ID_2 are attached to the ends of transactions T1 and T2, respectively. Accordingly, the transactions can be identified based on the identifiers ID_1 and ID_2.
- If replication is performed by the second replication method, data is extracted for each SQL and a corresponding data log is transmitted to the
target system 200. Accordingly, when a change into the first replication method of transmitting data for each transaction is generated, the final identifier ID_2 is searched for and subsequent data is deleted. -
FIG. 9 is a flowchart illustrating an integrated replication method when a replication method is changed according to an embodiment of the present invention. - Referring to
FIG. 9 , when theselection module 330 selects the first replication method (S1000), the final identifier ID_2 is searched for as described with reference toFIG. 8 (S2000). - When the final identifier ID_2 is searched for, data subsequent to the final identifier ID_2 is deleted (S3000).
- In accordance with the integrated replication system according to an embodiment of the present invention, a limit that the replication solution of a database does not support the real-time replication of a heterogeneous database can be overcome. Accordingly, there is an effect in that there can be provided a system capable of maintaining the continuity of business by replicating data in real time.
- In accordance with the integrated replication system according to an embodiment of the present invention, there is an effect in that there can be provided a system capable of minimizing a load of a database server and a network through a technology for guaranteeing the consistency of replicated data and a changed data replication technology.
- In accordance with the integrated replication system according to an embodiment of the present invention, there is an effect in that there can be provided a system capable of enhancing the availability of data by enabling the real-time verification of the consistency of data and real-time correction of data.
- In accordance with the integrated replication system according to an embodiment of the present invention, there is an effect in that change data can be accurately replicated although there is a change in a replication method because data after a specific point of time is deleted.
- While the present invention has been shown and described with reference to exemplary embodiments thereof, it will be understood by those of ordinary skill in the art that various changes in form and detail may be made herein without departing from the spirit and scope of the present invention, as defined by the following claims.
Claims (7)
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
KR10-2017-0129429 | 2017-10-11 | ||
KR1020170129429A KR101826827B1 (en) | 2017-10-11 | 2017-10-11 | Integrated replication system in real time |
PCT/KR2017/013091 WO2019074155A1 (en) | 2017-10-11 | 2017-11-17 | Inter-database real time integrated replication system |
Publications (2)
Publication Number | Publication Date |
---|---|
US20190138535A1 true US20190138535A1 (en) | 2019-05-09 |
US10303701B1 US10303701B1 (en) | 2019-05-28 |
Family
ID=61199031
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US15/770,214 Active US10303701B1 (en) | 2017-10-11 | 2017-11-17 | Real-time integrated replication system between databases |
Country Status (3)
Country | Link |
---|---|
US (1) | US10303701B1 (en) |
KR (1) | KR101826827B1 (en) |
WO (1) | WO2019074155A1 (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20230244691A1 (en) * | 2022-01-31 | 2023-08-03 | Nutanix, Inc. | Replication using data identity |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US11256713B2 (en) * | 2020-04-27 | 2022-02-22 | International Business Machines Corporation | Virtual transaction queues for database replication |
US11630814B2 (en) | 2020-12-10 | 2023-04-18 | International Business Machines Corporation | Automated online upgrade of database replication |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20140068587A1 (en) * | 2012-08-30 | 2014-03-06 | Nishant Krishna | System and method for efficient software replication |
US20140304229A1 (en) * | 2012-12-31 | 2014-10-09 | Sybase, Inc. | Continuous Change Data Capture Without Disruption of DDL |
US20150032695A1 (en) * | 2013-07-25 | 2015-01-29 | Oracle International Corporation | Client and server integration for replicating data |
Family Cites Families (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
KR100503899B1 (en) | 2002-11-26 | 2005-07-25 | 진진시스템(주) | Database replication system and the replication method |
JP4289056B2 (en) * | 2003-03-27 | 2009-07-01 | 株式会社日立製作所 | Data duplication control method between computer systems |
KR100926880B1 (en) * | 2007-05-21 | 2009-11-16 | 엔에이치엔(주) | Data replication method and system in DVMS |
KR101024249B1 (en) | 2008-05-28 | 2011-03-29 | 매크로임팩트 주식회사 | Real-time data replication system |
KR100891036B1 (en) | 2008-09-08 | 2009-03-31 | (주)데이타뱅크시스템즈 | Automatic recovery system for database using real-time replication and its method |
KR101513943B1 (en) | 2008-12-01 | 2015-04-23 | 주식회사 케이티 | Method and system for operating management of real-time replicated database |
KR101429575B1 (en) | 2012-10-22 | 2014-08-13 | 주식회사 엔써티 | Real time backup system of database, system of recovering data and method of recovering data |
GB2524540A (en) * | 2014-03-26 | 2015-09-30 | Ibm | Replication of a relational database |
KR101562359B1 (en) * | 2014-10-14 | 2015-10-22 | 주식회사 웨어밸리 | The replication utilization system and method for simultaneous service of OLTP and OLAP |
KR102253841B1 (en) * | 2014-10-31 | 2021-05-18 | 에스케이텔레콤 주식회사 | Apparatus for Processing Transaction with Modification of Data in Large-Scale Distributed File System and Computer-Readable Recording Medium with Program |
JP6293709B2 (en) * | 2015-07-22 | 2018-03-14 | 株式会社東芝 | Storage system and storage system program |
KR20170089067A (en) * | 2016-01-25 | 2017-08-03 | 한국전자통신연구원 | Bigdata processing system and method |
-
2017
- 2017-10-11 KR KR1020170129429A patent/KR101826827B1/en active IP Right Grant
- 2017-11-17 US US15/770,214 patent/US10303701B1/en active Active
- 2017-11-17 WO PCT/KR2017/013091 patent/WO2019074155A1/en active Application Filing
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20140068587A1 (en) * | 2012-08-30 | 2014-03-06 | Nishant Krishna | System and method for efficient software replication |
US20140304229A1 (en) * | 2012-12-31 | 2014-10-09 | Sybase, Inc. | Continuous Change Data Capture Without Disruption of DDL |
US20150032695A1 (en) * | 2013-07-25 | 2015-01-29 | Oracle International Corporation | Client and server integration for replicating data |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20230244691A1 (en) * | 2022-01-31 | 2023-08-03 | Nutanix, Inc. | Replication using data identity |
Also Published As
Publication number | Publication date |
---|---|
WO2019074155A1 (en) | 2019-04-18 |
US10303701B1 (en) | 2019-05-28 |
KR101826827B1 (en) | 2018-02-09 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109034993B (en) | Account checking method, account checking equipment, account checking system and computer readable storage medium | |
US11086531B2 (en) | Scaling events for hosting hierarchical data structures | |
EP4064067A1 (en) | Automatic query offloading to a standby database | |
US10120767B2 (en) | System, method, and computer program product for creating a virtual database | |
US10235376B2 (en) | Merging metadata for database storage regions based on overlapping range values | |
US10831724B2 (en) | Method of reconciling resources in the metadata hierarchy | |
US10089313B2 (en) | Conversion of data integration system files | |
US11138227B2 (en) | Consistent query execution in hybrid DBMS | |
US7143112B2 (en) | Method and apparatus for data integration | |
WO2017063520A1 (en) | Method and apparatus for operating database | |
KR20180055952A (en) | Data replication technique in database management system | |
US10303701B1 (en) | Real-time integrated replication system between databases | |
US20160179919A1 (en) | Asynchronous data replication using an external buffer table | |
CN105930228A (en) | data backup method and system | |
US8380663B2 (en) | Data integrity in a database environment through background synchronization | |
CN110019469B (en) | Distributed database data processing method and device, storage medium and electronic device | |
CN111062684B (en) | System and method for realizing consistency processing of business data and process data under cloud process platform | |
US10929100B2 (en) | Mitigating causality discrepancies caused by stale versioning | |
US20210286799A1 (en) | Automated transaction engine | |
US7069270B1 (en) | Automated method and mechanism for converting a single instance application to a multiple instance application | |
US8285742B2 (en) | Management of attribute information related to system resources | |
KR20220026603A (en) | File handling methods, devices, electronic devices and storage media | |
US7917609B2 (en) | Method and apparatus for managing lightweight directory access protocol information | |
US11074244B1 (en) | Transactional range delete in distributed databases | |
KR101859094B1 (en) | Integrated replication system considering change of replication method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: DATABANK SYSTEMS LTD., KOREA, REPUBLIC OF Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:JANG, YUN CHUL;LEE, JONG SOO;KWON, KIUK;REEL/FRAME:045605/0741 Effective date: 20180417 |
|
FEPP | Fee payment procedure |
Free format text: ENTITY STATUS SET TO UNDISCOUNTED (ORIGINAL EVENT CODE: BIG.); ENTITY STATUS OF PATENT OWNER: SMALL ENTITY |
|
FEPP | Fee payment procedure |
Free format text: ENTITY STATUS SET TO SMALL (ORIGINAL EVENT CODE: SMAL); ENTITY STATUS OF PATENT OWNER: SMALL ENTITY |
|
STCF | Information on status: patent grant |
Free format text: PATENTED CASE |
|
AS | Assignment |
Owner name: ARKDATA CO. LTD, KOREA, REPUBLIC OF Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:DATABANK SYSTEMS LTD.;REEL/FRAME:052278/0465 Effective date: 20200331 |
|
MAFP | Maintenance fee payment |
Free format text: PAYMENT OF MAINTENANCE FEE, 4TH YR, SMALL ENTITY (ORIGINAL EVENT CODE: M2551); ENTITY STATUS OF PATENT OWNER: SMALL ENTITY Year of fee payment: 4 |