Descriptive and prescriptive data cleaning

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2014, Pages 445-456

  Chalamalla, Anup ^a   Ilyas, Ihab F ^a   Ouzzani, Mourad ^b   Papotti, Paolo ^b  

^a UNIVERSITY OF WATERLOO   (Canada)

^b QATAR COMPUTING RESEARCH INSTITUTE   (Qatar)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; BENCHMARKING; REPAIR;

BUSINESS LOGIC; DATA CLEANING; EFFECTIVENESS AND EFFICIENCIES; MULTIPLE DATA SOURCES; REPAIR ALGORITHMS; SPACE AND TIME; TARGET LEVELS; TPC-H BENCHMARKS;

ERRORS;

EID: 84904358688     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/2588555.2610520     Document Type: Conference Paper

References (22)

1. G. Beskales, I. F. Ilyas, and L. Golab. Sampling the repairs of functional dependency violations under hard constraints. PVLDB, 3(1):197-207, 2010.
2. J. Cheney, L. Chiticariu, and W. C. Tan. Provenance in databases: Why, how, and where. Foundations and Trends in Databases, 1(4):379-474, 2009.
3. X. Chu, I. F. Ilyas, and P. Papotti. Holistic data cleaning: Putting violations into context. In ICDE, 2013.
4. V. Chvatal. A greedy heuristic for the set-covering problem. Mathematics of operations research, 4(3):233-235, 1979.
5. G. Cong, W. Fan, F. Geerts, J. Li, and J. Luo. On the complexity of view update analysis and its application to annotation propagation. IEEE TKDE, 24(3):506-519, 2012.
6. Y. Cui and J. Widom. Practical lineage tracing in data warehouses. In ICDE, pages 367-378, 2000.
7. M. Dallachiesa, A. Ebaid, A. Eldawy, A. Elmagarmid, I. Ilyas, M. Ouzzani, and N. Tang. Towards a commodity data cleaning system. In SIGMOD, 2013.
8. W. Fan and F. Geerts. Foundations of Data Quality Management. Morgan & Claypool Publishers, 2012.
9. W. Fan, S. Ma, Y. Hu, J. Liu, and Y. Wu. Propagating functional dependencies with conditions. PVLDB, 1(1):391-407, 2008.
10. F. Geerts, G. Mecca, P. Papotti, and D. Santoro. The Llunatic Data-Cleaning Framework. PVLDB, 6(9):625-636, 2013.
11. M. Herschel and M. A. Hernandez. Explaining missing answers to spjua queries. PVLDB, 3(1):185-196, 2010.
12. D. S. Hochbaum. Heuristics for the fixed cost median problem. Mathematical programming, 22(1):148-162, 1982.
13. W. H. Inmon. Building the Data Warehouse. John Wiley Publishers, 2005.
14. B. Kanagal, J. Li, and A. Deshpande. Sensitivity analysis and explanations for robust query evaluation in probabilistic databases. In SIGMOD, pages 841-852, 2011.
15. S. Kolahi and L. V. S. Lakshmanan. On approximating optimum repairs for functional dependency violations. In ICDT, 2009.
16. A. Meliou, W. Gatterbauer, S. Nath, and D. Suciu. Tracing data errors with view-conditioned causality. In SIGMOD, pages 505-516, 2011.
17. P. B. Mirchandani and R. L. Francis. Discrete location theory. 1990.
18. F. Murtagh. Clustering in massive data sets. In Handbook of massive data sets, pages 501-543. Springer, 2002.
19. Q. T. Tran and C.-Y. Chan. How to conquer why-not questions. In SIGMOD, pages 15-26, 2010.
20. Transaction Processing Performance Council. The TPC Benchmark H 2.16.0. http://www.tpc.org/tpch, 2013.
21. E. Wu and S. Madden. Scorpion: Explaining away outliers in aggregate queries. PVLDB, 6(8):553-564, 2013.
22. E. Wu, S. Madden, and M. Stonebraker. A demonstration of dbwipes: Clean as you query. PVLDB, 5(12):1894-1897, 2012.