CN105335428A - Data conversion method and apparatus - Google Patents
Data conversion method and apparatus Download PDFInfo
- Publication number
- CN105335428A CN105335428A CN201410390128.3A CN201410390128A CN105335428A CN 105335428 A CN105335428 A CN 105335428A CN 201410390128 A CN201410390128 A CN 201410390128A CN 105335428 A CN105335428 A CN 105335428A
- Authority
- CN
- China
- Prior art keywords
- data
- transformed
- transformations
- database
- target data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data conversion method and apparatus. The data conversion method comprises: obtaining reference data in a reference data source; reading a reference data format of the reference data; obtaining to-be-converted data in a to-be-converted data source, wherein a to-be-converted data format of the to-be-converted data is different from the reference data format; and converting the to-be-converted data 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. Through the data conversion method and apparatus, the problem that data of different data sources cannot be subjected to cross-data source analysis in related technologies is solved.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of data transformations method and apparatus.
Background technology
At present, electric system, when carrying out data analysis, needs the data analysis to a large amount of different pieces of information source.The data in different pieces of information source often have different data layouts.In the related, when analyzing the data source data of different data layouts, often adopt the technical scheme of independent analysis.
Independent data analytical plan is when analyzing data, and multiple data sources can not be merged, analysis efficiency is lower, and is unfavorable for the comprehensive simulating test of several data.
Such as, Power System Analysis program BPA is mainly and calculates and design, and only remains and calculates necessary per unit value information, and lack corresponding facility information and initial parameter, makes up that this is not enough, and system develops PSDB device pool management software specially.Wherein, PSDB adopts FOXPRO database, correspondingly add equipment nameplate value, PSD-BPA trend and stable data can be generated, PSD-BPA adopts the text of set form, and trend (.DAT) and stable (.SWI) two files contain the total data used by electromechanical transient.But PSDB software function is single, and Human Machine Interface is simple.
Again such as, production management system PMIS carries out system constructing based on the power business software platform of independent research completely, there is system standardization, defeated change join integration feature, but, data based on PMIS directly can not carry out the data analysis of extended formatting, that is, the data in different pieces of information source can not across analysis of data source.
Data for different pieces of information source in correlation technique across the problem of analysis of data source, can not yet propose effective solution at present.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of data transformations method and apparatus, can not across the problem of analysis of data source with the data solving different pieces of information source in correlation technique.
To achieve these goals, according to an aspect of the present invention, a kind of data transformations method is provided.The method comprises: obtain the reference data in source of reference data; Read the reference data form of described reference data; Obtain the data to be transformed in data source to be transformed, wherein, data layout to be transformed and the described reference data form of described data to be transformed are different-format; And according to described reference data form, described data transformations to be transformed is become target data, wherein, the target data form of described target data is identical with described reference data form.
Further, after according to described reference data form described data transformations to be transformed being become target data, described data transformations method also comprises: generate database according to described target data; And described target data is stored in the database.
Further, after storing in the database by described target data, described data transformations method also comprises: from described database, read described target data; And generating simulation document according to described target data, described simulation document is the file described target data being carried out to simulation process.
Further, after read described target data from described database, described data transformations method also comprises: generate graphic file according to described target data; Described graphic file is exported to software front end; And described graphic file is shown on the graphical interfaces of described software front end.
Further, target data is become to comprise described data transformations to be transformed according to described reference data form: described data to be transformed and described reference data to be contrasted; Judge whether described data to be transformed and described reference data there are differences; If judge that described data to be transformed and described reference data not there are differences, be then described target data by described data transformations to be transformed; And if judge that described data to be transformed and described reference data there are differences, then carry out alarm.
To achieve these goals, according to a further aspect in the invention, a kind of data transformations device is provided.This device comprises: the first acquiring unit, for obtaining the reference data in source of reference data; First reading unit, for reading the reference data form of described reference data; Second acquisition unit, for obtaining the data to be transformed in data source to be transformed, wherein, data layout to be transformed and the described reference data form of described data to be transformed are different-format; And conversion unit, for described data transformations to be transformed being become target data according to described reference data form, wherein, the target data form of described target data is identical with described reference data form.
Further, this data transformations device also comprises: the first generation unit, for after according to described reference data form described data transformations to be transformed being become target data, generates database according to described target data; And storage unit, for described target data is stored in the database.
Further, this data transformations device also comprises: the second reading unit, for after storing in the database by described target data, from described database, reads described target data; And second generation unit, for generating simulation document according to described target data, described simulation document is the file described target data being carried out to simulation process.
Further, this data transformations device also comprises: the 3rd generation unit, for after read described target data from described database, generates graphic file according to described target data; Output unit, for exporting described graphic file to software front end; And display unit, on the graphical interfaces in described software front end, show described graphic file.
Further, described conversion unit comprises: contrast module, for described data to be transformed and described reference data being contrasted; Judge module, for judging whether described data to be transformed and described reference data there are differences; Described data transformations to be transformed, for when judging that described data to be transformed and described reference data not there are differences, is described target data by conversion module; And alarm module, for judging that described data to be transformed and described reference data there are differences, carry out alarm.
By the present invention, adopt, the data solving different pieces of information source in correlation technique across the problem of analysis of data source, and then can not reach the effect being convenient to data analysis.
Accompanying drawing explanation
The accompanying drawing forming a application's part is used to provide a further understanding of the present invention, and schematic description and description of the present invention, for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the schematic diagram of the data transformations device according to the embodiment of the present invention;
Fig. 2 is the schematic diagram of the software architecture for data transformations according to the embodiment of the present invention;
Fig. 3 is the process flow diagram carrying out data processing according to the BPA interface of the embodiment of the present invention;
Fig. 4 is the process flow diagram carrying out data processing according to the PSDB interface of the embodiment of the present invention;
Fig. 5 is the process flow diagram carrying out data processing according to the PMIS interface of the embodiment of the present invention;
Fig. 6 is the process flow diagram of the model conversion according to the embodiment of the present invention;
Fig. 7 is the process flow diagram carrying out data processing according to the PSASP interface of the embodiment of the present invention; And
Fig. 8 is the process flow diagram of the data transformations method according to the embodiment of the present invention.
Embodiment
It should be noted that, when not conflicting, the embodiment in the application and the feature in embodiment can combine mutually.Below with reference to the accompanying drawings and describe the present invention in detail in conjunction with the embodiments.
Better the present invention program is understood in order to make those skilled in the art, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the embodiment of a part of the present invention, instead of whole embodiments.Based on the embodiment in the present invention, the every other embodiment obtained under those of ordinary skill in the art do not make creative work prerequisite, all should belong to protection scope of the present invention.
It should be noted that, term " first ", " second " etc. in instructions of the present invention and claims and above-mentioned accompanying drawing are for distinguishing similar object, and need not be used for describing specific order or precedence.Should be appreciated that the data used like this can be exchanged in the appropriate case, so as embodiments of the invention described herein can with except here diagram or describe those except order implement.In addition, term " comprises " and " having " and their any distortion, and intention is to cover not exclusive comprising.
According to embodiments of the invention, provide a kind of data transformations device, this data transformations device is used for different data source data to be converted into the identical data of form.
Fig. 1 is the schematic diagram of the data transformations device according to the embodiment of the present invention.
As shown in Figure 1, this device comprises: the first acquiring unit 10, first reading unit 20, second acquisition unit 30 and conversion unit 40.
First acquiring unit 10 is for obtaining the reference data in source of reference data.First reading unit 20 is for reading the reference data form of reference data.Second acquisition unit 30 is for obtaining the data to be transformed in data source to be transformed, and wherein, the data layout to be transformed of data to be transformed and reference data form are different-format.Conversion unit 40 is for becoming target data according to reference data form by data transformations to be transformed, and wherein, the target data form of target data is identical with reference data form.
In the invention process, by obtaining the reference data in source of reference data; Read the reference data form of reference data; Obtain the data to be transformed in data source to be transformed; According to reference data form, data transformations to be transformed is become target data, reach the effect being convenient to data analysis.
It should be noted that, source of reference data is the data source preset, and such as BPA data source can as reference data source, and wherein, the form of BPA data source comprises trend (.DAT) and stable (.SWI) two kinds of file layouts.Data source to be transformed can comprise PSDB data source, PSD-BPA data source and PMIS data source etc.Data in its data source can be transferred in data platform by respective data resource interface by different data sources carries out corresponding data transformations.Such as, corresponding data can transfer in aforementioned data platform respectively by PSDB data resource interface, PSD-BPA data resource interface and PMIS data resource interface by PSDB data source, PSD-BPA data source and PMIS data source.
It should be noted that, aforementioned data platform is the emulation platform of collection figure, mould, storehouse one, and it can realize the data fusion of PSDB, PSD-BPA and PMIS, picking out the data that there are differences, the data of indifference being saved in database by contrasting one by one.Realize the different running method of BPA, PSASP and PACAD/EMTDC and the automatic generation of layout data simulation calculation file on this basis.
The structure of this data platform as shown in Figure 2, wherein, this data platform comprises data resource interface: PSDB data resource interface, PSD-BPA data resource interface and PMIS data resource interface, these data resource interfaces are for inputting the data of the form relative with data source, particularly, PSDB adopts foxpro database, and PMIS can derive Excel file, and BPA adopts the data file of dat and swi form; This data platform also comprises data management module, be connected with aforesaid data resource interface, for PSDB, BPA and PMIS data are compared, extract and carry out data query, data edition, power grid increment data statistics in a database and add, data check and check, device statistics analysis and the maintenance of canonical parameter storehouse etc.; This data platform also comprises database, is connected with aforesaid data management module, for the data after storing conversion.This data platform also comprises graphical interfaces, be connected with aforesaid database, graphical interfaces adopts C# language exploitation to obtain, user can lead to this graphical interfaces, grid graph is drawn, electric network data is inquired about and editting function to utilize the data stored in database to realize, and power network topology and result of calculation also can be presented in graphical interfaces intuitively simultaneously; In addition, this data platform also comprise PSD-BPA interface, PSASP interface, PSACD EMTDC interface, these interfaces the data that obtain of aforementioned conversion can carry out rightabout conversion, obtain respectively and export BPA data, PSASP data and PSACD EMTDC data, particularly, PSD-BPA interface and PSASP interface can realize the automatic generation of PSD-BPA, PSASP Load flow calculation under different running method and electromechanical transient simulation file.PSACD EMTDC interface automatically can form the electromagnetic transient simulation file of designated analysis object according to the graph data in database and electrical network parameter.
It should be noted that, BPA, PSDB and PMIS are for exporting static data, and BPA is also for exporting steady state data.
Preferably, in embodiments of the present invention, this data transformations device can also comprise: the first generation unit and storage unit.
First generation unit is used for, after according to reference data form data transformations to be transformed being become target data, generating database according to target data.Storage unit is used for target data to store in a database.
Preferably, in embodiments of the present invention, this data transformations device can also comprise: the second reading unit and the second generation unit.
Second reading unit is used for, after storing in a database by target data, from database, reading target data.Second generation unit is used for generating simulation document according to target data, and simulation document is file target data being carried out to simulation process.
Preferably, in embodiments of the present invention, this data transformations device can also comprise: the 3rd generation unit, output unit and display unit
3rd generation unit is used for after read target data from database, generates graphic file according to target data; Output unit is used for software front end output pattern file; And display unit display graphics file on the graphical interfaces in software front end.
Preferably, in embodiments of the present invention, conversion unit 40 comprises: contrast module, judge module, conversion module and alarm module.Contrast module is used for data to be transformed and reference data to contrast; Judge module is for judging whether data to be transformed and reference data there are differences; Conversion module is used for when judging that data to be transformed and reference data not there are differences, and is target data by data transformations to be transformed; And alarm module is used for judging that data to be transformed and reference data there are differences, and carries out alarm.
It should be noted that, as shown in Figure 3, BPA is bidirectional interface, namely BPA data can write data platform, and the data of data platform also can generate BPA file, are also, the data of BPA data source can be converted into target data, also may be used for target data and are converted into, the data of BPA data source.BPA is format text, therefore, must resolve according to the form of BPA to its data, stored in data platform after the data of parsing and PSDB data being contrasted.Because relating to multi-source data, therefore must carry out itemize comparison to data could realize data fusion.In figure 3, BPA file (DAT, SWI) can carry out data fusion by platform database, also can carry out simulation document generation according to platform database.In platform database in figure, data can also comprise the data transforming PSDB data and PMIS data and obtain.
With BPA data for reference data, PSDB data are data instance to be transformed, following steps are performed: to identical recordings data in process that BPA and PSDB data are compared, convert the famous value of PSDB data to perunit value, the perunit value transforming perunit value and the BPA obtained is contrasted, when both differences are less than 5%, by BPA mark one data stored in data platform, and log; When both differences are greater than 5%, perform alarming processing, and log; To the data of difference record complementation, stored in database after adding.
It should be noted that, according to preset need condition, when generating BPA file, carrying out storing and generate BPA file according to default operation; BPA file is generated according to predeterminable area; BPA file is generated according to presetting the time of putting into operation.To transform after data analysis time, load data can generate according to load growth rate.
As shown in Figure 4, PSDB is the data file based on FoxPro, adopt the mode that multiple form stores, multiple form comprises line parameter circuit value table, transformer parameter table, generator parameter table, capacitor parameters table and reactor parameter list, for preserving the famous value parameter needed for Electrical power system analysis and computing.The PSDB of database imports as one-way interfaces, and namely the data of PSDB write data platform only.In the process of PSDB write into Databasce, on the basis of query mappings table, the parameter of each element is contrasted with the perunit value parameter of carrying out than BPA one by one, and by the database of each satisfactory parameter read-in to data platform.Particularly, BPA data and equipment topology information and PSDB data can be read from database, and these two kinds of data are carried out parameter comparison fusion, the data in generating platform database.
As shown in Figure 5, PMIS can derive EXCEL file, stores the production information of circuit and transformer equipment in database, as wire type, and electric pressure, maximum allowed current, length etc.Can by these information PSDB data and BPA data be verified and be added.Save run unit, asset units, electric pressure in PMIS database, safeguard teams and groups, circuit number, line name, galvanic properties, erection mode, total track length, cable length, shaft tower radix, wire type etc. answer information.Particularly, BPA data and equipment topology information and PMIS data can be read from database, and these two kinds of data are carried out parameter comparison fusion, the data in generating platform database.
As shown in Figure 6, BPA model data is utilized can automatically to build EMTDC model, basic process is as follows: first from the BPA model data record comprising topology information stored that database reads, then the BPA Data Analysis of dissimilar equipment is become component parameters information corresponding in EMTDC, generate each component models corresponding in EMTDC according to component parameters and network topological information.Utilizing model framework chart corresponding in BPA, realizing self-definition model conversion by actual parameter value being assigned to model attributes.Finally .psc file is automatically generated according to the format information memory of the module in .psc file, element etc.Particularly, from database, read the information such as BPA data and equipment topology, and resolve BPA data model, generate electromagnetic transient simulation file (.psc file).
As shown in Figure 7, for flow data, PSASP is by management data table bus (cdb_bus) corresponding in mySQL database, generator (cdb_generat), load (cdb_load is containing static characteristic load), circuit (cdb_acline), two-winding transformer (cdb_trans_2w) and the data such as three-winding transformer (cdb_trans_3w) and DC line (cdb_dcline).
By reading platform database from database, corresponding data are carried out conversion process, then corresponding data are inserted into mySQL database, obtain PSASPmySQL database, thus the example for PSASP simulation analysis can be formed.
According to embodiments of the invention, provide a kind of data transformations method, this data transformations method is used for different data source data to be converted into the identical data of form.This data transformations method may operate on computer-processing equipment.It should be noted that, the data transformations method that the embodiment of the present invention provides can be performed by the data transformations device of the embodiment of the present invention, and the data transformations device of the embodiment of the present invention also may be used for the data transformations method performing the embodiment of the present invention.
Fig. 8 is the process flow diagram of the data transformations method according to the embodiment of the present invention.
As shown in Figure 8, the method comprises following step S802 to step S808:
Step S802, obtains the reference data in source of reference data.
Step S804, reads the reference data form of reference data.
Step S806, obtains the data to be transformed in data source to be transformed, and wherein, the data layout to be transformed of data to be transformed and reference data form are different-format.
Step S808, becomes target data according to reference data form by data transformations to be transformed, and wherein, the target data form of target data is identical with reference data form.
In the invention process, by obtaining the reference data in source of reference data; Read the reference data form of reference data; Obtain the data to be transformed in data source to be transformed; According to reference data form, data transformations to be transformed is become target data, reach the effect being convenient to data analysis.
It should be noted that, source of reference data is the data source preset, and such as BPA data source can as reference data source, and wherein, the form of BPA data source comprises trend (.DAT) and stable (.SWI) two kinds of file layouts.Data source to be transformed can comprise PSDB data source, PSD-BPA data source and PMIS data source etc.Data in its data source can be transferred in data platform by respective data resource interface by different data sources carries out corresponding data transformations.Such as, corresponding data can transfer in aforementioned data platform respectively by PSDB data resource interface, PSD-BPA data resource interface and PMIS data resource interface by PSDB data source, PSD-BPA data source and PMIS data source.
It should be noted that, aforementioned data platform is the emulation platform of collection figure, mould, storehouse one, and it can realize the data fusion of PSDB, PSD-BPA and PMIS, picking out the data that there are differences, the data of indifference being saved in database by contrasting one by one.Realize the different running method of BPA, PSASP and PACAD/EMTDC and the automatic generation of layout data simulation calculation file on this basis.
The structure of this data platform as shown in Figure 2, wherein, this data platform comprises data resource interface: PSDB data resource interface, PSD-BPA data resource interface and PMIS data resource interface, these data resource interfaces are for inputting the data of the form relative with data source, particularly, PSDB adopts foxpro database, and PMIS can derive Excel file, and BPA adopts the data file of dat and swi form; This data platform also comprises data management module, be connected with aforesaid data resource interface, for PSDB, BPA and PMIS data are compared, extract and carry out data query, data edition, power grid increment data statistics in a database and add, data check and check, device statistics analysis and the maintenance of canonical parameter storehouse etc.; This data platform also comprises database, is connected with aforesaid data management module, for the data after storing conversion.This data platform also comprises graphical interfaces, be connected with aforesaid database, graphical interfaces adopts C# language exploitation to obtain, user can lead to this graphical interfaces, grid graph is drawn, electric network data is inquired about and editting function to utilize the data stored in database to realize, and power network topology and result of calculation also can be presented in graphical interfaces intuitively simultaneously; In addition, this data platform also comprise PSD-BPA interface, PSASP interface, PSACD EMTDC interface, these interfaces the data that obtain of aforementioned conversion can carry out rightabout conversion, obtain respectively and export BPA data, PSASP data and PSACD EMTDC data, particularly, PSD-BPA interface and PSASP interface can realize the automatic generation of PSD-BPA, PSASP Load flow calculation under different running method and electromechanical transient simulation file.PSACD EMTDC interface automatically can form the electromagnetic transient simulation file of designated analysis object according to the graph data in database and electrical network parameter.
It should be noted that, BPA, PSDB and PMIS are for exporting static data, and BPA is also for exporting steady state data.
Preferably, in embodiments of the present invention, after according to reference data form data transformations to be transformed being become target data, this data transformations method can also comprise:
S2, generates database according to target data; And
S4, stores target data in a database.
Preferably, in embodiments of the present invention, after storing in a database by target data, this data transformations method can also comprise:
S6, reads target data from database.
S8, generate simulation document according to target data, simulation document is file target data being carried out to simulation process.
Preferably, in embodiments of the present invention, after read target data from database, this data transformations method can also comprise:
S10, generates graphic file according to target data.
S12, to software front end output pattern file.
S14, display graphics file on the graphical interfaces of software front end.
Preferably, in embodiments of the present invention, target data is become to comprise data transformations to be transformed according to reference data form:
Data to be transformed and reference data are contrasted by S16.
S18, judges whether data to be transformed and reference data there are differences.
Data transformations to be transformed if judge that data to be transformed and reference data not there are differences, is then target data by S20.
S22, if judge that data to be transformed and reference data there are differences, then carries out alarm.
It should be noted that, as shown in Figure 3, BPA is bidirectional interface, namely BPA data can write data platform, and the data of data platform also can generate BPA file, are also, the data of BPA data source can be converted into target data, also may be used for target data and are converted into, the data of BPA data source.BPA is format text, therefore, must resolve according to the form of BPA to its data, stored in data platform after the data of parsing and PSDB data being contrasted.Because relating to multi-source data, therefore must carry out itemize comparison to data could realize data fusion.In figure 3, BPA file (DAT, SWI) can carry out data fusion by platform database, also can carry out simulation document generation according to platform database.In platform database in figure, data can also comprise the data transforming PSDB data and PMIS data and obtain.
With BPA data for reference data, PSDB data are data instance to be transformed, following steps are performed: to identical recordings data in process that BPA and PSDB data are compared, convert the famous value of PSDB data to perunit value, the perunit value transforming perunit value and the BPA obtained is contrasted, when both differences are less than 5%, by BPA mark one data stored in data platform, and log; When both differences are greater than 5%, perform alarming processing, and log; To the data of difference record complementation, stored in database after adding.
It should be noted that, according to preset need condition, when generating BPA file, carrying out storing and generate BPA file according to default operation; BPA file is generated according to predeterminable area; BPA file is generated according to presetting the time of putting into operation.To transform after data analysis time, load data can generate according to load growth rate.
As shown in Figure 4, PSDB is the data file based on FoxPro, adopt the mode that multiple form stores, multiple form comprises line parameter circuit value table, transformer parameter table, generator parameter table, capacitor parameters table and reactor parameter list, for preserving the famous value parameter needed for Electrical power system analysis and computing.The PSDB of database imports as one-way interfaces, and namely the data of PSDB write data platform only.In the process of PSDB write into Databasce, on the basis of query mappings table, the parameter of each element is contrasted with the perunit value parameter of carrying out than BPA one by one, and by the database of each satisfactory parameter read-in to data platform.Particularly, BPA data and equipment topology information and PSDB data can be read from database, and these two kinds of data are carried out parameter comparison fusion, the data in generating platform database.
As shown in Figure 5, PMIS can derive EXCEL file, stores the production information of circuit and transformer equipment in database, as wire type, and electric pressure, maximum allowed current, length etc.Can by these information PSDB data and BPA data be verified and be added.Save run unit, asset units, electric pressure in PMIS database, safeguard teams and groups, circuit number, line name, galvanic properties, erection mode, total track length, cable length, shaft tower radix, wire type etc. answer information.Particularly, BPA data and equipment topology information and PMIS data can be read from database, and these two kinds of data are carried out parameter comparison fusion, the data in generating platform database.
As shown in Figure 6, BPA model data is utilized can automatically to build EMTDC model, basic process is as follows: first from the BPA model data record comprising topology information stored that database reads, then the BPA Data Analysis of dissimilar equipment is become component parameters information corresponding in EMTDC, generate each component models corresponding in EMTDC according to component parameters and network topological information.Utilizing model framework chart corresponding in BPA, realizing self-definition model conversion by actual parameter value being assigned to model attributes.Finally .psc file is automatically generated according to the format information memory of the module in .psc file, element etc.Particularly, from database, read the information such as BPA data and equipment topology, and resolve BPA data model, generate electromagnetic transient simulation file (.psc file).
As shown in Figure 7, for flow data, PSASP is by management data table bus (cdb_bus) corresponding in mySQL database, generator (cdb_generat), load (cdb_load is containing static characteristic load), circuit (cdb_acline), two-winding transformer (cdb_trans_2w) and the data such as three-winding transformer (cdb_trans_3w) and DC line (cdb_dcline).
By reading platform database from database, corresponding data are carried out conversion process, then corresponding data are inserted into mySQL database, obtain PSASPmySQL database, thus the example for PSASP simulation analysis can be formed.
It should be noted that, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, but in some cases, can be different from the step shown or described by order execution herein.
Obviously, those skilled in the art should be understood that, above-mentioned of the present invention each module or each step can realize with general calculation element, they can concentrate on single calculation element, or be distributed on network that multiple calculation element forms, alternatively, they can realize with the executable program code of calculation element, thus, they can be stored and be performed by calculation element in the storage device, or they are made into each integrated circuit modules respectively, or the multiple module in them or step are made into single integrated circuit module to realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a data transformations method, is characterized in that, comprising:
Obtain the reference data in source of reference data;
Read the reference data form of described reference data;
Obtain the data to be transformed in data source to be transformed, wherein, data layout to be transformed and the described reference data form of described data to be transformed are different-format; And
According to described reference data form, described data transformations to be transformed is become target data, wherein, the target data form of described target data is identical with described reference data form.
2. data transformations method according to claim 1, is characterized in that, after according to described reference data form described data transformations to be transformed being become target data, described data transformations method also comprises:
Database is generated according to described target data; And
Described target data is stored in the database.
3. data transformations method according to claim 2, is characterized in that, after storing in the database by described target data, described data transformations method also comprises:
Described target data is read from described database; And
Generate simulation document according to described target data, described simulation document is the file described target data being carried out to simulation process.
4. data transformations method according to claim 3, is characterized in that, after read described target data from described database, described data transformations method also comprises:
Graphic file is generated according to described target data;
Described graphic file is exported to software front end; And
The graphical interfaces of described software front end shows described graphic file.
5. data transformations method according to claim 1, is characterized in that, becomes target data to comprise described data transformations to be transformed according to described reference data form:
Described data to be transformed and described reference data are contrasted;
Judge whether described data to be transformed and described reference data there are differences;
If judge that described data to be transformed and described reference data not there are differences, be then described target data by described data transformations to be transformed; And
If judge that described data to be transformed and described reference data there are differences, then carry out alarm.
6. a data transformations device, is characterized in that, comprising:
First acquiring unit, for obtaining the reference data in source of reference data;
First reading unit, for reading the reference data form of described reference data;
Second acquisition unit, for obtaining the data to be transformed in data source to be transformed, wherein, data layout to be transformed and the described reference data form of described data to be transformed are different-format; And
Conversion unit, for described data transformations to be transformed being become target data according to described reference data form, wherein, the target data form of described target data is identical with described reference data form.
7. data transformations device according to claim 6, is characterized in that, also comprise:
First generation unit, for after according to described reference data form described data transformations to be transformed being become target data, generates database according to described target data; And
Storage unit, for storing described target data in the database.
8. data transformations device according to claim 7, is characterized in that, also comprise:
Second reading unit, for after storing in the database by described target data, reads described target data from described database; And
Second generation unit, for generating simulation document according to described target data, described simulation document is the file described target data being carried out to simulation process.
9. data transformations device according to claim 8, is characterized in that, also comprise:
3rd generation unit, for after read described target data from described database, generates graphic file according to described target data;
Output unit, for exporting described graphic file to software front end; And
Display unit, shows described graphic file on the graphical interfaces in described software front end.
10. data transformations device according to claim 6, is characterized in that, described conversion unit comprises:
Contrast module, for contrasting described data to be transformed and described reference data;
Judge module, for judging whether described data to be transformed and described reference data there are differences;
Described data transformations to be transformed, for when judging that described data to be transformed and described reference data not there are differences, is described target data by conversion module; And
Alarm module, for judging that described data to be transformed and described reference data there are differences, carries out alarm.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410390128.3A CN105335428A (en) | 2014-08-08 | 2014-08-08 | Data conversion method and apparatus |
| PCT/CN2015/086046 WO2016019855A1 (en) | 2014-08-08 | 2015-08-04 | Data conversion method and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410390128.3A CN105335428A (en) | 2014-08-08 | 2014-08-08 | Data conversion method and apparatus |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105335428A true CN105335428A (en) | 2016-02-17 |
Family
ID=55263153
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410390128.3A Pending CN105335428A (en) | 2014-08-08 | 2014-08-08 | Data conversion method and apparatus |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN105335428A (en) |
| WO (1) | WO2016019855A1 (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106570260A (en) * | 2016-11-03 | 2017-04-19 | 北京航天时代光电科技有限公司 | Electric connection relation automatic generation method |
| 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 |
| CN114004451A (en) * | 2021-09-28 | 2022-02-01 | 广东电网有限责任公司 | Energy analysis system, energy analysis method, terminal device, and computer-readable storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101504662A (en) * | 2009-03-13 | 2009-08-12 | 北大方正集团有限公司 | Data conversion method and apparatus |
| CN101996271A (en) * | 2010-08-12 | 2011-03-30 | 武汉大学 | 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 |
| CN103150600A (en) * | 2013-03-27 | 2013-06-12 | 平阳电力有限责任公司 | Safety analyzing system of power network |
| CN103559171A (en) * | 2013-11-04 | 2014-02-05 | 北京锐安科技有限公司 | Data format conversion method and device for use in network application |
Family Cites Families (5)
| 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 |
| CN101556570B (en) * | 2009-05-27 | 2011-05-04 | 深圳市科陆电子科技股份有限公司 | Data transfer method for serial identifying equipment |
| JP5857611B2 (en) * | 2011-10-13 | 2016-02-10 | 株式会社リコー | Information processing device, system, program |
| CN102413075A (en) * | 2011-12-18 | 2012-04-11 | 上海量明科技发展有限公司 | Method and system for changing format during data transmission |
| CN104135581B (en) * | 2014-08-15 | 2016-05-04 | 国家电网公司 | A kind of communication means and device |
-
2014
- 2014-08-08 CN CN201410390128.3A patent/CN105335428A/en active Pending
-
2015
- 2015-08-04 WO PCT/CN2015/086046 patent/WO2016019855A1/en active Application Filing
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101504662A (en) * | 2009-03-13 | 2009-08-12 | 北大方正集团有限公司 | Data conversion method and apparatus |
| CN101996271A (en) * | 2010-08-12 | 2011-03-30 | 武汉大学 | 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 |
| CN103150600A (en) * | 2013-03-27 | 2013-06-12 | 平阳电力有限责任公司 | Safety analyzing system of power network |
| CN103559171A (en) * | 2013-11-04 | 2014-02-05 | 北京锐安科技有限公司 | Data format conversion method and device for use in network application |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106570260A (en) * | 2016-11-03 | 2017-04-19 | 北京航天时代光电科技有限公司 | Electric connection relation automatic generation method |
| 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 |
| CN114004451A (en) * | 2021-09-28 | 2022-02-01 | 广东电网有限责任公司 | Energy analysis system, energy analysis method, terminal device, and computer-readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2016019855A1 (en) | 2016-02-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| McMorran et al. | Translating CIM XML power system data to a proprietary format for system simulation | |
| CN102750406B (en) | Multi-version management method for model set and difference model-based power grid model | |
| CN105335428A (en) | Data conversion method and apparatus | |
| CN108153996B (en) | Method for realizing electric wiring group cabinet by COMOS platform | |
| Santodomingo et al. | Facilitating the automatic mapping of IEC 61850 signals and CIM measurements | |
| CN106709143A (en) | VFTO batch simulation analysis method and system based on ATP automatic modeling | |
| CN108228726A (en) | The increment unusual fluctuation content acquisition method and storage medium of power distribution network red and black figure | |
| McMorran et al. | Addressing the challenge of data interoperability for off-line analysis of distribution networks in the Smart Grid | |
| CN113094932A (en) | Method, device, equipment and storage medium for acquiring construction cost of power transformation project | |
| Zhang et al. | Smart grid-oriented algorithm of data retrieval and processing based on crio | |
| CN110135814A (en) | The correlating method of BIM and project data, system and terminal device | |
| CN106168995A (en) | It is applied to the figure of spacecraft, table conversion method and converting system | |
| CN112580178B (en) | Graph-model bidirectional verification method and device for energy management system | |
| CN107247827A (en) | Empty terminal model modeling and automatic connecting method based on machine learning | |
| CN112397210B (en) | Digital design system, method and equipment for nuclear power plant control system of database | |
| CN111340253B (en) | Analysis method and system for main network maintenance application form | |
| CN105046461A (en) | Method for information management of converting station spare parts based on quick response codes | |
| CN104809664A (en) | Information integration method for power distribution master station | |
| CN108563898A (en) | A kind of man-machine interactive power grid single wire digital modeling method | |
| CN110414172B (en) | Dynamic module dynamic monitoring management method and system | |
| CN112579827A (en) | Data-driven power system data processing method and system | |
| Liang et al. | An implementation of synthetic generation of wind data series | |
| CN112100985B (en) | Multi-source data integration, matching, conversion and synthesis method for transverse and longitudinal interactive power grid | |
| CN111404151A (en) | AC/DC large power grid frequency simulation inversion method and related device | |
| CN109543852A (en) | Optical cable link information analysis method and device for intelligent substation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160217 |