SQLite嵌入式数据库在PMU中的应用

作者：陈晓刚1，郑毅君2 日期：2008-04-17/span> 浏览：3337 查看PDF文档

SQLite嵌入式数据库在PMU中的应用
陈晓刚1，郑毅君2
（1.浙江大学 电气工程学院，浙江 杭州 310027； 2.江苏省无锡供电公司,江苏 无锡 214000）

摘 要：针对电力系统对PMU装置提出的高可靠性和高性能的要求，提出了在相量测量单元（PMU）中使用SQLite嵌入式数据库。分析了PMU装置对嵌入式数据库的需求。介绍了在QNX平台上SQLite嵌入式数据库的编译、安装和使用。重点介绍了C语言环境下SQLite的集成与开发，给出了关键代码示例。最后提出了使用内存式硬盘提高SQLite性能的方案。该方案已成功应用于PMU装置，实际测试表明其具有良好的实时性能。
关键词：QNX实时操作系统；SQLite；嵌入式数据库；相量测量单元；电力系统

Application of SQLite  embedded database in PMU
CHEN Xiaogang1, Zhen Yijun2
 (1.College of Electrical Engineering, Zhejiang University, Hangzhou 310027, China;
2.Jiangsu Wuxi Power Supply Company, Wuxi 214000, China)
Abstract: The application of SQLite embedded database to improve the reliability and performance of phasor unit measurement was introduced. The demand of embedded database in PMU was analyzed. Then the compilation, installation and usage of SQLite database on QNX platform were introduced. The integration and development in C language was especially demonstrated and also some example codes were given. Finally, the adoption of RAM disk technology to enhance the performance of SQLite was proposed. The SQLite database is successfully applied in PMU equipment and the test justifies its real time performance.
Key words: QNX real time operation system (RTOS); SQLite; embedded database; phasor measurement unit (PMU); power system

参考文献(Reference):
［1］张晓华,黄布毅.基于ARMLinuxde SQLite嵌入式数据库技术［J］.单片机与嵌入式系统应用,2005(4):21-24.
［2］陈 新,高凤梅,曹玲芝,等.嵌入式数据库SQLite在电梯B/S监控中的应用［J］.电子技术应用,2006,32（5）:59-61.
［3］张晓超,朱清新.基于DeltaOS的SQLite嵌入式数据库技术［J］.成都信息工程学院学报,2006,21(6):848-852.
［4］KRTEN R. The QNX Cookbook: Recipes for Programmers［M］. PARSE Software Devices,2003.
［5］侯业勤,张 菁.分布式嵌入式实时操作系统QNX［M］.北京:宇航出版社，1999.