Complexity and Approximation of Fixing Numerical Attributes in Databases Under Integrity Constraints
- 333 Downloads
Consistent query answering is the problem of computing the answers from a database that are consistent with respect to certain integrity constraints that the database as a whole may fail to satisfy. Those answers are characterized as those that are invariant under minimal forms of restoring the consistency of the database. In this context, we study the problem of repairing databases by fixing integer numerical values at the attribute level with respect to denial and aggregation constraints. We introduce a quantitative definition of database fix, and investigate the complexity of several decision and optimization problems, including DFP, i.e. the existence of fixes within a given distance from the original instance, and CQA, i.e. deciding consistency of answers to aggregate conjunctive queries under different semantics. We provide sharp complexity bounds, identify relevant tractable cases; and introduce approximation algorithms for some of those that are intractable. More specifically, we obtain results like undecidability of existence of fixes for aggregation constraints; MAXSNP-hardness of DFP, but a good approximation algorithm for a relevant special case; and intractability but good approximation for CQA for aggregate queries for one database atom denials (plus built-ins).
KeywordsIntegrity Constraint Local Denial Conjunctive Query Database Instance Aggregation Constraint
Unable to display preview. Download preview PDF.
- 2.Arenas, M., Bertossi, L., Chomicki, J.: Consistent Query Answers in Inconsistent Databases. In: Proc. ACM Symposium on Principles of Database Systems (PODS 1999), pp. 68–79 (1999)Google Scholar
- 4.Bertossi, L., Chomicki, J.: Query Answering in Inconsistent Databases. In: Chomicki, J., Saake, G., van der Meyden, R. (eds.) Logics for Emerging Applications of Databases. Springer, Heidelberg (2003)Google Scholar
- 5.Bertossi, L., Bravo, L., Franconi, E., Lopatenko, A.: Fixing Numerical Attributes Under Integrity Constraints. Corr. Archiv. paper cs.DB/0503032; March 15 (2005)Google Scholar
- 6.Bohannon, P., Michael, F., Fan, F., Rastogi, R.: A Cost-Based Model and Effective Heuristic for Repairing Constraints by Value Modification. In: Proc. ACM International Conference on Management of Data (SIGMOD 2005), pp. 143–154 (2005)Google Scholar
- 7.Cali, A., Lembo, D., Rosati, R.: On the Decidability and Complexity of Query Answering over Inconsistent and Incomplete Databases. In: Proc. ACM Symposium on Principles of Database Systems (PODS 2003), pp. 260–271 (2003)Google Scholar
- 15.Halldorsson, M., Radhakrishnan, J.: Greed is Good: Approximating Independent Sets in Sparse and Bounded-degree Graphs. In: Proc. ACM Symposium on Theory of Computing (SToC 1994), pp. 439–448 (1994)Google Scholar
- 16.Hochbaum, D. (ed.): Approximation Algorithms for NP-Hard Problems. PWS (1997)Google Scholar
- 24.Vazirani, V.: Approximation Algorithms. Springer, Heidelberg (2001)Google Scholar