Sampling from repairs of conditional functional dependency violations

VLDB Journal

Volumn 23, Issue 1, 2014, Pages 103-128

  Beskales, George ^a   Ilyas, Ihab F ^a   Golab, Lukasz ^b   Galiullin, Artur ^b  

^a QATAR COMPUTING RESEARCH INSTITUTE   (Qatar)

^b UNIVERSITY OF WATERLOO   (Canada)

Author keywords

Conditional functional dependency; Data cleaning; Integrity constraint violation; Sampling repairs

Indexed keywords

SEMANTICS;

CONDITIONAL FUNCTIONAL DEPENDENCIES; DATA CLEANING; DATA SEMANTICS; EXPONENTIAL NUMBERS; FUNCTIONAL DEPENDENCY; INTEGRITY CONSTRAINTS; WEB DATA EXTRACTION;

DATA INTEGRATION;

EID: 84892822296     PISSN: 10668888     EISSN: 0949877X     Source Type: Journal    
DOI: 10.1007/s00778-013-0316-z     Document Type: Article

References (31)

1. UIS data generator, http://www.cs.utexas.edu/users/ml/riddle.
2. Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley, Reading (1995).
3. Afrati, F. N., Kolaitis, P. G.: Repair checking in inconsistent databases: algorithms and complexity. In: ICDT, pp. 31-41 (2009).
4. Arenas, M., Bertossi, L. E., Chomicki, J.: Consistent query answers in inconsistent databases. In: PODS, pp. 68-79 (1999).
5. Baxter, R., Christen, P., Churches, T.: A comparison of fast blocking methods for record linkage. In ACM SIGKDD (2003).
6. Benjelloun, O., Sarma, A. D., Halevy, A. Y., Widom, J.: ULDBs: Databases with uncertainty and lineage. In: VLDB, pp. 953-964 (2006).
7. Beskales, G., Ilyas, I. F., Golab, L.: Sampling the repairs of functional dependency violations under hard constraints. PVLDB 3(1), 197-207 (2010).
8. Bohannon, P., Fan, W., Geerts, F., Jia, X., Kementsietsidis, A.: Conditional functional dependencies for data cleaning. In: ICDE, pp. 746-755 (2007).
9. Bohannon, P., Flaster, M., Fan, W., Rastogi, R.: A cost-based model and effective heuristic for repairing constraints by value modification. In: SIGMOD, pp. 143-154 (2005).
10. Chomicki, J., Marcinkowski, J.: Minimal-change integrity maintenance using tuple deletions. Inf. Comput. 197(1/2), 90-121 (2005).
11. Chomicki, J., Marcinkowski, J., Staworko, S.: Computing consistent query answers using conflict hypergraphs. In: CIKM, pp. 417-426 (2004).
12. Cong, G., Fan, W., Geerts, F., Jia, X., Ma, S.: Improving data quality: consistency and accuracy. In: VLDB, pp. 315-326 (2007).
13. Cormen, T. H., Leiserson, C. E., Rivest, R. L., Stein, C.: Introduction to Algorithms, 2nd edn. MIT Press and McGraw-Hill, Cambridge and New York (2001).
14. Yuan, Y. C.: Multiple imputation for missing data: Concepts and new development. In: The 25th Annual SAS Users Group International Conference (2002).
15. Eckerson, W. W.: Data quality and the bottom line: Achieving business success through a commitment to high quality data. TDWI Report Series (2002).
16. Elmagarmid, A. K., Ipeirotis, P. G., Verykios, V. S.: Duplicate record detection: a survey. IEEE Trans. Knowl. Data Eng. 19(1), 1-16 (2007).
17. Fan, W., Geerts, F., Jia, X., Kementsietsidis, A.: Conditional functional dependencies for capturing data inconsistencies. ACM Trans. Database Syst. 33(2), 616-648 (2008).
18. Fan, W., Li, J., Ma, S., Tang, N., Yu, W.: Towards certain fixes with editing rules and master data. PVLDB 3(1), 173-184 (2010).
19. Fan, W., Li, J., Ma, S., Tang, N., Yu, W.: Towards certain fixes with editing rules and master data. VLDB J. 21(2), 213-238 (2012).
20. Fuxman, A., Miller, R. J.: First-order query rewriting for inconsistent databases. J. Comput. Syst. Sci. 73(4), 610-635 (2007).
21. Greco, S., Molinaro, C.: Approximate probabilistic query answering over inconsistent databases. In: ER, pp. 311-325 (2008).
22. Jampani, R., Xu, F., Wu, M., Perez, L. L., Jermaine, C. M., Haas, P. J.: MCDB: a monte carlo approach to managing uncertain data. In: SIGMOD Conference, pp. 687-700 (2008).
23. Kolahi, S., Lakshmanan, L. V. S.: On approximating optimum repairs for functional dependency violations. In: ICDT, pp. 53-62 (2009).
24. Lopatenko, A., Bertossi, L. E.: Complexity of consistent query answering in databases under cardinality-based and incremental repair semantics. In: ICDT, pp. 179-193 (2007).
25. McCallum, A., Nigam, K., Ungar, L. H.: Efficient clustering of high-dimensional data sets with application to reference matching. In: KDD, pp. 169-178 (2000).
26. Müller, H., Freytag, J. C.: Problems, Methods and Challenges in Comprehensive Data Cleansing. Technical Report HUB-IB-164, Humboldt-Universität zu Berlin, Institut für Informatik (2003).
27. Mulry, M. H., Bean, S. L., Bauder, D. M., Wagner, D., Mule, T., Petroni, R. J. Evaluation of estimates of census duplication using administrative records information. J. Off. Stat. 22(4), 655-679 (2006).
28. Sen, P., Deshpande, A.: Representing and querying correlated tuples in probabilistic databases. In: ICDE, pp. 596-605 (2007).
29. Tarjan, R. E.: Efficiency of a good but not linear set union algorithm. J. ACM 22(2), 215-225 (1975).
30. Wijsen, J.: Condensed representation of database repairs for consistent query answering. In: ICDT, pp. 375-390 (2003).
31. Wijsen, J.: Database repairing using updates. ACM Trans. Database Syst. 30(3), 722-768 (2005).