Database multiple-historical data table-based working condition information section reconstruction method

一种基于数据库多张历史数据表的工况信息断面重现方法

Abstract

本发明公开了一种基于数据库多张历史数据表的工况信息断面重现方法,包括以下步骤:确定断面时间节点,并调取各历史数据表中时间戳与断面时间节点重合的工况数据作为断面工况数据;判断是否已经从每张历史数据表中提取断面工况数据;如果否,则从未被提取断面工况数据的历史数据表中调取一个时间戳与断面时间节点接近的工况数据作为替补数据,然后通过时间戳转换模型将替补数据对应的时间戳所表示的时间节点信息转换为与断面时间节点重合的时间节点信息,并将时间戳转换后的替补数据作为断面工况数据。本发明中时间戳转换模型的设置,可以解决精度是秒级的数据采集的时间戳一致性问题,由于不需要增加PMU设备,大大降低了成本。
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.

Claims

Description

Topics

Download Full PDF Version (Non-Commercial Use)

Patent Citations (0)

    Publication numberPublication dateAssigneeTitle

NO-Patent Citations (0)

    Title

Cited By (0)

    Publication numberPublication dateAssigneeTitle