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

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© software for generating a standardized file with classes definition of electrical components in distribution networks. Then, this file is processed using the Altova XMLSpy© 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.