成都工业学院学报2024,Vol.27Issue(6) :51-56.DOI:10.13542/j.cnki.51-1747/tn.2024.06.008

基于WebService的分布式数据库多层同步方法

A Multi-layer Synchronization Method for Distributed Database based on WebService

田艳芳
成都工业学院学报2024,Vol.27Issue(6) :51-56.DOI:10.13542/j.cnki.51-1747/tn.2024.06.008

基于WebService的分布式数据库多层同步方法

A Multi-layer Synchronization Method for Distributed Database based on WebService

田艳芳1
扫码查看

作者信息

  • 1. 辽宁民族师范高等专科学校 民族文化与职业教育系,辽宁 阜新 123100
  • 折叠

摘要

当前针对分布式数据库多层同步多采用共识机制,但此方法缺少对数据的一致性校验,导致数据库同步效率偏低.为此,提出基于WebService的分布式数据库多层同步方法.依据数据库多层同步原理,采用WebService模块设置的数据库接口技术协议,实现不同数据库之间的通信和数据交换.通过计算数据的校验水平,判断数据的一致性,并结合数据存放的分布状态,求取数据库间的同步标记序列函数,用于确定数据库之间的同步状态.将同步标记序列函数添加到数据库接口协议中,对数据库的操作状态进行标记,可以实时监测数据库的同步情况,并及时处理数据的更新和同步操作.通过构建触发器,实现分布式数据库的多层同步.当满足特定条件时触发同步操作,确保数据库之间的实时数据同步和更新.实验结果显示,所提方法每s同步的数据量高于70条,同步延迟低于0.62 ms.证明所提方法能够显著提升数据库的同步效率,同步结果较好.

Abstract

Currently,consensus mechanism is commonly used in multi-layer synchronization of distributed database,but this method lacks consistency verification of data,resulting in low efficiency of database synchronization.To this end,a multi-layer synchronization method for distributed databases based on WebService was proposed.Based on the principle of multi-layer database synchronization,the database interface technology protocol set by the WebService module was used to achieve communication and data exchange between different databases.By calculating the verification level of the data and judging the consistency of the data,and combining the distribution status of the data storage,the synchronization marker sequence function between database was obtained to determine the synchronization status between database.A synchronization marker sequence function was added to the database interface protocol to mark the operation status of the database,which can monitor the synchronization status of the database in real time and handle the update and synchronization of the data in a timely manner.By constructing trigger,multi-layer synchronization of distributed database could be achieved,and synchronization operation could be triggered when specific conditions were met to ensure real-time data synchronization and update between database.The experimental results show that the proposed method synchronizes more than 70 data points per second,and the synchronization delay is less than 0.62 ms.It has been proven that the proposed method can significantly improve the synchronization efficiency of the database,and the synchronization results are good.

关键词

WebService/分布式数据库/多层同步/同步效率

Key words

WebService/Distributed Database/multi-layer synchronization/synchronous efficiency

引用本文复制引用

出版年

2024
成都工业学院学报
成都电子机械高等专科学校

成都工业学院学报

影响因子:0.324
ISSN:2095-5383
段落导航相关论文