摘要
为了提升分布式数据库多层次之间的数据同步效率,提高数据的共享及复用性,分析了主流的同步机制,选用数据仓库的ETL及XML技术,采用触发器与时间戳相结合的方式实现变更数据的增量抽取,利用Range关键字标记实现断点续传,采用XML技术实现文件与数据库表之间的正反向映射转换。经过实例数据验证可知,随着同步数据量级的增长多层异构数据同步模型时延一直控制在5μs以内,性能优异且无数据丢失的现象,为分布式数据库多层级之间的数据同步提供了可参考方案。
In order to enhance multi-level distributed database data synchronization between the efficiency and improve the data sharing and reuse, mainstream synchronization mechanism are analyzed,and the use of the data warehouse ETL and XML technology,the incremental extraction of change data is realized by combining trigger and timestamp,using Range keywords tag breakpoint continuingly,XML technology is used to realize the forward and reverse mapping transformation between files and database tables. Through the example data verification,with the increase of the magnitude of synchronous data,the delay of the multi-layer heterogeneous data synchronization model is always controlled within 5 micro seconds,with excellent performance and the phenomenon of no data loss,which provides a reference scheme for the data synchronization among multi-levels of distributed database.
作者
刘雅莉
LIU Yali(Shangluo University Faculty of Economics and Management,Shangluo 726000,China)
出处
《电子设计工程》
2022年第16期36-40,共5页
Electronic Design Engineering
