CAJ | 학술논문

电网公司配电生产运行风险管控信息支撑平台需要各种在线监测数据、离线数据等大量的配电网运行状态数据，这些数据往往分布在不同的应用系统中，例如停电检修计划（OMS），电力生产管理系统（PMS），在线监测系统，地理信息系统（GIS），SDADA等系统，这些系统在建设的初期往往没有考虑到系统数据的横向集成，因此各业务的业务模型和数据的标准类型存在着较大的差异，为了实现配电生产运行的状态数据信息的有效准确提取，文章以ETL（Extract Transform Load）模型为研究基础，并在此基础上给出了一种通用化的数据抽取、转换和装载的方法，实现了从不同业务系统中对不同数据来源的数据进行抽取、转换和装载工作，为配电生产运行状态的风险管控工作提供了所需要的生产运行状态数据集，进而能够为保证配电生产正常运行提供有力的保障。
전망공사배전생산운행풍험관공신식지탱평태수요각충재선감측수거、리선수거등대량적배전망운행상태수거，저사수거왕왕분포재불동적응용계통중，례여정전검수계화（OMS），전력생산관리계통（PMS），재선감측계통，지리신식계통（GIS），SDADA등계통，저사계통재건설적초기왕왕몰유고필도계통수거적횡향집성，인차각업무적업무모형화수거적표준류형존재착교대적차이，위료실현배전생산운행적상태수거신식적유효준학제취，문장이ETL（Extract Transform Load）모형위연구기출，병재차기출상급출료일충통용화적수거추취、전환화장재적방법，실현료종불동업무계통중대불동수거래원적수거진행추취、전환화장재공작，위배전생산운행상태적풍험관공공작제공료소수요적생산운행상태수거집，진이능구위보증배전생산정상운행제공유력적보장。
Electric Power Company distribution network's production risk management and control platform needs various offiine and online status data in the status assessment work for its transmission and distribution equipment. However, these status data are scattered in different business systems, such as power outage maintenance plan (OMS),electricity production management system (PMS), online monitoring system, SCADA and so on . Each business system differs greatly in business model and data standards. In order to accurately and effectively extract the production of running status this paper proposes a universal data extraction and conversion method which can realize the extraction and conversion work of data with multiple models and sources and provide an running status dataset for the condition maintenance work of transmission and distribution equipment on the basis of extract transform load model (ETL). This method can lay a solid data foundation for production risk management and control platform of Electric Power Company in distribution network's production.