Proceedings

SPADE: A Semi-supervised Probabilistic Approach for Detecting Errors in Tables

Download BibTeX Cite

Proceedings of the Thirtieth International Joint Conference on Artificial Intelligence. Main Track. Pages 3543-3551.

https://doi.org/10.24963/ijcai.2021/488

© 2021 International Joint Conferences on Artificial Intelligence

Abstract

Error detection is one of the most important steps in data cleaning and usually requires extensive human interaction to ensure quality. Existing supervised methods in error detection require a significant amount of training data while unsupervised methods rely on fixed inductive biases, which are usually hard to generalize, to solve the problem. In this paper, we present SPADE, a novel semi-supervised probabilistic approach for error detection. SPADE introduces a novel probabilistic active learning model, where the system suggests examples to be labeled based on the agreements between user labels and indicative signals, which are designed to capture potential errors. SPADE uses a two-phase data augmentation process to enrich a dataset before training a deep learning classifier to detect unlabeled errors. In our evaluation, SPADE achieves an average F1-score of 0.91 over five datasets and yields a 10% improvement compared with the state-of-the-art systems.

  1. [Abedjan et al., 2016] Ziawasch Abedjan, Xu Chu, Dong Deng, Raul Castro Fernandez, Ihab F Ilyas, Mourad Ouz- zani, Paolo Papotti, Michael Stonebraker, and Nan Tang. Detecting data errors: Where are we and what needs to be done? Proceedings of the VLDB Endowment, 9(12):993- 1004, 2016.
  2. [Bach et al., 2017] Stephen H Bach, Matthias Broecheler, Bert Huang, and Lise Getoor. Hinge-loss markov random fields and probabilistic soft logic. The Journal of Machine Learning Research, 18(1):3846-3912, 2017.
  3. [Bojanowski et al., 2017] Piotr Bojanowski, Edouard Grave, Armand Joulin, and Tomas Mikolov. Enriching word vec- tors with subword information. Transactions of the Asso- ciation for Computational Linguistics, 5:135-146, 2017.
  4. [Breiman, 2001] Leo Breiman. Random forests. Machine learning, 45(1):5-32, 2001.
  5. [Chen and Guestrin, 2016] Tianqi Chen and Carlos Guestrin. Xgboost: A scalable tree boosting system. In Proceedings of the 22nd ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, KDD '16, page 785-794, 2016.
  6. [Chu et al., 2015] Xu Chu, John Morcos, Ihab F Ilyas, Mourad Ouzzani, Paolo Papotti, Nan Tang, and Yin Ye. Katara: A data cleaning system powered by knowledge bases and crowdsourcing. In Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data, pages 1247-1261, 2015.
  7. [Dallachiesa et al., 2013] Michele Dallachiesa, Amr Ebaid, Ahmed Eldawy, Ahmed Elmagarmid, Ihab F Ilyas, Mourad Ouzzani, and Nan Tang. Nadeef: a commod- ity data cleaning system. In Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data, pages 541-552, 2013.
  8. [Das et al., 2015] Sanjib Das, AnHai Doan, Paul Suganthan G. C., Chaitanya Gokhale, Pradap Konda, Yash Govind, and Derek Paulsen. The magellan data repository. https: //sites.google.com/site/anhaidgroup/projects/data, 2015. Link
  9. [Heidari et al., 2019] Alireza Heidari, Joshua McGrath, Ihab F Ilyas, and Theodoros Rekatsinas. Holodetect: Few- shot learning for error detection. In Proceedings of the 2019 International Conference on Management of Data, pages 829-846, 2019.
  10. [Hu et al., 2019] Kevin Hu, Snehalkumar'Neil'S Gaik- wad, Madelon Hulsebos, Michiel A Bakker, Emanuel Zgraggen, César Hidalgo, Tim Kraska, Guoliang Li, Arvind Satyanarayan, and C ¸agatay Demiralp. Viznet: Towards a large-scale visualization learning and bench- marking repository. In Proceedings of the 2019 CHI Conference on Human Factors in Computing Systems, pages 1-12, 2019.
  11. [Huang and He, 2018] Zhipeng Huang and Yeye He. Auto- detect: Data-driven error detection in tables. In Proceed- ings of the 2018 International Conference on Management of Data, pages 1377-1392, 2018.
  12. [Huang et al., 2014] Sheng-Jun Huang, Rong Jin, and Zhi- Hua Zhou. Active learning by querying informative and representative examples. IEEE Transactions on Pattern Analysis and Machine Intelligence, 36(10):1936-1949, 2014.
  13. [Krishnan et al., 2016] Sanjay Krishnan, Jiannan Wang, Eu- gene Wu, Michael J Franklin, and Ken Goldberg. Ac- tiveclean: Interactive data cleaning for statistical model- ing. Proceedings of the VLDB Endowment, 9(12):948- 959, 2016.
  14. [Li et al., 2012] Xian Li, Xin Luna Dong, Kenneth Lyons, Weiyi Meng, and Divesh Srivastava. Truth finding on the deep web: Is the problem solved? Proceedings of the VLDB Endowment, 6(2), 2012.
  15. [Mahdavi et al., 2019] Mohammad Mahdavi, Ziawasch Abedjan, Raul Castro Fernandez, Samuel Madden, Mourad Ouzzani, Michael Stonebraker, and Nan Tang. Raha: A configuration-free error detection system. In Proceedings of the 2019 International Conference on Management of Data, pages 865-882, 2019.
  16. [Mariet et al., 2016] Zelda Mariet, Rachael Harding, Sam Madden, et al. Outlier detection in heterogeneous datasets using automatic tuple expansion. 2016.
  17. [Neutatz et al., 2019] Felix Neutatz, Mohammad Mahdavi, and Ziawasch Abedjan. Ed2: A case for active learning in error detection. In Proceedings of the 28th ACM Inter- national Conference on Information and Knowledge Man- agement, pages 2249-2252, 2019.
  18. [Ouzzani et al., 2016] Mourad Ouzzani, Hossam Hammady, Zbys Fedorowicz, and Ahmed Elmagarmid. Rayyan-a web and mobile app for systematic reviews. Systematic reviews, 5(1):210, 2016.
  19. [Pedregosa et al., 2011] F. Pedregosa, G. Varoquaux, A. Gramfort, V. Michel, B. Thirion, O. Grisel, M. Blon- del, P. Prettenhofer, R. Weiss, V. Dubourg, J. Vanderplas, A. Passos, D. Cournapeau, M. Brucher, M. Perrot, and E. Duchesnay. Scikit-learn: Machine learning in Python. Journal of Machine Learning Research, 12:2825-2830, 2011.
  20. [Pham et al., 2019] Minh Pham, Craig A Knoblock, and Jay Pujara. Learning data transformations with minimal user effort. In 2019 IEEE International Conference on Big Data (Big Data), pages 657-664. IEEE, 2019.
  21. [Rekatsinas et al., 2017] Theodoros Rekatsinas, Xu Chu, Ihab F Ilyas, and Christopher Ré. Holoclean: Holistic data repairs with probabilistic inference. Proceedings of the VLDB Endowment, 10(11), 2017.
  22. [Singh, 2016] Rishabh Singh. Blinkfill: Semi-supervised programming by example for syntactic string transforma- tions. Proceedings of the VLDB Endowment, 9(10):816- 827, 2016.
  23. [Wang and He, 2019] Pei Wang and Yeye He. Uni-detect: A unified approach to automated error detection in tables. In Proceedings of the 2019 International Conference on Management of Data, pages 811-828, 2019.

References were extracted automatically from the PDF and may contain errors.

Welcome Future Conferences AI Journal Division IJCAI Proceedings About IJCAI IJCAI Awards