CN109669988A - 一种查询建表事物的拆分同步方法及系统 - Google Patents
一种查询建表事物的拆分同步方法及系统 Download PDFInfo
- Publication number
- CN109669988A CN109669988A CN201811541215.9A CN201811541215A CN109669988A CN 109669988 A CN109669988 A CN 109669988A CN 201811541215 A CN201811541215 A CN 201811541215A CN 109669988 A CN109669988 A CN 109669988A
- Authority
- CN
- China
- Prior art keywords
- log
- things
- sub
- transaction
- transaction log
- 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
- 230000001360 synchronised effect Effects 0.000 title claims abstract description 75
- 238000000034 method Methods 0.000 title claims abstract description 68
- 238000005194 fractionation Methods 0.000 title claims abstract description 38
- 238000003780 insertion Methods 0.000 claims abstract description 18
- 230000037431 insertion Effects 0.000 claims abstract description 18
- 230000008569 process Effects 0.000 claims description 41
- 238000004590 computer program Methods 0.000 claims description 5
- 238000012856 packing Methods 0.000 claims description 2
- 238000006243 chemical reaction Methods 0.000 claims 1
- 230000003111 delayed effect Effects 0.000 abstract 1
- 238000005516 engineering process Methods 0.000 description 5
- FFBHFFJDDLITSX-UHFFFAOYSA-N benzyl N-[2-hydroxy-4-(3-oxomorpholin-4-yl)phenyl]carbamate Chemical compound OC1=C(NC(=O)OCC2=CC=CC=C2)C=CC(=C1)N1CCOCC1=O FFBHFFJDDLITSX-UHFFFAOYSA-N 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000002618 waking effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 239000011159 matrix material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 230000002441 reversible effect Effects 0.000 description 1
Landscapes
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811541215.9A CN109669988B (zh) | 2018-12-17 | 2018-12-17 | 一种查询建表事务的拆分同步方法及系统 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811541215.9A CN109669988B (zh) | 2018-12-17 | 2018-12-17 | 一种查询建表事务的拆分同步方法及系统 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109669988A true CN109669988A (zh) | 2019-04-23 |
CN109669988B CN109669988B (zh) | 2020-10-30 |
Family
ID=66144450
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811541215.9A Active CN109669988B (zh) | 2018-12-17 | 2018-12-17 | 一种查询建表事务的拆分同步方法及系统 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109669988B (zh) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110825816A (zh) * | 2020-01-09 | 2020-02-21 | 四川新网银行股份有限公司 | 对分片数据库数据采集的系统和方法 |
CN111694798A (zh) * | 2020-04-23 | 2020-09-22 | 武汉达梦数据库有限公司 | 一种基于日志解析的数据同步方法及数据同步系统 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102542007A (zh) * | 2011-12-13 | 2012-07-04 | 中国电子科技集团公司第十五研究所 | 关系型数据库之间的同步方法及系统 |
US20160371319A1 (en) * | 2015-06-19 | 2016-12-22 | Sap Se | Synchronization on reactivation of asynchronous table replication |
CN106445687A (zh) * | 2016-09-27 | 2017-02-22 | 金蝶软件(中国)有限公司 | 一种大事务执行方法及其系统 |
CN106777270A (zh) * | 2016-12-28 | 2017-05-31 | 中国民航信息网络股份有限公司 | 一种基于提交点时间线同步的异构数据库复制并行执行系统及方法 |
-
2018
- 2018-12-17 CN CN201811541215.9A patent/CN109669988B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102542007A (zh) * | 2011-12-13 | 2012-07-04 | 中国电子科技集团公司第十五研究所 | 关系型数据库之间的同步方法及系统 |
US20160371319A1 (en) * | 2015-06-19 | 2016-12-22 | Sap Se | Synchronization on reactivation of asynchronous table replication |
CN106445687A (zh) * | 2016-09-27 | 2017-02-22 | 金蝶软件(中国)有限公司 | 一种大事务执行方法及其系统 |
CN106777270A (zh) * | 2016-12-28 | 2017-05-31 | 中国民航信息网络股份有限公司 | 一种基于提交点时间线同步的异构数据库复制并行执行系统及方法 |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110825816A (zh) * | 2020-01-09 | 2020-02-21 | 四川新网银行股份有限公司 | 对分片数据库数据采集的系统和方法 |
CN110825816B (zh) * | 2020-01-09 | 2020-04-21 | 四川新网银行股份有限公司 | 对分片数据库数据采集的系统和方法 |
CN111694798A (zh) * | 2020-04-23 | 2020-09-22 | 武汉达梦数据库有限公司 | 一种基于日志解析的数据同步方法及数据同步系统 |
CN111694798B (zh) * | 2020-04-23 | 2023-04-25 | 武汉达梦数据库股份有限公司 | 一种基于日志解析的数据同步方法及数据同步系统 |
Also Published As
Publication number | Publication date |
---|---|
CN109669988B (zh) | 2020-10-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110347746B (zh) | 一种异构数据库同步数据一致性校验方法及装置 | |
CN110209726B (zh) | 分布式数据库集群系统、数据同步方法及存储介质 | |
CA2793429C (en) | Database management system | |
KR950025564A (ko) | 재해복구를 위한 일관성 그룹 형성방법 및 레코드 갱신의 섀도잉 방법, 주시스템, 원격 데이타 섀도잉 시스템과 비동기 원격 데이타 복제 시스템 | |
CN105975579B (zh) | 一种内存数据库的主备复制方法及内存数据库系统 | |
CN109669988A (zh) | 一种查询建表事物的拆分同步方法及系统 | |
CN113987064A (zh) | 数据处理方法、系统及设备 | |
US9910733B2 (en) | Transaction completion in a synchronous replication environment | |
CN109558452A (zh) | 一种查询建表操作的同步方法 | |
CN112988916B (zh) | 针对Clickhouse的全量和增量同步方法、设备和存储介质 | |
CN110750594B (zh) | 一种基于mysql增量日志实时跨网络数据库同步方法 | |
CN104980307A (zh) | 数据访问请求的处理方法、装置及数据库服务器 | |
CN112527801A (zh) | 关系型数据库与大数据系统间的数据同步方法及系统 | |
US10579604B2 (en) | Database system, information processing device, method and medium | |
CN115269694A (zh) | 一种数据统一实时采集装置及采集方法 | |
CN110895547A (zh) | 基于db2联邦特性的多源异构数据库数据同步系统及方法 | |
CN114374701A (zh) | 一种多级联动人工智能平台样本模型透明共享装置 | |
CN111914028A (zh) | 一种基于图增量同步异构数据源数据关系的方法及装置 | |
CN112800060A (zh) | 数据处理方法、装置、计算机可读存储介质及电子设备 | |
WO2023138213A1 (zh) | 一种基于地铁车站系统的数仓数据查询方法及装置 | |
CN111770145A (zh) | 一种基于日志解析的单向网络双边数据同步系统及方法 | |
CN116340114A (zh) | 一种流式处理日志告警方法 | |
CN114661558A (zh) | 一种基于离线分析数据库Log的通用数据库表监控方法 | |
CN115185787A (zh) | 处理事务日志的方法及装置 | |
CN114528049A (zh) | 一种基于InfluxDB实现API调用信息统计的方法及系统 |
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 | ||
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. |
|
CB03 | Change of inventor or designer information |
Inventor after: Sun Feng Inventor after: Yu Yuanlan Inventor after: Zhao Jiawei Inventor before: Sun Feng Inventor before: Fu Quan Inventor before: Yu Yuanlan Inventor before: Zhao Jiawei |
|
CB03 | Change of inventor or designer information | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220907 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: 20230802 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 |
|
TR01 | Transfer of patent right |