A cross-section reconstruction method of working condition information based on multiple historical data tables of database

Abstract

The invention discloses a database multiple-historical data table-based working condition information section reconstruction method. The method includes the following steps that: a section time node is determined, and working condition data when timestamps in historical data tables are superposed with the section time node are adopted as section working condition data; whether section working condition data have been extracted from each historical data table is judged; if the section working condition data have not been extracted from each historical data table, working condition data when timestamps are approximate to the section time node are called from historical data tables from which section working condition data have not been extracted are adopted as backup data, and then, time node information which are represented by the timestamps corresponding to the backup data are converted into time node information superposed with the section time node through a timestamp conversion model, and the backup data which have been subjected to timestamp conversion are adopted as section working condition data. According to the database multiple-historical data table-based working condition information section reconstruction method of the invention, the timestamp conversion model is adopted, problems existing in timestamp consistency in data acquisition with second-level precision can be solved; and since PMU devices are not needed to be additionally adopted, cost can be greatly reduced.

Description

technical field [0001] The invention relates to the technical field of data statistics, in particular to a section reappearance method of working condition information based on multiple historical data tables of a database. Background technique [0002] When doing event or accident analysis, it is necessary to check the cross-section information at a certain time. Generally, there are two ways: one is to store the working condition information at this time in the same historical data table; the other is to use the PMU ( PhasorMeasurement Unit, power system synchrophasor measurement device) equipment collection to ensure that the time stamps of all collected data point to the same time. The purpose of these two methods is to be able to find the working condition information at the moment when the event or accident occurs. The working condition information at the same time has practical significance and value for analyzing events or faults at this time. However, the former m...

AI Technical Summary

Problems solved by technology

However, the former method needs to change the table structure of the database as the number of measuring points of the working condition information increases, and the database service needs to be shut down to change the table structure, which is absolutely not allowed for the application put into the production system; the latter method This method needs to increase the PMU equipment, which increases the cost of the entire system, and does not solve the disadvantages of the former method

Images