【摘要】 广域测量系统WAMS(WideAreaMeasurementSystem)需要保存海量的历史数据,保证历史数据库的高效性是构建WAMS的一个难点。提出了优化历史数据库的商用数据库性能调优和表结构调优的两类方法;重点分析了数据库表结构的调优。提出三种数据库表结构方案。通过测试及分析,最终确定一种方案为优化方案,该方案已经成功应用于多个WAMS,现场运行表明,该方案高效可靠。更多还原

【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.更多还原