Data management method based on load channel dynamic column and related device

Abstract

The invention discloses a data management method based on a load channel dynamic column and a related device. The method comprises the following steps: creating a mapping table of a load channel; configuring an OBIS mapping field; creating a collection task, and obtaining the table name, the field name, the field type and the precision information; dynamically generating an SQL script; and executing the SQL script to obtain a database table structure of the database. According to the method disclosed by the invention, the OBIS design is adopted to provide basic data for dynamically creating the library table structure, and the acquisition task design is adopted to provide an implementation method for dynamically creating the library table structure. Compared with the prior art, the method has the advantages that the database table structure is dynamically created as required, the problem that the storage redundancy of the database table is too large or too small is solved, the database table and the acquisition system do not need to be changed when the acquisition system is platformized and the OBIS is newly added to the load channel, and when the existing channels are insufficient and the new load channel is started, the system is expanded in parallel , and the maintenance cost of the platform is reduced.

Description

technical field [0001] The present invention relates to the field of database table storage, and more specifically, relates to a data management method and a related device based on load channel dynamic columns. Background technique [0002] The load curve function is an essential function of the smart meter, and it is also the basis for power dispatching and planning by the power bureau. Due to regional differences and differences in power grid structures, and the IEC62056 standard system supports flexible configuration of frozen data items of load curves, customers in various regions have different requirements for frozen data items of load curves. The load data poses a certain degree of confusion. [0003] The traditional acquisition system adopts the following schemes to design the database table storage structure: 1. Based on the needs of market customers, select the commonly used OBIS and create the corresponding database table structure; 2. Create the corresponding d...

AI Technical Summary

Problems solved by technology

However, the above three solutions also correspond to three defects: 1. The database table storage is redundant and wastes storage space resources; 2. The load channel adds OBIS, and both the database table and the acquisition system need to be modified; 3. The database table storage is redundant. Yu Xiao, adding OBIS, the database table and collection system need to be changed

Images