Research on Interconnection and Correspondence Between Relational Database and Embedded Database SQLite

Author

Xu, Yang ; Li, Hai-Yang

Author_Institution

Northwest A&F Univ., Yangling, China

Volume

1

fYear

2010

fDate

12-14 April 2010

Firstpage

279

Lastpage

283

Abstract

Considering agricultural product´s feature and the current sale status of China´s agricultural products, our system aims to use the Heterogeneous Database Synchronization technology to achieve the goal of Synchronous communication of Embedded Database SQLite and Relational Database MySQL. The system use JDBC technology connecting to the database and use an improved method of Change Capture Technology (Triggered Scanning Method) to accelerate the speed of scanning logs and improve the rate of data synchronization. The combination of Heterogeneous Database Synchronization technology and embedded technology can promote the application of the network of agricultural products marketing information.

Keywords

SQL; agriculture; relational databases; synchronisation; JDBC technology; MySQL; SQLite; agricultural products marketing information; change capture technology; embedded database; heterogeneous database synchronization technology; relational database; Agricultural products; Communications technology; Linux; Marketing and sales; Mobile communication; Mobile computing; Relational databases; Spatial databases; Technology management; Transaction databases; Embedded Database; Heterogeneous Database Synchronization; Triggered Scanning Method;

fLanguage

English

Publisher

ieee

Conference_Titel

Communications and Mobile Computing (CMC), 2010 International Conference on

Conference_Location

Shenzhen

Print_ISBN

978-1-4244-6327-5

Electronic_ISBN

978-1-4244-6328-2

Type

conf

DOI

10.1109/CMC.2010.188

Filename

5471470