System and method for applying deadband filtering to time series data streams to be stored within an industrial process manufacturing/production database
First Claim
1. A database server compression and storage facility that operates upon a stream of data points received from a data source in a control environment, to reduce the volume of data points that are stored in a database, wherein each data point specifies a value and timestamp, by discarding received data points that do not significantly depart from a signal trend established by a sequence of received data points from the streaming time stamped data source, a database server compression and storage facility comprising:
- a database a compression test sequence applied, upon receiving a new data point, to at least the received new data point, a held over data point and a last data point stored in the database; and
a time override that forces storing a candidate data point without regard to whether the candidate point would be stored as a result of applying the compression test sequence, upon receiving the new data points;
wherein the candidate data point is the held over data point; and
wherein the time override further comprises a real-time window timer that measures an elapsed period after the time stamp of the held over point and stores the held over data point in the database in response to a specified period, measured by the real-time window timer, expiring.
4 Assignments
0 Petitions
Accused Products
Abstract
A control system database server is disclosed that includes a data compression facility that implements a compression test sequence on streams of time stamped data points rendered by components of a control system. A deadband/time override is incorporated into the compression test sequence to ensure that a previously received data point, within the stream of received data points, is saved within a designated time period even if the compression test sequence would have determined that the data point be discarded. The series of compressed/tabled data points, corresponding to the received steams of data points, are thereafter provided by the historian to requesting client applications that, by way of example, retrieve the compressed, time stamped data point streams for the purpose of constructing and displaying trend graphs.
-
Citations
19 Claims
-
1. A database server compression and storage facility that operates upon a stream of data points received from a data source in a control environment, to reduce the volume of data points that are stored in a database, wherein each data point specifies a value and timestamp, by discarding received data points that do not significantly depart from a signal trend established by a sequence of received data points from the streaming time stamped data source, a database server compression and storage facility comprising:
-
a database a compression test sequence applied, upon receiving a new data point, to at least the received new data point, a held over data point and a last data point stored in the database; and a time override that forces storing a candidate data point without regard to whether the candidate point would be stored as a result of applying the compression test sequence, upon receiving the new data points; wherein the candidate data point is the held over data point; and wherein the time override further comprises a real-time window timer that measures an elapsed period after the time stamp of the held over point and stores the held over data point in the database in response to a specified period, measured by the real-time window timer, expiring. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. In a control environment, a data compression method for reducing the volume of time stamped data points, received from a streaming data source, that are stored in a database, by discarding received data points that do not significantly depart from a signal trend established by a sequence of received data points from the streaming data source, the method comprising:
-
providing a compression test sequence that is applied, upon receiving a new data point, to at least the received data point, a held over data point and a last data point stored in the database; receiving the new data point after the held over data point and the last stored data point, and in response performing the further steps of; executing the compression test sequence; and applying a time override to force storage of a candidate data point that would otherwise be discarded as a result of the executing step; wherein the candidate data point is the held over data point; and wherein the applying step comprises measuring, by a real-time window timer, an elapsed period after the time stamp of the held over point and storing the held over data point in the database in response to a specified period, measured by the real-time window timer, expiring. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. A computer-readable medium containing computer-executable instructions for facilitating performing, in a control environment, a data compression method for reducing the volume of time stamped data points, received from a streaming data source, that are stored in a database, by discarding received data points that do not significantly depart from a signal trend established by a sequence of received data points from the streaming data source, the computer-executable instructions facilitating performing the method comprising:
-
providing a compression test sequence that is applied, upon receiving a new data point, to at least the received data point, a held over data point and a last data point stored in the database; receiving the new data point after the held over data point and the last stored data point, and in response performing the further steps of; executing the compression test sequence; and applying a time override to force storage of a candidate data point that would otherwise be discarded as a result of the executing step; wherein the candidate data point is the held over data point; and wherein the applying step comprises measuring, by a real-time window timer, an elapsed period after the time stamp of the held over point and storing the held over data point in the database in response to a specified period, measured by the real-time window timer, expiring. - View Dependent Claims (15, 16, 17, 18, 19)
-
Specification