嵌入式数据库SQLite在测控系统设计中的应用  

Measurement and control system based on SQLite embedded database

作　　者：蔡勇[1] 王勇[1] 

机构地区：[1]南京邮电大学,南京210003

出　　处：《电子测试》2011年第10期89-93,共5页Electronic Test

摘　　要：基于嵌入式数据库SQLite3.0技术设计了一个新的测控系统。该系统以嵌入式服务器为核心,把现场采集到的数据,加工处理后发布到网络中,供远程用户及时浏览和查看。文中分析了嵌入式数据库的特点和关键技术,并且在此基础上,着重研究了SQLite3.0数据库的内部结构、应用方式和移植方法。该技术以SQLite3.0为后台,进行数据的存储和处理,前台通过Web技术,用户可以通过网络浏览器观察经过处理之后的数据。通过使用SQLite3.0数据库技术代替传统的数据库技术,可以降低嵌入式系统的内存消耗,提高嵌入式系统的处理能力,使得该系统更加适用于嵌入式系统环境。Based on the skills of embedded database SQLite3.0,a novel measurement and control system has been designed.An overall plan for the measurement and control system structure is made.The core of the system is Embedded Web Server,which is responsible for receiving the data collected by the underlying equipment,and releases it to the network after being processed.Through the technology of database,the remote users can analyze and store data immediately,and then know the current condition well.The function of data collection in the system is mainly accomplished by the sensors.All the data has been transmitted into the Web Server through the serial port.The software may be any kind of browser.The technology of embedded database has been investigated in this paper.After overview the technology of embedded database,we analyzed the key skill of the database,especially the SQLite3.0 database.And according to this,we designed the method to collect data.

关 键 词：嵌入式数据库 测控系统 SQLite3.0 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]