WSEAS Transactions on Power Systems
Print ISSN: 1790-5060, E-ISSN: 2224-350X
Volume 13, 2018
Data Warehouse Applied to SCADA Historical Data in Electrical Power Systems
Authors: Wesin Alves, Aldebaro Klautau
Abstract: Supervisory control and data acquisition (SCADA) systems are critical for protection and safety operations in modern energy systems. A current challenge is understanding the system behavior through the large volume of data generated by SCADA in which it involves measurements of thousands of heterogeneous physical variables of power systems stored in various tables in a database. In this scenario, the Online Analysis Process (OLAP) in a Data Warehouse (DW) stands out as the most appropriate tool for understanding the electrical system behavior using such complex database. The main contribution of this article is the elaboration of a multidimensional modeling of a DW applied to a SCADA in order to better understanding behavior system and provide easy access to the information stored in its database. Pentaho Suite tools were used to develop proposed approach and experiments with real data from a Brazilian energy company were carried out to illustrate the proposed approach.
Search Articles
Keywords: Data Warehouse, OLAP, massive datasets, multidimensional modeling, SCADA, electric power system
Pages: 217-226
WSEAS Transactions on Power Systems, ISSN / E-ISSN: 1790-5060 / 2224-350X, Volume 13, 2018, Art. #22