{"title":"关系型数据库与嵌入式数据库SQLite的互连与对应研究","authors":"Yang Xu, Hai-Yang Li","doi":"10.1109/CMC.2010.188","DOIUrl":null,"url":null,"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.","PeriodicalId":296445,"journal":{"name":"2010 International Conference on Communications and Mobile Computing","volume":"12 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2010-04-12","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Research on Interconnection and Correspondence Between Relational Database and Embedded Database SQLite\",\"authors\":\"Yang Xu, Hai-Yang Li\",\"doi\":\"10.1109/CMC.2010.188\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":296445,\"journal\":{\"name\":\"2010 International Conference on Communications and Mobile Computing\",\"volume\":\"12 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2010-04-12\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2010 International Conference on Communications and Mobile Computing\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/CMC.2010.188\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2010 International Conference on Communications and Mobile Computing","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/CMC.2010.188","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Research on Interconnection and Correspondence Between Relational Database and Embedded Database SQLite
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.