CN109656934B - Source Oracle database DDL synchronization method and device based on log analysis - Google Patents
Source Oracle database DDL synchronization method and device based on log analysis Download PDFInfo
- Publication number
- CN109656934B CN109656934B CN201811377371.6A CN201811377371A CN109656934B CN 109656934 B CN109656934 B CN 109656934B CN 201811377371 A CN201811377371 A CN 201811377371A CN 109656934 B CN109656934 B CN 109656934B
- Authority
- CN
- China
- Prior art keywords
- ddl
- database
- oracle
- log
- source
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000013507 mapping Methods 0.000 claims abstract description 22
- 230000001360 synchronised effect Effects 0.000 claims description 10
- 238000004891 communication Methods 0.000 claims description 8
- 239000000126 substance Substances 0.000 claims 1
- 230000006870 function Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008094 contradictory effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a source Oracle database DDL synchronization method and device based on log analysis. The method comprises the following steps: deploying a synchronization system on a source Oracle database and a target end database, initializing an Oracle system dictionary table by the source Oracle database synchronization system, constructing a data type mapping table from the source Oracle database to the target end database, and reading an Oracle log from the source Oracle database synchronization system; acquiring DDL operation log information and a transaction number according to an operation code of an Oracle log, collecting a DML operation log according to the log information and the transaction number, and collecting the log; analyzing the collected DDL operation log and the corresponding DML operation log, restoring DDL sentences according to an Oracle system dictionary table, and converting the restored DDL sentences into DDL sentences suitable for being executed by a target end database by combining a data type mapping table from a source end Oracle database to the target end database to realize the synchronization of the target end database. The embodiment of the invention can synchronize DDL operation between the source end Oracle database and the target end database.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a source Oracle database DDL synchronization method and device based on log analysis.
Background
In a database real-time synchronization system (supporting heterogeneous), if the source is Oracle, it is usually the case that an event trigger of Oracle is used to capture the DDL operation of the source. However, in an actual application system, the event trigger affects the execution efficiency of the Oracle database transaction, so there is a scenario that an application client does not allow the event trigger to be created on the source Oracle database. The object information in the database management system is stored by a series of system dictionary tables, and when a user creates an object, corresponding records (table names, column names and the like) are inserted into the system dictionary tables such as SYS.OBJ $, SYS.COL $andSYS.LOB $ofan Oracle database; when a user modifies the object structure, corresponding records in system dictionary tables such as SYS.OBJ $, SYS.COL $andSYS.ICOL $areupdated; when the user deletes the object, the corresponding records in the system dictionary tables such as sys.obj $, sys.col $, sys.icol $, etc. are deleted. Based on the consideration, how to obtain the DDL operation by using the DML reverse inversion through the system dictionary table of the Oracle database, and synchronize the DDL operation in the target database on the basis, is a technical problem to be solved in the industry.
Disclosure of Invention
Aiming at the problems in the prior art, the embodiment of the invention provides a source-end Oracle database DDL synchronization method and device based on log analysis.
In a first aspect, an embodiment of the present invention provides a source Oracle database DDL synchronization method based on log parsing, including: deploying a synchronization system on a source Oracle database and a target end database, initializing an Oracle system dictionary table by the source Oracle database synchronization system, constructing a data type mapping table from the source Oracle database to the target end database, and reading an Oracle log from the source Oracle database synchronization system; acquiring DDL operation log information and a transaction number according to an operation code of an Oracle log, collecting and obtaining a DML operation log according to the DDL operation log information and the transaction number, if the transaction number of the DML operation log is the same as the transaction number of the DDL operation log, collecting the DDL operation log, and if the type of the DML operation log is transaction submission, finishing collecting the DDL operation log; analyzing the collected DDL operation log and the corresponding DML operation log, restoring DDL sentences according to the Oracle system dictionary table, converting the restored DDL sentences into DDL sentences suitable for being executed by the target end database by combining with the data type mapping table from the source end Oracle database to the target end database, and sending the DDL sentences to the target end database to realize DDL sentence synchronization.
Further, the deploying and synchronizing system in the source-end Oracle database and the target-end database includes: a synchronous system management module, a log reading and analyzing module and a sending module are deployed in a source Oracle database.
Further, the deploying and synchronizing system in the source-end Oracle database and the target-end database includes: and deploying a synchronous system management module, a receiving module and an execution module in the target-end database.
Further, the target data includes: an Oracle database or a non-Oracle database.
Further, the Oracle system dictionary table includes: sys.obj $, sys.col $, sys.icol $, and/or sys.lob $.
In a second aspect, an embodiment of the present invention provides a source Oracle database DDL synchronization apparatus based on log parsing, including:
the system comprises an Oracle log acquisition module, a source end Oracle database synchronization system and a target end database synchronization system, wherein the Oracle database synchronization system is used for deploying a synchronization system on the source end Oracle database and the target end database, initializing an Oracle system dictionary table, constructing a data type mapping table from the source end Oracle database to the target end database, and reading an Oracle log from the source end Oracle database synchronization system;
the DDL operation log collection module is used for acquiring DDL operation log information and a transaction number according to an operation code of the Oracle log, collecting and obtaining a DML operation log according to the DDL operation log information and the transaction number, if the transaction number of the DML operation log is the same as the transaction number of the DDL operation log, collecting the DDL operation log, and if the type of the DML operation log is transaction submission, finishing collecting the DDL operation log;
and the DDL statement synchronization module is used for analyzing the collected DDL operation logs and the corresponding DML operation logs, restoring the DDL statements according to the Oracle system dictionary table, converting the restored DDL statements into DDL statements suitable for being executed by the target end database by combining with the data type mapping table from the source end Oracle database to the target end database, and sending the DDL statements to the target end database to realize DDL statement synchronization.
In a third aspect, an embodiment of the present invention provides an electronic device, including:
at least one processor; and
at least one memory communicatively coupled to the processor, wherein:
the memory stores program instructions executable by the processor, and the processor calls the program instructions to execute the log parsing based source Oracle database DDL synchronization method provided by any one of the various possible implementations of the first aspect.
In a fourth aspect, an embodiment of the present invention provides a non-transitory computer-readable storage medium, which stores computer instructions, where the computer instructions cause a computer to execute a method for source-end Oracle database DDL synchronization based on log parsing provided in any one of various possible implementations of the first aspect.
According to the source Oracle database DDL synchronization method and device based on log analysis, provided by the embodiment of the invention, by utilizing the fact that DML operation objects are all Oracle system dictionary tables, DDL operation is decomposed into a plurality of DML operations to be executed in the Oracle database, the corresponding DDL operation is obtained by reversely tracking the DML operations, the obtained DDL operation is mapped to the target end database to be executed, and the DDL operation can be synchronized between the source Oracle database and the target end database without adopting an event trigger to capture the DDL operation.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, a brief description will be given below to the drawings required for the description of the embodiments or the prior art, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a flowchart of a source Oracle database DDL synchronization method based on log parsing according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a source Oracle database DDL synchronization device based on log parsing according to an embodiment of the present invention;
fig. 3 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention. In addition, technical features of various embodiments or individual embodiments provided by the invention can be arbitrarily combined with each other to form a feasible technical solution, but must be realized by a person skilled in the art, and when the technical solution combination is contradictory or cannot be realized, the technical solution combination is not considered to exist and is not within the protection scope of the present invention.
The user's definitions for objects of the Oracle database management system are all stored in the system dictionary table, which the user can view but cannot modify, i.e., the system dictionary table is read-only by the user. The invention tracks DML operation of the corresponding system dictionary table in the log according to the change of the record of the Oracle database system dictionary table, and deduces DDL operation of creating, updating and deleting the user object. Therefore, the method for obtaining the DDL operation of the Oracle source end database is realized under the condition that no DDL operation record is provided in the Oracle source end database and no event trigger is allowed to be created on the Oracle source end database.
Based on the above reality, an embodiment of the present invention provides a source Oracle database DDL synchronization method based on log parsing, and referring to FIG. 1, the method includes:
101. deploying a synchronization system on a source Oracle database and a target end database, initializing an Oracle system dictionary table by the source Oracle database synchronization system, constructing a data type mapping table from the source Oracle database to the target end database, and reading an Oracle log from the source Oracle database synchronization system;
102. acquiring DDL operation log information and a transaction number according to an operation code of an Oracle log (in another embodiment, the operation code of the log is the log with the number of 24.1), collecting and obtaining a DML operation log according to the DDL operation log information and the transaction number, if the transaction number of the DML operation log is the same as the transaction number of the DDL operation log, collecting the DDL operation log, and if the type of the DML operation log is transaction submission, finishing collecting the DDL operation log;
103. analyzing the collected DDL operation log and the corresponding DML operation log, restoring DDL sentences according to the Oracle system dictionary table, converting the restored DDL sentences into DDL sentences suitable for being executed by the target end database by combining with the data type mapping table from the source end Oracle database to the target end database, and sending the DDL sentences to the target end database to realize DDL sentence synchronization.
The basic steps of the above embodiment can be explained as follows:
firstly, before a real-time synchronization system of a database with an Oracle source end is started, a source end Oracle storage object is defined, and a related system dictionary table is loaded with a table structure (such as SYS. OBJ $, SYS. COL $andSYS. ICOL $), namely, a table ID and a table definition of the system dictionary table are recorded. If the system dictionary table (table definition and table ID) is not initialized, the related operations cannot be restored to the table structure after the related dictionary table read from the log is operated because the real-time synchronization system has no definition of the system dictionary table structure. And the database real-time synchronization system tracks whether the Oracle has DDL operation, restores the DDL operation according to the related log corresponding to the system dictionary table ID in the DDL operation log and by combining the system dictionary table structure stored in the real-time synchronization system, and executes the DDL operation in a target library.
And judging the DDL operation according to the log operation code, and acquiring a transaction number (ID) of the DDL operation. And monitoring whether the DDL operation occurs in the database log, and if the DDL operation occurs, collecting a synchronous system dictionary table at the corresponding moment in the log according to the related information in the log, and restoring DDL statements. In the ORACLE database log, a specific log format is defined when the DDL operation of a user is recorded; the log operation code is 24.1, which represents the DDL operation, and after the operation code, the DDL operation type, the operation object name and the user to which the operation object belongs are recorded respectively.
And collecting DML operation logs related to the DDL operation logs according to the DDL operation transaction numbers, and realizing log screening. In an Oracle database, a DDL operation of a user is usually decomposed into a plurality of DMLs to be executed in the database, DML operation objects are a system dictionary table of Oracle, and the transaction number of each DML operation is the same as the transaction number of the DDL operation; collecting the DML operation with the same number as the DDL operation number, and taking the operation type as a submission as an end mark, thereby completing the collection work of the DDL operation record.
And establishing a data type mapping table, and solving the problem of incompatibility when Oracle is synchronized to a non-Oracle database. And when the destination database is a heterogeneous database, establishing a data type mapping table, and performing keyword mapping on the reduced DDL statement to ensure the correct execution of the DDL statement in the destination database management system. Keywords in a database management system include data types, functions, etc., such as char, varchar, int … …. If the mapping is not performed, the destination database management system may not support similar data types or functions, and the DDL statement execution fails.
On the basis of the foregoing embodiment, the source Oracle database DDL synchronization method based on log parsing provided in the embodiment of the present invention deploys a synchronization system in a source Oracle database and a target database, and includes: a synchronous system management module, a log reading and analyzing module and a sending module are deployed in a source Oracle database.
On the basis of the foregoing embodiment, the source Oracle database DDL synchronization method based on log parsing provided in the embodiment of the present invention deploys a synchronization system in a source Oracle database and a target database, and includes: and deploying a synchronous system management module, a receiving module and an execution module in the target-end database.
On the basis of the foregoing embodiment, in the source Oracle database DDL synchronization method based on log parsing provided in the embodiment of the present invention, the target end data includes: an Oracle database or a non-Oracle database.
On the basis of the foregoing embodiment, in the source Oracle database DDL synchronization method based on log parsing provided in the embodiment of the present invention, the Oracle system dictionary table includes: sys.obj $, sys.col $, sys.icol $, and/or sys.lob $.
In the source-end Oracle database DDL synchronization method based on log analysis provided by the embodiment of the invention, by using the fact that DML operation objects are all Oracle system dictionary tables, the DDL operation is decomposed into a plurality of DML operations to be executed in the Oracle database, the corresponding DDL operation is obtained by reversely tracking the DML operations, and the obtained DDL operation is mapped to the target-end database to be executed, so that the DDL operation can be synchronized between the source-end Oracle database and the target-end database without adopting an event trigger to capture the DDL operation.
The implementation basis of the various embodiments of the present invention is realized by programmed processing performed by a device having a processor function. Therefore, in engineering practice, the technical solutions and functions thereof of the embodiments of the present invention can be packaged into various modules. Based on this reality, on the basis of the foregoing embodiments, embodiments of the present invention provide a source-side Oracle database DDL synchronization apparatus based on log parsing, where the apparatus is configured to execute the source-side Oracle database DDL synchronization method based on log parsing in the foregoing method embodiments. Referring to fig. 2, the apparatus includes:
the Oracle log acquisition module 201 is used for deploying a synchronization system in a source Oracle database and a target end database, initializing an Oracle system dictionary table by the source Oracle database synchronization system, constructing a data type mapping table from the source Oracle database to the target end database, and reading an Oracle log from the source Oracle database synchronization system;
the DDL operation log collection module 202 is configured to obtain DDL operation log information and a transaction number according to an operation code of an Oracle log, collect and obtain a DML operation log according to the DDL operation log information and the transaction number, collect the DDL operation log if the transaction number of the DML operation log is the same as the transaction number of the DDL operation log, and end collection of the DDL operation log if the type of the DML operation log is transaction commit;
and the DDL statement synchronization module 203 is used for analyzing the collected DDL operation logs and the corresponding DML operation logs, restoring the DDL statements according to the Oracle system dictionary table, converting the restored DDL statements into DDL statements suitable for being executed by the target end database by combining with the data type mapping table from the source end Oracle database to the target end database, and sending the DDL statements to the target end database to realize DDL statement synchronization.
The source Oracle database DDL synchronization device based on log analysis provided by the embodiment of the invention adopts an Oracle log acquisition module, a DDL operation log collection module and a DDL statement synchronization module, decomposes DDL operation into a plurality of DML operations to be executed in an Oracle database by using that DML operation objects are all Oracle system dictionary tables, obtains the corresponding DDL operation from DML operation reverse tracking, maps the obtained DDL operation to a target end database to be executed, and can synchronize the DDL operation between the source Oracle database and the target end database under the condition that the DDL operation is captured without adopting an event trigger.
The method of the embodiment of the invention is realized by depending on the electronic equipment, so that the related electronic equipment is necessarily introduced. To this end, an embodiment of the present invention provides an electronic apparatus, as shown in fig. 3, including: at least one processor (processor)301, a communication Interface (Communications Interface)304, at least one memory (memory)302 and a communication bus 303, wherein the at least one processor 301, the communication Interface 304 and the at least one memory 302 are configured to communicate with each other via the communication bus 303. The at least one processor 301 may call logic instructions in the at least one memory 302 to perform the following method: deploying a synchronization system on a source Oracle database and a target end database, initializing an Oracle system dictionary table by the source Oracle database synchronization system, constructing a data type mapping table from the source Oracle database to the target end database, and reading an Oracle log from the source Oracle database synchronization system; acquiring DDL operation log information and a transaction number according to an operation code of an Oracle log, collecting and obtaining a DML operation log according to the DDL operation log information and the transaction number, if the transaction number of the DML operation log is the same as the transaction number of the DDL operation log, collecting the DDL operation log, and if the type of the DML operation log is transaction submission, finishing collecting the DDL operation log; analyzing the collected DDL operation log and the corresponding DML operation log, restoring DDL sentences according to the Oracle system dictionary table, converting the restored DDL sentences into DDL sentences suitable for being executed by the target end database by combining with the data type mapping table from the source end Oracle database to the target end database, and sending the DDL sentences to the target end database to realize DDL sentence synchronization.
Furthermore, the logic instructions in the at least one memory 302 may be implemented in software functional units and stored in a computer readable storage medium when sold or used as a stand-alone product. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. Examples include: deploying a synchronization system on a source Oracle database and a target end database, initializing an Oracle system dictionary table by the source Oracle database synchronization system, constructing a data type mapping table from the source Oracle database to the target end database, and reading an Oracle log from the source Oracle database synchronization system; acquiring DDL operation log information and a transaction number according to an operation code of an Oracle log, collecting and obtaining a DML operation log according to the DDL operation log information and the transaction number, if the transaction number of the DML operation log is the same as the transaction number of the DDL operation log, collecting the DDL operation log, and if the type of the DML operation log is transaction submission, finishing collecting the DDL operation log; analyzing the collected DDL operation log and the corresponding DML operation log, restoring DDL sentences according to the Oracle system dictionary table, converting the restored DDL sentences into DDL sentences suitable for being executed by the target end database by combining with the data type mapping table from the source end Oracle database to the target end database, and sending the DDL sentences to the target end database to realize DDL sentence synchronization. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (7)
1. A source Oracle database DDL synchronization method based on log analysis is characterized by comprising the following steps:
deploying a synchronization system on a source Oracle database and a target end database, initializing an Oracle system dictionary table by the source Oracle database synchronization system, constructing a data type mapping table from the source Oracle database to the target end database, and reading an Oracle log from the source Oracle database synchronization system;
acquiring DDL operation log information and a transaction number according to an operation code of an Oracle log, collecting and obtaining a DML operation log according to the DDL operation log information and the transaction number, if the transaction number of the DML operation log is the same as the transaction number of the DDL operation log, collecting the DDL operation log, and if the type of the DML operation log is transaction submission, finishing collecting the DDL operation log;
analyzing the collected DDL operation logs and corresponding DML operation logs, restoring DDL statements according to the Oracle system dictionary table, converting the restored DDL statements into DDL statements suitable for being executed by a target end database by combining with a data type mapping table from a source end Oracle database to the target end database, and sending the DDL statements to the target end database to realize DDL statement synchronization;
the Oracle system dictionary table includes:
sys.obj $, sys.col $, sys.icol $, and/or sys.lob $.
2. The source Oracle database DDL synchronization method based on log parsing of claim 1, wherein said deploying a synchronization system in a source Oracle database and a target database comprises:
a synchronous system management module, a log reading and analyzing module and a sending module are deployed in a source Oracle database.
3. The source Oracle database DDL synchronization method based on log parsing of claim 1, wherein said deploying a synchronization system in a source Oracle database and a target database comprises:
and deploying a synchronous system management module, a receiving module and an execution module in the target-end database.
4. The log parsing-based source Oracle database DDL synchronization method of claim 1, wherein the target end data comprises:
an Oracle database or a non-Oracle database.
5. A source Oracle database DDL synchronizer based on log parsing is characterized by comprising:
the system comprises an Oracle log acquisition module, a source end Oracle database synchronization system and a target end database synchronization system, wherein the Oracle database synchronization system is used for deploying a synchronization system on the source end Oracle database and the target end database, initializing an Oracle system dictionary table, constructing a data type mapping table from the source end Oracle database to the target end database, and reading an Oracle log from the source end Oracle database synchronization system;
the DDL operation log collection module is used for acquiring DDL operation log information and a transaction number according to an operation code of the Oracle log, collecting and obtaining a DML operation log according to the DDL operation log information and the transaction number, if the transaction number of the DML operation log is the same as the transaction number of the DDL operation log, collecting the DDL operation log, and if the type of the DML operation log is transaction submission, finishing collecting the DDL operation log;
the DDL statement synchronization module is used for analyzing the collected DDL operation logs and the corresponding DML operation logs, restoring DDL statements according to the Oracle system dictionary table, converting the restored DDL statements into DDL statements suitable for being executed by the target end database by combining with the data type mapping table from the source end Oracle database to the target end database, and sending the DDL statements to the target end database to realize DDL statement synchronization;
the Oracle system dictionary table includes:
sys.obj $, sys.col $, sys.icol $, and/or sys.lob $.
6. An electronic device, comprising:
at least one processor, at least one memory, a communication interface, and a bus; wherein the content of the first and second substances,
the processor, the memory and the communication interface complete mutual communication through the bus;
the memory stores program instructions executable by the processor, the processor calling the program instructions to perform the method of any of claims 1 to 4.
7. A non-transitory computer-readable storage medium storing computer instructions that cause a computer to perform the method of any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811377371.6A CN109656934B (en) | 2018-11-19 | 2018-11-19 | Source Oracle database DDL synchronization method and device based on log analysis |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811377371.6A CN109656934B (en) | 2018-11-19 | 2018-11-19 | Source Oracle database DDL synchronization method and device based on log analysis |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109656934A CN109656934A (en) | 2019-04-19 |
| CN109656934B true CN109656934B (en) | 2020-10-27 |
Family
ID=66111286
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811377371.6A Active CN109656934B (en) | 2018-11-19 | 2018-11-19 | Source Oracle database DDL synchronization method and device based on log analysis |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109656934B (en) |
Families Citing this family (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111858744A (en) * | 2019-04-29 | 2020-10-30 | 北京嘀嘀无限科技发展有限公司 | Database data synchronization method, server and system |
| CN110083617B (en) * | 2019-05-05 | 2021-06-01 | 上海达梦数据库有限公司 | DDL statement processing method and device, electronic device and medium |
| CN110222119B (en) * | 2019-05-23 | 2021-08-31 | 武汉达梦数据库股份有限公司 | Data conversion synchronization method, equipment and storage medium for heterogeneous database |
| CN110515913B (en) * | 2019-08-02 | 2022-08-09 | 北京互金新融科技有限公司 | Log processing method and device |
| CN110457181B (en) * | 2019-08-02 | 2023-05-16 | 武汉达梦数据库股份有限公司 | Log optimization analysis method and device for database |
| CN110727548B (en) * | 2019-09-29 | 2022-03-04 | 上海英方软件股份有限公司 | Continuous data protection method and device based on database DML synchronization |
| CN110784352B (en) * | 2019-10-30 | 2022-04-01 | 国网山东省电力公司信息通信公司 | Data synchronous monitoring and alarming method and device based on Oracle golden gate |
| CN110990482A (en) * | 2019-11-11 | 2020-04-10 | 中国建设银行股份有限公司 | Data synchronization method and device between asynchronous databases |
| CN111221909B (en) * | 2019-12-31 | 2021-05-28 | 武汉达梦数据库股份有限公司 | Database modification column synchronization method and device based on log analysis |
| CN111241094B (en) * | 2019-12-31 | 2021-06-08 | 武汉达梦数据库有限公司 | Database deleted column synchronization method and device based on log analysis |
| CN111241193B (en) * | 2019-12-31 | 2021-04-27 | 武汉达梦数据库股份有限公司 | Database added column synchronization method and device based on log analysis |
| CN111444278B (en) * | 2020-04-01 | 2023-08-29 | Oppo（重庆）智能科技有限公司 | Data synchronization method and device and transfer server |
| CN111694799B (en) * | 2020-04-30 | 2023-04-25 | 武汉达梦数据库股份有限公司 | Parallel log analysis method and data synchronization system based on log analysis synchronization |
| CN111858505B (en) * | 2020-06-04 | 2024-04-16 | 武汉达梦数据库股份有限公司 | Parallel execution method and data synchronization system based on log analysis synchronization |
| CN112000646B (en) * | 2020-08-25 | 2022-08-02 | 北京浪潮数据技术有限公司 | Database initialization method and device, electronic equipment and storage medium |
| CN112162989B (en) * | 2020-09-24 | 2023-09-15 | 北京人大金仓信息技术股份有限公司 | Database data consistency detection method and device, medium and electronic equipment |
| CN112231407B (en) * | 2020-10-22 | 2023-09-15 | 北京人大金仓信息技术股份有限公司 | DDL synchronization method, device, equipment and medium of PostgreSQL database |
| CN112433992B (en) * | 2020-11-16 | 2023-06-02 | 武汉船舶通信研究所（中国船舶重工集团公司第七二二研究所） | Data synchronization log optimization method |
| CN112612859A (en) * | 2020-12-31 | 2021-04-06 | 上海英方软件股份有限公司 | DDL analysis method and device based on log analysis |
| CN112966025B (en) * | 2021-03-17 | 2022-07-19 | 焦点科技股份有限公司 | Binlog log mining dictionary implementation method |
| CN113282605A (en) * | 2021-04-14 | 2021-08-20 | 上海瀚之友信息技术服务有限公司 | Real-time synchronization system and method for heterogeneous database |
| CN116804994B (en) * | 2023-08-23 | 2023-11-14 | 北京逐风科技有限公司 | Data synchronization method, system, device, electronic equipment and storage medium |
| CN117331963B (en) * | 2023-11-28 | 2024-03-08 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752372A (en) * | 2012-06-18 | 2012-10-24 | 天津神舟通用数据技术有限公司 | File based database synchronization method |
| CN103617176B (en) * | 2013-11-04 | 2017-03-15 | 广东电子工业研究院有限公司 | One kind realizes the autosynchronous method of multi-source heterogeneous data resource |
| US9965497B2 (en) * | 2014-05-29 | 2018-05-08 | Oracle International Corporation | Moving data between partitions |
| CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
-
2018
- 2018-11-19 CN CN201811377371.6A patent/CN109656934B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN109656934A (en) | 2019-04-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109656934B (en) | Source Oracle database DDL synchronization method and device based on log analysis | |
| CN109034993B (en) | Account checking method, account checking equipment, account checking system and computer readable storage medium | |
| CN110908997B (en) | Data blood relationship construction method and device, server and readable storage medium | |
| US20170344433A1 (en) | Apparatus and method for data migration | |
| CN107220142B (en) | Method and device for executing data recovery operation | |
| CN109271452B (en) | DB2 database data synchronous updating method and device | |
| EP3343411A1 (en) | Sql auditing method and apparatus, server and storage device | |
| CN110569214B (en) | Index construction method and device for log file and electronic equipment | |
| JP2005301329A (en) | Transactional consistency change tracking for database | |
| CN109241174B (en) | Data synchronization method and device, readable storage medium and electronic equipment | |
| CN110232093B (en) | Initial loading method and equipment based on flashback inquiry in database synchronization | |
| CN110737594B (en) | Database standard conformance testing method and device for automatically generating test cases | |
| CN110851209A (en) | Data processing method and device, electronic equipment and storage medium | |
| GB2503893A (en) | Selecting data from a database using data representing a sequence of operations | |
| CN106406913B (en) | Method and system for extracting codes from project | |
| CN109977168A (en) | The method for synchronizing data of database and equipment preloaded based on data page | |
| CN114416877A (en) | Data processing method, device and equipment and readable storage medium | |
| CN104462342B (en) | database snapshot synchronization processing method and device | |
| CN109800069B (en) | Method and device for realizing data management | |
| CN105159820A (en) | Transmission method and device of system log data | |
| CN114490554A (en) | Data synchronization method and device, electronic equipment and storage medium | |
| CN105574026A (en) | Method and device for service supporting by using non-relational database | |
| CN108108478B (en) | Data format conversion method and system and electronic equipment | |
| CN111176901B (en) | HDFS deleted file recovery method, terminal device and storage medium | |
| CN106959989A (en) | The synchronous method and device in master/slave data storehouse |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Sun Feng Inventor after: Fu Quan Inventor after: Chen Yan Inventor before: Sun Feng Inventor before: Fu Quan Inventor before: Chen Yan Inventor before: Yang Chun |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Patentee after: Wuhan dream database Co.,Ltd. Address before: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Patentee before: WUHAN DAMENG DATABASE Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20220902 Address after: 430073 16-19 / F, building C3, future science and technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province Patentee after: Wuhan dream database Co.,Ltd. Patentee after: HUAZHONG University OF SCIENCE AND TECHNOLOGY Address before: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Patentee before: Wuhan dream database Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20230728 Address after: 16-19/F, Building C3, Future Science and Technology Building, No. 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province, 430206 Patentee after: Wuhan dream database Co.,Ltd. Address before: 430073 16-19 / F, building C3, future science and technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province Patentee before: Wuhan dream database Co.,Ltd. Patentee before: HUAZHONG University OF SCIENCE AND TECHNOLOGY |