The Application Of OLAP Technology In Power Quality Data Analysis

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.