On approximating optimum repairs for functional dependency violations

ACM International Conference Proceeding Series

Volumn 361, Issue , 2009, Pages 53-62

  Kolahi, Solmaz ^a   Lakshmanan, Laks V S ^a  

^a UNIVERSITY OF BRITISH COLUMBIA   (Canada)

Author keywords

Approximation algorithm; Functional dependency violation; Inconsistent databases; Repair

Indexed keywords

APPROXIMATE SOLUTION; CONSTANT FACTOR APPROXIMATION; CONSTANT FACTORS; DATA CLEANING; DISTANCE MEASURE; FUNCTIONAL DEPENDENCY; FUNCTIONAL DEPENDENCY VIOLATION; INCONSISTENT DATABASE; INCONSISTENT DATABASES; NP COMPLETE; NP-HARD;

APPROXIMATION ALGORITHMS; COMPUTATIONAL COMPLEXITY; DATABASE SYSTEMS; SET THEORY;

REPAIR;

EID: 70349143135     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1514894.1514901     Document Type: Conference Paper

References (28)

1. Serge Abiteboul, Richard Hull, and Victor Vianu. Foundations of Databases. Addison-Wesley, 1995.
2. Serge Abiteboul, Paris C. Kanellakis, and Gösta Grahne. On the representation and querying of sets of possible worlds. Theor. Comput. Sci., 78(1):158-187, 1991.
3. Marcelo Arenas, Leopoldo E. Bertossi, and Jan Chomicki. Consistent query answers in inconsistent databases. In PODS, pages 68-79, 1999.
4. Marcelo Arenas, Leopoldo E. Bertossi, and Jan Chomicki. Answer sets for consistent query answering in inconsistent databases. TPLP, 3(4-5):393-424, 2003.
5. Marcelo Arenas, Leopoldo E. Bertossi, Jan Chomicki, Xin He, Vijay Raghavan, and Jeremy Spinrad. Scalar aggregation in inconsistent databases. Theor. Comput. Sci., 3(296):405-434, 2003.
6. Mihir Bellare, Shafi Goldwasser, Carsten Lund, and A. Russeli. Efficient probabilistically checkable proofs and applications to approximations. In STOC, pages 294-304, 1993.
7. Leopoldo E. Bertossi. Consistent query answering in databases. SIGMOD Record, 35(2):68-76, 2006.
8. Leopoldo E. Bertossi, Loreto Bravo, Enrico Eranconi, and Andrei Lopatenko. The complexity and approximation of fixing numerical attributes in databases under integrity constraints. Inf. Syst., 33(4-5):407-434, 2008.
9. Philip Bohannon, Wenfei Fan, Floris Geerts, Xibei Jia, and Anastasios Kementsietsidis. Conditional functional dependencies for data cleaning. In ICDE, pages 746-755, 2007.
10. Philip Bohannon, Michael Flaster, Wenfei Fan, and Rajeev Rastogi. A cost-based model and effective heuristic for repairing constraints by value modification. In SIGMOD Conference, pages 143-154, 2005.
11. Jan Chomicki. Consistent query answering: Five easy pieces. In IGDT, pages 1-17, 2007.
12. Jan Chomicki and Jerzy Marcinkowski. Minimal-change integrity maintenance using tuple deletions. Inf. Comput., 197(1-2):90-121, 2005.
13. Gao Cong, Wenfei Fan, Floris Geerts, Xibei Jia, and Shuai Ma. Improving data quality: Consistency and accuracy. In VLDB, pages 315-326, 2007.
14. Dorit S. Hochbaum (Editor). Approximation Algorithms for NP-Hard Problems. PWS, 1997.
15. Wenfei Fan. Dependencies revisited for improving data quality. In PODS, pages 159-170, 2008.
16. Sergio Flesca, Filippo Furfaro, and Francesco Parisi. Consistent query answers on numerical databases under aggregate constraints. In DBPL, pages 279-294, 2005.
17. Enrico Franconi, Antonio Laureti Palma, Nicola Leone, Simona Perri, and Francesco Scarcello. Census data repair: a challenging application of disjunctive logic programming. In LPAR, pages 561-578, 2001.
18. Filippo Furfaro, Sergio Greco, and Cristian Molinaro. A three-valued semantics for querying and repairing inconsistent databases. Ann. Math. Artif. Intell., 51(2-4):167-193, 2007.
19. Ariel Fuxman, Elham Fazli, and Renée J. Miller. Conquer: Efficient management of inconsistent databases. In SIGMOD Conference, pages 155-166, 2005.
20. Ariel Fuxman and Renée J. Miller. First-order query rewriting for inconsistent databases. J. Comput. Syst. Sci., 73(4):610-635, 2007.
21. Solmaz Kolahi and Leonid Libkin. On redundancy vs dependency preservation in normalization: an information-theoretic study of 3nf. In PODS, pages 114-123, 2006.
22. Gabriel M. Kuper, Leonid Libkin, and Jan Paredaens, editors. Constraint Databases. Springer, 2000.
23. Andrei Lopatenko and Loreto Bravo. Efficient approximation algorithms for repairing inconsistent databases. In ICDE, pages 216-225, 2007.
24. Christos H. Papadimitriou and Mihalis Yannakakis. Optimization, approximation, and complexity classes. J. Comput. Syst. Sci., 43(3):425-440, 1991.
25. Vijay V. Vazirani. Approximation Algorithms. Springer, 2003.
26. Jef Wijsen. Condensed representation of database repairs for consistent query answering. In IGDT, pages 375-390, 2003.
27. Jef Wijsen. Database repairing using updates. ACM Trans. Database Syst., 30(3):722-768, 2005.
28. Jef Wijsen. Project-join-repair: An approach to consistent query answering under functional dependencies. In FQAS, pages 1-12, 2006.