基于嵌入式数据库SQLITE的采煤机智能监控系统

Intelligent Monitoring System of Shearer Malfunction Based on Embedded Database of SQLITE

针对采煤机监控系统的数据批量操作、管理和维护的需要,采用SQLite数据库作为存储介质,设计3个独立数据库分别存储故障记录、参数修改记录、实时数据记录。介绍了采煤机数据存储的难点、SQLite数据库的特点和使用方法,详细阐述了采煤机监控系统数据库的功能设计和具体实现方法,简化了应用程序的开发过程,提高了数据管理的效率、查询速度,具有体积小、快速高效、稳定可靠、易移植等优势。

Owing to data operation, manage and maintenance of shearer intelligent monitoring system, this paper uses SQLite as database to save and query data, design three separate databses to save fault, parameter, data, introduces SQLite character and usage method, explains function design and realize means of monitoring system database. This way could simplify development process of application, enhance efficiency of saving records. And this way is effective, stable, reliable, and easily transplanted.