Automated analysis & reporting from relay setting database

Abstract

Protection engineers often verify relay settings stored in a database. The conventional way to view settings is to open the setting files with software released by the respective manufacturer. Often times, the most commonly used settings are stored in a report for quick access by protection and other departments within the same utility. Depending on the size of the network, creating and updating such reports can be time consuming. This paper proposes a process to automatically create customized reports based on setting files stored in a database. Logics are programmed to read relay settings and intelligently convey tripping information to the relay engineer. The connection to the settings database is facilitated by using an Open Database Connectivity (ODBC) link. Custom queries are utilized to retrieve relay settings by a predefined search pattern. The relay engineer can generate reports based on a specific settings file, relay, position, or substation.