嵌入式数据库技术在煤矿井上监控系统的开发与应用

【作者】 陈锦强；

【导师】 李琨；

【作者基本信息】 昆明理工大学 ， 控制理论与控制工程， 2007， 硕士

【摘要】 近年来随着嵌入式系统的迅猛发展，在嵌入式系统中需要存储和管理的数据量也高速增长，一种全新的数据库产品——嵌入式数据库系统应运而生。嵌入式数据库是指支持某种特定计算模式的数据库管理系统，它通常与操作系统和具体应用集成在一起，运行在智能型嵌入式设备或实时应用环境中。和传统数据库相比，嵌入式数据库具有占用内存资源很少、系统开销较低、和应用紧密结合、系统健壮、伸缩性良好等特点，在数据库系统实现方面因而有自己的特色。本文针对当前煤矿安全监测监控系统设备结构庞大、稳定性能较弱，难以适应矿井生产环境易于振动、多灰、潮湿、高温等恶劣条件的特点，提出了嵌入式系统技术在煤矿安全监测监控终端中的应用；并根据嵌入式系统存储资源少、计算能力弱等特点，研究了嵌入式数据库技术在煤矿井上监控系统中的开发与应用。论文首先介绍了嵌入式系统的相关概念和软硬件环境，阐明煤矿井上监控终端的嵌入式系统需求和Windows CE嵌入式操作系统选择；接着，从嵌入式数据库的相关概念和煤矿井上监控终端的嵌入式数据库需求及特点出发，详细研究Berkeley DB数据库的关键技术特性以及在煤矿井上监控系统中的适用性，并介绍Berkeley DB数据库的基本概念和基本API函数操作。在前述分析与讨论的基础上，论文结合“云南省煤矿联网安全监控管理系统”项目，开发设计了基于Berkeley DB数据库的煤矿井上监控系统。系统采用基于WindowsCE嵌入式操作系统和Berkeley DB嵌入式数据库的软件构架；使用Visual C++和Embedded Visual C++工具开发监控终端应用程序。设计分析了基于Berkeley DB数据库煤矿井上监控系统的总体结构和功能模块；阐述了主要功能模块的设计思想和程序实现，并深入讨论了系统的数据采集方法、数据库KEY／DATA对存储方案及实时／历史传感器数据的数据库查询策略。在本文最后，作者对论文所作的研究内容进行了工作总结，同时指出了研究和程序设计的后续工作和尚且需要解决的关键问题。更多还原

【Abstract】 In recent years, with the rapid development of embedded systems, the needs for storage and management of data in embedded system are also in high-speed growth, a new database product called embedded database system emerged. Embedded Database is a database management system to support a particular computing mode, it is usually integrated with operating systems and specific application, and works in intelligent embedded equipment or real-time operating environments. Compared to traditional database, embedded database has some features such as less memory resources occupation, lower system costs, closer integration with application, healthier system, better scalability, and so on. So, in realizing of the database system, embedded database has its own characteristics.With the features of the present Mine Safety Monitoring System such as huge equipment structure, weak stability, difficult to adapt to vibrate production environment, gray, humid, high temperature and other adverse conditions, this paper has proposed the application of the Embedded System Technology in Mine Safety Monitoring and Control Terminal. And based on the characteristics of embedded hardware system such as lack of hardware storage resources, low operating speed, this paper has researched the development and application of Embedded Database Technology in Mine Monitoring System.This paper first introduced the embedded system concept and the related hardware and software environment, clarified the embedded system needs of Mine Monitoring System and the choice of Windows CE embedded operating system. Then, from the related concept of embedded database and the embedded database needs of Mine Monitoring System, this paper deeply researched the key technical characteristics of Berkeley DB database and its applicability in Mine Monitoring System, and it introduced the basic concepts of Berkeley DB database and its basic API function operations.On the basis of the above analysis and discussion, this paper combined the project of Yunnan Coal Mine Safety Monitoring network management system, designed the Mine Monitoring System based on Berkeley DB embedded database. The system adapted the software architecture of Windows CE embedded operating system and Berkeley DB embedded database, used Visual C++ and Embedded Visual C++ toolkits to develop MineMonitoring and Control Terminal software application. This design analyzed the overall structure and function modules of Mine Monitoring System based on Berkeley DB embedded database, clarified the design ideas of main function modules and realization of the program. Further more, this paper deeply discussed the system data acquisition method, database storage program of KEY/DATA pairs, and the database query strategy of real-time / historical sensor data.At the end of this paper, I has done the work summary for the research of this paper, and pointed out the follow-up work of the design and the key issues to be resolved.更多还原