基于SQL Server的水电机组运行数据的挖掘模型

Mining Model of Running Data for Turbine Generator Sets Based on SQL Server

基于SQL Server 2005提供的用于创建和使用的数据挖掘模型集成环境,建立了水电机组水轮机振动数据的挖掘模型,以四川省铜街子水电站为例,利用该模型从海量原始运行数据中发掘出有用的特征数据,并与原始数据进行分析比较,获得了水电机组最优运行工况的参数区域。实例结果表明,该方法可大幅提高面对海量数据时的处理效率,简化了数据挖掘操作的复杂性,为水电机组故障诊断系统提供了一种切实可行的方法。

Integrated environment of data mining models in SQL Server 2005 is used to build mining models of vibration data for hydropower plant. Taking the Tongjiezi hydropower station in Sichuan Province for an example,the useful characteristic data is mined from the original mass operation data.And then comparative analysis of the original data,the parameter range of turbine generator sets in optimal operation condition is obtained.The instance results show that the proposed method increases efficiency for deal with mass data and simplifies the complexity of data mining,which provides a feasible method for fault diagnosis system of turbine generator sets.