WAMS系统历史数据库的优化  

Optimization of history database in WAMS

作　　者：王立鼎[1] 杨东[1] 吴京涛[1] 刘洪林 

机构地区：[1]北京四方继保自动化股份有限公司,北京100085 [2]江西实验技术学校,江西南昌330008

出　　处：《电力自动化设备》2005年第2期62-64,共3页Electric Power Automation Equipment

摘　　要：广域测量系统WAMS(WideAreaMeasurementSystem)需要保存海量的历史数据,保证历史数据库的高效性是构建WAMS的一个难点。提出了优化历史数据库的商用数据库性能调优和表结构调优的两类方法;重点分析了数据库表结构的调优。提出三种数据库表结构方案。通过测试及分析,最终确定一种方案为优化方案,该方案已经成功应用于多个WAMS,现场运行表明,该方案高效可靠。Huge history records should be stored in WAMS(Wide Area Measurement System),andit is necessary to ensure its high efficiency during WAMS construction. Two methods to optimizehistory database are presented:the performance optimization of commercial database and the table structure optimization of database. The latter is emphasized and three schemes are put forward. Test and analysis are carried out to select one as the best,which has been applied in several WAMS successfully. Practice shows it efficient and reliable.

关 键 词：广域测量系统 同步相量测量单元 历史数据库优化 

分 类 号：TP393[自动化与计算机技术—计算机应用技术]