Remote Monitoring System Based On Embedded Database

With the gradual popularization of automated systems, many factories and enterprises are equipped with a variety of remote monitoring system. In the remote monitoring system, data management function is a more important function which can be accomplished by traditional databases. But in the embedded server, traditional databases are no longer suitable due to hardware and software resource constraints. In this case, the embedded database's applications and researches are much more important obviously.This paper has designed a remote monitoring system which is bases on the skills of embedded database SQLite 3.0.The main contents are as follows:(1) An overall plan for the remote monitoring system structure is made. Embedded Web Server is the core of the system, 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 timely, and then know the current condition well. The function of data collection in the system is mainly accomplished by the sensors. And the data has been transmitted into the Web Server through the serial port. The software can be any kind of browser.(2) A remote monitoring system development environment is established. According to the design proposal, the model of ARM9 development board and the sensor has been selected. After studying the embedded system's principle of work, the Linux operating system has been transplanted. The transplantation mainly includes setting main engine environment, bootloader transplantation and root file system transplantation. Through analyzing the design and implementation principle, a web server platform has been build successfully.(3) The technology of embedded database has been researched and applied to. After overview the technology of embedded database, the paper analyzed the key skills of the database, especially the SQLite 3.0 database. And according to this, the paper designed the method to collect data.(4) Monitoring software is designed and implemented. Combined with the overall planning system and functional analysis, this paper designs the monitoring structure of the software model. The ways to achieve is described, especially several main functional modules and instructions.Through the application of embedded database SQLite 3.0, the embedded technology and database technology has been combined for the purpose of enhancing data management capabilities of the system and ultimately improving the remote monitoring system performance.