Abstract:As the basis of data management and analysis, data quality issues have increasingly become a research hotspot in related fields, which contributes to optimization of big data and artificial intelligence technology.Generally, physical failures or technical defects in data collectors and recorders cause anomalies in collected data.These anomalies will strongly impact on subsequent data analysis and artificial intelligence processes; thus, data should be processed and cleaned accordingly before application.Existing repairing methods based on smoothing will cause a large number of originally correct data points being over-repaired into wrong values.The constraint-based methods such as sequential dependency and SCREEN cannot accurately repair data under complex conditions since the constraints are relatively simple.A time series data repairing method under multi-speed constraints is further proposed based on the principle of minimum repairing.Then, dynamic programming is used to solve the problem of data anomalies with optimal repairing.Specifically, multiple speed intervals are set to constrain time series data, and a series of candidate repairing points are formed for each data point according to the speed constraints.Next, the optimal repair solution is selected from these candidates based on the dynamic programming method.With regard to the feasibility study of this method, an artificial dataset, two real datasets, and another real dataset with real anomalies are employed for experiments in case of different rates of anomalies and data sizes.Experimental results demonstrate that, compared with the existing methods based on smoothing or constraints, the proposed method has better performance in terms of RMS errors and time cost.In addition, the investigation of clustering and classification accuracy with several datasets reveals the impact of data quality on subsequent data analysis and artificial intelligence.The proposed method can improve the quality of data analysis and artificial intelligence results.

On Repairing Timestamps for Regular Interval Time Series.

Cleaning Timestamps with Temporal Constraints

Time Series Data Cleaning: From Anomaly Detection to Anomaly Repairing (Technical Report)

Misplaced Subsequences Repairing with Application to Multivariate Industrial Time Series Data

Time Series Data Cleaning under Expressive Constraints on Both Rows and Columns

Time Series Data Cleaning under Multi-speed Constraints

Time Series Data Cleaning Based on Dynamic Speed Constraints.

EXPERIENCE: Algorithms and Case Study for Explaining Repairs with Uniform Profiles over IoT Data

Time Series Data Quality Enhancing Based on Pattern Alignment.

TsQuality: Measuring Time Series Data Quality in Apache IoTDB

Leveraging Currency for Repairing Inconsistent and Incomplete Data (extended Abstract).

Time-of-day Breakpoints Optimisation Through Recursive Time Series Partitioning

Time Series Data Cleaning with Regular and Irregular Time Intervals

A Novel Cost-Based Model for Data Repairing

An Improvement of Time-Reassigned Synchrosqueezing Transform Algorithm and Its Application in Mechanical Fault Diagnosis

Repairing Data Through Regular Expressions

Time Series Cleaning Under Variance Constraints.

STAP: A Spatio-Temporal Correlative Estimating Model for Improving Quality of Traffic Data

Sequence Pattern Matching over Time-Series Data with Temporal Uncertainty

Real-Time Repair of Business Processes Based on Alternative Operations in Case of Uncertainty

Improve3C: Data Cleaning on Consistency and Completeness with Currency.