WO2016019855A1 - Data conversion method and apparatus - Google Patents

Data conversion method and apparatus Download PDF

Info

Publication number
WO2016019855A1
WO2016019855A1 PCT/CN2015/086046 CN2015086046W WO2016019855A1 WO 2016019855 A1 WO2016019855 A1 WO 2016019855A1 CN 2015086046 W CN2015086046 W CN 2015086046W WO 2016019855 A1 WO2016019855 A1 WO 2016019855A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
converted
target
database
format
Prior art date
Application number
PCT/CN2015/086046
Other languages
French (fr)
Chinese (zh)
Inventor
孙健
竺懋渝
袁清芳
王海云
杨楠
高明伟
刘慧珍
杜晨红
张岩
王存平
Original Assignee
国家电网公司
国网北京市电力公司
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 国家电网公司, 国网北京市电力公司 filed Critical 国家电网公司
Publication of WO2016019855A1 publication Critical patent/WO2016019855A1/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor

Definitions

  • the present invention relates to the field of data processing, and in particular to a data conversion method and apparatus.
  • the power system needs to analyze the data of a large number of different data sources when performing data analysis.
  • Data from different data sources often have different data formats.
  • a technical solution of independent analysis is often adopted.
  • the power system analysis program BPA is mainly designed for calculation. It only retains the standard value information necessary for calculation, but lacks corresponding equipment information and original parameters.
  • the system specially developed PSDB equipment library management. software.
  • PSDB uses FOXPRO database, correspondingly increased device nameplate value, can generate PSD-BPA trend and stable data
  • PSD-BPA uses fixed format text file
  • trend (.DAT) and stable (.SWI) two files contain All data used in electromechanical transients.
  • the PSDB software has a single function and a simple human-machine interface design.
  • the production management system PMIS is completely based on the self-developed power business software platform for system construction, which has the characteristics of system standardization, transmission and distribution integration, but the data based on PMIS cannot directly analyze data in other formats, ie different data. Source data cannot be analyzed across data sources.
  • Embodiments of the present invention provide a data conversion method and apparatus, to at least solve the technical problem that data of different data sources in the related art cannot be analyzed across data sources.
  • a data conversion method includes: obtaining reference data in a reference data source; reading a reference data format of the reference data; and acquiring data to be converted in the data source to be converted, where the data format of the data to be converted and the reference data format are different formats. And converting the data to be converted into target data according to a reference data format, wherein the target number of target data The format is the same as the reference data format.
  • the data conversion method further includes: generating a database according to the target data; and storing the target data in the database.
  • the data conversion method further includes: reading the target data from the database; and generating a simulation file according to the target data, where the simulation file is a file for performing simulation processing on the target data.
  • the data conversion method further comprises: generating a graphic file according to the target data; outputting the graphic file to the software front end; and displaying the graphic file on the graphic interface of the software front end.
  • converting the data to be converted into the target data according to the reference data format includes: comparing the data to be converted with the reference data; determining whether there is a difference between the data to be converted and the reference data; if it is determined that there is no difference between the data to be converted and the reference data , the data to be converted is converted into target data; and if it is determined that there is a difference between the data to be converted and the reference data, an alarm is generated.
  • a data conversion apparatus configured to obtain reference data in a reference data source; a first reading unit, configured to read a reference data format of the reference data; and a second acquiring unit, configured to obtain the data source to be converted Data to be converted, wherein the data format of the data to be converted and the reference data format are different formats; and a conversion unit for converting the data to be converted into target data according to the reference data format, wherein the target data format of the target data Same as the reference data format.
  • the data conversion apparatus further includes: a first generating unit, configured to generate a database according to the target data after converting the data to be converted into the target data according to the reference data format; and a storage unit configured to store the target data in the database in.
  • the data conversion device further includes: a second reading unit, configured to read the target data from the database after storing the target data in the database; and a second generating unit, configured to generate the simulation file according to the target data
  • the simulation file is a file that simulates the target data.
  • the data conversion device further includes: a third generating unit, configured to: after reading the target data from the database, generate a graphic file according to the target data; an output unit, configured to output the graphic file to the software front end; and a display unit, Used to display graphic files on the graphical interface of the software front end.
  • a third generating unit configured to: after reading the target data from the database, generate a graphic file according to the target data
  • an output unit configured to output the graphic file to the software front end
  • a display unit Used to display graphic files on the graphical interface of the software front end.
  • the converting unit includes: a comparing module, configured to compare the data to be converted with the reference data; and a determining module, configured to determine whether there is a difference between the data to be converted and the reference data; and a conversion module, configured to determine the data to be converted and When there is no difference in the reference data, the data to be converted is converted into the target data; and the alarm module is configured to perform an alarm when it is determined that there is a difference between the data to be converted and the reference data.
  • the reference data in the reference data source is obtained, the reference data format of the reference data is read, and the data to be converted in the data source to be converted is obtained, where the data to be converted is to be converted.
  • FIG. 1 is a schematic diagram of a data conversion apparatus according to an embodiment of the present invention.
  • FIG. 2 is a schematic diagram of a software architecture for data conversion in accordance with an embodiment of the present invention
  • FIG. 3 is a schematic diagram of data processing performed by a BPA interface according to an embodiment of the present invention.
  • FIG. 4 is a schematic diagram of data processing performed by a PSDB interface according to an embodiment of the present invention.
  • FIG. 5 is a schematic diagram of data processing performed by a PMIS interface according to an embodiment of the present invention.
  • FIG. 6 is a schematic diagram of model conversion in accordance with an embodiment of the present invention.
  • FIG. 7 is a schematic diagram of data processing performed by a PSASP interface according to an embodiment of the present invention.
  • FIG. 8 is a flow chart of a data conversion method in accordance with an embodiment of the present invention.
  • a data conversion apparatus for converting different data source data into data of the same format.
  • FIG. 1 is a schematic diagram of a data conversion device in accordance with an embodiment of the present invention.
  • the apparatus includes: a first acquisition unit 10, a first reading unit 20, a second acquisition unit 30, and a conversion unit 40.
  • the first obtaining unit 10 is configured to acquire reference data in the reference data source.
  • the first reading unit 20 is configured to read a reference data format of the reference data.
  • the second obtaining unit 30 is configured to obtain data to be converted in the data source to be converted, where the data format of the data to be converted and the reference data format are in different formats.
  • the converting unit 40 is configured to convert the data to be converted into target data according to a reference data format, wherein the target data format of the target data is the same as the reference data format.
  • the reference data in the reference data source is obtained; the reference data format of the reference data is read; the data to be converted in the data source to be converted is obtained; and the data to be converted is converted into the target data according to the reference data format. It is convenient for data analysis.
  • the reference data source is a preset data source, for example, the BPA data source can be used as a reference data source, wherein the BPA data source format includes a power flow (.DAT) and a stable (.SWI) file format.
  • the data source to be converted may include a PSDB data source, a PSD-BPA data source, and a PMIS data source.
  • Different data sources can transfer data in their own data sources to the data platform through their respective data source interfaces for corresponding data conversion.
  • the PSDB data source, the PSD-BPA data source, and the PMIS data source can transmit corresponding data to the foregoing data platform through the PSDB data source interface, the PSD-BPA data source interface, and the PMIS data source interface, respectively.
  • the foregoing data platform is a simulation platform integrating graphics, modules and libraries. It can realize data fusion of PSDB, PSD-BPA and PMIS, and identify data with differences by one by one, and save data without difference. Go to the database. On this basis, different operation modes of BPA, PSASP and PACAD/EMTDC and automatic generation of planning data simulation calculation files are realized.
  • the data platform includes a data source interface: a PSDB data source interface, a PSD-BPA data source interface, and a PMIS data source interface.
  • a data source interface a data source interface
  • PSDB uses the foxpro database
  • the PMIS can export the Excel file
  • the BPA uses the data files in the dat and swi formats
  • the data platform also includes a data management module, and
  • the foregoing data source interfaces are connected for comparing, extracting, and performing data query, data editing, grid incremental data statistics and addition, data check and check, and device statistics on the PSDB, BPA, and PMIS data.
  • the data platform also includes a database, connected to the aforementioned data management module, for storing data after conversion.
  • the data platform also includes a graphical interface. Connected with the aforementioned database, the graphical interface is developed in C# language. Users can use the graphical interface to use the data stored in the database to realize grid graphics rendering, grid data query and editing functions. At the same time, the grid topology and calculation results can be intuitive. Displayed in the graphical interface; in addition, the data platform also includes a PSD-BPA interface, a PSASP interface, and a PSACD ⁇ EMTDC interface.
  • These interfaces can convert the data obtained by the foregoing transformation in opposite directions, respectively, and obtain and output BPA data, PSASP data, and PSACD ⁇ EMTDC data, specifically, PSD-BPA interface and PSASP interface can realize PSD-BPA, PSASP power flow calculation and automatic generation of electromechanical transient simulation files under different operation modes.
  • PSD-BPA interface and PSASP interface can realize PSD-BPA, PSASP power flow calculation and automatic generation of electromechanical transient simulation files under different operation modes.
  • the PSACD ⁇ EMTDC interface can automatically form an electromagnetic transient simulation file of the specified analysis object according to the graphic data and the grid parameters in the database.
  • BPA, PSDB and PMIS are used to output static data, and BPA is also used to output steady state data.
  • the data conversion device may further include: a first generating unit and a storage unit.
  • the first generating unit is configured to generate a database according to the target data after converting the data to be converted into the target data according to the reference data format.
  • the storage unit is used to store the target data in a database.
  • the data conversion device may further include: a second reading unit and a second generating unit.
  • the second reading unit is configured to read the target data from the database after storing the target data in the database.
  • the second generating unit is configured to generate a simulation file according to the target data, where the simulation file is a file for performing simulation processing on the target data.
  • the data conversion device may further include: a third generation unit, an output unit, and a display unit
  • the third generating unit is configured to generate a graphic file according to the target data after reading the target data from the database; the output unit is configured to output the graphic file to the software front end; and the display unit is configured to display the graphic file on the graphic interface of the software front end.
  • the converting unit 40 includes: a comparison module, a determination module, a conversion module, and an alarm module.
  • the comparison module is configured to compare the data to be converted with the reference data; the determining module is configured to determine whether there is a difference between the data to be converted and the reference data; and the conversion module is configured to be converted when it is determined that there is no difference between the data to be converted and the reference data.
  • the data is converted into target data; and the alarm module is configured to perform an alarm when it is determined that there is a difference between the data to be converted and the reference data.
  • FIG. 3 is a schematic diagram of data processing performed by the BPA interface according to an embodiment of the present invention.
  • the BPA is a bidirectional interface, that is, BPA data can be written into the data platform, and data of the data platform can also generate BPA.
  • the file, that is, the data of the BPA data source can be converted into target data, and can also be used to convert the target data into data of the BPA data source.
  • BPA is formatted text. Therefore, the data must be parsed according to the BPA format, and the parsed data is compared with the PSDB data and stored in the data platform. Because it involves multiple sources of data, Data must be categorized one by one to achieve data fusion.
  • BPA files (DAT, SWI) can be used for data fusion through the platform database, or simulation files can be generated according to the platform database.
  • the data in the platform database in the figure may also include data obtained by converting PSDB data and PMIS data.
  • the BPA file when the BPA file is generated, the BPA file is stored and generated according to the preset job; the BPA file is generated according to the preset area; and the BPA file is generated according to the preset commissioning time.
  • the load data can be generated according to the load growth rate.
  • the PSDB is a data file based on FoxPro, and uses multiple table storage methods, and multiple tables include a line parameter table and a transformer parameter table.
  • the generator parameter table, the capacitor parameter table and the reactor parameter table are used to save the named value parameters required for power system analysis and calculation.
  • the PSDB of the database is imported as a one-way interface, that is, the data of the PSDB can only be written to the data platform.
  • the parameters of each component are compared one by one with the standard value parameter of the BPA, and each parameter that meets the requirements is written into the database of the data platform.
  • the BPA data and the device topology information and the PSDB data can be read from the database, and the two data are compared and fused to generate data in the platform database.
  • the PMIS can export an EXCEL file
  • the database stores the production information of the line and the transformer device, such as the wire type, the voltage level, and the maximum allowable. Current, length, etc. This information allows verification and addition of PSDB data and BPA data.
  • the PMIS database stores information such as operating unit, asset unit, voltage level, maintenance team, line number, line name, current nature, erection mode, line length, cable length, tower base number, and wire type.
  • the BPA data and the device topology information and the PMIS data can be read from the database, and the two data are compared and fused to generate data in the platform database.
  • an EMTDC model can be automatically constructed by using BPA model data.
  • the basic process is as follows: a stored BPA model including topology information is first read from a database. Data recording, then parsing the BPA data of different types of devices into corresponding component parameter information in the EMTDC, and generating corresponding component models in the EMTDC according to the component parameters and the network topology information. Using the corresponding model block diagram in BPA, the custom model transformation is realized by assigning the actual parameter values to the model attributes. Finally, the .psc file is automatically generated according to the information storage format of modules, components, etc. in the .psc file. Specifically, the BPA data and the device topology are read from the database, and the BPA data model is parsed to generate an electromagnetic transient simulation file (.psc file).
  • PSASP manages a bus (cdb_bus), a generator (cdb_generat), and a corresponding data table in the mySQL database.
  • Data such as load (cdb_load with static characteristic load), line (cdb_acline), dual winding transformer (cdb_trans_2w), and three-winding transformer (cdb_trans_3w) and DC line (cdb_dcline).
  • a data conversion method for converting different data source data into data of the same format can be run on a computer processing device. It should be noted that the data conversion method provided by the embodiment of the present invention may be performed by the data conversion apparatus of the embodiment of the present invention. The data conversion apparatus of the embodiment of the present invention may also be used to perform the data conversion method of the embodiment of the present invention.
  • FIG. 8 is a flow chart of a data conversion method in accordance with an embodiment of the present invention. As shown in FIG. 8, the method includes the following steps S802 to S808:
  • Step S802 acquiring reference data in the reference data source.
  • Step S804 reading a reference data format of the reference data.
  • Step S806 the data to be converted in the data source to be converted is obtained, where the data format of the data to be converted and the reference data format are in different formats.
  • Step S808 Convert the data to be converted into target data according to a reference data format, wherein the target data format of the target data is the same as the reference data format.
  • the reference data in the reference data source is obtained; the reference data format of the reference data is read; the data to be converted in the data source to be converted is obtained; and the data to be converted is converted into the target data according to the reference data format. It is convenient for data analysis.
  • the reference data source is a preset data source, for example, the BPA data source can be used as a reference data source, wherein the BPA data source format includes a power flow (.DAT) and a stable (.SWI) file format.
  • the data source to be converted may include a PSDB data source, a PSD-BPA data source, and a PMIS data source.
  • Different data sources can transfer data in their own data sources to the data platform through their respective data source interfaces for corresponding data conversion.
  • the PSDB data source, the PSD-BPA data source, and the PMIS data source can transmit corresponding data to the foregoing data platform through the PSDB data source interface, the PSD-BPA data source interface, and the PMIS data source interface, respectively.
  • the foregoing data platform is a simulation platform integrating graphics, modules and libraries, which can realize data fusion of PSDB, PSD-BPA and PMIS, and identify data with differences by one by one, and will have no difference data. Save to the database. On this basis, different operation modes of BPA, PSASP and PACAD/EMTDC and automatic generation of planning data simulation calculation files are realized.
  • the structure of the data platform is as shown in FIG. 2, wherein the data platform includes a data source interface: a PSDB data source interface, a PSD-BPA data source interface, and a PMIS data source interface, and the data source interfaces are used to input the data source.
  • Format data specifically, PSDB uses foxpro database, PMIS can export Excel file, BPA uses dat and swi format data files;
  • the data platform also includes data management module, which is connected with the aforementioned data source interface for PSDB , BPA and PMIS data are compared, extracted, and data query, data editing, grid incremental data statistics and additions, data inspection and verification, equipment statistical analysis, and typical parameter library maintenance are performed in the database;
  • the database is included and connected to the foregoing data management module for storing the converted data.
  • the data platform also includes a graphical interface, which is connected with the aforementioned database, and the graphical interface is developed by using the C# language.
  • the user can use the graphical interface to utilize the data stored in the database to realize grid graphic drawing, grid data query and editing functions, and the grid.
  • the topology and calculation results can also be displayed visually in the graphical interface.
  • the data platform also includes a PSD-BPA interface, a PSASP interface, and a PSACD ⁇ EMTDC interface. These interfaces can be converted in the opposite direction by the data obtained by the foregoing transformation, respectively.
  • the BPA data, the PSASP data and the PSACD ⁇ EMTDC data are outputted.
  • the PSD-BPA interface and the PSASP interface can automatically generate PSD-BPA, PSASP power flow calculation and electromechanical transient simulation files in different operation modes.
  • the PSACD ⁇ EMTDC interface can automatically form an electromagnetic transient simulation file of the specified analysis object according to the graphic data and the grid parameters in the database.
  • BPA, PSDB and PMIS are used to output static data, and BPA is also used to output steady state data.
  • the data conversion method may further include:
  • the target data is stored in the database.
  • the data conversion method may further include:
  • S8 Generate a simulation file according to the target data, where the simulation file is a file for performing simulation processing on the target data.
  • the data conversion method may further include:
  • converting the data to be converted into target data according to the reference data format may include:
  • the BPA is a bidirectional interface, that is, the BPA data can be written into the data platform, and the data of the data platform can also generate a BPA file, that is, the data of the BPA data source can be converted into the target data, and also Can be used to convert target data into data from BPA data sources.
  • BPA is formatted text. Therefore, the data must be parsed according to the BPA format, and the parsed data is compared with the PSDB data and stored in the data platform. Because of the multi-source data involved, it is necessary to record the data one by one to achieve data fusion.
  • BPA files (DAT, SWI) can be used for data fusion through the platform database, or simulation files can be generated according to the platform database.
  • the data in the platform database in the figure may also include data obtained by converting PSDB data and PMIS data.
  • the BPA file when the BPA file is generated, the BPA file is stored and generated according to the preset job; the BPA file is generated according to the preset area; and the BPA file is generated according to the preset commissioning time.
  • the load data can be generated according to the load growth rate.
  • the PSDB is a FoxPro-based data file, which uses multiple table storage methods.
  • the multiple tables include a line parameter table, a transformer parameter table, a generator parameter table, a capacitor parameter table, and a reactor parameter table for Save the named value parameters required for power system analysis calculations.
  • the PSDB of the database is imported as a one-way interface, that is, the data of the PSDB can only be written to the data platform.
  • the parameters of each component are compared one by one with the standard value parameter of the BPA, and each parameter that meets the requirements is written into the database of the data platform.
  • the BPA data and the device topology information and the PSDB data can be read from the database, and the two data are compared and fused to generate data in the platform database.
  • PMIS can export EXCEL files, which store the production of lines and transformers. Information such as wire type, voltage rating, maximum allowable current, length, etc. This information allows verification and addition of PSDB data and BPA data.
  • the PMIS database stores information such as operating unit, asset unit, voltage level, maintenance team, line number, line name, current nature, erection mode, line length, cable length, tower base number, and wire type.
  • the BPA data and the device topology information and the PMIS data can be read from the database, and the two data are compared and fused to generate data in the platform database.
  • the EMTDC model can be automatically constructed by using the BPA model data.
  • the basic process is as follows: the stored BPA model data record including the topology information is read from the database, and then the BPA data of different types of devices is parsed into EMTDC. The corresponding component parameter information is generated, and corresponding component models in the EMTDC are generated according to the component parameters and the network topology information. Using the corresponding model block diagram in BPA, the custom model transformation is realized by assigning the actual parameter values to the model attributes. Finally, the .psc file is automatically generated according to the information storage format of modules, components, etc. in the .psc file. Specifically, the BPA data and the device topology are read from the database, and the BPA data model is parsed to generate an electromagnetic transient simulation file (.psc file).
  • PSASP manages the bus (cdb_bus), generator (cdb_generat), load (cdb_load static load), line (cdb_acline), and double winding transformer through the corresponding data table in the mySQL database.
  • cdb_trans_2w generator
  • cdb_trans_3w three-winding transformer
  • DC line cdb_dcline
  • the disclosed technical contents may be implemented in other manners.
  • the device embodiments described above are only schematic.
  • the division of the unit may be a logical function division.
  • there may be another division manner for example, multiple units or components may be combined or may be Integrate into another system, or some features can be ignored or not executed.
  • the mutual coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection through some interface, unit or module, and may be electrical or otherwise.
  • the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of the embodiment.
  • each functional unit in each embodiment of the present invention may be integrated into one processing unit, or Each unit is physically physically present, or two or more units may be integrated into one unit.
  • the above integrated unit can be implemented in the form of hardware or in the form of a software functional unit.
  • the integrated unit if implemented in the form of a software functional unit and sold or used as a standalone product, may be stored in a computer readable storage medium.
  • the technical solution of the present invention which is essential or contributes to the prior art, or all or part of the technical solution, may be embodied in the form of a software product stored in a storage medium.
  • a number of instructions are included to cause a computer device (which may be a personal computer, server or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present invention.
  • the foregoing storage medium includes: a U disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk, and the like. .

Abstract

A data conversion method and apparatus. The data conversion method comprises: acquiring reference data in a reference data source (S802); reading a reference data format of the reference data (S804); acquiring to-be-converted data in a to-be-converted data source (S806), a to-be-converted data format of the to-be-converted data and the reference data format being different formats; and converting the to-be-converted data into target data according to the reference data format (S808), a target data format of the target data being the same as the reference data format. The method solves the technical problem in the related art that cross-data source analysis cannot be performed on data of different data sources.

Description

数据转化方法和装置Data conversion method and device 技术领域Technical field
本发明涉及数据处理领域,具体而言,涉及一种数据转化方法和装置。The present invention relates to the field of data processing, and in particular to a data conversion method and apparatus.
背景技术Background technique
目前,电力系统在进行数据分析时,需要对大量不同数据源的数据进行分析。不同数据源的数据往往具有不同的数据格式。在相关技术中,在对不同的数据格式的数据源数据进行分析时,往往采用独立分析的技术方案。At present, the power system needs to analyze the data of a large number of different data sources when performing data analysis. Data from different data sources often have different data formats. In the related art, when analyzing data source data of different data formats, a technical solution of independent analysis is often adopted.
独立数据分析方案在分析数据时,不能将多种数据源进行融合,分析效率比较低,且不利于多种数据的综合仿真测试。When analyzing data, independent data analysis schemes cannot combine multiple data sources, and the analysis efficiency is relatively low, which is not conducive to comprehensive simulation test of multiple data.
例如,电力系统分析程序BPA主要为计算而设计,仅仅保留了计算所必须的标么值信息,而缺乏相应的设备信息和原始参数,为了弥补这一不足,系统所专门开发了PSDB设备库管理软件。其中,PSDB采用FOXPRO数据库,相应增加了设备铭牌值,可以生成PSD-BPA潮流和稳定数据,PSD-BPA采用固定格式的文本文件,潮流(.DAT)和稳定(.SWI)两个文件包含了机电暂态所用到的全部数据。然而,PSDB软件功能单一,人机界面设计简单。For example, the power system analysis program BPA is mainly designed for calculation. It only retains the standard value information necessary for calculation, but lacks corresponding equipment information and original parameters. In order to make up for this deficiency, the system specially developed PSDB equipment library management. software. Among them, PSDB uses FOXPRO database, correspondingly increased device nameplate value, can generate PSD-BPA trend and stable data, PSD-BPA uses fixed format text file, trend (.DAT) and stable (.SWI) two files contain All data used in electromechanical transients. However, the PSDB software has a single function and a simple human-machine interface design.
又例如,生产管理系统PMIS完全基于自主研发的电力业务软件平台进行系统构建,具有系统标准化、输变配一体化的特点,但是,基于PMIS的数据不能直接进行其他格式的数据分析,即不同数据源的数据不能跨数据源分析。For example, the production management system PMIS is completely based on the self-developed power business software platform for system construction, which has the characteristics of system standardization, transmission and distribution integration, but the data based on PMIS cannot directly analyze data in other formats, ie different data. Source data cannot be analyzed across data sources.
针对相关技术中不同数据源的数据不能跨数据源分析的问题,目前尚未提出有效的解决方案。For the problem that data of different data sources in related technologies cannot be analyzed across data sources, no effective solution has been proposed yet.
发明内容Summary of the invention
本发明实施例提供了一种数据转化方法和装置,以至少解决相关技术中不同数据源的数据不能跨数据源分析的技术问题。Embodiments of the present invention provide a data conversion method and apparatus, to at least solve the technical problem that data of different data sources in the related art cannot be analyzed across data sources.
为了实现上述目的,根据本发明的一个方面,提供了一种数据转化方法。该方法包括:获取参考数据源中的参考数据;读取参考数据的参考数据格式;获取待转化数据源中的待转化数据,其中,待转化数据的待转化数据格式与参考数据格式为不同格式;以及根据参考数据格式将待转化数据转化成目标数据,其中,目标数据的目标数 据格式与参考数据格式相同。In order to achieve the above object, according to an aspect of the present invention, a data conversion method is provided. The method includes: obtaining reference data in a reference data source; reading a reference data format of the reference data; and acquiring data to be converted in the data source to be converted, where the data format of the data to be converted and the reference data format are different formats. And converting the data to be converted into target data according to a reference data format, wherein the target number of target data The format is the same as the reference data format.
进一步地,在根据参考数据格式将待转化数据转化成目标数据之后,数据转化方法还包括:根据目标数据生成数据库;以及将目标数据存储在数据库中。Further, after converting the data to be converted into target data according to the reference data format, the data conversion method further includes: generating a database according to the target data; and storing the target data in the database.
进一步地,在将目标数据存储在数据库中之后,数据转化方法还包括:从数据库中读取目标数据;以及根据目标数据生成仿真文件,仿真文件为对目标数据进行仿真处理的文件。Further, after the target data is stored in the database, the data conversion method further includes: reading the target data from the database; and generating a simulation file according to the target data, where the simulation file is a file for performing simulation processing on the target data.
进一步地,在从数据库中读取目标数据之后,数据转化方法还包括:根据目标数据生成图形文件;向软件前端输出图形文件;以及在软件前端的图形界面上显示图形文件。Further, after reading the target data from the database, the data conversion method further comprises: generating a graphic file according to the target data; outputting the graphic file to the software front end; and displaying the graphic file on the graphic interface of the software front end.
进一步地,根据参考数据格式将待转化数据转化成目标数据包括:将待转化数据和参考数据进行对比;判断待转化数据和参考数据是否存在差异;如果判断出待转化数据和参考数据不存在差异,则将待转化数据转化为目标数据;以及如果判断出待转化数据和参考数据存在差异,则进行告警。Further, converting the data to be converted into the target data according to the reference data format includes: comparing the data to be converted with the reference data; determining whether there is a difference between the data to be converted and the reference data; if it is determined that there is no difference between the data to be converted and the reference data , the data to be converted is converted into target data; and if it is determined that there is a difference between the data to be converted and the reference data, an alarm is generated.
为了实现上述目的,根据本发明的另一方面,提供了一种数据转化装置。该装置包括:第一获取单元,用于获取参考数据源中的参考数据;第一读取单元,用于读取参考数据的参考数据格式;第二获取单元,用于获取待转化数据源中的待转化数据,其中,待转化数据的待转化数据格式与参考数据格式为不同格式;以及转化单元,用于根据参考数据格式将待转化数据转化成目标数据,其中,目标数据的目标数据格式与参考数据格式相同。In order to achieve the above object, according to another aspect of the present invention, a data conversion apparatus is provided. The device includes: a first acquiring unit, configured to acquire reference data in a reference data source; a first reading unit, configured to read a reference data format of the reference data; and a second acquiring unit, configured to obtain the data source to be converted Data to be converted, wherein the data format of the data to be converted and the reference data format are different formats; and a conversion unit for converting the data to be converted into target data according to the reference data format, wherein the target data format of the target data Same as the reference data format.
进一步地,该数据转化装置还包括:第一生成单元,用于在根据参考数据格式将待转化数据转化成目标数据之后,根据目标数据生成数据库;以及存储单元,用于将目标数据存储在数据库中。Further, the data conversion apparatus further includes: a first generating unit, configured to generate a database according to the target data after converting the data to be converted into the target data according to the reference data format; and a storage unit configured to store the target data in the database in.
进一步地,该数据转化装置还包括:第二读取单元,用于在将目标数据存储在数据库中之后,从数据库中读取目标数据;以及第二生成单元,用于根据目标数据生成仿真文件,仿真文件为对目标数据进行仿真处理的文件。Further, the data conversion device further includes: a second reading unit, configured to read the target data from the database after storing the target data in the database; and a second generating unit, configured to generate the simulation file according to the target data The simulation file is a file that simulates the target data.
进一步地,该数据转化装置还包括:第三生成单元,用于在从数据库中读取目标数据之后,根据目标数据生成图形文件;输出单元,用于向软件前端输出图形文件;以及显示单元,用于在软件前端的图形界面上显示图形文件。Further, the data conversion device further includes: a third generating unit, configured to: after reading the target data from the database, generate a graphic file according to the target data; an output unit, configured to output the graphic file to the software front end; and a display unit, Used to display graphic files on the graphical interface of the software front end.
进一步地,转化单元包括:对比模块,用于将待转化数据和参考数据进行对比;判断模块,用于判断待转化数据和参考数据是否存在差异;转化模块,用于在判断出待转化数据和参考数据不存在差异时,将待转化数据转化为目标数据;以及告警模块,用于在判断出待转化数据和参考数据存在差异,进行告警。 Further, the converting unit includes: a comparing module, configured to compare the data to be converted with the reference data; and a determining module, configured to determine whether there is a difference between the data to be converted and the reference data; and a conversion module, configured to determine the data to be converted and When there is no difference in the reference data, the data to be converted is converted into the target data; and the alarm module is configured to perform an alarm when it is determined that there is a difference between the data to be converted and the reference data.
在本发明实施例中,通过获取参考数据源中的参考数据;读取所述参考数据的参考数据格式;获取待转化数据源中的待转化数据,其中,所述待转化数据的待转化数据格式与所述参考数据格式为不同格式;以及根据所述参考数据格式将所述待转化数据转化成目标数据,其中,所述目标数据的目标数据格式与所述参考数据格式相同,从而实现了达到了便于数据分析的效果的技术效果,进而解决了相关技术中不同数据源的数据不能跨数据源分析的技术问题。In the embodiment of the present invention, the reference data in the reference data source is obtained, the reference data format of the reference data is read, and the data to be converted in the data source to be converted is obtained, where the data to be converted is to be converted. Formatting the reference data format into a different format; and converting the data to be converted into target data according to the reference data format, wherein a target data format of the target data is the same as the reference data format, thereby implementing The technical effect of facilitating the effect of data analysis is achieved, thereby solving the technical problem that data of different data sources in the related art cannot be analyzed across data sources.
附图说明DRAWINGS
此处所说明的附图用来提供对本发明的进一步理解,构成本申请的一部分,本发明的示意性实施例及其说明用于解释本发明,并不构成对本发明的不当限定。在附图中:The drawings described herein are intended to provide a further understanding of the invention, and are intended to be a part of the invention. In the drawing:
图1是根据本发明实施例的数据转化装置的示意图;1 is a schematic diagram of a data conversion apparatus according to an embodiment of the present invention;
图2是根据本发明实施例的用于数据转化的软件架构的示意图;2 is a schematic diagram of a software architecture for data conversion in accordance with an embodiment of the present invention;
图3是根据本发明实施例的BPA接口进行数据处理的示意图;3 is a schematic diagram of data processing performed by a BPA interface according to an embodiment of the present invention;
图4是根据本发明实施例的PSDB接口进行数据处理的示意图;4 is a schematic diagram of data processing performed by a PSDB interface according to an embodiment of the present invention;
图5是根据本发明实施例的PMIS接口进行数据处理的示意图;FIG. 5 is a schematic diagram of data processing performed by a PMIS interface according to an embodiment of the present invention; FIG.
图6是根据本发明实施例的模型转换的示意图;6 is a schematic diagram of model conversion in accordance with an embodiment of the present invention;
图7是根据本发明实施例的PSASP接口进行数据处理的示意图;以及7 is a schematic diagram of data processing performed by a PSASP interface according to an embodiment of the present invention;
图8是根据本发明实施例的数据转化方法的流程图。8 is a flow chart of a data conversion method in accordance with an embodiment of the present invention.
具体实施方式detailed description
为了使本技术领域的人员更好地理解本发明方案,下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本发明一部分的实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例,都应当属于本发明保护的范围。The technical solutions in the embodiments of the present invention are clearly and completely described in the following with reference to the accompanying drawings in the embodiments of the present invention. It is an embodiment of the invention, but not all of the embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative efforts shall fall within the scope of the present invention.
需要说明的是,本发明的说明书和权利要求书及上述附图中的术语“第一”、“第二”等是用于区别类似的对象,而不必用于描述特定的顺序或先后次序。应该理解这样使用的数据在适当情况下可以互换,以便这里描述的本发明的实施例能够以除了在这里图示或描述的那些以外的顺序实施。此外,术语“包括”和“具有”以及他们的任何变形,意图在于覆盖不排他的包含,例如,包含了一系列步骤或单元的过程、方 法、系统、产品或设备不必限于清楚地列出的那些步骤或单元,而是可包括没有清楚地列出的或对于这些过程、方法、产品或设备固有的其它步骤或单元。It is to be understood that the terms "first", "second" and the like in the specification and claims of the present invention are used to distinguish similar objects, and are not necessarily used to describe a particular order or order. It is to be understood that the data so used may be interchanged where appropriate, so that the embodiments of the invention described herein can be implemented in a sequence other than those illustrated or described herein. In addition, the terms "comprising" and "having" and any variants thereof are intended to cover a non-exclusive inclusion, for example, a process that includes a series of steps or units. The method, system, product, or device is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not explicitly listed or are inherent to such processes, methods, products, or devices.
根据本发明的实施例,提供了一种数据转化装置,该数据转化装置用于将不同的数据源数据转化为格式相同的数据。According to an embodiment of the present invention, there is provided a data conversion apparatus for converting different data source data into data of the same format.
图1是根据本发明实施例的数据转化装置的示意图。1 is a schematic diagram of a data conversion device in accordance with an embodiment of the present invention.
如图1所示,该装置包括:第一获取单元10、第一读取单元20、第二获取单元30和转化单元40。As shown in FIG. 1, the apparatus includes: a first acquisition unit 10, a first reading unit 20, a second acquisition unit 30, and a conversion unit 40.
第一获取单元10用于获取参考数据源中的参考数据。第一读取单元20用于读取参考数据的参考数据格式。第二获取单元30用于获取待转化数据源中的待转化数据,其中,待转化数据的待转化数据格式与参考数据格式为不同格式。转化单元40用于根据参考数据格式将待转化数据转化成目标数据,其中,目标数据的目标数据格式与参考数据格式相同。The first obtaining unit 10 is configured to acquire reference data in the reference data source. The first reading unit 20 is configured to read a reference data format of the reference data. The second obtaining unit 30 is configured to obtain data to be converted in the data source to be converted, where the data format of the data to be converted and the reference data format are in different formats. The converting unit 40 is configured to convert the data to be converted into target data according to a reference data format, wherein the target data format of the target data is the same as the reference data format.
在本发明实施中,通过获取参考数据源中的参考数据;读取参考数据的参考数据格式;获取待转化数据源中的待转化数据;根据参考数据格式将待转化数据转化成目标数据,达到了便于数据分析的效果。In the implementation of the present invention, the reference data in the reference data source is obtained; the reference data format of the reference data is read; the data to be converted in the data source to be converted is obtained; and the data to be converted is converted into the target data according to the reference data format. It is convenient for data analysis.
需要说明的是,参考数据源为预先设定的数据源,例如BPA数据源可以作为参考数据源,其中,BPA数据源的格式包括潮流(.DAT)和稳定(.SWI)两种文件格式。待转化数据源可以包括PSDB数据源、PSD-BPA数据源和PMIS数据源等。不同的数据源可以通过各自的数据源接口将自身数据源内的数据传输至数据平台中进行相应的数据转化。例如,PSDB数据源、PSD-BPA数据源和PMIS数据源可以分别通过PSDB数据源接口、PSD-BPA数据源接口和PMIS数据源接口将相应的数据传输至前述数据平台中。It should be noted that the reference data source is a preset data source, for example, the BPA data source can be used as a reference data source, wherein the BPA data source format includes a power flow (.DAT) and a stable (.SWI) file format. The data source to be converted may include a PSDB data source, a PSD-BPA data source, and a PMIS data source. Different data sources can transfer data in their own data sources to the data platform through their respective data source interfaces for corresponding data conversion. For example, the PSDB data source, the PSD-BPA data source, and the PMIS data source can transmit corresponding data to the foregoing data platform through the PSDB data source interface, the PSD-BPA data source interface, and the PMIS data source interface, respectively.
需要说明的是,前述数据平台为集图、模、库一体的仿真平台,它能够实现PSDB、PSD-BPA及PMIS的数据融合,通过逐条对比辨识出存在差异的数据,将无差异的数据保存到数据库中。在此基础上实现BPA、PSASP及PACAD/EMTDC的不同运行方式和规划数据仿真计算文件的自动生成。It should be noted that the foregoing data platform is a simulation platform integrating graphics, modules and libraries. It can realize data fusion of PSDB, PSD-BPA and PMIS, and identify data with differences by one by one, and save data without difference. Go to the database. On this basis, different operation modes of BPA, PSASP and PACAD/EMTDC and automatic generation of planning data simulation calculation files are realized.
图2是根据本发明实施例的用于数据转化的软件架构的示意图,如图2所示,该数据平台包括数据源接口:PSDB数据源接口、PSD-BPA数据源接口和PMIS数据源接口,这些数据源接口用于输入与数据源相对的格式的数据,具体地,PSDB采用foxpro数据库,PMIS可导出Excel文件,BPA采用dat和swi格式的数据文件;该数据平台还包括数据管理模块,与前述的数据源接口相连接,用于对PSDB、BPA和PMIS数据进行比对、提取、并在数据库中进行数据查询、数据编辑、电网增量数据统计和追加、数据检查和校核、设备统计分析以及典型参数库维护等;该数据平台还包括数据库,与前述的数据管理模块相连接,用于存储转化之后的数据。该数据平台还包括图形界面, 与前述的数据库相连接,图形界面采用C#语言开发得到,用户可以通该图形界面,利用数据库中存储的数据实现电网图形绘制、电网数据查询和编辑功能,同时电网拓扑和计算结果也能直观的显示在图形界面中;另外,该数据平台还包括PSD-BPA接口、PSASP接口、PSACD\EMTDC接口,这些接口可以前述转化得到的数据进行相反方向的转化,分别得到并输出BPA数据、PSASP数据和PSACD\EMTDC数据,具体地,PSD-BPA接口和PSASP接口可实现不同运行方式下的PSD-BPA、PSASP潮流计算和机电暂态仿真文件的自动生成。PSACD\EMTDC接口可以根据数据库中的图形数据和电网参数自动形成指定分析对象的电磁暂态仿真文件。2 is a schematic diagram of a software architecture for data conversion according to an embodiment of the present invention. As shown in FIG. 2, the data platform includes a data source interface: a PSDB data source interface, a PSD-BPA data source interface, and a PMIS data source interface. These data source interfaces are used to input data in a format opposite to the data source. Specifically, the PSDB uses the foxpro database, the PMIS can export the Excel file, and the BPA uses the data files in the dat and swi formats; the data platform also includes a data management module, and The foregoing data source interfaces are connected for comparing, extracting, and performing data query, data editing, grid incremental data statistics and addition, data check and check, and device statistics on the PSDB, BPA, and PMIS data. Analysis and typical parameter library maintenance, etc.; the data platform also includes a database, connected to the aforementioned data management module, for storing data after conversion. The data platform also includes a graphical interface. Connected with the aforementioned database, the graphical interface is developed in C# language. Users can use the graphical interface to use the data stored in the database to realize grid graphics rendering, grid data query and editing functions. At the same time, the grid topology and calculation results can be intuitive. Displayed in the graphical interface; in addition, the data platform also includes a PSD-BPA interface, a PSASP interface, and a PSACD\EMTDC interface. These interfaces can convert the data obtained by the foregoing transformation in opposite directions, respectively, and obtain and output BPA data, PSASP data, and PSACD\EMTDC data, specifically, PSD-BPA interface and PSASP interface can realize PSD-BPA, PSASP power flow calculation and automatic generation of electromechanical transient simulation files under different operation modes. The PSACD\EMTDC interface can automatically form an electromagnetic transient simulation file of the specified analysis object according to the graphic data and the grid parameters in the database.
需要说明的是,BPA、PSDB和PMIS用于输出静态数据,BPA还用于输出稳态数据。It should be noted that BPA, PSDB and PMIS are used to output static data, and BPA is also used to output steady state data.
优选地,在本发明实施例中,该数据转化装置还可以包括:第一生成单元和存储单元。Preferably, in the embodiment of the present invention, the data conversion device may further include: a first generating unit and a storage unit.
第一生成单元用于在根据参考数据格式将待转化数据转化成目标数据之后,根据目标数据生成数据库。存储单元用于将目标数据存储在数据库中。The first generating unit is configured to generate a database according to the target data after converting the data to be converted into the target data according to the reference data format. The storage unit is used to store the target data in a database.
优选地,在本发明实施例中,该数据转化装置还可以包括:第二读取单元和第二生成单元。Preferably, in the embodiment of the present invention, the data conversion device may further include: a second reading unit and a second generating unit.
第二读取单元用于在将目标数据存储在数据库中之后,从数据库中读取目标数据。第二生成单元用于根据目标数据生成仿真文件,仿真文件为对目标数据进行仿真处理的文件。The second reading unit is configured to read the target data from the database after storing the target data in the database. The second generating unit is configured to generate a simulation file according to the target data, where the simulation file is a file for performing simulation processing on the target data.
优选地,在本发明实施例中,该数据转化装置还可以包括:第三生成单元、输出单元和显示单元Preferably, in the embodiment of the present invention, the data conversion device may further include: a third generation unit, an output unit, and a display unit
第三生成单元用于在从数据库中读取目标数据之后,根据目标数据生成图形文件;输出单元用于向软件前端输出图形文件;以及显示单元用于在软件前端的图形界面上显示图形文件。The third generating unit is configured to generate a graphic file according to the target data after reading the target data from the database; the output unit is configured to output the graphic file to the software front end; and the display unit is configured to display the graphic file on the graphic interface of the software front end.
优选地,在本发明实施例中,转化单元40包括:对比模块、判断模块、转化模块和告警模块。对比模块用于将待转化数据和参考数据进行对比;判断模块用于判断待转化数据和参考数据是否存在差异;转化模块用于在判断出待转化数据和参考数据不存在差异时,将待转化数据转化为目标数据;以及告警模块用于在判断出待转化数据和参考数据存在差异,进行告警。Preferably, in the embodiment of the present invention, the converting unit 40 includes: a comparison module, a determination module, a conversion module, and an alarm module. The comparison module is configured to compare the data to be converted with the reference data; the determining module is configured to determine whether there is a difference between the data to be converted and the reference data; and the conversion module is configured to be converted when it is determined that there is no difference between the data to be converted and the reference data. The data is converted into target data; and the alarm module is configured to perform an alarm when it is determined that there is a difference between the data to be converted and the reference data.
需要说明的是,图3是根据本发明实施例的BPA接口进行数据处理的示意图,如图3所示,BPA为双向接口,即BPA数据可以写入数据平台,数据平台的数据也可以生成BPA文件,也即,BPA数据源的数据可以转化为目标数据,也可以用于将目标数据转化为BPA数据源的数据。BPA为格式文本,因此,须按照BPA的格式对其数据进行解析,将解析的数据与PSDB数据进行对比后存入数据平台。因涉及多源数据,因此 必须对数据进行逐条记录比对才能实现数据融合。在图3中,BPA文件(DAT、SWI)可以通过平台数据库进行数据融合,也可根据平台数据库进行仿真文件生成。图中的平台数据库中数据还可以包括转化PSDB数据和PMIS数据得到的数据。It should be noted that FIG. 3 is a schematic diagram of data processing performed by the BPA interface according to an embodiment of the present invention. As shown in FIG. 3, the BPA is a bidirectional interface, that is, BPA data can be written into the data platform, and data of the data platform can also generate BPA. The file, that is, the data of the BPA data source can be converted into target data, and can also be used to convert the target data into data of the BPA data source. BPA is formatted text. Therefore, the data must be parsed according to the BPA format, and the parsed data is compared with the PSDB data and stored in the data platform. Because it involves multiple sources of data, Data must be categorized one by one to achieve data fusion. In Figure 3, BPA files (DAT, SWI) can be used for data fusion through the platform database, or simulation files can be generated according to the platform database. The data in the platform database in the figure may also include data obtained by converting PSDB data and PMIS data.
以BPA数据为参考数据,PSDB数据为待转化数据为例,在对BPA与PSDB数据进行比对过程中执行以下步骤:对相同记录数据,将PSDB数据的有名值转换成标幺值,将转化得到的标幺值与BPA的标幺值进行对比,当两者的差值小于5%时,将BPA标幺数据存入数据平台,并记录日志;当两者的差值大于5%时,执行告警处理,并记录日志;对不同记录互补的数据,追加后存入数据库。Taking BPA data as reference data and PSDB data as data to be converted as an example, in the process of comparing BPA and PSDB data, the following steps are performed: for the same recorded data, the named value of the PSDB data is converted into a standard value, which will be converted. The obtained standard value is compared with the standard value of BPA. When the difference between the two is less than 5%, the BPA standard data is stored in the data platform, and the log is recorded; when the difference between the two is greater than 5%, Perform alarm processing and record logs; add data to different records and add them to the database.
需要说明的是,根据预设需求条件,在生成BPA文件时,按照预设作业进行存储和生成BPA文件;按照预设区域生成BPA文件;按照预设投运时间生成BPA文件。在对转化后的数据进行分析时,负荷数据可按照负荷增长率生成。It should be noted that, according to the preset requirement condition, when the BPA file is generated, the BPA file is stored and generated according to the preset job; the BPA file is generated according to the preset area; and the BPA file is generated according to the preset commissioning time. When analyzing the transformed data, the load data can be generated according to the load growth rate.
图4是根据本发明实施例的PSDB接口进行数据处理的示意图,如图4所示,PSDB为基于FoxPro的数据文件,采用多个表格存储的方式,多个表格包括线路参数表、变压器参数表、发电机参数表、电容器参数表以及电抗器参数表,用于保存电力系统分析计算所需的有名值参数。数据库的PSDB导入为单向接口,即PSDB的数据只可写入数据平台。在PSDB写入数据库的过程中,在查询映射表的基础上,将各元件的参数逐条与进行比BPA的标幺值参数进行对比,并将各符合要求的参数写入到数据平台的数据库。具体地,可以从数据库中读取BPA数据和设备拓扑信息以及PSDB数据,并将这两种数据进行参数对比融合,生成平台数据库中的数据。4 is a schematic diagram of data processing performed by a PSDB interface according to an embodiment of the present invention. As shown in FIG. 4, the PSDB is a data file based on FoxPro, and uses multiple table storage methods, and multiple tables include a line parameter table and a transformer parameter table. The generator parameter table, the capacitor parameter table and the reactor parameter table are used to save the named value parameters required for power system analysis and calculation. The PSDB of the database is imported as a one-way interface, that is, the data of the PSDB can only be written to the data platform. In the process of writing the PSDB into the database, on the basis of the query mapping table, the parameters of each component are compared one by one with the standard value parameter of the BPA, and each parameter that meets the requirements is written into the database of the data platform. Specifically, the BPA data and the device topology information and the PSDB data can be read from the database, and the two data are compared and fused to generate data in the platform database.
图5是根据本发明实施例的PMIS接口进行数据处理的示意图,如图5所示,PMIS可导出EXCEL文件,数据库中存储了线路和变压器设备的生产信息,如导线型号,电压等级、最大允许电流、长度等。通过这些信息可以对PSDB数据和BPA数据进行验证和追加。PMIS数据库中保存了运行单位、资产单位、电压等级、维护班组、线路编号、线路名称、电流性质、架设方式、线路全长、电缆长度、杆塔基数、导线型号等应信息。具体地,可以从数据库中读取BPA数据和设备拓扑信息以及PMIS数据,并将这两种数据进行参数对比融合,生成平台数据库中的数据。5 is a schematic diagram of data processing performed by a PMIS interface according to an embodiment of the present invention. As shown in FIG. 5, the PMIS can export an EXCEL file, and the database stores the production information of the line and the transformer device, such as the wire type, the voltage level, and the maximum allowable. Current, length, etc. This information allows verification and addition of PSDB data and BPA data. The PMIS database stores information such as operating unit, asset unit, voltage level, maintenance team, line number, line name, current nature, erection mode, line length, cable length, tower base number, and wire type. Specifically, the BPA data and the device topology information and the PMIS data can be read from the database, and the two data are compared and fused to generate data in the platform database.
图6是根据本发明实施例的模型转换的示意图,如图6所示,利用BPA模型数据可以自动构建EMTDC模型,基本过程如下:先从数据库读取的已存储好的包括拓扑信息的BPA模型数据记录,然后将不同类型设备的BPA数据解析成EMTDC中对应的元件参数信息,根据元件参数和网络拓扑信息生成EMTDC中对应的各元件模型。利用BPA中对应的模型框图,通过将实际参数值赋给模型属性实现自定义模型转换。最后,根据.psc文件中的模块、元件等的信息存储格式自动生成.psc文件。具体地,从数据库中读取BPA数据和设备拓扑等信息,并解析BPA数据模型,生成电磁暂态仿真文件(.psc文件)。 6 is a schematic diagram of model conversion according to an embodiment of the present invention. As shown in FIG. 6, an EMTDC model can be automatically constructed by using BPA model data. The basic process is as follows: a stored BPA model including topology information is first read from a database. Data recording, then parsing the BPA data of different types of devices into corresponding component parameter information in the EMTDC, and generating corresponding component models in the EMTDC according to the component parameters and the network topology information. Using the corresponding model block diagram in BPA, the custom model transformation is realized by assigning the actual parameter values to the model attributes. Finally, the .psc file is automatically generated according to the information storage format of modules, components, etc. in the .psc file. Specifically, the BPA data and the device topology are read from the database, and the BPA data model is parsed to generate an electromagnetic transient simulation file (.psc file).
图7是根据本发明实施例的PSASP接口进行数据处理的示意图,如图7所示,以潮流数据为例,PSASP通过mySQL数据库中相应的数据表管理母线(cdb_bus)、发电机(cdb_generat)、负荷(cdb_load含静特性负荷)、线路(cdb_acline)、双绕组变压器(cdb_trans_2w)和三绕组变压器(cdb_trans_3w)以及直流线路(cdb_dcline)等数据。7 is a schematic diagram of data processing performed by a PSASP interface according to an embodiment of the present invention. As shown in FIG. 7, taking the power flow data as an example, PSASP manages a bus (cdb_bus), a generator (cdb_generat), and a corresponding data table in the mySQL database. Data such as load (cdb_load with static characteristic load), line (cdb_acline), dual winding transformer (cdb_trans_2w), and three-winding transformer (cdb_trans_3w) and DC line (cdb_dcline).
通过从数据库中读取平台数据库,将相应的数据进行转换处理,然后将相应的数据插入到mySQL数据库,得到PSASPmySQL数据库,从而可形成用于PSASP仿真分析的实例。By reading the platform database from the database, converting the corresponding data, and then inserting the corresponding data into the mySQL database to obtain the PSASPmySQL database, which can form an instance for PSASP simulation analysis.
根据本发明的实施例,还提供了一种数据转化方法,该数据转化方法用于将不同的数据源数据转化为格式相同的数据。该数据转化方法可以运行在计算机处理设备上。需要说明的是,本发明实施例所提供的数据转化方法可以通过本发明实施例的数据转化装置来执行,本发明实施例的数据转化装置也可以用于执行本发明实施例的数据转化方法。According to an embodiment of the present invention, there is also provided a data conversion method for converting different data source data into data of the same format. The data conversion method can be run on a computer processing device. It should be noted that the data conversion method provided by the embodiment of the present invention may be performed by the data conversion apparatus of the embodiment of the present invention. The data conversion apparatus of the embodiment of the present invention may also be used to perform the data conversion method of the embodiment of the present invention.
图8是根据本发明实施例的数据转化方法的流程图。如图8所示,该方法包括如下的步骤S802至步骤S808:8 is a flow chart of a data conversion method in accordance with an embodiment of the present invention. As shown in FIG. 8, the method includes the following steps S802 to S808:
步骤S802,获取参考数据源中的参考数据。Step S802, acquiring reference data in the reference data source.
步骤S804,读取参考数据的参考数据格式。Step S804, reading a reference data format of the reference data.
步骤S806,获取待转化数据源中的待转化数据,其中,待转化数据的待转化数据格式与参考数据格式为不同格式。Step S806, the data to be converted in the data source to be converted is obtained, where the data format of the data to be converted and the reference data format are in different formats.
步骤S808,根据参考数据格式将待转化数据转化成目标数据,其中,目标数据的目标数据格式与参考数据格式相同。Step S808: Convert the data to be converted into target data according to a reference data format, wherein the target data format of the target data is the same as the reference data format.
在本发明实施中,通过获取参考数据源中的参考数据;读取参考数据的参考数据格式;获取待转化数据源中的待转化数据;根据参考数据格式将待转化数据转化成目标数据,达到了便于数据分析的效果。In the implementation of the present invention, the reference data in the reference data source is obtained; the reference data format of the reference data is read; the data to be converted in the data source to be converted is obtained; and the data to be converted is converted into the target data according to the reference data format. It is convenient for data analysis.
需要说明的是,参考数据源为预先设定的数据源,例如BPA数据源可以作为参考数据源,其中,BPA数据源的格式包括潮流(.DAT)和稳定(.SWI)两种文件格式。待转化数据源可以包括PSDB数据源、PSD-BPA数据源和PMIS数据源等。不同的数据源可以通过各自的数据源接口将自身数据源内的数据传输至数据平台中进行相应的数据转化。例如,PSDB数据源、PSD-BPA数据源和PMIS数据源可以分别通过PSDB数据源接口、PSD-BPA数据源接口和PMIS数据源接口将相应的数据传输至前述数据平台中。It should be noted that the reference data source is a preset data source, for example, the BPA data source can be used as a reference data source, wherein the BPA data source format includes a power flow (.DAT) and a stable (.SWI) file format. The data source to be converted may include a PSDB data source, a PSD-BPA data source, and a PMIS data source. Different data sources can transfer data in their own data sources to the data platform through their respective data source interfaces for corresponding data conversion. For example, the PSDB data source, the PSD-BPA data source, and the PMIS data source can transmit corresponding data to the foregoing data platform through the PSDB data source interface, the PSD-BPA data source interface, and the PMIS data source interface, respectively.
需要说明的是,前述数据平台为集图、模、库一体的仿真平台,它能够实现PSDB、PSD-BPA及PMIS的数据融合,通过逐条对比辨识出存在差异的数据,将无差异的数据 保存到数据库中。在此基础上实现BPA、PSASP及PACAD/EMTDC的不同运行方式和规划数据仿真计算文件的自动生成。It should be noted that the foregoing data platform is a simulation platform integrating graphics, modules and libraries, which can realize data fusion of PSDB, PSD-BPA and PMIS, and identify data with differences by one by one, and will have no difference data. Save to the database. On this basis, different operation modes of BPA, PSASP and PACAD/EMTDC and automatic generation of planning data simulation calculation files are realized.
该数据平台的结构如图2所示,其中,该数据平台包括数据源接口:PSDB数据源接口、PSD-BPA数据源接口和PMIS数据源接口,这些数据源接口用于输入与数据源相对的格式的数据,具体地,PSDB采用foxpro数据库,PMIS可导出Excel文件,BPA采用dat和swi格式的数据文件;该数据平台还包括数据管理模块,与前述的数据源接口相连接,用于对PSDB、BPA和PMIS数据进行比对、提取、并在数据库中进行数据查询、数据编辑、电网增量数据统计和追加、数据检查和校核、设备统计分析以及典型参数库维护等;该数据平台还包括数据库,与前述的数据管理模块相连接,用于存储转化之后的数据。该数据平台还包括图形界面,与前述的数据库相连接,图形界面采用C#语言开发得到,用户可以通该图形界面,利用数据库中存储的数据实现电网图形绘制、电网数据查询和编辑功能,同时电网拓扑和计算结果也能直观的显示在图形界面中;另外,该数据平台还包括PSD-BPA接口、PSASP接口、PSACD\EMTDC接口,这些接口可以前述转化得到的数据进行相反方向的转化,分别得到并输出BPA数据、PSASP数据和PSACD\EMTDC数据,具体地,PSD-BPA接口和PSASP接口可实现不同运行方式下的PSD-BPA、PSASP潮流计算和机电暂态仿真文件的自动生成。PSACD\EMTDC接口可以根据数据库中的图形数据和电网参数自动形成指定分析对象的电磁暂态仿真文件。The structure of the data platform is as shown in FIG. 2, wherein the data platform includes a data source interface: a PSDB data source interface, a PSD-BPA data source interface, and a PMIS data source interface, and the data source interfaces are used to input the data source. Format data, specifically, PSDB uses foxpro database, PMIS can export Excel file, BPA uses dat and swi format data files; the data platform also includes data management module, which is connected with the aforementioned data source interface for PSDB , BPA and PMIS data are compared, extracted, and data query, data editing, grid incremental data statistics and additions, data inspection and verification, equipment statistical analysis, and typical parameter library maintenance are performed in the database; The database is included and connected to the foregoing data management module for storing the converted data. The data platform also includes a graphical interface, which is connected with the aforementioned database, and the graphical interface is developed by using the C# language. The user can use the graphical interface to utilize the data stored in the database to realize grid graphic drawing, grid data query and editing functions, and the grid. The topology and calculation results can also be displayed visually in the graphical interface. In addition, the data platform also includes a PSD-BPA interface, a PSASP interface, and a PSACD\EMTDC interface. These interfaces can be converted in the opposite direction by the data obtained by the foregoing transformation, respectively. The BPA data, the PSASP data and the PSACD\EMTDC data are outputted. Specifically, the PSD-BPA interface and the PSASP interface can automatically generate PSD-BPA, PSASP power flow calculation and electromechanical transient simulation files in different operation modes. The PSACD\EMTDC interface can automatically form an electromagnetic transient simulation file of the specified analysis object according to the graphic data and the grid parameters in the database.
需要说明的是,BPA、PSDB和PMIS用于输出静态数据,BPA还用于输出稳态数据。It should be noted that BPA, PSDB and PMIS are used to output static data, and BPA is also used to output steady state data.
优选地,在本发明实施例中,在根据参考数据格式将待转化数据转化成目标数据之后,该数据转化方法还可以包括:Preferably, in the embodiment of the present invention, after the data to be converted is converted into the target data according to the reference data format, the data conversion method may further include:
S2,根据目标数据生成数据库;以及S2, generating a database according to the target data;
S4,将目标数据存储在数据库中。S4, the target data is stored in the database.
优选地,在本发明实施例中,在将目标数据存储在数据库中之后,该数据转化方法还可以包括:Preferably, in the embodiment of the present invention, after the target data is stored in the database, the data conversion method may further include:
S6,从数据库中读取目标数据。S6, reading the target data from the database.
S8,根据目标数据生成仿真文件,仿真文件为对目标数据进行仿真处理的文件。S8: Generate a simulation file according to the target data, where the simulation file is a file for performing simulation processing on the target data.
优选地,在本发明实施例中,在从数据库中读取目标数据之后,该数据转化方法还可以包括:Preferably, in the embodiment of the present invention, after the target data is read from the database, the data conversion method may further include:
S10,根据目标数据生成图形文件。S10. Generate a graphic file according to the target data.
S12,向软件前端输出图形文件。 S12, outputting a graphic file to the software front end.
S14,在软件前端的图形界面上显示图形文件。S14, displaying a graphic file on a graphical interface of the software front end.
优选地,在本发明实施例中,根据参考数据格式将待转化数据转化成目标数据可以包括:Preferably, in the embodiment of the present invention, converting the data to be converted into target data according to the reference data format may include:
S16,将待转化数据和参考数据进行对比。S16, comparing the data to be converted with the reference data.
S18,判断待转化数据和参考数据是否存在差异。S18. Determine whether there is a difference between the data to be converted and the reference data.
S20,如果判断出待转化数据和参考数据不存在差异,则将待转化数据转化为目标数据。S20. If it is determined that there is no difference between the data to be converted and the reference data, the data to be converted is converted into the target data.
S22,如果判断出待转化数据和参考数据存在差异,则进行告警。S22. If it is determined that there is a difference between the data to be converted and the reference data, an alarm is performed.
需要说明的是,如图3所示,BPA为双向接口,即BPA数据可以写入数据平台,数据平台的数据也可以生成BPA文件,也即,BPA数据源的数据可以转化为目标数据,也可以用于目标数据转化为,BPA数据源的数据。BPA为格式文本,因此,须按照BPA的格式对其数据进行解析,将解析的数据与PSDB数据进行对比后存入数据平台。因涉及多源数据,因此必须对数据进行逐条记录比对才能实现数据融合。在图3中,BPA文件(DAT、SWI)可以通过平台数据库进行数据融合,也可根据平台数据库进行仿真文件生成。图中的平台数据库中数据还可以包括转化PSDB数据和PMIS数据得到的数据。It should be noted that, as shown in FIG. 3, the BPA is a bidirectional interface, that is, the BPA data can be written into the data platform, and the data of the data platform can also generate a BPA file, that is, the data of the BPA data source can be converted into the target data, and also Can be used to convert target data into data from BPA data sources. BPA is formatted text. Therefore, the data must be parsed according to the BPA format, and the parsed data is compared with the PSDB data and stored in the data platform. Because of the multi-source data involved, it is necessary to record the data one by one to achieve data fusion. In Figure 3, BPA files (DAT, SWI) can be used for data fusion through the platform database, or simulation files can be generated according to the platform database. The data in the platform database in the figure may also include data obtained by converting PSDB data and PMIS data.
以BPA数据为参考数据,PSDB数据为待转化数据为例,在对BPA与PSDB数据进行比对过程中执行以下步骤:对相同记录数据,将PSDB数据的有名值转换成标幺值,将转化得到的标幺值与BPA的标幺值进行对比,当两者的差值小于5%时,将BPA标幺数据存入数据平台,并记录日志;当两者的差值大于5%时,执行告警处理,并记录日志;对不同记录互补的数据,追加后存入数据库。Taking BPA data as reference data and PSDB data as data to be converted as an example, in the process of comparing BPA and PSDB data, the following steps are performed: for the same recorded data, the named value of the PSDB data is converted into a standard value, which will be converted. The obtained standard value is compared with the standard value of BPA. When the difference between the two is less than 5%, the BPA standard data is stored in the data platform, and the log is recorded; when the difference between the two is greater than 5%, Perform alarm processing and record logs; add data to different records and add them to the database.
需要说明的是,根据预设需求条件,在生成BPA文件时,按照预设作业进行存储和生成BPA文件;按照预设区域生成BPA文件;按照预设投运时间生成BPA文件。在对转化后的数据进行分析时,负荷数据可按照负荷增长率生成。It should be noted that, according to the preset requirement condition, when the BPA file is generated, the BPA file is stored and generated according to the preset job; the BPA file is generated according to the preset area; and the BPA file is generated according to the preset commissioning time. When analyzing the transformed data, the load data can be generated according to the load growth rate.
如图4所示,PSDB为基于FoxPro的数据文件,采用多个表格存储的方式,多个表格包括线路参数表、变压器参数表、发电机参数表、电容器参数表以及电抗器参数表,用于保存电力系统分析计算所需的有名值参数。数据库的PSDB导入为单向接口,即PSDB的数据只可写入数据平台。在PSDB写入数据库的过程中,在查询映射表的基础上,将各元件的参数逐条与进行比BPA的标幺值参数进行对比,并将各符合要求的参数写入到数据平台的数据库。具体地,可以从数据库中读取BPA数据和设备拓扑信息以及PSDB数据,并将这两种数据进行参数对比融合,生成平台数据库中的数据。As shown in FIG. 4, the PSDB is a FoxPro-based data file, which uses multiple table storage methods. The multiple tables include a line parameter table, a transformer parameter table, a generator parameter table, a capacitor parameter table, and a reactor parameter table for Save the named value parameters required for power system analysis calculations. The PSDB of the database is imported as a one-way interface, that is, the data of the PSDB can only be written to the data platform. In the process of writing the PSDB into the database, on the basis of the query mapping table, the parameters of each component are compared one by one with the standard value parameter of the BPA, and each parameter that meets the requirements is written into the database of the data platform. Specifically, the BPA data and the device topology information and the PSDB data can be read from the database, and the two data are compared and fused to generate data in the platform database.
如图5所示,PMIS可导出EXCEL文件,数据库中存储了线路和变压器设备的生产 信息,如导线型号,电压等级、最大允许电流、长度等。通过这些信息可以对PSDB数据和BPA数据进行验证和追加。PMIS数据库中保存了运行单位、资产单位、电压等级、维护班组、线路编号、线路名称、电流性质、架设方式、线路全长、电缆长度、杆塔基数、导线型号等应信息。具体地,可以从数据库中读取BPA数据和设备拓扑信息以及PMIS数据,并将这两种数据进行参数对比融合,生成平台数据库中的数据。As shown in Figure 5, PMIS can export EXCEL files, which store the production of lines and transformers. Information such as wire type, voltage rating, maximum allowable current, length, etc. This information allows verification and addition of PSDB data and BPA data. The PMIS database stores information such as operating unit, asset unit, voltage level, maintenance team, line number, line name, current nature, erection mode, line length, cable length, tower base number, and wire type. Specifically, the BPA data and the device topology information and the PMIS data can be read from the database, and the two data are compared and fused to generate data in the platform database.
如图6所示,利用BPA模型数据可以自动构建EMTDC模型,基本过程如下:先从数据库读取的已存储好的包括拓扑信息的BPA模型数据记录,然后将不同类型设备的BPA数据解析成EMTDC中对应的元件参数信息,根据元件参数和网络拓扑信息生成EMTDC中对应的各元件模型。利用BPA中对应的模型框图,通过将实际参数值赋给模型属性实现自定义模型转换。最后,根据.psc文件中的模块、元件等的信息存储格式自动生成.psc文件。具体地,从数据库中读取BPA数据和设备拓扑等信息,并解析BPA数据模型,生成电磁暂态仿真文件(.psc文件)。As shown in Fig. 6, the EMTDC model can be automatically constructed by using the BPA model data. The basic process is as follows: the stored BPA model data record including the topology information is read from the database, and then the BPA data of different types of devices is parsed into EMTDC. The corresponding component parameter information is generated, and corresponding component models in the EMTDC are generated according to the component parameters and the network topology information. Using the corresponding model block diagram in BPA, the custom model transformation is realized by assigning the actual parameter values to the model attributes. Finally, the .psc file is automatically generated according to the information storage format of modules, components, etc. in the .psc file. Specifically, the BPA data and the device topology are read from the database, and the BPA data model is parsed to generate an electromagnetic transient simulation file (.psc file).
如图7所示,以潮流数据为例,PSASP通过mySQL数据库中相应的数据表管理母线(cdb_bus)、发电机(cdb_generat)、负荷(cdb_load含静特性负荷)、线路(cdb_acline)、双绕组变压器(cdb_trans_2w)和三绕组变压器(cdb_trans_3w)以及直流线路(cdb_dcline)等数据。As shown in Figure 7, taking the power flow data as an example, PSASP manages the bus (cdb_bus), generator (cdb_generat), load (cdb_load static load), line (cdb_acline), and double winding transformer through the corresponding data table in the mySQL database. (cdb_trans_2w) and three-winding transformer (cdb_trans_3w) and DC line (cdb_dcline) and other data.
通过从数据库中读取平台数据库,将相应的数据进行转换处理,然后将相应的数据插入到mySQL数据库,得到PSASPmySQL数据库,从而可形成用于PSASP仿真分析的实例。By reading the platform database from the database, converting the corresponding data, and then inserting the corresponding data into the mySQL database to obtain the PSASPmySQL database, which can form an instance for PSASP simulation analysis.
上述本发明实施例序号仅仅为了描述,不代表实施例的优劣。The serial numbers of the embodiments of the present invention are merely for the description, and do not represent the advantages and disadvantages of the embodiments.
在本发明的上述实施例中,对各个实施例的描述都各有侧重,某个实施例中没有详述的部分,可以参见其他实施例的相关描述。In the above-mentioned embodiments of the present invention, the descriptions of the various embodiments are different, and the parts that are not detailed in a certain embodiment can be referred to the related descriptions of other embodiments.
在本申请所提供的几个实施例中,应该理解到,所揭露的技术内容,可通过其它的方式实现。其中,以上所描述的装置实施例仅仅是示意性的,例如所述单元的划分,可以为一种逻辑功能划分,实际实现时可以有另外的划分方式,例如多个单元或组件可以结合或者可以集成到另一个系统,或一些特征可以忽略,或不执行。另一点,所显示或讨论的相互之间的耦合或直接耦合或通信连接可以是通过一些接口,单元或模块的间接耦合或通信连接,可以是电性或其它的形式。In the several embodiments provided by the present application, it should be understood that the disclosed technical contents may be implemented in other manners. The device embodiments described above are only schematic. For example, the division of the unit may be a logical function division. In actual implementation, there may be another division manner, for example, multiple units or components may be combined or may be Integrate into another system, or some features can be ignored or not executed. In addition, the mutual coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection through some interface, unit or module, and may be electrical or otherwise.
所述作为分离部件说明的单元可以是或者也可以不是物理上分开的,作为单元显示的部件可以是或者也可以不是物理单元,即可以位于一个地方,或者也可以分布到多个单元上。可以根据实际的需要选择其中的部分或者全部单元来实现本实施例方案的目的。The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of the embodiment.
另外,在本发明各个实施例中的各功能单元可以集成在一个处理单元中,也可以 是各个单元单独物理存在,也可以两个或两个以上单元集成在一个单元中。上述集成的单元既可以采用硬件的形式实现,也可以采用软件功能单元的形式实现。In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or Each unit is physically physically present, or two or more units may be integrated into one unit. The above integrated unit can be implemented in the form of hardware or in the form of a software functional unit.
所述集成的单元如果以软件功能单元的形式实现并作为独立的产品销售或使用时,可以存储在一个计算机可读取存储介质中。基于这样的理解,本发明的技术方案本质上或者说对现有技术做出贡献的部分或者该技术方案的全部或部分可以以软件产品的形式体现出来,该计算机软件产品存储在一个存储介质中,包括若干指令用以使得一台计算机设备(可为个人计算机、服务器或者网络设备等)执行本发明各个实施例所述方法的全部或部分步骤。而前述的存储介质包括:U盘、只读存储器(ROM,Read-Only Memory)、随机存取存储器(RAM,Random Access Memory)、移动硬盘、磁碟或者光盘等各种可以存储程序代码的介质。The integrated unit, if implemented in the form of a software functional unit and sold or used as a standalone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention, which is essential or contributes to the prior art, or all or part of the technical solution, may be embodied in the form of a software product stored in a storage medium. A number of instructions are included to cause a computer device (which may be a personal computer, server or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: a U disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk, and the like. .
以上所述仅是本发明的优选实施方式,应当指出,对于本技术领域的普通技术人员来说,在不脱离本发明原理的前提下,还可以做出若干改进和润饰,这些改进和润饰也应视为本发明的保护范围。 The above description is only a preferred embodiment of the present invention, and it should be noted that those skilled in the art can also make several improvements and retouchings without departing from the principles of the present invention. It should be considered as the scope of protection of the present invention.

Claims (10)

  1. 一种数据转化方法,其特征在于,包括:A data conversion method, comprising:
    获取参考数据源中的参考数据;Obtain reference data in the reference data source;
    读取所述参考数据的参考数据格式;Reading a reference data format of the reference data;
    获取待转化数据源中的待转化数据,其中,所述待转化数据的待转化数据格式与所述参考数据格式为不同格式;以及Obtaining data to be converted in the data source to be converted, wherein the data format of the data to be converted and the reference data format are different formats;
    根据所述参考数据格式将所述待转化数据转化成目标数据,其中,所述目标数据的目标数据格式与所述参考数据格式相同。Converting the data to be converted into target data according to the reference data format, wherein a target data format of the target data is the same as the reference data format.
  2. 根据权利要求1所述的数据转化方法,其特征在于,在根据所述参考数据格式将所述待转化数据转化成目标数据之后,所述数据转化方法还包括:The data conversion method according to claim 1, wherein after the data to be converted is converted into target data according to the reference data format, the data conversion method further comprises:
    根据所述目标数据生成数据库;以及Generating a database based on the target data;
    将所述目标数据存储在所述数据库中。The target data is stored in the database.
  3. 根据权利要求2所述的数据转化方法,其特征在于,在将所述目标数据存储在所述数据库中之后,所述数据转化方法还包括:The data conversion method according to claim 2, wherein after the storing the target data in the database, the data conversion method further comprises:
    从所述数据库中读取所述目标数据;以及Reading the target data from the database;
    根据所述目标数据生成仿真文件,所述仿真文件为对所述目标数据进行仿真处理的文件。Generating a simulation file according to the target data, where the simulation file is a file for performing simulation processing on the target data.
  4. 根据权利要求3所述的数据转化方法,其特征在于,在从所述数据库中读取所述目标数据之后,所述数据转化方法还包括:The data conversion method according to claim 3, wherein after the reading the target data from the database, the data conversion method further comprises:
    根据所述目标数据生成图形文件;Generating a graphic file according to the target data;
    向软件前端输出所述图形文件;以及Outputting the graphic file to a software front end;
    在所述软件前端的图形界面上显示所述图形文件。The graphic file is displayed on a graphical interface of the software front end.
  5. 根据权利要求1所述的数据转化方法,其特征在于,根据所述参考数据格式将所述待转化数据转化成目标数据包括:The data conversion method according to claim 1, wherein converting the data to be converted into target data according to the reference data format comprises:
    将所述待转化数据和所述参考数据进行对比;Comparing the data to be converted with the reference data;
    判断所述待转化数据和所述参考数据是否存在差异;Determining whether there is a difference between the data to be converted and the reference data;
    如果判断出所述待转化数据和所述参考数据不存在差异,则将所述待转化数 据转化为所述目标数据;以及If it is determined that there is no difference between the data to be converted and the reference data, the number of to-be-converted Converted to the target data;
    如果判断出所述待转化数据和所述参考数据存在差异,则进行告警。If it is determined that there is a difference between the data to be converted and the reference data, an alarm is performed.
  6. 一种数据转化装置,其特征在于,包括:A data conversion device, comprising:
    第一获取单元,用于获取参考数据源中的参考数据;a first acquiring unit, configured to acquire reference data in a reference data source;
    第一读取单元,用于读取所述参考数据的参考数据格式;a first reading unit, configured to read a reference data format of the reference data;
    第二获取单元,用于获取待转化数据源中的待转化数据,其中,所述待转化数据的待转化数据格式与所述参考数据格式为不同格式;以及a second acquiring unit, configured to acquire data to be converted in the data source to be converted, where the data format of the data to be converted and the reference data format are different formats;
    转化单元,用于根据所述参考数据格式将所述待转化数据转化成目标数据,其中,所述目标数据的目标数据格式与所述参考数据格式相同。a converting unit, configured to convert the data to be converted into target data according to the reference data format, wherein a target data format of the target data is the same as the reference data format.
  7. 根据权利要求6所述的数据转化装置,其特征在于,还包括:The data conversion device according to claim 6, further comprising:
    第一生成单元,用于在根据所述参考数据格式将所述待转化数据转化成目标数据之后,根据所述目标数据生成数据库;以及a first generating unit, configured to generate a database according to the target data after converting the data to be converted into target data according to the reference data format;
    存储单元,用于将所述目标数据存储在所述数据库中。a storage unit, configured to store the target data in the database.
  8. 根据权利要求7所述的数据转化装置,其特征在于,还包括:The data conversion device according to claim 7, further comprising:
    第二读取单元,用于在将所述目标数据存储在所述数据库中之后,从所述数据库中读取所述目标数据;以及a second reading unit, configured to read the target data from the database after storing the target data in the database;
    第二生成单元,用于根据所述目标数据生成仿真文件,所述仿真文件为对所述目标数据进行仿真处理的文件。And a second generating unit, configured to generate a simulation file according to the target data, where the simulation file is a file that performs simulation processing on the target data.
  9. 根据权利要求8所述的数据转化装置,其特征在于,还包括:The data conversion device according to claim 8, further comprising:
    第三生成单元,用于在从所述数据库中读取所述目标数据之后,根据所述目标数据生成图形文件;a third generating unit, configured to generate a graphic file according to the target data after reading the target data from the database;
    输出单元,用于向软件前端输出所述图形文件;以及An output unit for outputting the graphic file to a software front end;
    显示单元,用于在所述软件前端的图形界面上显示所述图形文件。And a display unit, configured to display the graphic file on a graphical interface of the software front end.
  10. 根据权利要求6所述的数据转化装置,其特征在于,所述转化单元包括:The data conversion device according to claim 6, wherein the conversion unit comprises:
    对比模块,用于将所述待转化数据和所述参考数据进行对比;a comparison module, configured to compare the data to be converted with the reference data;
    判断模块,用于判断所述待转化数据和所述参考数据是否存在差异;a determining module, configured to determine whether there is a difference between the data to be converted and the reference data;
    转化模块,用于在判断出所述待转化数据和所述参考数据不存在差异时,将所述待转化数据转化为所述目标数据;以及 a conversion module, configured to convert the data to be converted into the target data when it is determined that there is no difference between the data to be converted and the reference data;
    告警模块,用于在判断出所述待转化数据和所述参考数据存在差异,进行告警。 The alarm module is configured to perform an alarm when it is determined that there is a difference between the data to be converted and the reference data.
PCT/CN2015/086046 2014-08-08 2015-08-04 Data conversion method and apparatus WO2016019855A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201410390128.3A CN105335428A (en) 2014-08-08 2014-08-08 Data conversion method and apparatus
CN201410390128.3 2014-08-08

Publications (1)

Publication Number Publication Date
WO2016019855A1 true WO2016019855A1 (en) 2016-02-11

Family

ID=55263153

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2015/086046 WO2016019855A1 (en) 2014-08-08 2015-08-04 Data conversion method and apparatus

Country Status (2)

Country Link
CN (1) CN105335428A (en)
WO (1) WO2016019855A1 (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106570260B (en) * 2016-11-03 2019-12-20 北京航天时代光电科技有限公司 Automatic generation method of electrical connection relation
CN107133355A (en) * 2017-05-25 2017-09-05 国网天津市电力公司 Route parameter calculation and data management-control method in the range of regional dispatching
CN107328995A (en) * 2017-07-18 2017-11-07 国网天津市电力公司 A kind of high-voltage dc transmission electrical impedance scanning method
CN108846251A (en) * 2018-09-13 2018-11-20 浙江大学 A kind of Electrical-Machanical Transient Simulation of Power System system and method for self-adapting data format

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101222515A (en) * 2007-01-12 2008-07-16 英华达(南京)科技有限公司 Data transition method and data transmission system between different communication networks
CN101556570A (en) * 2009-05-27 2009-10-14 深圳市科陆电子科技股份有限公司 Data transfer method for serial identifying equipment
CN102413075A (en) * 2011-12-18 2012-04-11 上海量明科技发展有限公司 Method and system for changing format during data transmission
US20130094056A1 (en) * 2011-10-13 2013-04-18 Hiroto Kobayashi Information processing apparatus, system
CN104135581A (en) * 2014-08-15 2014-11-05 国家电网公司 Communication method and device

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101504662B (en) * 2009-03-13 2012-07-11 北大方正集团有限公司 Data conversion method and apparatus
CN101996271B (en) * 2010-08-12 2013-08-14 武汉大学 Software interface for automatically generating simulation calculation model of PSCAD power system
CN102457475A (en) * 2010-10-15 2012-05-16 中国人民解放军国防科学技术大学 Integration and conversion system for network security data
CN102855303A (en) * 2012-08-20 2013-01-02 慈溪市供电局 Method and device for data transmission between SCADA (supervisory control and data acquisition) system and database platform
CN103150600B (en) * 2013-03-27 2018-01-02 平阳电力有限责任公司 A kind of power grid security analysis system
CN103559171A (en) * 2013-11-04 2014-02-05 北京锐安科技有限公司 Data format conversion method and device for use in network application

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101222515A (en) * 2007-01-12 2008-07-16 英华达(南京)科技有限公司 Data transition method and data transmission system between different communication networks
CN101556570A (en) * 2009-05-27 2009-10-14 深圳市科陆电子科技股份有限公司 Data transfer method for serial identifying equipment
US20130094056A1 (en) * 2011-10-13 2013-04-18 Hiroto Kobayashi Information processing apparatus, system
CN102413075A (en) * 2011-12-18 2012-04-11 上海量明科技发展有限公司 Method and system for changing format during data transmission
CN104135581A (en) * 2014-08-15 2014-11-05 国家电网公司 Communication method and device

Also Published As

Publication number Publication date
CN105335428A (en) 2016-02-17

Similar Documents

Publication Publication Date Title
WO2016019855A1 (en) Data conversion method and apparatus
CN101354423A (en) System and method for model building of impact load based on actual measurement
McMorran et al. Addressing the challenge of data interoperability for off-line analysis of distribution networks in the Smart Grid
CN108228726A (en) The increment unusual fluctuation content acquisition method and storage medium of power distribution network red and black figure
JP2009213238A (en) Power information integrated management system
CN115425760A (en) Digital power grid system based on digital twinning
CN111597166B (en) Power database model construction method, device, computer equipment and storage medium
CN112783966A (en) SQL visual design generation method and system based on business metadata
CN103577930A (en) System for evaluating influence of power construction project on reliability of power distribution network
CN112200465A (en) Electric power AI method and system based on multimedia information intelligent analysis
CN116244348A (en) Method, device, equipment and storage medium for processing vehicle diagnosis demand data
CN108205086A (en) Monitoring method, device and system for power grid equipment
CN113626995B (en) Substation logic model handover method based on digital design
Zhang et al. Economic dispatch considering volatile wind power generation with lower-semi-deviation risk measure
CN115574867A (en) Mutual inductor fault detection method and device, electronic equipment and storage medium
CN104765616B (en) A kind of method and system for automatically generating I/O model
CN112200458B (en) Power distribution network planning data application method and system
CN112559455B (en) IFC data management system and method based on semantic network technology
CN108153929A (en) A kind of grid graph and model expansion method
CN114238335A (en) Buried point data generation method and related equipment thereof
CN110908962A (en) SCD model rapid data processing method for intelligent substation
Sarker et al. Cp-sam: Cyber-power security assessment and resiliency analysis tool for distribution system
Guddanti et al. Better data structures for co-simulation of distribution system with gridlab-d and python
CN104933106A (en) Database device for IFC informatization model
CN103995925A (en) Software system of analog simulation busbar protection devices

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 15830124

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 15830124

Country of ref document: EP

Kind code of ref document: A1