CN105868287B - Multi-source data-based WAMS application system data integration method - Google Patents

Multi-source data-based WAMS application system data integration method Download PDF

Info

Publication number
CN105868287B
CN105868287B CN201610170110.1A CN201610170110A CN105868287B CN 105868287 B CN105868287 B CN 105868287B CN 201610170110 A CN201610170110 A CN 201610170110A CN 105868287 B CN105868287 B CN 105868287B
Authority
CN
China
Prior art keywords
data
data model
file
test case
fault recording
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201610170110.1A
Other languages
Chinese (zh)
Other versions
CN105868287A (en
Inventor
黄远超
施秀萍
汤伟
张文朝
杨铖
范新桥
张传凯
闫亚军
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
NANJING NANRUI GROUP CO
State Grid Corp of China SGCC
State Grid Anhui Electric Power Co Ltd
Original Assignee
NANJING NANRUI GROUP CO
State Grid Corp of China SGCC
State Grid Anhui Electric Power Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by NANJING NANRUI GROUP CO, State Grid Corp of China SGCC, State Grid Anhui Electric Power Co Ltd filed Critical NANJING NANRUI GROUP CO
Priority to CN201610170110.1A priority Critical patent/CN105868287B/en
Publication of CN105868287A publication Critical patent/CN105868287A/en
Application granted granted Critical
Publication of CN105868287B publication Critical patent/CN105868287B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/254Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Abstract

The invention relates to a multi-source data-based WAMS application system data integration method, which comprises the following steps: establishing a self-defined platform data model according to actual conditions; establishing a fault recording event data model; matching the user-defined platform data model and the fault recording event data model through a data interface layer to obtain a standardized test case applied to the WAMS application system; the method provided by the invention can be used for establishing a self-defined platform data information model based on the power system application integration standard extension, integrating related test case information such as a four-way WAMS master station data file, a BPA stable calculation output file, a comprehensive program stable calculation output file, a PMU dynamic data file and the like in a standard mode, and performing memory mapping and data playback on test data and self-defined platform data by calling a dynamic real-time library interface to achieve the aim of simulation operation of the test data under different conditions and provide a solution of a standardized interactive test process for WAMS advanced application.

Description

Multi-source data-based WAMS application system data integration method
Technical Field
The invention relates to the field of power systems, in particular to a data integration method of a WAMS application system based on multi-source data.
Background
A Wide Area Monitoring System (WAMS) is based on a synchrophasor measurement unit (PMU) and a high-speed communication technology, realizes monitoring and analysis of dynamic behaviors of a power system with a wide region, becomes an important means for guaranteeing safe operation of a large power grid, and is a key point of investment construction of power companies of various countries in the aspect of power grid monitoring in recent decades. However, as the power grid is in a stable operation state for most of time, long-time data accumulation is needed for complete online test, which brings inconvenience to development, research and engineering practice, and therefore, a more efficient WAMS test method needs to be researched.
Under the condition that an original system is not changed, how to analyze and integrate test data from different data sources in a WAMS advanced application system to complete data acquisition, conversion and integration to form a test case for the WAMS advanced application system is a problem which needs to be solved urgently at present. Because WAMS test data is distributed among a plurality of systems having different formats and interfaces, the systems are not related to each other, and the different contents contained in the systems are not communicated with each other, there is a need for an ability to easily access specific heterogeneous database data.
Disclosure of Invention
The invention provides a WAMS application system data integration method based on multi-source data, which aims to establish a self-defined platform data information model based on the application integration standard extension of an electric power system, integrate related test case information such as a four-way WAMS master station data file, a BPA stable calculation output file, a comprehensive program stable calculation output file, a PMU dynamic data file and the like in a standard mode, and perform memory mapping and data playback on test data and self-defined platform data by calling a dynamic real-time library interface to achieve the aim of simulation operation of the test data under different conditions and provide a solution of a standardized interactive test process for WAMS advanced application.
The purpose of the invention is realized by adopting the following technical scheme:
in a method of multi-source data based WAMS application system data integration, the improvement comprising:
(1) establishing a self-defined platform data model according to actual conditions;
(2) acquiring a fault source file by simulating the fault condition of fault recording, and establishing a fault recording event data model according to the incidence relation of a station, physical equipment and a data channel corresponding to the fault source file, wherein the description of a fault recording event by an event record is taken as a main key for data storage;
(3) and matching the user-defined platform data model and the fault recording event data model through a data interface layer to obtain a standardized test case applied to the WAMS application system.
Preferably, in the step (1), the custom platform data model is established according to the association relationship among the plant station, the physical device and the data channel in the WAMS application system.
Preferably, the fault condition of the fault recording includes: voltage fluctuations, frequency fluctuations, and power fluctuations.
Preferably, the failed source file includes: the system comprises a WAMS master station data file, an edb, a BPA stable calculation output file, an swx, a comprehensive program stable calculation output file, a sot and a PMU dynamic data file, wherein the data file is a file name.
Preferably, in the step (3), the step of matching the user-defined platform data model and the fault recording event data model through a data interface layer to obtain a standardized test case applied to the WAMS application system includes the steps of:
(3-1) if the plant station in the user-defined platform data model and the fault recording event data model is the same plant station, associating and matching the plant station name of the user-defined platform data model, the plant station name of the fault recording event data model and an equipment list corresponding to the plant station, and constructing a first test case framework;
(3-2) performing correlation matching on the line name of the self-defined platform data model corresponding to the plant station, the generator name of the self-defined platform data model corresponding to the plant station, the line name of the fault recording event data model corresponding to the plant station, the generator name of the fault recording event data model corresponding to the plant station and a channel list corresponding to equipment to construct a second test case framework of the test case, wherein the second test case framework is a lower-level framework of the equipment list;
(3-3) carrying out association matching on a channel name corresponding to the line of the user-defined platform data model, a channel name corresponding to the generator of the user-defined platform data model, a channel name corresponding to the line of the fault recording event data model, a channel name corresponding to the generator of the fault recording event data model and a channel attribute list, and constructing a third test case framework of the test case, wherein the third test case framework is a lower framework of the channel list, and the channel list comprises attributes of all channels in the third test case framework.
The invention has the beneficial effects that:
(1) the invention provides a method for integrating WAMS application system data based on multi-source data, which is characterized in that a self-defined full-network data topology information model and a fault recording event information model are established based on IECTC57CIM extension, and four-side WAMS master station data files including an edb and BPA stable calculation output file including an swx and a comprehensive program stable calculation output file including a sot, a PMU dynamic data file including a dyn and other related fault recording data can be integrated in a standard mode to form a standardized test case.
(2) The method for integrating the data of the WAMS application system based on the multi-source data collects the data of fault recording and the like from each service system into a platform through means of extraction, conversion, loading and the like, has high data acquisition efficiency, is effective and convenient, builds a foundation for further event analysis and simulation operation, and realizes multi-directional test of the WAMS application system from different angles and different levels, thereby better verifying the accuracy, reliability and stability of the WAMS application system, and having important significance for reducing the development cost of the WAMS advanced application system and accelerating the development progress.
Drawings
FIG. 1 is a flow chart of a method of multi-source data based WAMS application system data integration in accordance with the present invention;
FIG. 2 is a diagram illustrating a standardized test case structure according to an embodiment of the present invention.
Detailed Description
The following detailed description of embodiments of the invention refers to the accompanying drawings.
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention provides a brand-new method for integrating and integrating data of a WAMS application system based on multi-source data by aiming at the system requirements, algorithms and data flow characteristics of the WAMS and combining the existing engineering practice. The requirements of the WAMS system on massive data and data security are met, an integrated data platform with unified massive data and high data security can be provided for each business department of the dispatching center, and upgrading and expansion of functions of the WAMS system are facilitated, as shown in FIG. 1, the method comprises the following steps:
(1) establishing a self-defined platform data model according to actual conditions;
(2) acquiring a fault source file by simulating the fault condition of fault recording, and establishing a fault recording event data model according to the incidence relation of a station, physical equipment and a data channel corresponding to the fault source file;
the method comprises the following steps of storing data by taking the description of a fault recording event by an event record as a main key;
the fault conditions of the fault recording comprise: voltage fluctuations, frequency fluctuations, and power fluctuations;
the failed source file comprises: the data file of the WAMS master station includes an edb data file, a BPA stable calculation output file, a swx data file, a Sot data file, a PMU dynamic data file, and a dyn data file, wherein the document name is the name of the document;
in practical application, the basic information of the failed source file can be acquired through the interface corresponding to the failed source file, for example: A. the method for acquiring the EDB file basic information through the four-way data EDB file interface comprises the following steps:
step1, using the function bone GetFileInfoEDB (char Strile Name, signed int & uiBgnSOC, signed int & uiEndSOC, signed int & uiInterval, signed int & uiSmpNum) to obtain the EDB file basic information.
a) Char strFileName EDB data file name
b) Signaled int & uiBgnSOC data start time SOC
c) Signaled int & uiEndSOC data end time SOC
d) unsigned int & uiInterval data storage Interval
e) Number of unique int & uiSmpNum data storage points
Step2, using function bool GetConfigEDB (char StrFileName, strucConfig config) to obtain EDB file configuration information.
a) Char strFileName EDB filename
b) strucConfig configuration information return
Step3, setting configuration information of the data to be acquired by using a function bool SetConfigEDB (stuck Config. fig.).
a) stucConfig requires configuration information of data
Step4, setting time information of data to be acquired by using a function boot SetTimeEDB (signaled int & uiBgnSOC, signaled int & uiEndSOC).
a) Signaled int & uiBgnSOC data start time SOC
b) Signaled int & uiEndSOC data end time SOC
Step5, the function of bool WriteFileEDB (char StrFileName) is used to output the data file.
a) Char strFileName output data file name
B. Acquiring basic information of the BPA file through a BPA data file interface, wherein the basic information comprises the following steps:
step1, using function boot GetFileInfoBPA (character string name, signed int & uiBgnSOC, signed int & uiEndSOC, signed int & uiInterval, signed int & uiSmpNum) to obtain BPA file basic information.
a) Char strFileName BPA data file name
b) Signaled int & uiBgnSOC data start time SOC
c) Signaled int & uiEndSOC data end time SOC
d) unsigned int & uiInterval data storage Interval
e) Number of unique int & uiSmpNum data storage points
Step2, using function bool GetConfigBPA (char StrFileName, strucConfig config) to obtain data configuration information.
a) Char strFileName BPA filename
b) strucConfig configuration information return
Step3, setting configuration information of the data to be acquired by using a function bool SetConfigBPA (stuck Config config).
a) stucConfig requires configuration information of data
Step4, setting time information required to acquire data by using a function boot SetTimeBPA (unknown int & uiBgnSOC, unknown int & uiEndSOC).
a) Signaled int & uiBgnSOC data start time SOC
b) Signaled int & uiEndSOC data end time SOC
Step5, output data file by using function bool WriteFileBPA (char StrFileName).
a) Char strFileName output data file name
C. Obtaining the essential information of the sot file through the sot file of the integrated program data, which comprises the following steps:
step1, using function boot GetFileInfoSOT (char StrictFileName, signed int & uiBgnSOC, signed int & uiEndSOC, signed int & uiInterval, signed int & uiSmpNum) to obtain basic information of file.
a) Char strFileName integrated program data SOT file name
b) Signaled int & uiBgnSOC data start time SOC
c) Signaled int & uiEndSOC data end time SOC
d) unsigned int & uiInterval data storage Interval
e) Number of unique int & uiSmpNum data storage points
Step2, using function bool GetConfigSOT (char StrFileName, strucConfig config) to obtain data configuration information.
a) Char strFileName SOT filename
b) strucConfig configuration information return
Step3, setting configuration information of the data to be acquired by using a function bool SetConfigSOT (stuck config).
a) stucConfig requires configuration information of data
Step4, setting time information of data to be acquired by using a function boot SetTimeSOT (unknown int & uibgsoc, unknown int & uiEndSOC).
a) Signaled int & uiBgnSOC data start time SOC
b) Signaled int & uiEndSOC data end time SOC
Step5, using the function of pool WriteFileSOT (char StrFileName) to output the data file.
a) Char strFileName output data file name
D. Obtaining basic information of dyn files through a PMU dynamic data interface, comprising:
step1, using the function pool GetFileInfoPMU (char StrDirName, signed int & uiBgnSOC, signed int & uiEndSOC, signed int & uiInterval, signed int & uiSmpNum) to obtain the basic information of the file.
a) Char strDirName dynamic data PMU file name
b) Signaled int & uiBgnSOC data start time SOC (based on the earliest time in the data file under the directory)
c) End time SOC of signaled int & uiEndSOC data (based on the latest time in data file under directory)
d) unsigned int & uiInterval data storage Interval
e) Number of unique int & uiSmpNum data storage points
Step2, obtaining data configuration information by using a function bool GetConfigPMU (char StrFileName, strucConfig config).
a) Char strFileName dynamic data PMU file name
b) strucConfig configuration information return
Step3, setting configuration information of data to be acquired by using a function pool SetConfig PMU (stuck Config).
a) stucConfig requires configuration information of data
Step4, setting time information needed to acquire data by using a function pool SetTimePMU (signaled int & uibgsoc, signaled int & uiEndSOC).
a) Signaled int & uiBgnSOC data start time SOC
b) Signaled int & uiEndSOC data end time SOC
Step5, output data file by using function boot WriteFilePMU (char StrFileName).
a) Char strFileName output data file name
(3) And matching the user-defined platform data model and the fault recording event data model through a data interface layer to obtain a standardized test case applied to the WAMS application system.
Specifically, in the step (1), the custom platform data model is established according to the association relationship among the plant station, the physical device and the data channel in the WAMS application system.
In the step (3), the user-defined platform data model and the fault recording event data model are matched through a data interface layer to obtain a standardized test case applied to the WAMS application system, as shown in fig. 2, which includes the steps of:
(3-1) if the plant station in the user-defined platform data model and the fault recording event data model is the same plant station, associating and matching the plant station name of the user-defined platform data model, the plant station name of the fault recording event data model and an equipment list corresponding to the plant station, and constructing a first test case framework;
(3-2) performing correlation matching on the line name of the self-defined platform data model corresponding to the plant station, the generator name of the self-defined platform data model corresponding to the plant station, the line name of the fault recording event data model corresponding to the plant station, the generator name of the fault recording event data model corresponding to the plant station and a channel list corresponding to equipment to construct a second test case framework of the test case, wherein the second test case framework is a lower-level framework of the equipment list;
(3-3) carrying out association matching on a channel name corresponding to the line of the user-defined platform data model, a channel name corresponding to the generator of the user-defined platform data model, a channel name corresponding to the line of the fault recording event data model, a channel name corresponding to the generator of the fault recording event data model and a channel attribute list, and constructing a third test case framework of the test case, wherein the third test case framework is a lower framework of the channel list, and the channel list comprises attributes of all channels in the third test case framework.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting the same, and although the present invention is described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications and equivalents may be made to the embodiments of the invention without departing from the spirit and scope of the invention, which is to be covered by the claims.

Claims (3)

1. A method for integrating WAMS application system data based on multi-source data is characterized by comprising the following steps:
(1) establishing a self-defined platform data model according to actual conditions;
(2) acquiring a fault source file by simulating the fault condition of fault recording, and establishing a fault recording event data model according to the incidence relation of a station, physical equipment and a data channel corresponding to the fault source file, wherein the description of a fault recording event by an event record is taken as a main key for data storage;
(3) matching the user-defined platform data model and the fault recording event data model through a data interface layer to obtain a standardized test case applied to the WAMS application system;
in the step (3), the user-defined platform data model and the fault recording event data model are matched through a data interface layer to obtain a standardized test case applied to the WAMS application system, and the method comprises the following steps:
(3-1) if the plant station in the user-defined platform data model and the fault recording event data model is the same plant station, associating and matching the plant station name of the user-defined platform data model, the plant station name of the fault recording event data model and an equipment list corresponding to the plant station, and constructing a first test case framework;
(3-2) performing correlation matching on the line name of the self-defined platform data model corresponding to the plant station, the generator name of the self-defined platform data model corresponding to the plant station, the line name of the fault recording event data model corresponding to the plant station, the generator name of the fault recording event data model corresponding to the plant station and a channel list corresponding to equipment to construct a second test case framework of the test case, wherein the second test case framework is a lower-level framework of the equipment list;
(3-3) carrying out association matching on a channel name corresponding to a line of the user-defined platform data model, a channel name corresponding to a generator of the user-defined platform data model, a channel name corresponding to a line of the fault recording event data model, a channel name corresponding to a generator of the fault recording event data model and a channel attribute list, and constructing a third test case framework of the test case, wherein the third test case framework is a lower framework of the channel list, and the channel list comprises attributes of all channels in the third test case framework;
in the step (2), the failed source file includes: the system comprises a WAMS master station data file, an edb, a BPA stable calculation output file, an swx, a comprehensive program stable calculation output file, a sot and a PMU dynamic data file, wherein the data file is a file name.
2. The method of claim 1, wherein in step (1), the custom platform data model is established according to an association relationship among the plant stations, the physical devices and the data channels in the WAMS application system.
3. The method of claim 1, wherein in step (2), the fault condition of the fault recording comprises: voltage fluctuations, frequency fluctuations, and power fluctuations.
CN201610170110.1A 2016-03-23 2016-03-23 Multi-source data-based WAMS application system data integration method Active CN105868287B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610170110.1A CN105868287B (en) 2016-03-23 2016-03-23 Multi-source data-based WAMS application system data integration method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610170110.1A CN105868287B (en) 2016-03-23 2016-03-23 Multi-source data-based WAMS application system data integration method

Publications (2)

Publication Number Publication Date
CN105868287A CN105868287A (en) 2016-08-17
CN105868287B true CN105868287B (en) 2021-04-06

Family

ID=56624811

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610170110.1A Active CN105868287B (en) 2016-03-23 2016-03-23 Multi-source data-based WAMS application system data integration method

Country Status (1)

Country Link
CN (1) CN105868287B (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107729451B (en) * 2017-10-09 2021-02-23 四川巧夺天工信息安全智能设备有限公司 Method for searching data in EDB database source file
CN107862023B (en) * 2017-10-31 2021-12-24 四川巧夺天工信息安全智能设备有限公司 Method for analyzing data in EDB database source file
CN108632077B (en) * 2018-02-28 2021-03-26 全球能源互联网研究院有限公司 Power business data transmission modeling process and transmission channel determination method
CN112328574A (en) * 2020-11-03 2021-02-05 上海许继电气有限公司 Relay protection fault information master station data migration method and device

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102928738A (en) * 2012-10-31 2013-02-13 辽宁省电力有限公司沈阳供电公司 Dynamic layer diagnostic device and method of smart power grid fault
CN105093033A (en) * 2015-09-01 2015-11-25 华中电网有限公司 Power grid multi-source information-based fault integrated analysis system and analysis method

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100485734C (en) * 2007-07-17 2009-05-06 东北大学 Electric energy quality and electrical power system malfunction detection wave recording device and method
CN101996271B (en) * 2010-08-12 2013-08-14 武汉大学 Software interface for automatically generating simulation calculation model of PSCAD power system
CN103326467B (en) * 2013-06-03 2015-07-29 中国南方电网有限责任公司 A kind of protection act report implementation method based on Prudential Master device wave-record chart
CN104239643B (en) * 2014-09-22 2018-01-19 国家电网公司 WAMS applications algorithm checking system and its verification method based on fault recorder data

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102928738A (en) * 2012-10-31 2013-02-13 辽宁省电力有限公司沈阳供电公司 Dynamic layer diagnostic device and method of smart power grid fault
CN105093033A (en) * 2015-09-01 2015-11-25 华中电网有限公司 Power grid multi-source information-based fault integrated analysis system and analysis method

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
Descriptive Model of a Generic WAMS;JF Hauer 等;《Pacific Northwest National Laboratory》;20070601;1-45 *
基于多源信息的电网故障综合分析系统;谢俊 等;《电气安全》;20160305;第35卷(第5期);56-62 *

Also Published As

Publication number Publication date
CN105868287A (en) 2016-08-17

Similar Documents

Publication Publication Date Title
CN107402976B (en) Power grid multi-source data fusion method and system based on multi-element heterogeneous model
CN105868287B (en) Multi-source data-based WAMS application system data integration method
CN107357856B (en) Method for realizing data integration and data service based on power grid panoramic service model
CN103675600B (en) Based on the Fault Diagnosis of Distribution Network system and method for topological knowledge
CN105225076B (en) Cost analysis data acquisition and processing system
CN104573032A (en) Emergency simulation drilling all-in-one machine for nuclear emergency device
CN103337012B (en) Towards the multi-threaded intelligent comprehensive alert analysis method of grid equipment monitoring
US20140039818A1 (en) Determining a connectivity model in smart grids
CN105589791A (en) Method for application system log monitoring management in cloud computing environment
CN103106565A (en) Power grid information real-time display method and device which are based on geographic information system (GIS) and supervisory control and data acquisition (SCADA)
CN110908590A (en) Distributed storage method and system for transformer substation data
CN105426482A (en) Figure-database integrated HBase transfer storage method of massive monitoring information of 10kV railway power distribution network
CN113612306A (en) Distributed power distribution cabinet and control system thereof
CN105868441B (en) Multi-source data-based WAMS application system data integration test platform
CN113934807A (en) Territorial space planning system and method based on GIS
Klugman et al. Grid watch: Mapping blackouts with smart phones
CN104112183A (en) Plug-and-play intelligent scheduling model management system and management method of intelligent substation
CN110910276A (en) Power dispatching data integration system
CN103247087A (en) City distribution network graphical intelligent anti-misoperation system and method of system
CN109741594B (en) Configuration method and device for equipment data acquisition
CN114356051A (en) Research on electronic information storage technology based on cloud computing and cloud server
CN114116252A (en) System and method for storing operation measurement data of regulation and control system
CN208158632U (en) Electric energy metering system data intelligence processing system
CN110990382A (en) Data traceability management system for information operation monitoring
CN112670942A (en) Distribution network system relay protection setting calculation and data management system

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant