SYSTEM AND METHODS FOR REAL-TIME DETECTION, CORRECTION, AND TRANSFORMATION OF TIME SERIES DATA

• US 20140032506A1
• Filed: 06/12/2013
• Published: 01/30/2014
• Est. Priority Date: 06/12/2012
• Status: Abandoned Application

• Current Assignee: Quality Attributes Software Incorporated
• Original Assignee: Quality Attributes Software Incorporated
• Inventors: Hoey, Bill, Dassi, Nasser
• Application Number:
  US13/916,513
• Publication Number:
  US 20140032506A1
• Time in Patent Office: Days
• US Class Current: 707/691
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors

Abstract

Systems and methods for time series data error detection, correction, and transformation may detect gaps and anomalies in time series data, such as from a meter device, and may correct the gaps and adjust the anomalies prior to long-term record storage. Data forecasting may be used to correct the errors in the time series data. The error corrected data may be regarded as an actual set of time series data and become a base data set against which additional heuristic projections are generated. In addition, the time series data may be transformed into any number of physical and virtual device hierarchies that represent the underlying data source configurations, and may then be stored in an analytical database for further analysis. The hierarchies may be irregular and may change over time.

Claims

1. A computer-implemented method for evaluating a time series data point from a meter device, comprising:

receiving a time series data point corresponding to a meter reading;

performing an error detection analysis on the time series data point;

performing an error correction procedure on the time series data point in response to an error found by the error detection analysis;

storing the time series data point in a warehouse database;

retrieving the time series data point from the warehouse database;

transforming the time series data point according to a configuration definition; and

storing the transformed time series data point in an analytical database.

2. A computer-implemented method according to claim 1, wherein the error detection analysis comprises at least one of gap detection and anomaly detection.

3. A computer-implemented method according to claim 2, wherein the anomaly detection comprises a regression analysis.

4. A computer-implemented method according to claim 1, wherein the error correction procedure comprises estimating an actual value of the time series data point based on at least one of a raw time series data point, a time series data point in the warehouse database, and a time series data point in the analytical database.

5. A computer-implemented method according to claim 4, wherein estimating the actual value of the time series data point is based on an external influencing factor.

6. A computer-implemented method according to claim 1, wherein the time series data point corresponding to a meter reading is received from the analytical database.

7. The computer-implemented method of claim 1, wherein the analytical database comprises an online analytical processing database.

8. The computer-implemented method of claim 1, wherein the configuration definition describes an irregular hierarchy of meter devices.

9. A non-transitory computer-readable medium storing computer-executable instructions for evaluating a time series data point from a meter device, wherein the instructions are configured to cause a computer to:

receive a time series data point corresponding to a meter reading;

perform an error detection analysis on the time series data point;

perform an error correction procedure on the time series data point in response to an error found by the error detection analysis;

store the time series data point in a warehouse database;

retrieve the time series data point from the warehouse database;

transform the time series data point according to a configuration definition; and

store the transformed time series data point in an analytical database.

10. A non-transitory computer-readable medium storing computer-executable instructions according to claim 9, wherein the error detection analysis comprises at least one of gap detection and anomaly detection.

11. A non-transitory computer-readable medium storing computer-executable instructions according to claim 10, wherein the anomaly detection comprises a regression analysis.

12. A non-transitory computer-readable medium storing computer-executable instructions according to claim 9, wherein the error correction procedure comprises estimating an actual value of the time series data point based on at least one of a raw time series data point, a time series data point in the warehouse database, and a time series data point in the analytical database.

13. A non-transitory computer-readable medium storing computer-executable instructions according to claim 12, wherein estimating the actual value of the time series data point is based on an external influencing factor.

14. A non-transitory computer-readable medium storing computer-executable instructions according to claim 9, wherein the time series data point corresponding to a meter reading is received from the analytical database.

15. A non-transitory computer-readable medium storing computer-executable instructions according to claim 9, wherein the analytical database comprises an online analytical processing database.

16. A non-transitory computer-readable medium storing computer-executable instructions according to claim 9, wherein the configuration definition describes an irregular hierarchy of meter devices.

17. A time series data error detection, correction, and transformation system, comprising:

an error detection and correction module configured to;

receive a time series data point corresponding to a meter reading;

perform an error detection analysis on the time series data point; and

perform an error correction procedure on the time series data point in response to an error found by the error detection analysis;

a data warehouse communicatively linked with the error detection and correction module and configured to store the time series data point;

a configuration definition store configured to store a configuration definition;

a transformation module communicatively linked with the data warehouse module and the configuration definition store, and configured to;

retrieve a configuration definition from the configuration definition store;

retrieve the time series data point from the data warehouse; and

transform the time series data point according to the configuration definition; and

an analytical database communicatively linked with the transformation module and the error detection and correction module, and configured to store the transformed time series data point.

18. A system according to claim 17, wherein the error detection analysis comprises at least one of gap detection and anomaly detection.

19. A system according to claim 17, wherein the error correction procedure comprises estimating the actual value of the time series data point based on at least one of a raw time series data point, a time series data point in the warehouse database, and a time series data point in the analytical database.

20. A system according to claim 17, wherein the configuration definition describes an irregular hierarchy of meter devices.