Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/2882903.2915233acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article

Sequential Data Cleaning: A Statistical Approach

Published: 14 June 2016 Publication History
  • Get Citation Alerts
  • Abstract

    Errors are prevalent in data sequences, such as GPS trajectories or sensor readings. Existing methods on cleaning sequential data employ a constraint on value changing speeds and perform constraint-based repairing. While such speed constraints are effective in identifying large spike errors, the small errors that do not significantly deviate from the truth and indeed satisfy the speed constraints can hardly be identified and repaired. To handle such small errors, in this paper, we propose a statistical based cleaning method. Rather than declaring a broad constraint of max/min speeds, we model the probability distribution of speed changes. The repairing problem is thus to maximize the likelihood of the sequence w.r.t. the probability of speed changes. We formalize the likelihood-based cleaning problem, show its NP-hardness, devise exact algorithms, and propose several approximate/heuristic methods to trade off effectiveness for efficiency. Experiments on real data sets (in various applications) demonstrate the superiority of our proposal.

    References

    [1]
    P. Bohannon, M. Flaster, W. Fan, and R. Rastogi. A cost-based model and effective heuristic for repairing constraints by value modification. In SIGMOD, pages 143--154, 2005.
    [2]
    D. R. Brillinger. Time series: data analysis and theory, volume 36. Siam, 2001.
    [3]
    X. Chu, I. F. Ilyas, and P. Papotti. Holistic data cleaning: Putting violations into context. In ICDE, pages 458--469, 2013.
    [4]
    T. Dasu and J. M. Loh. Statistical distortion: Consequences of data cleaning. PVLDB, 5(11):1674--1683, 2012.
    [5]
    N. R. Draper and H. Smith. Applied regression analysis (2. ed.). Wiley series in probability and mathematical statistics. Wiley, 1981.
    [6]
    E. S. Gardner Jr. Exponential smoothing: The state of the art--part ii. International Journal of Forecasting, 22(4):637--666, 2006.
    [7]
    L. Golab, H. J. Karloff, F. Korn, A. Saha, and D. Srivastava. Sequential dependencies. PVLDB, 2(1):574--585, 2009.
    [8]
    S. R. Jeffery, M. N. Garofalakis, and M. J. Franklin. Adaptive cleaning for RFID data streams. In VLDB, pages 163--174, 2006.
    [9]
    R. M. Karp. Reducibility among combinatorial problems. In Proceedings of a symposium on the Complexity of Computer Computations, held at the IBM Thomas J. Watson Research Center, Yorktown Heights, New York., pages 85--103, 1972.
    [10]
    X. Li, X. L. Dong, K. Lyons, W. Meng, and D. Srivastava. Truth finding on the deep web: Is the problem solved? PVLDB, 6(2):97--108, 2012.
    [11]
    C. Mayfield, J. Neville, and S. Prabhakar. ERACER: a database approach for statistical inference and data cleaning. In SIGMOD, pages 75--86, 2010.
    [12]
    M. D. Smucker, J. Allan, and B. Carterette. A comparison of statistical significance tests for information retrieval evaluation. In CIKM, pages 623--632, 2007.
    [13]
    S. Song, C. Li, and X. Zhang. Turn waste into wealth: On simultaneous clustering and cleaning over dirty data. In SIGKDD, pages 1115--1124, 2015.
    [14]
    S. Song, A. Zhang, J. Wang, and P. S. Yu. SCREEN: stream data cleaning under speed constraints. In SIGMOD, pages 827--841, 2015.
    [15]
    M. Yakout, L. Berti-Equille, and A. K. Elmagarmid. Don't be scared: use scalable automatic repairing with maximal likelihood and bounded changes. In SIGMOD, pages 553--564, 2013.

    Cited By

    View all
    • (2024)IoTDQ: An Industrial IoT Data Analysis Library for Apache IoTDBBig Data Mining and Analytics10.26599/BDMA.2023.90200107:1(29-41)Online publication date: Mar-2024
    • (2024)Akane: Perplexity-Guided Time Series Data CleaningProceedings of the ACM on Management of Data10.1145/36549932:3(1-26)Online publication date: 30-May-2024
    • (2024)High Precision ≠ High Cost: Temporal Data Fusion for Multiple Low-Precision SensorsProceedings of the ACM on Management of Data10.1145/36549462:3(1-27)Online publication date: 30-May-2024
    • Show More Cited By

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    SIGMOD '16: Proceedings of the 2016 International Conference on Management of Data
    June 2016
    2300 pages
    ISBN:9781450335317
    DOI:10.1145/2882903
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 14 June 2016

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. likelihood-based cleaning
    2. speed changes

    Qualifiers

    • Research-article

    Funding Sources

    • China NSFC

    Conference

    SIGMOD/PODS'16
    Sponsor:
    SIGMOD/PODS'16: International Conference on Management of Data
    June 26 - July 1, 2016
    California, San Francisco, USA

    Acceptance Rates

    Overall Acceptance Rate 785 of 4,003 submissions, 20%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)76
    • Downloads (Last 6 weeks)6
    Reflects downloads up to 27 Jul 2024

    Other Metrics

    Citations

    Cited By

    View all
    • (2024)IoTDQ: An Industrial IoT Data Analysis Library for Apache IoTDBBig Data Mining and Analytics10.26599/BDMA.2023.90200107:1(29-41)Online publication date: Mar-2024
    • (2024)Akane: Perplexity-Guided Time Series Data CleaningProceedings of the ACM on Management of Data10.1145/36549932:3(1-26)Online publication date: 30-May-2024
    • (2024)High Precision ≠ High Cost: Temporal Data Fusion for Multiple Low-Precision SensorsProceedings of the ACM on Management of Data10.1145/36549462:3(1-27)Online publication date: 30-May-2024
    • (2023)Mobile Phone Data Feature Denoising for Expressway Traffic State EstimationSustainability10.3390/su1507581115:7(5811)Online publication date: 27-Mar-2023
    • (2023)Apache IoTDB: A Time Series Database for IoT ApplicationsProceedings of the ACM on Management of Data10.1145/35897751:2(1-27)Online publication date: 20-Jun-2023
    • (2023)Outlier Elimination and Reliability Assessment for Peak and Declining Time Series Datasets2023 IEEE International Conference on Data Mining Workshops (ICDMW)10.1109/ICDMW60847.2023.00083(593-600)Online publication date: 4-Dec-2023
    • (2023)Will my Flight be on Time? Learning from Part Failures to Predict Future Reliability2023 IEEE International Conference on Big Data (BigData)10.1109/BigData59044.2023.10386304(1803-1813)Online publication date: 15-Dec-2023
    • (2023)An automatic and integrated self-diagnosing system for the silting disease of drainage pipelines based on SSAE-TSNE and MS-LSTMTunnelling and Underground Space Technology10.1016/j.tust.2023.105076136(105076)Online publication date: Jun-2023
    • (2023)A dynamic balanced quadtree for real-time streaming dataKnowledge-Based Systems10.1016/j.knosys.2023.110291263(110291)Online publication date: Mar-2023
    • (2023)State of the art on quality control for data streamsComputer Science Review10.1016/j.cosrev.2023.10055448:COnline publication date: 1-May-2023
    • Show More Cited By

    View Options

    Get Access

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media