CurrentClean: Spatio-Temporal Cleaning of Stale Data
Authors:
- Zheng ZhengZZZheng Zheng
- Fei ChiangFCFei Chiang
- 1 April 2019
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 172-183
Abstract
Data currency is imperative towards achieving up-to-date and accurate data analysis. Data is considered current if changes in real world entities are reflected in the database. When this does not occur, stale data arises. Identifying and repairing stale data goes beyond simply having timestamps. Individual entities each have their own update patterns in both space and time. These update patterns can be learned and predicted given available query logs. In this paper, we present CurrentClean, a probabilistic system for identifying and cleaning stale values. We introduce a spatio-temporal probabilistic model that captures the database update patterns to infer stale values, and propose a set of inference rules that model spatio-temporal update patterns commonly seen in real data. We recommend repairs to clean stale values by learning from past update values over cells. Our evaluation shows CurrentClean's effectiveness to identify stale values over real data, and achieves improved error detection and repair accuracy over state-of-the-art techniques.Keywords
This publication has 20 references indexed in Scilit:
- Temporal rules discovery for web data cleaningProceedings of the VLDB Endowment, 2015
- Incremental knowledge base construction using DeepDiveProceedings of the VLDB Endowment, 2015
- SCREEN2015
- KATARA2015
- The LLUNATIC data-cleaning frameworkProceedings of the VLDB Endowment, 2013
- Determining the relative accuracy of attributes2013
- Foundations of Data Quality ManagementSynthesis Lectures on Data Management, 2012
- Towards certain fixes with editing rules and master dataThe VLDB Journal, 2011
- Recognizing patterns in streams with imprecise timestampsProceedings of the VLDB Endowment, 2010
- The locality principleCommunications of the ACM, 2005