Development of a Relational Database Oriented on the Common Information Model for Power Distribution Networks

Author(s)

De Barros, Joao Victor ; Leite, Jonatas B. ; IEEE

• Document type: Journal article
• Source: 2021 IEEE URUCON; v. N/A, p. 4-pg., 2021-01-01.

Abstract

Over the years and the evolution of electrical power systems, there has been a need to design and plan distribution systems with interconnected networks, that are operated by several electricity utilities. These operations use many data, which are stored in the databases of each company with different formats. To establish a standardization of these data and facilitate the exchange of information, the research group called "Electric Power Research Institute (ERPI)" published a standard data model, the "Common Information Model (CIM) for Distribution", which is a combination between the IEC 61970-301 and IEC 61968-11 standards. In this work, the electrical power distribution system is described through the standard CIM, with the aiding of the Enterprise Architect (c) software for generating a standardized file with classes definition of electrical components in distribution networks. Then, this file is processed using the Altova XMLSpy (c) software that enables the specification and creation of tables covering every electrical component of distribution network in a database server. The created relational database is populated, and the stored data is accessed through standardized files. Results illustrate the proposed methodology. (AU)

• FAPESP's process: 20/02491-5 - Development of Common Information Model based Oriented Data Base for Topology Processing and Integration with Electricity Distribution Network using Relational Mapping Tools
• Grantee: João Victor de Barros
• Support Opportunities: Scholarships in Brazil - Technical Training Program - Technical Training
• FAPESP's process: 19/07436-5 - Development of situational awareness and proactive control techniques in the reliability improvement of power distribution networks
• Grantee: Jonatas Boas Leite
• Support Opportunities: Regular Research Grants