Title :
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
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;
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
DOI :
10.1109/CMC.2010.188
