SQLite数据库在电力抄表集中器中的应用
|
摘要
文章基于AT91SAM9260处理器和SQLite数据库设计并实现了抄表集中器数据管理方案。详细介绍了SQLite在基于嵌入式Linux平台的抄表集中器上的移植,以及基于SQLite数据库API函数C++封装类CppSQLite实现电表数据的管理功能。测试结果表明,SQLite可以提高系统运行效率,可以用于嵌入式抄表集中器系统进行数据管理。
This paper designs and implements a data management solution for meter concentrator based on AT91SAM9260 microprocessor and SQLite database. It introduces in detail the SQLite transplantation on the meter concentrator based on ARM-Linux platform, and the implementation of concentrator data management function by CppSQLite, which is a C++ wrapper of SQLite database API function. The test results show that SQLite can improve the efficiency and it can be used in data management for embedded meter concentrator system.
This paper designs and implements a data management solution for meter concentrator based on AT91SAM9260 microprocessor and SQLite database. It introduces in detail the SQLite transplantation on the meter concentrator based on ARM-Linux platform, and the implementation of concentrator data management function by CppSQLite, which is a C++ wrapper of SQLite database API function. The test results show that SQLite can improve the efficiency and it can be used in data management for embedded meter concentrator system.
引文
[1]张晶,徐新华,崔仁涛.智能电网用电信息采集系统技术与应用[M].北京:中国电力出版社,2013.
[2]刘友旗.智能电力系统抄表集中器的设计与实现[J].贵州大学学报,2010,27(6):86–91.LIU You-qi.Design and implementation of intelligent electric meter-reading system[J].Journal of Guizhou University,2010,27(6):86–91.
[3]ALLEN G,OWENS M.SQLite权威指南[M].北京:电子工业出版社,2012.
[4]刘琼,马海波,姜薇.SQLite在嵌入式Web服务器中应用研究[J].微计算机信息,2010,26(32):44–46.LIU Qiong,MA Hai-bo,JIANG Wei.Research of SQLite being used in embedded web service[J].Microcomputer Information,2010,26(32):44–46.
[5]蒋晓宇,贺永胜,王金明.基于SQlite3的用电信息采集终端数据平台设计及研究[J].电测与仪表,2010,47(S1):103–107.JIANG Xiao-yu,HE Yong-sheng,WANG Jin-ming.Discussion for electric energy data terminal’s information platform design based on Sqlite3[J].Electrical Measurement&Instrumentation,2010,47(S1):103–107.
[2]刘友旗.智能电力系统抄表集中器的设计与实现[J].贵州大学学报,2010,27(6):86–91.LIU You-qi.Design and implementation of intelligent electric meter-reading system[J].Journal of Guizhou University,2010,27(6):86–91.
[3]ALLEN G,OWENS M.SQLite权威指南[M].北京:电子工业出版社,2012.
[4]刘琼,马海波,姜薇.SQLite在嵌入式Web服务器中应用研究[J].微计算机信息,2010,26(32):44–46.LIU Qiong,MA Hai-bo,JIANG Wei.Research of SQLite being used in embedded web service[J].Microcomputer Information,2010,26(32):44–46.
[5]蒋晓宇,贺永胜,王金明.基于SQlite3的用电信息采集终端数据平台设计及研究[J].电测与仪表,2010,47(S1):103–107.JIANG Xiao-yu,HE Yong-sheng,WANG Jin-ming.Discussion for electric energy data terminal’s information platform design based on Sqlite3[J].Electrical Measurement&Instrumentation,2010,47(S1):103–107.