CN112905642A - Method for storing IEC61850 report data into relational database based on CSV mapping file - Google Patents
Method for storing IEC61850 report data into relational database based on CSV mapping file Download PDFInfo
- Publication number
- CN112905642A CN112905642A CN202110207571.2A CN202110207571A CN112905642A CN 112905642 A CN112905642 A CN 112905642A CN 202110207571 A CN202110207571 A CN 202110207571A CN 112905642 A CN112905642 A CN 112905642A
- Authority
- CN
- China
- Prior art keywords
- iec61850
- data
- csv
- report data
- mapping
- 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.)
- Granted
Links
- 238000013507 mapping Methods 0.000 title claims abstract description 67
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000004458 analytical method Methods 0.000 claims abstract description 10
- 230000016507 interphase Effects 0.000 claims description 10
- 238000005259 measurement Methods 0.000 claims description 10
- 230000008520 organization Effects 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 7
- 238000003491 array Methods 0.000 claims description 3
- 238000013500 data storage Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005191 phase separation Methods 0.000 description 1
- 238000004088 simulation Methods 0.000 description 1
- 238000006467 substitution reaction Methods 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Marketing (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Computational Linguistics (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for storing IEC61850 report data into a relational database based on a CSV mapping file, which comprises the following steps: step S1, editing and generating a table format file of the warehousing relation mapping table in the CSV file format, where the table format file includes three columns of data: the method comprises the following steps that (1) a database table name character string, a column name character string and an IEC61850 address character string are arranged; step S2, analyzing the CSV mapping file to generate a warehousing mapping relation through a CSV file mapping relation analysis module; and S3, receiving the IEC61850 report data through the IEC61850 report data receiving module to form a buffer structure of the IEC61850 address character string and the data value. The method and the device have the advantages that the mapping relation of the IEC61850 address character strings stored in the relational database table is defined by the CSV file which is simple in format, easy to edit and easy to resolve, the IEC61850 data are suitable for an automatic system or a device which needs to store the IEC61850 data in the relational database of various application occasions, and the problems in the prior art are solved.
Description
Technical Field
The invention relates to the technical field of substation automation systems of power systems, in particular to a method for storing IEC61850 report data into a relational database based on a CSV mapping file.
Background
The IEC61850 standard is the "substation communication networks and systems" series of standards newly specified by the international electrotechnical commission TC57 working group for solving new problems of interoperation faced by substation automation systems. The standard is supported by most mainstream manufacturers at home and abroad, and becomes the only unified standard in the field of substation automation globally.
With the popularization and application of the protection device, the measurement and control device and the power quality device of the intelligent substation based on the IEC61850 standard, how to flexibly and conveniently store data sent by the IEC61850 report into a system database is a frequently encountered problem. The data sent by the IEC61850 report is indexed in a way of adapting to the object-oriented address character string of the hierarchical structure, while the relational database used by the general system is defined by the table name and the column name for data storage, and there is no natural mapping way between the address character string of the hierarchical structure and the table and the column of the database.
Therefore, the invention is urgently needed to create a universal method which has strong engineering practical significance and can flexibly configure and store the IEC61850 report uploading data into the relational database.
Disclosure of Invention
The invention aims to provide a method for storing IEC61850 report data into a relational database based on a CSV mapping file, and aims to solve the problems that the relational database used by a common system in the prior art is defined in a table name and column name mode for data storage, and no natural corresponding mapping mode exists between an address character string of a hierarchical structure and a table and a column of the database.
In order to achieve the purpose, the technical scheme of the invention is as follows: the method for storing IEC61850 report data into a relational database based on a CSV mapping file comprises the following steps:
step S1, editing and generating a table format file of the warehousing relation mapping table in the CSV file format, where the table format file includes three columns of data: the method comprises the following steps that (1) a database table name character string, a column name character string and an IEC61850 address character string are arranged;
step S2, analyzing the CSV mapping file to generate a warehousing mapping relation through a CSV file mapping relation analysis module;
step S3, receiving IEC61850 report data through an IEC61850 report data receiving module to form a buffer data structure of the EC61850 address character string and the IEC61850 report data value;
step S4, forming a warehousing SQL statement according to the warehousing mapping relation and the cache structure of the IEC61850 report data through a warehousing SQL statement organization module, and executing;
step S5, repeating steps S3 and S4 for processing the IEC61850 report data.
Further, based on step S1, the specific implementation manner of defining the data meaning corresponding to the tabular form file of the CSV file mapping file is as follows:
defining a tabular form in the CSV mapping file into three columns;
the column name string and the IEC61850 address string are defined as phase-class meanings for processing the measurement, and wildcards "#" are used instead of the single-phase a, the single-phase B and the single-phase C, respectively, the wildcards "# #" are used instead of the interphase AB, the interphase BC and the interphase CA, and the wildcards "%" are used to represent the array type data subscripts of IEC 61850.
Further, based on step S2, the specific implementation manner of the CSV file mapping relationship parsing module parsing the CSV mapping file to generate the warehousing mapping relationship is as follows:
the CSV file mapping relation analysis module reads in CSV mapping files line by line, uses commas to separate read-in line character strings to obtain required database table names, column name character strings and IEC61850 address character strings, then uses single-phase A, B, C to replace ' single-phase wildcards, uses AB, BC and CA to replace ' # ' phase-to-phase wildcards, retains array data subscripts represented by ' percent ', and then establishes arrays of IEC61850 address character strings and key value pairs of database table names and column names.
Further, based on step S3, the IEC61850 report data receiving module sets the data index datareference bit of the selection region OptFlds of the report object to be 1 when registering the subscription report according to the IEC61850 specification, so as to ensure that the received report data includes the IEC61850 address character string or the data index corresponding to the report data value, and then the IEC61850 report data issued by the receiving apparatus can form the cache data structure of the IEC61850 address character string and the IEC61850 report data value.
Furthermore, the buffer structure is formed in such a way that each IEC61850 report data corresponds to one IEC61850 character string and a key-value pair corresponding to a buffer data value, and all the key-value pairs in the IEC61850 report data form a complete key-value pair queue.
Further, based on step S4, the specific implementation of forming the warehousing SQL statement is as follows: the warehousing SQL sentence organization module acquires an IEC61850 address character string and an IEC61850 report data value of each piece of data by traversing a cache data structure formed by the IEC61850 report data receiving module, acquires a table name and a column name of the report data value to be stored in the database by searching an IEC61850 address character string and a database table name and column name key value pair queue established by the CSV file mapping relation analysis module, and then combines all columns and data corresponding to the same table of the database to form a warehousing SQL sentence character string and execute the warehousing SQL sentence character string.
Further, when the entry SQL statement organization module obtains the table names and the column names of the database, in the common data class of IEC61850, the ARRAY type ARRAY is used to represent the measurement values of multiple corresponding harmonics, if such harmonic data measurement values exist, the subscript of the ARRAY type data is extracted on the basis of replacing the corresponding phase, the ARRAY subscript of the address character string is replaced by "%" and then the table name and the column name of the corresponding database are searched, and if the table name and the column name contain the wildcard "%" and then the wildcard is replaced by the corresponding ARRAY subscript number, thereby obtaining the actual table names and column names of the database.
The invention achieves the purpose of flexibly configuring and defining the IEC61850 report data to be stored in the database by using the CSV file which is simple, easy to edit and easy to resolve to define the mapping relation of the IEC61850 address character string stored in the relational database table and by matching the CSV file mapping relation resolving module, the IEC61850 report data receiving module and the warehousing SQL sentence organizing module, is suitable for automatic systems or devices which need to store the IEC61850 data in the relational databases of various application occasions, and solves the problems in the prior art.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description, serve to explain the principles of the invention, and are best understood by reference to the accompanying drawings in which:
FIG. 1 is a schematic flow chart of a simulation method according to an embodiment of the present invention;
fig. 2 is a table format diagram of a CSV mapping file according to an embodiment of the invention.
Detailed Description
The technical solution of the present invention is further described in detail with reference to the accompanying drawings and examples.
As shown in fig. 1-2, the method for storing IEC61850 report data into a relational database based on a CSV mapping file according to the present invention includes the following steps:
step S1, editing and generating a table format file of the warehousing relation mapping table in the CSV file format, where the table format file includes three columns of data: the method comprises the following steps that (1) a database table name character string, a column name character string and an IEC61850 address character string are arranged;
step S2, analyzing the CSV mapping file to generate a warehousing mapping relation through a CSV file mapping relation analysis module;
step S3, receiving IEC61850 report data through an IEC61850 report data receiving module to form an EC61850 address character string and data value cache structure;
step S4, forming a warehousing SQL sentence according to the warehousing mapping relation and the cache structure of the IEC61850 report data through a warehousing SQL sentence organization module, and executing;
step S5, repeating steps S3 and S4 for processing IEC61850 report data.
As an embodiment of the present invention, based on step S1, the specific implementation manner of defining the data meaning corresponding to the table format of the CSV file mapping file is as follows:
defining a tabular form in the CSV mapping file into three columns;
column name strings and IEC61850 address strings are defined as phase class meanings for processing measurements, and wildcards "#" are used instead of single-phase class a, single-phase class B and single-phase class C, respectively, wildcards "# #" are used instead of interphase class AB, interphase class BC and interphase class CA, and wildcards "%" are used to represent array type data subscripts for IEC 61850.
As an embodiment of the present invention, based on step S2, the specific implementation manner of the CSV file mapping relationship parsing module parsing the CSV mapping file to generate the warehousing mapping relationship is as follows:
the CSV file mapping relation analysis module reads in CSV mapping files line by line, uses commas to separate read-in line character strings to obtain required database table names, column name character strings and IEC61850 address character strings, then uses single-phase A, B, C to replace ' single-phase wildcards, uses AB, BC and CA to replace ' # ' phase-to-phase wildcards, retains array data subscripts represented by ' percent ', and then establishes arrays of IEC61850 address character strings and key value pairs of database table names and column names.
As an embodiment of the present invention, based on step S3, the buffer structure is formed in that each IEC61850 report data corresponds to one IEC61850 string and the key-value pair corresponding to the buffer data value, and all the key-value pairs in the IEC61850 report data form a complete key-value pair queue.
As an embodiment of the present invention, based on step S3, the IEC61850 report data receiving module sets the data index reference bit of the selection region OptFlds of the report object to be 1 when registering the subscription report according to the IEC61850 standard, so as to ensure that the received report data includes the IEC61850 address character string or the data index corresponding to the report data value, and then the IEC61850 report data issued by the receiving apparatus may form the cache data structure of the IEC61850 address character string and the IEC61850 report data value.
As an embodiment of the present invention, based on step S4, a specific implementation manner of forming the warehousing SQL statement is as follows: the warehousing SQL sentence organization module acquires the IEC61850 address character string and the IEC61850 report data value of each piece of data by traversing the cache data structure formed by the IEC61850 report data receiving module, namely, each IEC61850 address character string in the buffer data key value pair queue of the received IEC61850 report data is compared with the warehousing mapping relation, and processing wildcard symbol "#", wildcard symbol "# #" and wildcard symbol "%", if the above comparison information exists, extracting the corresponding phase and the array type data subscript of IEC61850, then, the table name and the column name of the report data value which should be stored in the database are obtained by searching the IEC61850 address character string established by the CSV file mapping relation analysis module and the queue of the key value pair of the table name and the column name of the database, and then all columns and data corresponding to the same table of the database are merged to form a warehoused SQL statement character string, and the warehouse entry SQL statement character string is executed.
In an embodiment of the present invention, when the entry SQL statement organization module obtains a table name and a column name of a database, in a public data class of IEC61850, an ARRAY type ARRAY is used to represent a measurement value of multiple corresponding harmonics, if such a harmonic data measurement value exists, a subscript of ARRAY type data is extracted on the basis of replacing a corresponding phase, the ARRAY subscript of the address character string is replaced with a "%" and then the table name and the column name of the corresponding database are searched, and if a wildcard character "%" is found in the table name and the column name, the wildcard character is replaced with a corresponding ARRAY subscript number, thereby obtaining an actual table name and a column name of the database.
In an embodiment of the invention, the method for storing IEC61850 report data into the relational database specific definition table in a flexible configuration manner based on the CSV mapping file, the CSV mapping file can be modified by using a convenient table editing tool or a text editing tool, the requirement of different application occasions for storing IEC61850 data into a relational database is met, the problems of learning difficulty and maintenance difficulty caused by program hard coding or other definition modes are avoided, meanwhile, in the invention, when the CSV file is defined, the special wildcards are used for representing single-phase, interphase phase and the array type data subscript of IEC61850, thereby simplifying the definition content, enriching the expression capacity of the definition file, well meeting the characteristic of phase separation of the power system data, and the problem of complicated mapping definition caused by the practical situation of using an array mode to express when the power quality data can reach 50 times of harmonic data is solved.
The above-mentioned embodiments, objects, technical solutions and advantages of the present invention are further described in detail, it should be understood that the above-mentioned embodiments are only specific embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (7)
1. The method for storing IEC61850 report data into a relational database based on a CSV mapping file comprises the following steps:
step S1, editing and generating a table format file of the warehousing relation mapping table in the CSV file format, where the table format file includes three columns of data: the method comprises the following steps that (1) a database table name character string, a column name character string and an IEC61850 address character string are arranged;
step S2, analyzing the CSV mapping file to generate a warehousing mapping relation through a CSV file mapping relation analysis module;
step S3, receiving IEC61850 report data through an IEC61850 report data receiving module to form a buffer data structure of the EC61850 address character string and the IEC61850 report data value;
step S4, forming a warehousing SQL statement according to the warehousing mapping relation and the cache structure of the IEC61850 report data through a warehousing SQL statement organization module, and executing;
step S5, repeating steps S3 and S4 for processing the IEC61850 report data.
2. The method for storing IEC61850 report data in a relational database based on CSV mapping file according to claim 1, wherein: based on step S1, the specific implementation manner of defining the data meaning corresponding to the tabular form file of the CSV file mapping file is as follows:
defining a tabular form in the CSV mapping file into three columns;
the column name string and the IEC61850 address string are defined as phase-class meanings for processing the measurement, and wildcards "#" are used instead of the single-phase a, the single-phase B and the single-phase C, respectively, the wildcards "# #" are used instead of the interphase AB, the interphase BC and the interphase CA, and the wildcards "%" are used to represent the array type data subscripts of IEC 61850.
3. The method for storing IEC61850 report data in a relational database based on CSV mapping file according to claim 1, wherein: based on step S2, the specific implementation manner of the CSV file mapping relationship parsing module parsing the CSV mapping file to generate the warehousing mapping relationship is as follows:
the CSV file mapping relation analysis module reads in CSV mapping files line by line, uses commas to separate read-in line character strings to obtain required database table names, column name character strings and IEC61850 address character strings, then uses single-phase A, B, C to replace ' single-phase wildcards, uses AB, BC and CA to replace ' # ' phase-to-phase wildcards, retains array data subscripts represented by ' percent ', and then establishes arrays of IEC61850 address character strings and key value pairs of database table names and column names.
4. The method for storing IEC61850 report data in a relational database based on CSV mapping file according to claim 1, wherein: based on step S3, the IEC61850 report data receiving module sets the data index reference bit of the selected region OptFlds of the report object to 1 when registering the subscription report according to the IEC61850 standard, so as to ensure that the received report data includes the IEC61850 address character string or the data index corresponding to the report data value, and then the IEC61850 report data issued by the receiving device can form the cache data structure of the IEC61850 address character string and the IEC61850 report data value.
5. The method for storing IEC61850 report data in a relational database based on CSV mapping file according to claim 4, wherein: the buffer structure is characterized in that each IEC61850 report data corresponds to an IEC61850 character string and a key-value pair corresponding to a buffer data value, and all the key-value pairs in the IEC61850 report data form a complete key-value pair queue.
6. The method for storing IEC61850 report data in a relational database based on CSV mapping file according to claim 1, wherein: based on step S4, the specific implementation of forming the warehousing SQL statement is as follows: the warehousing SQL sentence organization module acquires an IEC61850 address character string and an IEC61850 report data value of each piece of data by traversing a cache data structure formed by the IEC61850 report data receiving module, acquires a table name and a column name of the report data value to be stored in the database by searching an IEC61850 address character string and a database table name and column name key value pair queue established by the CSV file mapping relation analysis module, and then combines all columns and data corresponding to the same table of the database to form a warehousing SQL sentence character string and execute the warehousing SQL sentence character string.
7. The method for storing IEC61850 report data in a relational database based on CSV mapping file according to claim 6, wherein: when the entry SQL sentence organization module obtains the table names and the column names of the database, in a public data class of IEC61850, an ARRAY type ARRAY is used for representing a measurement value of corresponding multiple harmonics, if the measurement value of the harmonic data exists, a subscript of ARRAY type data is extracted on the basis of replacing a corresponding phase, the ARRAY subscript of the address character string is replaced by a "%" and then the table name and the column name of the corresponding database are searched, and if the table name and the column name contain a wildcard character "%" are found, the wildcard character is replaced by a corresponding ARRAY subscript number, so that the actual table names and the column names of the database are obtained.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110207571.2A CN112905642B (en) | 2021-02-24 | 2021-02-24 | Method for storing IEC61850 report data into relational database based on CSV mapping file |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110207571.2A CN112905642B (en) | 2021-02-24 | 2021-02-24 | Method for storing IEC61850 report data into relational database based on CSV mapping file |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112905642A true CN112905642A (en) | 2021-06-04 |
| CN112905642B CN112905642B (en) | 2023-06-20 |
Family
ID=76107571
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110207571.2A Active CN112905642B (en) | 2021-02-24 | 2021-02-24 | Method for storing IEC61850 report data into relational database based on CSV mapping file |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112905642B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113642408A (en) * | 2021-07-15 | 2021-11-12 | 杭州玖欣物联科技有限公司 | Method for processing and analyzing picture data in real time through industrial internet |
| CN114006954A (en) * | 2021-10-19 | 2022-02-01 | 许继集团有限公司 | GOOSE message receiving and sending method and device |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1687930A (en) * | 2005-05-25 | 2005-10-26 | 北京四方继保自动化股份有限公司 | Method of implementing IEC 61850 information indirect access real-time database |
| US20080005197A1 (en) * | 2006-06-29 | 2008-01-03 | Kyusun Chang | Dynamic report mapping apparatus to physical data source when creating report definitions for information technology service management reporting for peruse of report definition transparency and reuse |
| US20080263018A1 (en) * | 2007-04-20 | 2008-10-23 | Computer Associates Think, Inc. | Method and System for Mapping Business Objects to Relational Database Tables |
| CN101694952A (en) * | 2009-09-28 | 2010-04-14 | 国电南京自动化股份有限公司 | Method for generating embedded telecontrol system definitions by IEC61850 SCD files |
| CN102779156A (en) * | 2012-05-31 | 2012-11-14 | 南京南瑞继保电气有限公司 | Configuration method for database of communication device in digital substation |
| CN102938581A (en) * | 2012-10-26 | 2013-02-20 | 广东电网公司电力科学研究院 | Communication service method and system for on-line monitoring of transformer substation |
| CN104899225A (en) * | 2014-03-07 | 2015-09-09 | 北京四达时代软件技术股份有限公司 | Object relational mapping method and device as well as processor |
| CN111913935A (en) * | 2020-07-09 | 2020-11-10 | 河北工业大学 | Wind power plant centralized control center SCADA system based on CIM model |
-
2021
- 2021-02-24 CN CN202110207571.2A patent/CN112905642B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1687930A (en) * | 2005-05-25 | 2005-10-26 | 北京四方继保自动化股份有限公司 | Method of implementing IEC 61850 information indirect access real-time database |
| US20080005197A1 (en) * | 2006-06-29 | 2008-01-03 | Kyusun Chang | Dynamic report mapping apparatus to physical data source when creating report definitions for information technology service management reporting for peruse of report definition transparency and reuse |
| US20080263018A1 (en) * | 2007-04-20 | 2008-10-23 | Computer Associates Think, Inc. | Method and System for Mapping Business Objects to Relational Database Tables |
| CN101694952A (en) * | 2009-09-28 | 2010-04-14 | 国电南京自动化股份有限公司 | Method for generating embedded telecontrol system definitions by IEC61850 SCD files |
| CN102779156A (en) * | 2012-05-31 | 2012-11-14 | 南京南瑞继保电气有限公司 | Configuration method for database of communication device in digital substation |
| CN102938581A (en) * | 2012-10-26 | 2013-02-20 | 广东电网公司电力科学研究院 | Communication service method and system for on-line monitoring of transformer substation |
| CN104899225A (en) * | 2014-03-07 | 2015-09-09 | 北京四达时代软件技术股份有限公司 | Object relational mapping method and device as well as processor |
| CN111913935A (en) * | 2020-07-09 | 2020-11-10 | 河北工业大学 | Wind power plant centralized control center SCADA system based on CIM model |
Non-Patent Citations (4)
| Title |
|---|
| QIAO ZHI: "ORM(对象关系映射)", Retrieved from the Internet <URL:https://www.cnblogs.com/qlqwjy/p/7782207.html> * |
| 李忠明 等: "基于IEC 61850标准的传统水电站智能化改造关键技术研究", 华电技术 * |
| 李蓓: "基于关系模型映射的IEC 61850 SCL配置器建模", 电网技术 * |
| 王一苇: "电网调度机器人混合数据库构建及应用研究", 工程科技Ⅱ辑 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113642408A (en) * | 2021-07-15 | 2021-11-12 | 杭州玖欣物联科技有限公司 | Method for processing and analyzing picture data in real time through industrial internet |
| CN114006954A (en) * | 2021-10-19 | 2022-02-01 | 许继集团有限公司 | GOOSE message receiving and sending method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112905642B (en) | 2023-06-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108446313B (en) | Data format conversion method and device | |
| CN104317864B (en) | A method of the information model automatic identification based on IEC61850 logical nodes | |
| CN112905642B (en) | Method for storing IEC61850 report data into relational database based on CSV mapping file | |
| CN102867049B (en) | Chinese PINYIN quick word segmentation method based on word search tree | |
| CN101727502A (en) | Data query method, data query device and data query system | |
| CN111309868B (en) | Knowledge graph construction and retrieval method and device | |
| CN104573022A (en) | Data query method and device for HBase | |
| CN106528786A (en) | Method and system for rapidly transferring multi-source heterogeneous power grid big data to HBase | |
| CN104750825A (en) | Intelligent substation SCD document rapid analysis method | |
| CN113901135B (en) | Cross-source heterogeneous data intelligent visual analysis display method and equipment | |
| CN102999600A (en) | Method and system for automatically generating embedded database | |
| CN104572978A (en) | User behavior counting method for power scheduling automatic system based on log | |
| CN104820700B (en) | Processing method of unstructured data of transformer substation | |
| CN110569243B (en) | Data query method, data query plug-in and data query server | |
| CN114443656A (en) | Customizable automated data model analysis tool and use method thereof | |
| CN111984673B (en) | Fuzzy retrieval method and device for tree structure of power grid electric energy metering system | |
| CN109271560A (en) | A kind of link data critical word querying method based on tree template | |
| CN103902651A (en) | Cloud code query method and device based on MongoDB | |
| CN111522820A (en) | Data storage structure, storage retrieval method, system, device and storage medium | |
| CN115937881A (en) | Method for automatically identifying content of knowledge graph construction standard form | |
| CN115599897A (en) | Power distribution network equipment intelligent question-answering system construction method and system based on knowledge graph | |
| KR102351846B1 (en) | Query Optimization Method using Index Merge on Distributed Database | |
| CN113239039A (en) | Dynamic data storage method, query method, management method and management system | |
| CN113284573A (en) | Method and device for searching document database | |
| CN118312524B (en) | Table recall method, apparatus, electronic device and medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |