CN109614444A - 一种数据同步时的数据初始化方法 - Google Patents
一种数据同步时的数据初始化方法 Download PDFInfo
- Publication number
- CN109614444A CN109614444A CN201811338934.0A CN201811338934A CN109614444A CN 109614444 A CN109614444 A CN 109614444A CN 201811338934 A CN201811338934 A CN 201811338934A CN 109614444 A CN109614444 A CN 109614444A
- Authority
- CN
- China
- Prior art keywords
- data
- vernier
- synchronous
- load table
- load
- 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 21
- 238000011423 initialization method Methods 0.000 title claims abstract description 16
- 238000000034 method Methods 0.000 claims abstract description 18
- 238000003756 stirring Methods 0.000 claims abstract description 12
- 238000012217 deletion Methods 0.000 claims abstract description 6
- 230000037430 deletion Effects 0.000 claims abstract description 6
- 230000008569 process Effects 0.000 claims abstract description 6
- 238000003780 insertion Methods 0.000 claims description 7
- 230000037431 insertion Effects 0.000 claims description 7
- 230000009471 action Effects 0.000 claims description 5
- 238000005096 rolling process Methods 0.000 claims description 5
- 238000004590 computer program Methods 0.000 claims description 3
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Hardware Redundancy (AREA)
- Stored Programmes (AREA)
Abstract
Description
Claims (5)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811338934.0A CN109614444B (zh) | 2018-11-12 | 2018-11-12 | 一种数据同步时的数据初始化方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811338934.0A CN109614444B (zh) | 2018-11-12 | 2018-11-12 | 一种数据同步时的数据初始化方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109614444A true CN109614444A (zh) | 2019-04-12 |
CN109614444B CN109614444B (zh) | 2023-05-16 |
Family
ID=66003879
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811338934.0A Active CN109614444B (zh) | 2018-11-12 | 2018-11-12 | 一种数据同步时的数据初始化方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109614444B (zh) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111601324A (zh) * | 2020-04-30 | 2020-08-28 | 重庆科技学院 | 一种针对终端中应用数据的统计方法及统计*** |
CN117093638A (zh) * | 2023-10-17 | 2023-11-21 | 博智安全科技股份有限公司 | 一种微服务数据初始化方法、***、电子设备及存储介质 |
Citations (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102081611A (zh) * | 2009-11-26 | 2011-06-01 | 中兴通讯股份有限公司 | 一种主、备网管***数据库同步的实现方法及装置 |
CN102346775A (zh) * | 2011-09-26 | 2012-02-08 | 苏州博远容天信息科技有限公司 | 一种基于日志的异构多源数据库同步方法 |
JP2012155498A (ja) * | 2011-01-25 | 2012-08-16 | Fujitsu Ltd | データベースサーバ装置、データベース更新方法及びデータベース更新プログラム |
CN103064976A (zh) * | 2013-01-14 | 2013-04-24 | 浙江水利水电专科学校 | 基于主动数据库技术的同异构dbms间数据交换方法 |
CN104967658A (zh) * | 2015-05-08 | 2015-10-07 | 成都品果科技有限公司 | 一种多终端设备上的数据同步方法 |
CN105183860A (zh) * | 2015-09-10 | 2015-12-23 | 北京京东尚科信息技术有限公司 | 数据同步方法和*** |
CN105320680A (zh) * | 2014-07-15 | 2016-02-10 | ***通信集团公司 | 一种数据同步方法及装置 |
CN105512284A (zh) * | 2015-12-07 | 2016-04-20 | 上海爱数信息技术股份有限公司 | 基于事务形态数据和binlog文件的MySQL数据保护方法 |
CN105589924A (zh) * | 2015-11-23 | 2016-05-18 | 江苏瑞中数据股份有限公司 | 一种数据库事务粒度同步方法 |
US20160259837A1 (en) * | 2014-03-24 | 2016-09-08 | Hitachi, Ltd. | Database management system and method for controlling synchronization between databases |
US20160350353A1 (en) * | 2015-05-29 | 2016-12-01 | Oracle International Corporation | Elimination of log file synchronization delay at transaction commit time |
CN107562882A (zh) * | 2017-09-04 | 2018-01-09 | 郑州云海信息技术有限公司 | 一种基于日志分析的数据同步方法及装置 |
CN108509462A (zh) * | 2017-02-28 | 2018-09-07 | 华为技术有限公司 | 一种同步活动事务表的方法及装置 |
-
2018
- 2018-11-12 CN CN201811338934.0A patent/CN109614444B/zh active Active
Patent Citations (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102081611A (zh) * | 2009-11-26 | 2011-06-01 | 中兴通讯股份有限公司 | 一种主、备网管***数据库同步的实现方法及装置 |
JP2012155498A (ja) * | 2011-01-25 | 2012-08-16 | Fujitsu Ltd | データベースサーバ装置、データベース更新方法及びデータベース更新プログラム |
CN102346775A (zh) * | 2011-09-26 | 2012-02-08 | 苏州博远容天信息科技有限公司 | 一种基于日志的异构多源数据库同步方法 |
CN103064976A (zh) * | 2013-01-14 | 2013-04-24 | 浙江水利水电专科学校 | 基于主动数据库技术的同异构dbms间数据交换方法 |
US20160259837A1 (en) * | 2014-03-24 | 2016-09-08 | Hitachi, Ltd. | Database management system and method for controlling synchronization between databases |
CN105320680A (zh) * | 2014-07-15 | 2016-02-10 | ***通信集团公司 | 一种数据同步方法及装置 |
CN104967658A (zh) * | 2015-05-08 | 2015-10-07 | 成都品果科技有限公司 | 一种多终端设备上的数据同步方法 |
US20160350353A1 (en) * | 2015-05-29 | 2016-12-01 | Oracle International Corporation | Elimination of log file synchronization delay at transaction commit time |
CN105183860A (zh) * | 2015-09-10 | 2015-12-23 | 北京京东尚科信息技术有限公司 | 数据同步方法和*** |
CN105589924A (zh) * | 2015-11-23 | 2016-05-18 | 江苏瑞中数据股份有限公司 | 一种数据库事务粒度同步方法 |
CN105512284A (zh) * | 2015-12-07 | 2016-04-20 | 上海爱数信息技术股份有限公司 | 基于事务形态数据和binlog文件的MySQL数据保护方法 |
CN108509462A (zh) * | 2017-02-28 | 2018-09-07 | 华为技术有限公司 | 一种同步活动事务表的方法及装置 |
CN107562882A (zh) * | 2017-09-04 | 2018-01-09 | 郑州云海信息技术有限公司 | 一种基于日志分析的数据同步方法及装置 |
Non-Patent Citations (1)
Title |
---|
丁建立: "基于连接驱动SQL捕获的远程数据库同步机制", 《计算机工程》 * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111601324A (zh) * | 2020-04-30 | 2020-08-28 | 重庆科技学院 | 一种针对终端中应用数据的统计方法及统计*** |
CN117093638A (zh) * | 2023-10-17 | 2023-11-21 | 博智安全科技股份有限公司 | 一种微服务数据初始化方法、***、电子设备及存储介质 |
CN117093638B (zh) * | 2023-10-17 | 2024-01-23 | 博智安全科技股份有限公司 | 一种微服务数据初始化方法、***、电子设备及存储介质 |
Also Published As
Publication number | Publication date |
---|---|
CN109614444B (zh) | 2023-05-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20220129476A1 (en) | Enhanced mechanisms for managing multidimensional data | |
CN110209728B (zh) | 一种分布式异构数据库同步方法、电子设备及存储介质 | |
CN107609188B (zh) | 基于GoldenGate的数据同步校验方法 | |
US6826604B2 (en) | Input/output device information management system for multi-computer system | |
US7912819B2 (en) | Systems and methods for versioning based triggers | |
US20040205598A1 (en) | Method and system for management of structured document and medium having processing program therefor | |
CN110727724B (zh) | 数据抽取方法、装置、计算机设备和存储介质 | |
CN106991104B (zh) | 数据库脚本部署装置和数据库脚本部署方法 | |
CN109614444A (zh) | 一种数据同步时的数据初始化方法 | |
CN112632105B (zh) | 大规模事务负载生成与数据库隔离级别正确性验证***及方法 | |
CN111930850A (zh) | 数据校验方法、装置、计算机设备和存储介质 | |
EP3147789A1 (en) | Method for re-establishing standby database, and apparatus thereof | |
CN111125067A (zh) | 数据维护方法及装置 | |
CN114860689A (zh) | 一种在异构数据库之间迁移数据对象的方法及*** | |
CN109271199A (zh) | 一种用于数据库持续集成与脚本文件管理的方法及*** | |
CN117472647A (zh) | 一种数据库事务回滚方法及装置 | |
CN117131060A (zh) | 分布式数据库并发控制方法、***、计算机设备 | |
CN109902085B (zh) | 一种配置存储结构优化方法及*** | |
CN109117173B (zh) | 一种基于项目版本开发的配制文件管理方法 | |
US8904348B2 (en) | Method and system for handling errors during script execution | |
CN115344966A (zh) | 一种cad装配体零部件替换方法及*** | |
CN109656932A (zh) | 一种数据同步时利用更新游标的数据初始化方法 | |
WO2023045054A1 (zh) | 结构化查询语句的生成方法、装置和计算机设备 | |
CN112232768A (zh) | 一种基于全生命周期管理的商户数据处理方法 | |
US8015150B2 (en) | Method for editing related data in a database |
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 |
Inventor after: Sun Feng Inventor after: Fu Quan Inventor before: Sun Feng Inventor before: Fu Quan Inventor before: Yang Chun |
|
CB03 | Change of inventor or designer information | ||
CB02 | Change of applicant information |
Address after: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Applicant 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 Applicant before: WUHAN DAMENG DATABASE Co.,Ltd. |
|
CB02 | Change of applicant information | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20220919 Address after: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Applicant after: Wuhan dream database Co.,Ltd. Applicant 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 Applicant before: Wuhan dream database Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right |
Effective date of registration: 20230725 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 dream database Co.,Ltd. Patentee before: HUAZHONG University OF SCIENCE AND TECHNOLOGY |
|
TR01 | Transfer of patent right |