K. Iliev, Ahsan Mirza, Lori Marshall, G. Wen, Saman Alaeddini, A. Bidram
{"title":"自动分析和报告继电器设置数据库","authors":"K. Iliev, Ahsan Mirza, Lori Marshall, G. Wen, Saman Alaeddini, A. Bidram","doi":"10.1109/CPRE.2018.8349776","DOIUrl":null,"url":null,"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.","PeriodicalId":285875,"journal":{"name":"2018 71st Annual Conference for Protective Relay Engineers (CPRE)","volume":"2 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2018-03-26","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"3","resultStr":"{\"title\":\"Automated analysis & reporting from relay setting database\",\"authors\":\"K. Iliev, Ahsan Mirza, Lori Marshall, G. Wen, Saman Alaeddini, A. Bidram\",\"doi\":\"10.1109/CPRE.2018.8349776\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":285875,\"journal\":{\"name\":\"2018 71st Annual Conference for Protective Relay Engineers (CPRE)\",\"volume\":\"2 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2018-03-26\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"3\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2018 71st Annual Conference for Protective Relay Engineers (CPRE)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/CPRE.2018.8349776\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2018 71st Annual Conference for Protective Relay Engineers (CPRE)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/CPRE.2018.8349776","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Automated analysis & reporting from relay setting database
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.