CN100342379C - Method of implementing IEC 61850 information indirect access real-time database - Google Patents
Method of implementing IEC 61850 information indirect access real-time database Download PDFInfo
- Publication number
- CN100342379C CN100342379C CNB200510071822XA CN200510071822A CN100342379C CN 100342379 C CN100342379 C CN 100342379C CN B200510071822X A CNB200510071822X A CN B200510071822XA CN 200510071822 A CN200510071822 A CN 200510071822A CN 100342379 C CN100342379 C CN 100342379C
- Authority
- CN
- China
- Prior art keywords
- information
- real
- iec61850
- time data
- data base
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a method of indirectly accessing real-time databases for object oriented information (IEC61850 information for short) which conforms to IEC61850 communication standards. The method comprises: information needed by a real-time database is extracted from a configuration file by a configuration tool; a real-time database structure and a mapping relationship between the IEC61850 information and the information of the real-time database are automatically generated by an application module; a communication module implements data exchange with the real-time database by inquiring the mapping relationship. The implementing method has the advantage that the real-time database structure and the mapping relationship between the IEC61850 information and the information of the real-time database are automatically generated. Simultaneously, the whole process can be flexibly controlled by engineering staff.
Description
Technical field
The present invention relates to the data access technology of Automation of Electric Systems, the implementation method that inserts existing non-object-oriented real-time data base based on the object-oriented information of IEC61850 communication standard is provided, particularly provide and utilized configuration information to generate the real time data library structure automatically, generated the method for mapping relations between IEC61850 information and the existing real-time data base automatically.
Background technology
On the basis of the TC57 of International Electrotechnical Commission communication protocol before summing up, formulated the IEC61850 communication standard.This communication standard is by carrying out unified Modeling to the object in the electric substation automation system, adopt Object-oriented Technique and the Abstract Common Service Interface (ACSI) that is independent of network structure, strengthen the interoperability of equipment room, can between the equipment of different manufacturers, realize seamless link.This standard possesses the characteristics of flexible configuration, reliability height, high safety, has represented automation of transformation substations technology development in future direction.
The core of IEC61850 communication standard is exactly " model and modeling ", the model that not only comprises data object in the electric substation automation system, and comprise the model of substation communication system, these models and OO Abstract Common Service Interface (ACSI) combine, and have just formed the communications platform that has the opening of enriching self-described information.
The indexed mode of IEC61850 communication standard information index mode and existing communication protocol is also inequality, the index of existing protocol generally is made up of the certain physical meaning of representative " numbering ", and IEC61850 communication standard information index is made up of represents physical implication " description character string ".At present, the real-time data base of electric substation automation system is substantially according to existing communication protocol structure, with IEC61850 communication standard and incompatible.
Existing electric substation automation system is extensive use of, and in a period of time, existing real-time data base remains the main flow in market, and real-time data base does not have bigger variation yet simultaneously.In this case, being applied in a period of time of IEC61850 communication standard need be carried out on existing electric substation automation system.
At present, the implementation (as shown in Figure 1) of existing electric substation automation system access IEC61850 communication standard information mainly is:
At first, utilize configuration tool and IEC61850 configuration file to generate the structure of real-time data base, the mapping relations of configuration IEC61850 information and existing stipulations or inner stipulation, then, utilize this mapping relations, the information translation that receives is become existing puppy parc or internal agreement, and the information after the conversion enters real-time data base according to the mode of existing information access real-time database.
The advantage of this implementation is not change the existing application program, and shortcoming is the hierarchical relationship that the protocol conversion mode needs extra increase information to insert, and makes program efficiency reduce, and has also increased the complicated process of system; Increase the quantities of configuration, not only will dispose the mapping relations of IEC61850 information and existing protocol, also will dispose the mapping relations of existing protocol and application program real-time data base.
In order to utilize the IEC61850 communication standard better, the efficient of system is provided, reduce engineering configuration effort amount, the present invention proposes the method that a kind of IEC61850 information indirect inserts the existing application real-time data base.
Summary of the invention
The invention provides a kind of needs existing application is carried out a spot of upgrading, do not need to revise existing real-time data base, just can realize that IEC61850 information inserts the method for application program real-time data base.
The principle of this implementation method is:
In the IEC61850 communication standard, main exchanges data is undertaken by data set and controller, so the data member in data set and the controller can be used as the major part of application program real time data library structure.
At first, by configuration tool identification configuration information (SCL file), the data member of data set and controller is extracted, the engineering staff has the right the data member that extracts is further screened, after the screening, configuration tool generates The selection result intermediate file (file layout is determined by application program) automatically or passes to application module by interface.
Because real-time data base is the part of application program, therefore application module of needs is realized the interface between intermediate file and the real-time data base.The major function of application module is the data member information after the form by intermediate file or interface obtains screening, call format according to real-time data base, data member is inserted real-time data base uniquely, thereby generate the index of real time data library structure and data.Simultaneously, because application module had both been known the data member information after the screening, know the real time data library information again, so application module have the ability to generate the mapping relations between IEC61850 information and the real time data library information, and this mapping relations are preserved with the form of mapped file.
After communication subsystem receives IEC61850 information, just can search corresponding mapping relations, and the information after will shining upon, access real-time database.
Therefore, according to the method that the invention provides a kind of IEC61850 information access real-time database, comprise step: a), from configuration file, resolve and screen with data set model in the IEC61850 information and the main source of report controll block model as the real time data library structure; B) application module becomes the form of real time data library information with the IEC61850 information translation, and when putting into the appropriate section of database, generates the index of real-time data base automatically, thereby generated the structure of real-time data base according to the data member after screening; When c) generating real-time data base automatically, application module is preserved the mapping relations of IEC61850 information and real time data library information, generates mapped file; D) user resolves mapped file in internal memory, when receiving IEC61850 information, according to the index of mapping relationship searching real-time data base, according to the result who searches with IEC61850 information access real-time database.
The advantage of the method for this IEC61850 information access real-time database is that IEC61850 information is fairly simple to link between the database, can carry out some simple modifications by application programs and just can realize; Generate the process of real time data library structure and the process of generation mapping relations and mainly finish, saved a large amount of engineering configuration efforts by Automatic Program; Simultaneously, whole process can be controlled by the engineering staff, guarantees the dirigibility of implementation procedure.
The characteristics of this implementation method are:
1. existing real-time data base is not done any change.
2. extract the information that real-time data base needs by configuration tool.
3. generate the real time data library structure automatically.
4. generate the mapping relations of IEC61850 information and real time data library information automatically.
5. whole process can be controlled flexibly by the engineering staff.
Description of drawings
Fig. 1 has shown existing IEC61850 information access real-time database synoptic diagram;
Fig. 2 has shown IEC61850 information indirect access real-time database synoptic diagram of the present invention;
Fig. 3 has shown the process flow diagram of garbled data member among the embodiment of method of the present invention;
Fig. 4 has shown the process flow diagram that generates real time data library structure and mapped file among the embodiment of method of the present invention;
Fig. 5 has shown the process flow diagram of user IEC61850 information access real-time database among the embodiment of method of the present invention.
Embodiment
The implementation method of IEC61850 information access real-time database comprises that automatic generation, the IEC61850 operation information of screening, real time data library structure and the mapping relations of data member insert real-time storehouse.
1) screening of data member
IEC61850 communication provides rich data model and data, services, wherein data set model and report controll block model can be the set of bulk information, and data set model and report controll block relevant service can realize the exchange of bulk information, so data set model and report that the controll block model can be used as the main source of real-time library structure.Data model and report controll block model have carried out detailed description in configuration file, configuration file after configuration is finished can provide complete data set model and report the information of controll block model, therefore at first configuration file is analyzed by configuration tool, from configuration file, find the information of data set model and report controll block, and these information analysis are come out, and the union of the collection model information of fetching data and report controll block model information, thereby guarantee information is unique.Information after the parsing at first is shown to the engineering staff, and the engineering staff can screen the information after resolving as required, removes the unconcerned information of application program, and definite The selection result.Result after the screening can be kept at (form of this intermediate file is according to the needs decision of application module) in the intermediate file, and also the interface that can directly provide by application module generates the structure of real-time data base automatically.
2) generate the structure and the mapping relations of real-time data base automatically
Data member through after engineering staff's the screening has embodied the requirement of real-time data base, is again the IEC61850 form, and each data member content has comprised information such as IEC61850 index (Reference), physical meaning, IEC61850 data type.The information format of real-time data base then is traditional index (period), physical meaning, real-time data base data type etc., and therefore the data member after the screening can not directly deposit real-time data base in.In order to address this problem, application module is according to the content of the data member after screening, requirement according to real-time storehouse, the IEC61850 information translation is become the form (comprising data type etc.) of real time data library information, and put into the appropriate section of real-time data base one by one, when placing, application module generates the index (period) of real-time data base automatically, thereby has generated the structure of real-time data base automatically.Automatically the real time data library structure that generates no longer comprises the information characteristics of IEC61850, but has kept the descriptors such as some physical meaning in the IEC61850 configuration file.In order to distinguish, can put the mark of IEC61850 standard with the real-time data base part that IEC61850 is information-related.
When generating real-time data base automatically, the corresponding relation that has comprised IEC61850 information and real time data library information in the application module, the information that these corresponding relations comprise is abundanter, wherein just comprised the corresponding relation of IEC61850 index (Reference) and real-time data base index (period), these corresponding relations are extremely important for IEC61850 information access real-time database.Therefore, application module is when generating the real time data library structure automatically, map informations such as index, data type are preserved according to equipment (can dwindle the hunting zone of IEC61850 information when the real-time data base information mapping like this), and the corresponding relation of preserving device number in IEC61850 equipment and the real-time data base also preserved, the form of preservation is a mapped file.
As shown in Table 1 and Table 2, mapped file comprises two parts: the one, and the corresponding relation of IEC61850 information and real time data library information, the one, the corresponding relation of IEC61850 equipment and real time data library facilities.
The corresponding relation of table 1 IEC61850 information and real time data library information:
| Sequence number | IEC6185 0 logical device title | IEC6185 0 data object and data attribute title | IEC6185 0 data type | Real time data library facilities index | The real-time data base information index | The real-time data base data type | |||
| Address 1 | Address 2 | Address 3 | Address 4 | ||||||
| 1 | E1Q1SB1 CSI200E | MMXU1$M X$A$phs A$instC Val$mag $f | ST_FLOA T | Low-pressure side CSI200E | 1 | 1 | 81 | 1 | float |
| … | |||||||||
The corresponding relation of table 2 IEC61850 equipment and real time data library facilities:
| Sequence number | IEC61850 logical device title | Real time data library facilities index | This device map is closed the skew that ties up in " corresponding relation of IEC61850 information and real-time data base " table |
| 1 | E1Q1SB1CSI200 E | Low-pressure side CSI200E | 102 |
| … |
3) IEC61850 operation information access real-time database
When equipment operation, the conversion of IEC61850 information and real time data library information is two-way, and existing information transmission from the IEC61850 client to the real-time data base direction also has the information transmission from real-time data base to the IEC61850 client.
From embodiment 1) part to 2) part, the realization of these layoutprocedures has generated mapped file automatically.In the time of the IEC61850 client terminal start-up, just mapped file is read in the internal memory and (can accelerates search speed like this).After the IEC61850 client receives IEC61850 information, just can find relevant device number according to mapping relations, and the search mapping relations obtain the index of concrete data in real-time data base in the scope of this equipment, thereby information can be changed, and access real-time database.The real time data library information will be delivered to the IEC61850 client, only need carry out an inverse process, converts IEC61850 information to by mapping relations, and passes to the IEC61850 client.
Embodiment
Fig. 2 has shown the synoptic diagram of IEC61850 information indirect access real-time database, in the left side of empty frame, is the layoutprocedure of IEC61850 client, and the right side of empty frame is a real-time data base, and the inside of empty frame is main realization part of the present invention.The mode of transmitting information between configuration and the application module can be an intermediate file, also can be application programming interfaces.In the layoutprocedure, application module produces mapping relations and is kept in the mapped file, and in operational process, the content of mapped file will be read in the internal memory.
1) screening of data member
As shown in Figure 3, data member comprises automatic extraction and engineering staff manually two aspects of control, the wherein bigger proportion of part accounting that extracts automatically.
Each step function among Fig. 3 is explained as follows:
S01-opens and resolves configuration file, mainly is the parsing of SCL file layout.
S02-extracts data set and report controll block data member, and the data member of data set and report controll block is the chief component of real-time data base.
S03-judges whether this data member is unique, and under many circumstances, same data member may be the member of data set and report controll block simultaneously, therefore will remove the data member of repetition.
S04-puts into first order result, with the temporary transient preservation of the data member that extracts and guarantee uniqueness.
S05-judges to extract whether finish, and just enters next step after extracting fully.
S06-judges whether engineering staff's screening finishes, and it is freely that the engineering staff screens according to the application program needs, and this place opens to give the engineering staff, is controlled by the engineering staff.
S07-judges whether by the intermediate file swap data, if the result after then will screening is saved in intermediate file; If not, then be directly passed to application module by interface.
S08-result deposits intermediate file in, with the result after the form preservation screening of file.
S09-result passes to application module by interface.
2) generate the structure and the mapping relations of real-time data base automatically
As shown in Figure 4, generate real time data library structure and mapping relations automatically and all finish in application module, the source of information is the configuration information after the engineering staff screens.
Each step function among Fig. 4 is explained as follows:
S01-becomes the form of real-time library information with the IEC61850 information translation, and the function of this step is the conversion of the information of carrying out, and the correspondence of general data type is particularly classified to information according to the requirement of real-time data base.
S02-puts into the appropriate section of real-time data base, puts in storage according to classification results.
S03-generates the real-time data base index, and this process is automatically, mainly is the definition requirement according to the real-time data base index, to the automatic allocation index of information.
S04-puts the mark of IEC61850 standard, and this step is optionally, mainly is the convenience according to application program.
S05-writes mapping relations to configuration file, and behind the generation real-time data base index, reality has produced the mapping relations of IEC61850 information and real time data library information, is saved in to make things convenient for other modules to use in the file.
S06-judges whether to finish, and just finishes and finishes, otherwise continue next data member is handled.
3) IEC61850 operation information access real-time database
As shown in Figure 5, the process of IEC61850 operation information access real-time database mainly is the mapping process of index.IEC61850 information access real-time database is two-way, has only inquired into the information translation from the IEC61850 client to the real-time data base direction here.
Each step function among Fig. 5 is explained as follows:
S01-resolves mapped file in internal memory, and this step is in order to accelerate search speed.
The S02-IEC61850 client receives IEC61850 information, and this step more complicated is not the emphasis of this patent.
S03-is according to the index of mapping relationship searching real-time data base, and this process at first is to find the equipment index,
From the map information of current device, find the index of this information in real-time data base again.
The S04-access real-time database is according to the result who searches, with the information access real-time database.
Whether the S06-determining program finishes, and does not finish, and with regard to continuing next data member is handled.
Claims (8)
1, a kind of object-oriented information of the IEC61850 of meeting communication standard inserts the method in real-time storehouse, and the object-oriented information that wherein will meet the IEC61850 communication standard abbreviates IEC61850 information as, and this method step comprises:
A) with data set model in the IEC61850 information and the main source of report controll block model, from configuration file, resolve and screen, information that obtains parsing and the data that filter out as the real time data library structure;
B) application module becomes the form of real time data library information with the IEC61850 information translation, and when putting into the appropriate section of database, generates the index of real-time data base automatically, thereby generated the structure of real-time data base according to the data member after screening;
When c) generating real-time data base automatically, application module is preserved the mapping relations of IEC61850 information and real time data library information, generates mapped file;
D) user resolves mapped file in internal memory, when receiving IEC61850 information, according to the index of mapping relationship searching real-time data base, according to the result who searches with IEC61850 information access real-time database.
2, according to the method for claim 1, in step a), configuration tool is analyzed configuration file, from configuration file, find the information of data set model and report controll block model, parse this information, and the union of fetch data collection model and report controll block model information, the uniqueness of guarantee information.
3, according to the method for claim 1, the information that parses described in the step a) is screened by the engineering staff, and definite The selection result.
4, according to the method for claim 1, the data that filter out described in the step a) can be kept in the intermediate file, and the form of this intermediate file is decided according to the needs of application module.
5, according to the method for claim 1, in step b), the described IEC61850 information that converts the real-time data base information format to can be put the mark of IEC61850 standard.
6, according to the method for claim 1, in step c), described application module is that the map information of index and data type is preserved according to equipment, and the corresponding relation of preserving device number in IEC61850 equipment and the real-time data base is also preserved, and the form of preservation is a mapped file.
7, according to the method for claim 1, in step d), described process of searching the real-time data base index is, at first finds the equipment index, finds the index of this information in real-time data base again from the map information of current device.
8, according to the method for claim 1, when the real time data library information will be delivered to the IEC61850 user side, only need carry out the inverse process of step d), the information of real-time data base converts IEC61850 information to by mapping relations, passes to the IEC61850 user side.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB200510071822XA CN100342379C (en) | 2005-05-25 | 2005-05-25 | Method of implementing IEC 61850 information indirect access real-time database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB200510071822XA CN100342379C (en) | 2005-05-25 | 2005-05-25 | Method of implementing IEC 61850 information indirect access real-time database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1687930A CN1687930A (en) | 2005-10-26 |
| CN100342379C true CN100342379C (en) | 2007-10-10 |
Family
ID=35305971
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB200510071822XA Expired - Fee Related CN100342379C (en) | 2005-05-25 | 2005-05-25 | Method of implementing IEC 61850 information indirect access real-time database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100342379C (en) |
Families Citing this family (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101521406B (en) * | 2008-02-26 | 2011-05-04 | 浙江省电力试验研究院 | GOOSE dual-net redundant communication signal transmission method |
| CN101771581B (en) * | 2009-12-16 | 2012-05-30 | 广东电网公司电力科学研究院 | Server-side simulating system based on IEC61850 and method thereof |
| CN101706816B (en) * | 2009-12-22 | 2011-05-04 | 广东电网公司电力科学研究院 | Method for detecting digitized transformer station model |
| CN101826113A (en) * | 2010-05-14 | 2010-09-08 | 珠海世纪鼎利通信科技股份有限公司 | High-efficiency and unified method for storing wireless measurement data |
| CN102495891B (en) * | 2011-12-09 | 2014-12-03 | 国网冀北电力有限公司管理培训中心 | Method for realizing real-time database for miniature power grid intelligent terminal |
| CN102779156B (en) * | 2012-05-31 | 2014-11-05 | 南京南瑞继保电气有限公司 | Configuration method for database of communication device in digital substation |
| CN103593568B (en) * | 2013-11-15 | 2017-02-08 | 国家电网公司 | On-line monitoring data model mapping method based on IEC 61850 |
| CN103605780B (en) * | 2013-11-29 | 2016-08-24 | 长园深瑞继保自动化有限公司 | The interface processing system of IEC61850 data |
| CN104615649B (en) * | 2014-12-26 | 2018-08-10 | 深圳市科陆电子科技股份有限公司 | A kind of data mapping method and module based on MMS-EASE Lite |
| CN106021203B (en) * | 2016-05-26 | 2021-08-27 | 中国电力科学研究院有限公司 | Intelligent substation anti-misoperation lockout logic graphical expression method |
| CN106054837B (en) * | 2016-06-22 | 2018-08-21 | 国家电网公司 | The method that IEC61850 normal datas realize interoperability with DCS real-time data bases |
| CN112905642B (en) * | 2021-02-24 | 2023-06-20 | 南京久为自动化科技有限公司 | Method for storing IEC61850 report data into relational database based on CSV mapping file |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1136847A (en) * | 1993-12-03 | 1996-11-27 | 艾利森电话股份有限公司 | Method and device for extracting data from a group of data |
| CN1237737A (en) * | 1997-10-06 | 1999-12-08 | 太阳微系统有限公司 | Inline database for receiver types in object-oriented systems |
| US6453333B1 (en) * | 1997-06-11 | 2002-09-17 | Lion Bioscience Ag | Research system using multi-platform object oriented program language for providing objects at runtime for creating and manipulating biological or chemical data to facilitate research |
| US20030204517A1 (en) * | 1998-05-29 | 2003-10-30 | Brian Skinner | Method and apparatus of performing active update notification |
-
2005
- 2005-05-25 CN CNB200510071822XA patent/CN100342379C/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1136847A (en) * | 1993-12-03 | 1996-11-27 | 艾利森电话股份有限公司 | Method and device for extracting data from a group of data |
| US6453333B1 (en) * | 1997-06-11 | 2002-09-17 | Lion Bioscience Ag | Research system using multi-platform object oriented program language for providing objects at runtime for creating and manipulating biological or chemical data to facilitate research |
| CN1237737A (en) * | 1997-10-06 | 1999-12-08 | 太阳微系统有限公司 | Inline database for receiver types in object-oriented systems |
| US20030204517A1 (en) * | 1998-05-29 | 2003-10-30 | Brian Skinner | Method and apparatus of performing active update notification |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1687930A (en) | 2005-10-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100342379C (en) | Method of implementing IEC 61850 information indirect access real-time database | |
| US20220075908A1 (en) | Device and a method for accurately mapping the building information modeling and the Internet of Things monitoring item | |
| CN1687922A (en) | Distributed data source data integration system and method | |
| CN100583783C (en) | Integration tool for telecommunication area inheritance system based on configuration policy | |
| CN101035099A (en) | General gateway design method for realizing the IEC61850 standard | |
| CN102780574B (en) | The collocation method of the office data of service-oriented, device and check method, device | |
| CN101706773A (en) | Method for realizing fast and automatic modeling of transformer substation IEC 61850 by adopting XML information recombination | |
| CN101841515A (en) | Target variable protocol data unit codec code automatic generation implementation method | |
| CN101345707A (en) | Method and apparatus for implementing IPv6 packet classification | |
| CN108200111A (en) | Resource allocation information update method, device and resource interface equipment | |
| CN1928813A (en) | Translation method and system for man/machine interaction interface of application program | |
| CN1526104A (en) | Parsing structured data | |
| CN109116828A (en) | Model code configuration method and device in a kind of controller | |
| CN1633080A (en) | Method for implementing log in network management system | |
| CN1684430A (en) | Configurating data collecting system and its method in network management | |
| CN107807977A (en) | A kind of object properties Metadata Extraction system based on configuration | |
| CN112905642B (en) | Method for storing IEC61850 report data into relational database based on CSV mapping file | |
| CN103888790A (en) | EPG (Electronic Program Guide) adaptation system and method | |
| CN101261645B (en) | Method and apparatus for obtaining multiple layer information | |
| CN115374765B (en) | Computing power network 5G data analysis system and method based on natural language processing | |
| CN103220274B (en) | A kind of network message pattern matching process for operator's network outlet and system | |
| CN101977251A (en) | Server-side website resource optimization device and optimization method thereof | |
| CN1601970A (en) | General command line inputting device based on man-machine interactive languages, and its method | |
| CN106293862A (en) | A kind of analysis method and device of expandable mark language XML data | |
| CN105335928A (en) | Method and system for reusing materials for cartoon games |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20071010 Termination date: 20180525 |