| 引用本文: | 王立鼎,杨东,吴京涛,刘洪林.WAMS系统历史数据库的优化[J].电力自动化设备,2005,(2):62-64 |
| .Optimization of history database in WAMS[J].Electric Power Automation Equipment,2005,(2):62-64 |
|
|
| 摘要: |
| 广域测量系统WAMS(Wide Area Measurement System)需要保存海量的历史数据，保证历史数据库的高效性是构建WAMS的一个难点。提出了优化历史数据库的商用数据库性能调优和表结构调优的两类方法；重点分析了数据库表结构的调优。提出三种数据库表结构方案。通过测试及分析，最终确定一种方案为优化方案，该方案已经成功应用于多个WAMS，现场运行表明，该方案高效可靠。 |
| 关键词: 广域测量系统 同步相量测量单元 历史数据库优化 |
| DOI： |
| 分类号:TP393 |
| 基金项目: |
|
| Optimization of history database in WAMS |
|
WANG Li-ding1 YANG Dong1 WU Jing-tao1 LIU Hong-lin2
|
| Abstract: |
| 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. |
| Key words: WAMS,phasor measurement unit,history database optimization |
