Supercharge Your Innovation With Domain-Expert AI Agents!

Method for storing IEC61850 report data into relational database based on CSV mapping file

A technology for mapping files and databases, applied in the field of power system substation automation systems, can solve the problem of no corresponding mapping between address strings and database tables and columns, etc.

Pending Publication Date: 2021-06-04
南京久为自动化科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The object of the present invention is to provide the method that IEC61850 report data is stored in the relational database based on the CSV mapping file, aims to solve the problem that the relational database used by the general system in the prior art is defined in the form of table name and column name for data storage, and There is no natural corresponding mapping method between the address string of the hierarchical structure and the database table and column

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for storing IEC61850 report data into relational database based on CSV mapping file
  • Method for storing IEC61850 report data into relational database based on CSV mapping file

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The technical solution of the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments.

[0026] Such as Figure 1-2 Shown, the method for storing the IEC61850 report data into a relational database based on the CSV mapping file of the present invention may further comprise the steps:

[0027] Step S1, editing and generating a warehousing relationship mapping table format file in the form of a CSV file, wherein the table format file includes three columns of data: database table name string, column name string and IEC61850 address string;

[0028] Step S2, analyzing the CSV mapping file through the CSV file mapping relationship analysis module to generate the storage mapping relationship;

[0029] Step S3, through the IEC61850 report data receiving module, receive the IEC61850 report data, and form the cache structure of the EC61850 address character string and data value;

[0030] Step S4, through the s...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for storing IEC61850 report data into a relational database based on a CSV mapping file, and the method comprises the following steps: S1, editing and generating a storage relational mapping table form file in a CSV file form, wherein the table form file comprises three columns of data: a database table name character string, a column name character string and an IEC61850 address character string; S2, analyzing the CSV mapping file through a CSV file mapping relation analysis module to generate a storage mapping relation; and S3, receiving the IEC61850 report data through an IEC61850 report data receiving module, and forming a cache structure of an IEC61850 address character string and a data value. The mapping relation of the IEC61850 address character string stored in the relational database table is defined by using the CSV file which is simple in format and easy to edit and analyze, the method is suitable for an automatic system or device which needs to store IEC61850 data in relational databases of various application occasions, and the existing technical problems are solved.

Description

technical field [0001] The invention relates to the technical field of power system substation automation systems, in particular to a method for storing IEC61850 report data into a relational database based on a CSV mapping file. Background technique [0002] The IEC61850 standard is the latest "Substation Communication Network and System" series standards designated by the International Electrotechnical Commission TC57 Working Group to solve the new interoperability problems faced by the substation automation system. This standard is supported by most mainstream manufacturers at home and abroad, and has become the only unified standard in the field of substation automation in the world. [0003] With the promotion and application of protection devices, measurement and control devices, and power quality devices for smart substations based on the IEC61850 standard, how to flexibly and conveniently store the data sent by the IEC61850 report into the system database is a proble...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/2455G06F16/25G06F16/28G06F16/22G06Q50/06
CPCG06F16/24552G06F16/25G06F16/284G06F16/2228G06Q50/06Y04S10/50
Inventor 李忠明袁珂俊李纪云詹成国
Owner 南京久为自动化科技有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com