OLAP技术在电能质量数据分析中的应用
|
摘要
本课题从电能质量决策者的数据分析需求出发,针对传统的查询分析方式在电能质量数据分析过程中的局限性,提出了基于OLAP技术的电能质量智能信息系统多维分析解决方案,以更加全面、细致、迅速的分析电能质量数据。电能质量智能信息系统是用于区域电网电能质量监控的软件系统,对采集的电能质量数据进行智能计算并向用户提供了Web查询接口,但随着信息社会的不断发展以及历史数据的增长,现有的查询分析方式已经逐渐表现出一些弊端,这种弊端在暂降分析模块和综合评估模块中体现的尤为明显,亟需使用OLAP技术实现多维数据分析。
根据暂降分析模块和综合评估模块的多维分析需求,本课题设计并实现了B/S结构的电能质量“多维分析子系统”,该子系统为用户提供多角度、多层次、高效率的数据分析方式,极大的改善了分析数据时的用户体验,并有效的辅助了电能质量分析决策。在该子系统的实现过程中对暂降分析和综合评估模块中涉及的电能质量数据进行了合理的星型模型和雪花模型设计,在SQL Server Analysis Services中设计了暂降分析和综合评估相关的多维数据集,并使用Dundas OLAP Service实现了丰富的客户端多维展示。
To meet the data analysis needs of decision makers and point to the limitation of the traditional analysis methods in the power quality data analysis process, this article proposes an OLAP-based Multi-dimensional analysis solution for power quality intelligent information system,that can analysis power quality data more overall,more detailedly, and more rapidly. Power Quality Intelligent Information System is a software used to monitor power quality of regional power grid.It can compute the collected power quality data intelligently and provide web query interface for users. But, with the development of information society and the growth of historical data, the existing data analysis method has been gradually showed some drawbacks, that especially reflected in Sag analysis and Comprehensive assessment modules, so it's urgent to use OLAP technology to achieve Multi-dimensional data analysis.
According to the Multi-dimensional analysis demand of Sag analysis module and Comprehensive assessment module, this article designs and achieves a Power Quality Multi-dimensional Analysis Subsystem of B/S structure. This subsystem provides users with a multi-angle, multi-level and efficient way to analysis data.Besides, it greatly improves the user's experience in the analysis of data and is efficiently helpful for power quality analysis and decision. In the implementation process of the subsystem, this article rationally designs the star schema and snowflake schema for the power quality data about Sag analysis module and Comprehensive assessment module, designs Multi-dimensional Cube for Sag analysis and Comprehensive assessment with SQL Server Analysis Services, and achieves a rich Multi-dimensional client display with Dundas OLAP Service.
根据暂降分析模块和综合评估模块的多维分析需求,本课题设计并实现了B/S结构的电能质量“多维分析子系统”,该子系统为用户提供多角度、多层次、高效率的数据分析方式,极大的改善了分析数据时的用户体验,并有效的辅助了电能质量分析决策。在该子系统的实现过程中对暂降分析和综合评估模块中涉及的电能质量数据进行了合理的星型模型和雪花模型设计,在SQL Server Analysis Services中设计了暂降分析和综合评估相关的多维数据集,并使用Dundas OLAP Service实现了丰富的客户端多维展示。
To meet the data analysis needs of decision makers and point to the limitation of the traditional analysis methods in the power quality data analysis process, this article proposes an OLAP-based Multi-dimensional analysis solution for power quality intelligent information system,that can analysis power quality data more overall,more detailedly, and more rapidly. Power Quality Intelligent Information System is a software used to monitor power quality of regional power grid.It can compute the collected power quality data intelligently and provide web query interface for users. But, with the development of information society and the growth of historical data, the existing data analysis method has been gradually showed some drawbacks, that especially reflected in Sag analysis and Comprehensive assessment modules, so it's urgent to use OLAP technology to achieve Multi-dimensional data analysis.
According to the Multi-dimensional analysis demand of Sag analysis module and Comprehensive assessment module, this article designs and achieves a Power Quality Multi-dimensional Analysis Subsystem of B/S structure. This subsystem provides users with a multi-angle, multi-level and efficient way to analysis data.Besides, it greatly improves the user's experience in the analysis of data and is efficiently helpful for power quality analysis and decision. In the implementation process of the subsystem, this article rationally designs the star schema and snowflake schema for the power quality data about Sag analysis module and Comprehensive assessment module, designs Multi-dimensional Cube for Sag analysis and Comprehensive assessment with SQL Server Analysis Services, and achieves a rich Multi-dimensional client display with Dundas OLAP Service.
引文
[1]肖湘宁.电能质量分析与控制[M].北京：中国电力出版社,2010
[2]崔东.基于OLAP技术的数据分析的研究与应用[D].武汉：武汉理工大学,2006
[3]Brian Larson.Delivering Business Intelligence with Microsoft SQL Server[M].McGraw-Hill Osborne Media,2006
[4]刘宁,申晓留.OLAP技术及在电力行业的应用前景研究[J].中国电力教育,2007年S1期
[5]Han Hongke,Qi Linhai. Application and research of multidimensional data analysis in power quality[A].International Conference on Computer Design and Applications (ICCDA)[C],2010:V1-390-393
[6]2009-2010年中国商业智能(BI)市场发展趋势研究报告[EB/OL].北京：时代计世资讯有限公司,2010
[7]杨胜,孙翱.OLAP技术的发展新动态[J].计算机应用与软件,2003年07期
[8]Cognos Business Intelligence and Financial Performance Management [EB/OL].http://www-01.ibm.com/software/analytics/cognos/
[9]任慧.基于OLAP的能效分析方法研究与应用[D].上海：同济大学,2009
[10]孙博.传统OLAP系统的特点及发展方向[J].科技信息,2009年06期
[11]Chunhua Ju,Minghua Han. Effectiveness of OLAP-Based Sales Analysis in Retail Enterprises[A].ISECS International Colloquium on Computing, Communication, Control, and Management[C],2008:240-244
[12]Cuzzocrea, A., DEIS Dept., Calabria Univ.Accuracy Control in Compressed Multidimensional Data Cubes for Quality of Answer-based OLAP Tools[A].International Conference on Scientific and Statistical Database Management [C],2006:301-310
[13]Blanco,C.,Fernandez-Medina,E.,Trujillo,J.,etal.Implementing Multidimensional Security into OLAPTools[A].International Conference on Availability, Reliability and Security[C],2008:1248-1253
[14]Hsu, K.C., Ming-Zhong Li,et al. Applying Multi-dimensional Scaling Analysis for Finding Similarity Knowledge in OLAP Reports [A]. International Conference on Computer Engineering and Applications (ICCEA)[C].2010:269-275
[15]黄晔玮.基于数据仓库的联机分析处理[J].中国新技术新产品,2009年04期
[16]Cuzzocrea,A..Privacy preserving OLAP:Models, issues, algorithms [A]. International Conference on MIPRO[C],2011:1538-1543
[17]Erik Thomsen.OLAP solutions:building multidimensional information systems[M] John Wiley & Sons,2002
[18]Hua-long Zhao.Application of OLAP to the analysis of the curriculum chosen by students [A]. International Conference on Anti-counterfeiting, Security and Identification (ASID)[C].2008:97-100
[19]周熙.基于OLAP的多维数据分析在中小企业应用的研究[D].武汉：中南民族大学,2008
[20]Bhowmik, T., Sarkar, A., Debnath, N.C..OLAP umbrella:Visualization model for multidimensional databases[A]. IEEE/ACS International Conference on Computer Systems and Applications (AICCSA)[C],2010:1-8
[21]Robert Wrembel,Christian Koncilia.Data Warehouses and OLAP:Concepts, Architectures and Solutions[M].IRM Press,2006
[22]Reed Jacobson,Stacia Misner,Hitachi Consulting.Microsoft SQL Server 2005 Analysis Services Step by Step[M]. Washington:Microsoft Press,2006
[23]Zhijun Ren.Solving Business Problems with SQL Server 2005 Analysis Services[A].Asia-Pacific Conf on (CICC-ITOE)[C].2010:79-82
[24]Overview of Dundas OLAP Architecture[EB/OL]. http://support2.dundas. com/OnlineDocumentation/WebOLAP/Overview%20of%20Dundas%20 Architecture.html
[25]GB/T17626.11-22008,电压暂降标准[S].中国标准出版社,2008
[26]GB/T 14549—93,电能质量公用电网谐波[S].中国标准出版社,1993
[27]程时杰,张伯明,夏道止.电力系统分析(第2版)[M].北京：中国电力出版社,2011
[28]李娜娜.电能质量综合评估及分质计价方法研究[D].四川：西南交通大学,2009
[29]齐明,马素霞.多维数据分析在电力营销中的应用研究[J].电力信息化,2008年11期
[30]刘博.电能质量综合评价方法及其应用研究[D].广州：华南理工大学,2011
[31]刘实,刘杉,郭俊芳等.基于SQL Server Analysis Services的招生数据分析[J].中山大学学报(自然科学版),2009年S1期
[32]Jinyu Chen, Ten Long,Kangming Deng.The Consistency of Materialized View Maintenance and Drill-Down in a Warehousing Environment [A].The 9th International Conference for Digital Object Identifier[C].2008:1169-1174
[33]SQL Server 2005 Analysis Services性能指南：优化维度设计[EB/OL].http://www.cnblogs.com/esestt/archive/2007/12/14/994289.html
[34]SQL Server Analysis Services Tutorial-Defining Calculations[EB/OL] http://technet.microsoft.com/en-us/library/ms169748.aspx
[35]郭亚光,寿志勤,刘波.基于OLAP技术的政府网站评估数据仓库应用研究[J].情报杂志,2011年08期
[36]陈元中.基于聚类的OLAP多维分析查询推荐方法研究[J].计算机工程与设计,2010年15期
[37]谭华,张俊,杨宝祝.基于B/S结构的OLAP技术在项目管理中的研究与实践[J].农业网络信息,2010年08期
[38]Analysis Services Concepts and Objects-Analysis Services Architecture [EB/OL]. http://technet.microsoft.com/en-US/library/ms174518(v=sq1.90) .aspx
[39]程荣赟.基于SSAS的网站访问日志分析和BI前端展现[D].成都：西南财经大学,2010
[40]Microsoft Share Point2010 Product Information[EB/OL]. http://sharepoint.microsoft.com/en-us/product/Pages/default.aspx
[41]Mangla, M.,Comput. Dept., Terna Eng. Coll.,et al. Exploiting OLAP and data mining for augmenting e-business [A].International Conference on Intelligent Agent & Multi-Agent Systems(IAMA)[C].2009:1-2
[42]Usman, M, Asghar, S, Fong, S.,et al. Data mining and automatic OLAP schema generation [A].International Conference on Digital Information Management (ICDIM) [C].2010:35-43
[2]崔东.基于OLAP技术的数据分析的研究与应用[D].武汉：武汉理工大学,2006
[3]Brian Larson.Delivering Business Intelligence with Microsoft SQL Server[M].McGraw-Hill Osborne Media,2006
[4]刘宁,申晓留.OLAP技术及在电力行业的应用前景研究[J].中国电力教育,2007年S1期
[5]Han Hongke,Qi Linhai. Application and research of multidimensional data analysis in power quality[A].International Conference on Computer Design and Applications (ICCDA)[C],2010:V1-390-393
[6]2009-2010年中国商业智能(BI)市场发展趋势研究报告[EB/OL].北京：时代计世资讯有限公司,2010
[7]杨胜,孙翱.OLAP技术的发展新动态[J].计算机应用与软件,2003年07期
[8]Cognos Business Intelligence and Financial Performance Management [EB/OL].http://www-01.ibm.com/software/analytics/cognos/
[9]任慧.基于OLAP的能效分析方法研究与应用[D].上海：同济大学,2009
[10]孙博.传统OLAP系统的特点及发展方向[J].科技信息,2009年06期
[11]Chunhua Ju,Minghua Han. Effectiveness of OLAP-Based Sales Analysis in Retail Enterprises[A].ISECS International Colloquium on Computing, Communication, Control, and Management[C],2008:240-244
[12]Cuzzocrea, A., DEIS Dept., Calabria Univ.Accuracy Control in Compressed Multidimensional Data Cubes for Quality of Answer-based OLAP Tools[A].International Conference on Scientific and Statistical Database Management [C],2006:301-310
[13]Blanco,C.,Fernandez-Medina,E.,Trujillo,J.,etal.Implementing Multidimensional Security into OLAPTools[A].International Conference on Availability, Reliability and Security[C],2008:1248-1253
[14]Hsu, K.C., Ming-Zhong Li,et al. Applying Multi-dimensional Scaling Analysis for Finding Similarity Knowledge in OLAP Reports [A]. International Conference on Computer Engineering and Applications (ICCEA)[C].2010:269-275
[15]黄晔玮.基于数据仓库的联机分析处理[J].中国新技术新产品,2009年04期
[16]Cuzzocrea,A..Privacy preserving OLAP:Models, issues, algorithms [A]. International Conference on MIPRO[C],2011:1538-1543
[17]Erik Thomsen.OLAP solutions:building multidimensional information systems[M] John Wiley & Sons,2002
[18]Hua-long Zhao.Application of OLAP to the analysis of the curriculum chosen by students [A]. International Conference on Anti-counterfeiting, Security and Identification (ASID)[C].2008:97-100
[19]周熙.基于OLAP的多维数据分析在中小企业应用的研究[D].武汉：中南民族大学,2008
[20]Bhowmik, T., Sarkar, A., Debnath, N.C..OLAP umbrella:Visualization model for multidimensional databases[A]. IEEE/ACS International Conference on Computer Systems and Applications (AICCSA)[C],2010:1-8
[21]Robert Wrembel,Christian Koncilia.Data Warehouses and OLAP:Concepts, Architectures and Solutions[M].IRM Press,2006
[22]Reed Jacobson,Stacia Misner,Hitachi Consulting.Microsoft SQL Server 2005 Analysis Services Step by Step[M]. Washington:Microsoft Press,2006
[23]Zhijun Ren.Solving Business Problems with SQL Server 2005 Analysis Services[A].Asia-Pacific Conf on (CICC-ITOE)[C].2010:79-82
[24]Overview of Dundas OLAP Architecture[EB/OL]. http://support2.dundas. com/OnlineDocumentation/WebOLAP/Overview%20of%20Dundas%20 Architecture.html
[25]GB/T17626.11-22008,电压暂降标准[S].中国标准出版社,2008
[26]GB/T 14549—93,电能质量公用电网谐波[S].中国标准出版社,1993
[27]程时杰,张伯明,夏道止.电力系统分析(第2版)[M].北京：中国电力出版社,2011
[28]李娜娜.电能质量综合评估及分质计价方法研究[D].四川：西南交通大学,2009
[29]齐明,马素霞.多维数据分析在电力营销中的应用研究[J].电力信息化,2008年11期
[30]刘博.电能质量综合评价方法及其应用研究[D].广州：华南理工大学,2011
[31]刘实,刘杉,郭俊芳等.基于SQL Server Analysis Services的招生数据分析[J].中山大学学报(自然科学版),2009年S1期
[32]Jinyu Chen, Ten Long,Kangming Deng.The Consistency of Materialized View Maintenance and Drill-Down in a Warehousing Environment [A].The 9th International Conference for Digital Object Identifier[C].2008:1169-1174
[33]SQL Server 2005 Analysis Services性能指南：优化维度设计[EB/OL].http://www.cnblogs.com/esestt/archive/2007/12/14/994289.html
[34]SQL Server Analysis Services Tutorial-Defining Calculations[EB/OL] http://technet.microsoft.com/en-us/library/ms169748.aspx
[35]郭亚光,寿志勤,刘波.基于OLAP技术的政府网站评估数据仓库应用研究[J].情报杂志,2011年08期
[36]陈元中.基于聚类的OLAP多维分析查询推荐方法研究[J].计算机工程与设计,2010年15期
[37]谭华,张俊,杨宝祝.基于B/S结构的OLAP技术在项目管理中的研究与实践[J].农业网络信息,2010年08期
[38]Analysis Services Concepts and Objects-Analysis Services Architecture [EB/OL]. http://technet.microsoft.com/en-US/library/ms174518(v=sq1.90) .aspx
[39]程荣赟.基于SSAS的网站访问日志分析和BI前端展现[D].成都：西南财经大学,2010
[40]Microsoft Share Point2010 Product Information[EB/OL]. http://sharepoint.microsoft.com/en-us/product/Pages/default.aspx
[41]Mangla, M.,Comput. Dept., Terna Eng. Coll.,et al. Exploiting OLAP and data mining for augmenting e-business [A].International Conference on Intelligent Agent & Multi-Agent Systems(IAMA)[C].2009:1-2
[42]Usman, M, Asghar, S, Fong, S.,et al. Data mining and automatic OLAP schema generation [A].International Conference on Digital Information Management (ICDIM) [C].2010:35-43
© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号 地址：北京市海淀区学院路29号 邮编：100083 电话：办公室：(+86 10)66554848；文献借阅、咨询服务、科技查新：66554700 |