Due to the increasing share of renewable energy, new requirements are placed on control room software. Such software is often exclusive to the supplier, but other suppliers could offer new and better methods. For security reasons, external applications often have no direct data access to control room software. Such software can provide information about the power grid via a periodic file transfer in CIM (Common Information Model) format. These files are often very large, containing complete records, delivering information not always relevant to the external applications. Extracting the relevant information required by external applications can be time-consuming, thus presenting a problem for time-critical applications. This paper presents a method allowing different applications to efficiently access the relevant data from the massive data stream contained in the CIM files. This method has been tested with a distribution system operator and clearly increases performance, allowing different applications to access the relevant data.
KeywordsCommon Information Model (CIM)Grid Control Room SoftwareElectrical Grid
Ramchurn, S.D., Vytelingum, P., Rogers, A. and Jennings, N.R. (2012) Putting the “Smarts” into the Smart Grid: A Grand Challenge for Artificial Intelligence. Communications of the ACM, 55, 86-97. https://doi.org/10.1145/2133806.2133825
Güngör, V.C., Sahin, D., Kocak, T., Ergüt, S., Buccella, C., Cecati, C. and Hancke, G.P. (2011) Smart Grid Technologies: Communication Technologies and Standards. IEEE Transactions on Industrial Informatics, 7, 529-539. https://doi.org/10.1109/TII.2011.2166794
Albano, M., Ferreira, L.L. and Miguel Pinho, L. (2015) Convergence of Smart Grid ICT Architectures for the Last Mile. IEEE Transactions on Industrial Informatics, 11, 187-197. https://doi.org/10.1109/TII.2014.2379436
Wu, F.F., Moslehi, K. and Bose, A. (2005) Power System Control Centers: Past, Present, and Future. Proceedings of the IEEE, 93, 1890-1908. https://doi.org/10.1109/JPROC.2005.857499
Saad, A., Youssef, T., Elsayed, A.T., Amin, A., Abdalla, O.H. and Mohammed, O. (2019) Data-Centric Hierarchical Distributed Model Predictive Control for Smart Grid Energy Management. IEEE Transactions on Industrial Informatics, 15, 4086-4098. https://doi.org/10.1109/TII.2018.2883911
Wende von Berg, S., Bornhorst, N., Gehler, S., Schneider, E. and Hänchen, H. (2016) SysDL 2.0 Systemdienstleistungen aus Flächenverteilnetzen: Methoden und Anwendungen. https://www.tugraz.at/fileadmin/user_upload/Events/Eninnov2016/files/pr/Stream_C/Session_ C4/PR_Wende_von_Berg.pdf
Palensky, P. and Dietrich, D. (2011) Demand Side Management: Demand Response, Intelligent Energy Systems, and Smart Loads. IEEE Transactions on Industrial Informatics, 7, 381-388. https://doi.org/10.1109/TII.2011.2158841
Uslar, M., Specht, M., Dänekas, C., Trefke, J., Rohjans, S. and González, J.M. (2013) ICT and Energy Supply: IEC 61970/61968 Common Information Model. In: Standardization in Smart Grids, Springer-Verlag, Berlin, 99-114. https://doi.org/10.1007/978-3-642-34916-4_6
Britton, J., Brown, P., Moseley, J. and Bunda, M. (2016) Optimizing Operations with CIM: Today’s Grid Relies on Network Analysis (and a Lot of Data). IEEE Power and Energy Magazine, 14, 48-57. https://doi.org/10.1109/MPE.2015.2481783
Österlund, L.-O., Hunter, K., Demaree, K., Goodrich, M., McMorran, A., Iverson, B. and Kostic, A. (2016) Under the Hood: An Overview of the Common Information Model Data Exchanges. IEEE Power and Energy Magazine, 14, 68-82. https://doi.org/10.1109/MPE.2015.2485859
Hargreaves, N., Taylor, G. and Carter, A. (2012) Information Standards to Support Application and Enterprise Interoperability for the Smart Grid. IEEE PES General Meeting, San Diego, 1-6. https://doi.org/10.1109/PESGM.2012.6345134
Marten, F., Hammermeister, I., Ringelstein, J., Requardt, B. and Martin, B. (2019) CIM CGMES-Extensions for the TSO-DSO Data Exchange in the EU-Project “TDX-ASSIST”. ETG, Esslingen am Neckar, 69-74.
Dán, G., Sandberg, H. and Ekstedt, M. (2012) Challenges in Power System Information Security. IEEE Security Privacy, 10, 62-70. https://doi.org/10.1109/MSP.2011.151
Tan, S., De, D., Song, W.-Z., Yang, J. and Das, S.K. (2017) Survey of Security Advances in Smart Grid: A Data Driven Approach. IEEE Communications Surveys & Tutorials, 19, 397-422. https://doi.org/10.1109/COMST.2016.2616442
Kostic, T. and Cukalevski, N. (2005) Data Exchange Issues within the Power System Operation and Control Environment. CIGRE/IEEE PES, New Orleans, 5-7 October 2005, 290-298.
Stojkovic, B. and Vukasovic, M. (2006) A New SCADA System Design in the Power System of Montenegro—ICCP/TASE.2 and Web-Based Real-Time Electricity Demand Metering Extensions. IEEE PES, Atlanta, 2194-2199. https://doi.org/10.1109/PSCE.2006.296282
Mercurio, A., Di Giorgio, A. and Cioci, P. (2009) Open-Source Implementation of Monitoring and Controlling Services for EMS/SCADA Systems by Means of Web Services—IEC 61850 and IEC 61970 Standards. IEEE Transactions on Power Delivery, 24, 1148-1153. https://doi.org/10.1109/TPWRD.2008.2008461
Johnson, M. (2011) IEC 61968-100. Austin, TX, USA. http://www.ucaiug.org/Meetings/Austin2011/Shared%20Documents/CIMug/CIM%20University/ IEC%2061968-100%20Implementation%20Profile%20Overview.pdf
Sánchez-López, A., Islas-Pérez, E., Espinosa-Reza, A. and Quintero-Reyes, A. (2015) Deploying SCADA Data to Web Services for Interoperability Purposes. GIIS, Guadalajara, 28-30 October 2015, 1-8. https://doi.org/10.1109/GIIS.2015.7347172
Gray, A.D.L., Pisica, I., Taylor, G.A. and Whitehurst, L. (2017) A Standardised Modular Approach for Site SCADA Applications within a Water Utility. IEEE Access, 5, 17177-17187. https://doi.org/10.1109/ACCESS.2017.2654685
Ruh, W.A., Maginnis, F.X. and Brown, W.J. (2001) Basic Building Blocks. In: Enterprise Application Integration: A Wiley Tech Brief, Wiley & Sons, New York, 52-57.
Maffei, A., Srinivasan, S., Meola, D., Palmieri, G., Iannelli, L., Holhjem, Ø.H., Marafioti, G., Mathisen, G. and Glielmo, L. (2018) A Cyber-Physical Systems Approach for Implementing the Receding Horizon Optimal Power Flow in Smart Grids. IEEE Transactions on Sustainable Computing, 3, 98-111. https://doi.org/10.1109/TSUSC.2017.2737144
Rozic, B., Mlakar, D., Gruden, M. and Petrovic, N. (2017) Elektro Gorenjska CIM Project. CIRED, Glasgow, 12-15 June 2017, 2263-2264. https://doi.org/10.1049/oap-cired.2017.0222
Ascher, D. and Kondzialka, C. (2018) Towards Model-Driven CIM-Based Data Exchange for DSOs. Energy Informatics, 1, 213-224. https://doi.org/10.1186/s42162-018-0032-4
Goering, A., Meister, J., Lehnhoff, S., Herdt, P., Jung, M. and Rohr, M. (2017) Reference Architecture for Open, Maintainable and Secure Software for the Operation of Energy Networks. 24th International Conference & Exhibition on Electricity Distribution, 12-15 June 2017, 1410-1413. https://doi.org/10.1049/oap-cired.2017.0965
Melton, R.B., Schneider, K.P., Lightner, E., Mcdermott, T.E., Sharma, P., Zhang, Y., Ding, F., Vadari, S., Podmore, R., Dubey, A., Wies, R.W. and Stephan, E.G. (2018) Leveraging Standards to Create an Open Platform for the Development of Advanced Distribution Applications. IEEE Access, 6, 37361-37370. https://doi.org/10.1109/ACCESS.2018.2851186
Newman, S. (2015) Microservices. In: Building Microservices, O’Reilly Media, Sebastopol, 2-8.
McMorran, A.W., Ault, G.W., Morgan, C., Elders, I.M. and McDonald, J.R. (2006) A Common Information Model (CIM) Toolkit Framework Implemented in Java. IEEE Transactions on Power Systems, 21, 194-201. https://doi.org/10.1109/TPWRS.2005.857846
Requardt, B., Wende von Berg, S., Wagner, T., Toebermann, C. and Braun, M. (2017) Modular System Architecture for Processing of CIM. ETG, Bonn, 28-29 November 2017, 1-6.
Schulte, S., Berbner, R., Steinmetz, R. and Uslar, R. (2007) Implementing and Evaluating the Common Information Model in a Relational and RDF-Based Database. ICSC, Irvine, 17-19 September 2007, 109-118. https://doi.org/10.1007/978-3-540-71335-7_13
Gómez, F.J., Aguilera Chaves, M., Vanfretti, L. and Olsen, S.H. (2018) Multi-Domain Semantic Information and Physical Behavior Modeling of Power Systems and Gas Turbines Expanding the Common Information Model. IEEE Access, 6, 72663-72674. https://doi.org/10.1109/ACCESS.2018.2882311
Simmons Jr., R. (2004) Data Modeling. In: Hardcore Java: Secrets of the Java Masters, O’Reilly Media, Sebastopol, 198.
Oracle (2017) The Java™ Tutorials. https://docs.oracle.com/javase/tutorial/reflect/index.html
Wu, J., Cheng, Y. and Schulz, N.N. (2006) Overview of Real-Time Database Management System Design for Power System SCADA System. IEEE SoutheastCon, Memphis, 31 March-2 April 2006, 62-66.
Ravikumar, G. and Khaparde, S.A. (2017) A Common Information Model Oriented Graph Database Framework for Power Systems. IEEE Transactions on Power Systems, 32, 2560-2569. https://doi.org/10.1109/TPWRS.2016.2631242
Tomlinson, R.F. (2007) Choose a Logical Data Model. In: Thinking about GIS: Geographic Information System Planning for Managers, 3rd Edition, ESRI PR, New York, 97.
De, B. (2017) API Authentication and Authorization. In: API Management, Apress, Bangalore, 113-114.
Pradeep, Y., Seshuraju, P., Khaparde, S.A. and Joshi, R.K. (2011) CIM-Based Connectivity Model for Bus-Branch Topology Extraction and Exchange. IEEE Transactions on Smart Grid, 2, 244-253. https://doi.org/10.1109/TSG.2011.2109016
Gomez, F.J., Vanfretti, L. and Olsen, S.H. (2018) CIM-Compliant Power System Dynamic Model-to-Model Transformation and Modelica Simulation. IEEE Transactions on Industrial Informatics, 14, 3989-3996. https://doi.org/10.1109/TII.2017.2785439
Thurner, L., Scheidler, A., Schäfer, F., Menke, J.-H., Dollichon, J., Meier, F., Meinecke, S. and Braun, M. (2018) Pandapower—An Open Source Python Tool for Convenient Modeling, Analysis and Optimization of Electric Power Systems. IEEE Transactions on Power Systems, 33, 6510-6521. https://doi.org/10.1109/TPWRS.2018.2829021
Rodger, J.A. (2015) Discovery of Medical Big Data Analytics: Improving the Prediction of Traumatic Brain Injury Survival Rates by Data Mining Patient Informatics Processing Software Hybrid Hadoop Hive. Informatics in Medicine Unlocked, 1, 17-26. https://doi.org/10.1016/j.imu.2016.01.002