Home

Scalar aggregation in FD-inconsistent databases


Author(s) : Jan Chomicki Leopoldo Bertossi Marcelo Arenas, 
Publisher : N/A
Publication Date : 1973
ISSN : N/A
Abstract : Abstract. We consider here scalar aggregation queries in databases that may violate a given set of functional dependencies. We show how to compute consistent answers (answers true in every minimal repair of the database) to such queries. We provide a complete characterization of the computational complexity of this problem. We also show how tractability can be obtained in several special cases (one involves a novel application of the perfect graph theory) and present a practical hybrid query evaluation method. 1,