Remote Database Synchronization Mechanism Based on SQL Capture from Connection Driver

Gespeichert in:
Bibliographische Detailangaben
Titel: Remote Database Synchronization Mechanism Based on SQL Capture from Connection Driver
Autoren: DING Jianli,ZHOU Dongxue,WANG Jing,WANG Jialiang
Quelle: Jisuanji gongcheng, Vol 43, Iss 9, Pp 39-42,50 (2017)
Verlagsinformationen: Editorial Office of Computer Engineering, 2017.
Publikationsjahr: 2017
Bestand: LCC:Computer engineering. Computer hardware
LCC:Computer software
Schlagwörter: data synchronization, sql capture, consistency, distant double live data center, heterogeneous database, java database connectivity(jdbc), Computer engineering. Computer hardware, TK7885-7895, Computer software, QA76.75-76.765
Beschreibung: Data synchronization is the key technology for the implementation of distant double live data center.As current remote database synchronization mechanisms have low efficiency and there is no good solution for the synchronization of heterogeneous databases,this paper presents a new remote database synchronization mechanism.It analyzes the procedure of an application manipulating the database,researches the method of capturing SQL from the database connection driver,and designs a consistency algorithm for data verification.Experimental result shows that this mechanism can improve the efficiency of remote database synchronization and support the synchronization of heterogeneous databases,which provides technical support for the construction of multi-data center and disaster recovery system in the age of big data.
Publikationsart: article
Dateibeschreibung: electronic resource
Sprache: English
Chinese
ISSN: 1000-3428
Relation: https://www.ecice06.com/fileup/1000-3428/PDF/201709008.pdf; https://doaj.org/toc/1000-3428
DOI: 10.3969/j.issn.1000-3428.2017.09.008
Zugangs-URL: https://doaj.org/article/057ed5bd3727419dbbbe7d49d8700a6d
Dokumentencode: edsdoj.057ed5bd3727419dbbbe7d49d8700a6d
Datenbank: Directory of Open Access Journals
Beschreibung
Abstract:Data synchronization is the key technology for the implementation of distant double live data center.As current remote database synchronization mechanisms have low efficiency and there is no good solution for the synchronization of heterogeneous databases,this paper presents a new remote database synchronization mechanism.It analyzes the procedure of an application manipulating the database,researches the method of capturing SQL from the database connection driver,and designs a consistency algorithm for data verification.Experimental result shows that this mechanism can improve the efficiency of remote database synchronization and support the synchronization of heterogeneous databases,which provides technical support for the construction of multi-data center and disaster recovery system in the age of big data.
ISSN:10003428
DOI:10.3969/j.issn.1000-3428.2017.09.008