CN110781162A - Database modeling method based on SCD - Google Patents
Database modeling method based on SCD Download PDFInfo
- Publication number
- CN110781162A CN110781162A CN201910922270.0A CN201910922270A CN110781162A CN 110781162 A CN110781162 A CN 110781162A CN 201910922270 A CN201910922270 A CN 201910922270A CN 110781162 A CN110781162 A CN 110781162A
- Authority
- CN
- China
- Prior art keywords
- information
- scd
- database
- class
- file
- 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
- 238000000034 method Methods 0.000 title claims abstract description 18
- 230000006854 communication Effects 0.000 claims abstract description 40
- 238000004891 communication Methods 0.000 claims abstract description 37
- 238000012986 modification Methods 0.000 abstract description 4
- 230000004048 modification Effects 0.000 abstract description 4
- 238000012544 monitoring process Methods 0.000 description 7
- 238000012545 processing Methods 0.000 description 5
- 238000005070 sampling Methods 0.000 description 4
- 238000006243 chemical reaction Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000013499 data model Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012552 review Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J3/00—Circuit arrangements for ac mains or ac distribution networks
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Power Engineering (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention discloses a database modeling method based on SCD, which comprises the steps of analyzing an SCD file in a total station, and storing SCD information in the SCD file as a binary file; and generating temporary data template information, generating database model communication information, generating database interval class, primary equipment class and logic node class information according to the binary information, and finally generating primary equipment class downlink measuring point information for describing and analyzing signals described in the communication message. The SCD file integrated with the equipment can be automatically imported into the database, and a 61850 data structure-based database model which can be directly communicated with the device is established. The point table modification is not required to be manually created, and the debugging is simple.
Description
Technical Field
The invention belongs to the field of substation automation, and particularly relates to a database modeling method based on SCD.
Background
The transformer substation model is an important basis for the application of the power system automation technology. With the continuous development of the substation automation technology, the intelligent substation widely adopts the IEC61850 model expression mode at present. The device ICD file and the SSD (System Specification description) file are used for uniformly configuring the instances of all the devices to generate the SCD configuration file of the whole station. The substation configuration language SCL is used for describing the configuration of the equipment in the substation and the interaction of configuration information, and abstracts the substation equipment information and defines the information by object-oriented classes. The SCL mainly defines four parts of information, Communication class (Communication), primary device class (subsystem), intelligent electronic device class (IED), and DataTypeTemplate class (DataTypeTemplate) (fig. 2). The database comprises a plurality of tables, and the data of each table is organized in rows and columns and is also a relation. All the tables are associated through certain information to form a required real-time database. The background system needs to generate a monitoring system database by analyzing the SCD model file. How to adopt an automatic mode, the SCD model data is safely, quickly and conveniently mapped to the monitoring system database model, and the method has important significance for daily debugging of the transformer substation.
The conventional station generally adopts 103 protocol communication with the background or adopts proprietary protocols of various manufacturers for communication.
The conventional station background monitoring system needs an engineer to manually integrate and create a database model according to an equipment point table, and then communicates with the station control layer device according to device protocols of different manufacturers. The intelligent station communicates in an 61860 mode, and data of a monitoring system and IEC 61850-based data have great difference in storage format and data model construction, so that the two data formats are difficult to map in the access process, and therefore a common monitoring background end needs to convert four-remote signals into a format conforming to 81850 communication according to a four-remote storage point table and then communicates with secondary equipment.
However, since the point table is manually created by an engineer, there are disadvantages that the workload is large and errors are easy to occur. If the conventional station device and background communication have problems, the conventional station device and the background communication also need to be debugged in sequence according to different protocols, the debugging level requirement of engineering personnel is high, and the difficulty is high. And the ordinary intelligent station converts the four-remote signal into a format conforming to 81850 communication and then communicates with secondary equipment to perform data structure conversion, so that the efficiency is low.
Therefore, a new technical solution is needed to solve the above problems.
Disclosure of Invention
The purpose of the invention is as follows: aiming at the problems, the SCD file integrated with the equipment can be automatically imported into the database, and a database model which can be directly communicated with the device and is based on a 61850 data structure is established. The point table modification is not required to be manually created, and the debugging is simple.
The technical scheme is as follows: in order to achieve the purpose, the invention adopts the following technical scheme:
a database modeling method based on SCD is characterized by comprising the following steps:
(1) analyzing the SCD file of the whole station, and storing SCD information in the SCD file as a binary file;
(2) reading the binary file information to establish temporary data template information;
(3) generating database model communication information according to the communication data in the binary file information; various parameter information of a substation communication network including network IP, logic nodes and the like is obtained by analyzing the hierarchical structure of the communication class;
(4) generating database interval class, primary equipment class and logic node class information according to the primary equipment class and intelligent electronic equipment class data in the binary file;
(5) and (3) generating primary equipment downlink measuring point information according to the data type template information in the binary file and the temporary template information generated in the step (2) for describing and analyzing signals described in the communication message.
Further, the total station SCD file in step (1) is obtained by providing a device configuration tool by a device manufacturer to generate a device configuration description ICD file, and then providing a system configuration tool by a system integrator to generate a total station SCD file.
Further, in step (1), the SCD information includes communication class information, primary device class information, intelligent electronic device class information, and data type template class information.
Further, in the step (2), the temporary database template information is defined to include wiring terminal information, associated main point information, data type information and device type information.
Further, in the step (4), the database interval class, primary device class and logical node class information includes device communication information, interval allocation, primary device type and associated logical node relation.
And further, the method also comprises the step (6) of checking whether the information in the current database model is consistent with the information in the SCD model, so that the stability of the model is ensured.
Has the advantages that: compared with the prior art, the invention has the beneficial effects that:
in the modeling method used by the invention, because the information of the produced measuring points is completely consistent with the model in the 61850 communication message, the communication message can be directly analyzed and stored without data type conversion by a communication program, and secondary signals are processed, such as alarm and historical data sampling; namely, the database model can be directly used for 61850 communication, so that the software communication process is simplified, the communication rate can be improved, the time for processing real-time data by a program is greatly saved, and the operation efficiency of processing data, such as data sampling, historical data review and the like, by a subsequent monitoring system is improved.
Drawings
Fig. 1 is a schematic diagram of an object and data model of an IED in an SCD according to the present invention.
Fig. 2 is a schematic diagram of SCL basic architecture.
FIG. 3 is a schematic diagram of the main modules of data access in the database modeling method of the present invention.
Detailed Description
One aspect of the invention is described in further detail below with reference to the accompanying drawings.
As shown in fig. 1, a database modeling method based on SCD includes the following steps:
(1) providing a device configuration tool by a device manufacturer, generating a device configuration description ICD (IED capability description) file, and then providing a system configuration tool by a system integrator to generate a total-station SCD file; analyzing the SCD file of the whole station, and storing SCD information in the SCD file as a binary file; the SCD information comprises communication information, primary equipment information, intelligent electronic equipment information and data type template information.
(2) And reading the binary file information to establish temporary data template information, wherein the temporary data template information comprises wiring terminal information, associated main point information, data type information and device type information.
(3) Generating database model communication information according to the communication data in the binary file information; and various parameter information of the substation communication network including network IP, logic nodes and the like is obtained by analyzing the hierarchical structure of the communication class.
(4) And generating database interval class, primary equipment class and logic node class information according to the primary equipment class and intelligent electronic equipment class data in the binary file, wherein the database interval class, the primary equipment class and the logic node class information comprise device communication information, interval distribution, primary equipment types and associated logic node relations.
(5) And (3) generating primary equipment downlink measuring point information according to the data type template information in the binary file and the temporary template information generated in the step (2) for describing and analyzing signals described in the communication message.
And (6) checking whether the information in the current database model is consistent with the information in the SCD model, and ensuring the stability of the model.
In the method, because the produced measuring point information is completely consistent with the model in the 61850 communication message, the communication message can be directly analyzed and stored without data type conversion by a communication program, secondary signal processing such as alarming, historical data sampling and the like is performed, the time for processing real-time data by the program is greatly saved, and the operation efficiency of a subsequent monitoring system for processing data such as data sampling, historical data review and the like is improved.
In addition, the present invention has many specific implementations and ways, and the above description is only a preferred embodiment of the present invention. It should be noted that, for those skilled in the art, without departing from the principle of the present invention, several improvements and modifications can be made, and these improvements and modifications should also be construed as the protection scope of the present invention. All the components not specified in the present embodiment can be realized by the prior art.
Claims (6)
1. A database modeling method based on SCD is characterized by comprising the following steps:
(1) analyzing the SCD file of the whole station, and storing SCD information in the SCD file as a binary file;
(2) reading the binary file information to establish temporary data template information;
(3) generating database model communication information according to the communication data in the binary file information; various parameter information of a substation communication network including network IP, logic nodes and the like is obtained by analyzing the hierarchical structure of the communication class;
(4) generating database interval class, primary equipment class and logic node class information according to the primary equipment class and intelligent electronic equipment class data in the binary file;
(5) and (3) generating primary equipment downlink measuring point information according to the data type template information in the binary file and the temporary template information generated in the step (2) for describing and analyzing signals described in the communication message.
2. The database modeling method of claim 1, wherein: the total station SCD file in step (1) is obtained by providing a device configuration tool by a device manufacturer to generate a device configuration description ICD file, and then providing a system configuration tool by a system integrator to generate a total station SCD file.
3. The database modeling method of claim 1, wherein: in the step (1), the SCD information includes communication information, primary device information, intelligent electronic device information, and data type template information.
4. The database modeling method of claim 1, wherein: in the step (2), the temporary database template information is defined to comprise wiring terminal information, associated main measuring point information, data type information and device type information.
5. The database modeling method of claim 1, wherein: in the step (4), the database interval class, primary equipment class and logic node class information includes device communication information, interval allocation, primary equipment type and associated relation of the logic node.
6. The database modeling method of claim 1, wherein: and (6) checking whether the information in the current database model is consistent with the information in the SCD model, and ensuring the stability of the model.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910922270.0A CN110781162A (en) | 2019-09-27 | 2019-09-27 | Database modeling method based on SCD |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910922270.0A CN110781162A (en) | 2019-09-27 | 2019-09-27 | Database modeling method based on SCD |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110781162A true CN110781162A (en) | 2020-02-11 |
Family
ID=69384604
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910922270.0A Pending CN110781162A (en) | 2019-09-27 | 2019-09-27 | Database modeling method based on SCD |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110781162A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112287648A (en) * | 2020-10-27 | 2021-01-29 | 国电南瑞科技股份有限公司 | SCD-based substation monitoring system data point table generation and synchronization method |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101706773A (en) * | 2009-11-19 | 2010-05-12 | 北京四方继保自动化股份有限公司 | Method for realizing fast and automatic modeling of transformer substation IEC 61850 by adopting XML information recombination |
WO2010150048A1 (en) * | 2009-06-26 | 2010-12-29 | Abb Research Ltd | A method for configuring an intelligent electronic device and a substation automation system |
CN102799620A (en) * | 2012-06-19 | 2012-11-28 | 中国电力科学研究院 | IEC 61850 universal database information model and design method for interface of IEC 61850 universal database information model |
CN104317864A (en) * | 2014-10-15 | 2015-01-28 | 许继电气股份有限公司 | Automatic identification method of information model based on IEC61850 logical nodes |
US20190170822A1 (en) * | 2017-12-05 | 2019-06-06 | State Grid Hebei Electric Power Research Institute | Fully-automatic closed-loop detection method and device for intelligent substation |
-
2019
- 2019-09-27 CN CN201910922270.0A patent/CN110781162A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2010150048A1 (en) * | 2009-06-26 | 2010-12-29 | Abb Research Ltd | A method for configuring an intelligent electronic device and a substation automation system |
CN101706773A (en) * | 2009-11-19 | 2010-05-12 | 北京四方继保自动化股份有限公司 | Method for realizing fast and automatic modeling of transformer substation IEC 61850 by adopting XML information recombination |
CN102799620A (en) * | 2012-06-19 | 2012-11-28 | 中国电力科学研究院 | IEC 61850 universal database information model and design method for interface of IEC 61850 universal database information model |
CN104317864A (en) * | 2014-10-15 | 2015-01-28 | 许继电气股份有限公司 | Automatic identification method of information model based on IEC61850 logical nodes |
US20190170822A1 (en) * | 2017-12-05 | 2019-06-06 | State Grid Hebei Electric Power Research Institute | Fully-automatic closed-loop detection method and device for intelligent substation |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112287648A (en) * | 2020-10-27 | 2021-01-29 | 国电南瑞科技股份有限公司 | SCD-based substation monitoring system data point table generation and synchronization method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106951694B (en) | Adaptive modeling method for online monitoring system of secondary equipment of power system | |
CN102510127B (en) | Method for unifying models of on-line monitored first and secondary equipment of power grid | |
CN106528880B (en) | Method and system for regulating data structure format of multi-source power business data | |
CN103414251B (en) | A kind of substation network communication analogue system based on IEC61850 | |
CN111585344B (en) | Substation intelligent checking method and device based on total station IED simulation | |
CN101964542B (en) | Method for accessing IEC61970 dispatching EMS system to IEC61850 digital transformer substation | |
CN105809260A (en) | Method for intelligently generating monitoring information point list of dispatching automation system | |
CN108414849A (en) | Intelligent substation automatization test system and method | |
CN104699801A (en) | Method and device of secondary equipment associating configuration | |
CN105095600A (en) | Intelligent substation and regulation and control center coordinative modeling method | |
CN104580245B (en) | A kind of 104 packet parsing system of distribution terminal and its analytic method | |
CN112328323B (en) | Relay protection device capability description file generation system | |
CN112287648A (en) | SCD-based substation monitoring system data point table generation and synchronization method | |
CN110766263A (en) | Automatic acceptance method for secondary equipment of transformer substation and terminal equipment | |
CN110768845A (en) | Intelligent substation process level virtual connection fault positioning system | |
CN103151840A (en) | Communication method and device of IEC (international electrotechnical commission) 61850 system and non-IEC 61850 system | |
CN110768372A (en) | IEC61850 standard-based protection information system source end modeling method | |
CN116628937B (en) | Automatic fusion maintenance method, device, equipment and medium for power grid equipment model | |
CN107565690B (en) | Rapid replacement method for transformer substation measurement and control device under fault condition | |
CN106780150A (en) | Intelligent telecontrol fixed value list platform for making and method | |
CN105743870A (en) | Design method of intelligent substation integrated business platform service interfaces | |
CN111221794A (en) | Multi-source data fusion method for wide-area measurement control system of power distribution network | |
CN110781162A (en) | Database modeling method based on SCD | |
CN104156230A (en) | Automatic red and black figure implementation method based on debug system data objectification | |
CN106302485A (en) | OPC standard and the bi-directional conversion system of power remote agreement |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200211 |
|
RJ01 | Rejection of invention patent application after publication |