CN109558452B - Synchronization method for query table building operation - Google Patents
Synchronization method for query table building operation Download PDFInfo
- Publication number
- CN109558452B CN109558452B CN201811377399.XA CN201811377399A CN109558452B CN 109558452 B CN109558452 B CN 109558452B CN 201811377399 A CN201811377399 A CN 201811377399A CN 109558452 B CN109558452 B CN 109558452B
- Authority
- CN
- China
- Prior art keywords
- query
- synchronization
- table building
- sql
- building
- 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 43
- 230000008569 process Effects 0.000 claims abstract description 12
- 230000001360 synchronised effect Effects 0.000 claims description 12
- 238000004458 analytical method Methods 0.000 claims description 9
- 238000001914 filtration Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 5
- 238000012216 screening Methods 0.000 claims description 5
- 230000005540 biological transmission Effects 0.000 claims description 4
- 238000000605 extraction Methods 0.000 claims description 2
- 238000003780 insertion Methods 0.000 claims description 2
- 230000037431 insertion Effects 0.000 claims description 2
- 230000010076 replication Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000007717 exclusion Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000005012 migration Effects 0.000 description 1
- 238000013508 migration Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
name of field | Type (B) | Description of the invention |
OBJ_SCHNAME | VARchar(128) | Object schema name |
OBJ_NAME | VARchar(128) | Object name |
OP_SQL | CLOB | SQL statement of DDL operation |
OP_TIME | DATETIME(6) | Time of operation |
Claims (8)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811377399.XA CN109558452B (en) | 2018-11-19 | 2018-11-19 | Synchronization method for query table building operation |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811377399.XA CN109558452B (en) | 2018-11-19 | 2018-11-19 | Synchronization method for query table building operation |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109558452A CN109558452A (en) | 2019-04-02 |
CN109558452B true CN109558452B (en) | 2020-12-08 |
Family
ID=65866818
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811377399.XA Active CN109558452B (en) | 2018-11-19 | 2018-11-19 | Synchronization method for query table building operation |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109558452B (en) |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110688367A (en) * | 2019-09-27 | 2020-01-14 | 浪潮软件集团有限公司 | Universal database migration adaptation method and system |
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 |
CN111221907B (en) * | 2019-12-31 | 2021-03-30 | 武汉达梦数据库股份有限公司 | Database added column synchronization method and device based on log analysis |
CN112559626B (en) * | 2020-12-11 | 2022-06-21 | 武汉达梦数据库股份有限公司 | Synchronous method and synchronous system of DDL operation based on log analysis |
CN112765180B (en) * | 2021-01-27 | 2023-01-17 | 上海英方软件股份有限公司 | Method and device for analyzing column names of table building logs of DB2 database |
CN114253925B (en) * | 2021-12-01 | 2024-08-20 | 北京人大金仓信息技术股份有限公司 | Method, server, terminal and electronic equipment for accessing database logs |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101615199A (en) * | 2009-07-31 | 2009-12-30 | 深圳市珍爱网信息技术有限公司 | Heterogeneous database synchronization method and system |
CN103617176A (en) * | 2013-11-04 | 2014-03-05 | 广东电子工业研究院有限公司 | Method for achieving automatic synchronization of multi-source heterogeneous data resources |
CN104679841A (en) * | 2015-02-11 | 2015-06-03 | 北京京东尚科信息技术有限公司 | Consumption terminal data flow copying method and system |
CN106326376A (en) * | 2016-08-15 | 2017-01-11 | 东软集团股份有限公司 | Method and device for copying information after table structure modification |
CN108664659A (en) * | 2018-05-21 | 2018-10-16 | 四川中电启明星信息技术有限公司 | A kind of method of data synchronization and device of Distributed Heterogeneous Database |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8086564B2 (en) * | 2007-12-12 | 2011-12-27 | Oracle International Corporation | Techniques for the logical replication of high-level procedures |
-
2018
- 2018-11-19 CN CN201811377399.XA patent/CN109558452B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101615199A (en) * | 2009-07-31 | 2009-12-30 | 深圳市珍爱网信息技术有限公司 | Heterogeneous database synchronization method and system |
CN103617176A (en) * | 2013-11-04 | 2014-03-05 | 广东电子工业研究院有限公司 | Method for achieving automatic synchronization of multi-source heterogeneous data resources |
CN104679841A (en) * | 2015-02-11 | 2015-06-03 | 北京京东尚科信息技术有限公司 | Consumption terminal data flow copying method and system |
CN106326376A (en) * | 2016-08-15 | 2017-01-11 | 东软集团股份有限公司 | Method and device for copying information after table structure modification |
CN108664659A (en) * | 2018-05-21 | 2018-10-16 | 四川中电启明星信息技术有限公司 | A kind of method of data synchronization and device of Distributed Heterogeneous Database |
Also Published As
Publication number | Publication date |
---|---|
CN109558452A (en) | 2019-04-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109558452B (en) | Synchronization method for query table building operation | |
EP3968175B1 (en) | Data replication method and apparatus, and computer device and storage medium | |
US11138227B2 (en) | Consistent query execution in hybrid DBMS | |
US8868512B2 (en) | Logging scheme for column-oriented in-memory databases | |
CN102402596B (en) | A kind of reading/writing method of master slave separation database and system | |
CA2485936C (en) | High-performance change capture for data warehousing | |
US7406489B2 (en) | Apparatus, system and method for persistently storing data in a data synchronization process | |
US8380663B2 (en) | Data integrity in a database environment through background synchronization | |
US20080140627A1 (en) | Method and apparatus for aggregating database runtime information and analyzing application performance | |
CA2483039A1 (en) | Method and apparatus for change data capture in a database system | |
CN102346775A (en) | Method for synchronizing multiple heterogeneous source databases based on log | |
CN109086382B (en) | Data synchronization method, device, equipment and storage medium | |
KR102038529B1 (en) | System for processing real-time data modification of in-memory database | |
CN109508346B (en) | Cascade synchronous control method and system for DDL operation | |
CN111625552B (en) | Data collection method, device, equipment and readable storage medium | |
KR101429046B1 (en) | Method for searching, inputting, deleting and garbage collecting of data in database having key-value structure | |
CN111694893B (en) | Partial rollback analysis method and data synchronization system based on log analysis | |
CN106846024B (en) | Redis-based coupon issuing method, system and computer-readable storage medium | |
CN111782671A (en) | Optimization method for realizing CDC (performance control) based on distributed database | |
Zhou et al. | An ETL strategy for real-time data warehouse | |
CN110222121A (en) | A kind of SQL Server database increment synchronization realization method and system based on CDC mode | |
CN106919566A (en) | A kind of query statistic method and system based on mass data | |
CN117743459A (en) | Incremental data synchronization method, device, system, electronic equipment and readable medium | |
CN109669988B (en) | Splitting and synchronizing method and system for inquiring table-building transaction | |
WO2023142610A1 (en) | Data processing method and apparatus |
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: Yu Yuanlan Inventor before: Sun Feng Inventor before: Fu Quan Inventor before: Yu Yuanlan 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: 20220915 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: 20230719 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 |