嵌入式数据库SQLite在家居能源控制子系统中的应用

Application of SQlite Embedded Database to the Measurement and Control Subsystem for Residential Energy

针对家居能源控制系统测控点多,实时性和可靠性要求高的特点,提出了使用嵌入式数据库SQLite对系统的批量数据进行管理和维护.本文分别介绍了家居能源控制系统的总体设计,软件设计和数据库设计,以及在嵌入式系统WinCE4.2下SQLite的使用方法,并结合实例具体说明了SQLite在家居能源控制系统中的应用,最后用实验证明了SQLite的优越性.SQLite实现简单,可以提高程序的运行效率,增加程序的稳定性和可读性,因此具有广泛的应用前景.

The application of SQLite embedded database to the measurement and control subsystem for residential energy to manage and sustain a batch of dates of the system can improve the real - time and reliability of the system, and deal with more information of the test and control points. It introduces the collectivity design of the system, the design of the software, the design of the database and the use of SQLite on wince 4.2 embedded system. With a specific example, it concretely shows the application of SQLite to the measurement and control subsystem for residential energy, and then testifies the superiority of SQLite. SQlite is easily accomplishment, and can improve the efficiency, the stability and readability of the programs. Therefore, it will be employed widely.