Wondering why data are missing from query results? Ask Conseil Why-Not

Melanie Herschel (1, 2)

1 LRI - Laboratoire de Recherche en Informatique
2 OAK - Database optimizations and architectures for complex large data

In analyzing and debugging data transformations, or more specifically relational queries, a subproblem is to understand why some data are not part of the query result. This problem has recently been addressed from different perspectives for various fragments of relational queries. The different perspectives yield different, yet complementary explanations of such missing-answers. This paper first aims at unifying the different approaches by defining a new type of explanation, called hybrid explanation, that encompasses the variety of previously defined types of explanations. This solution goes beyond simply forming the union of explanations produced by different algorithms and is shown to be able to explain a larger set of missing-answers. Second, we present Conseil, an algorithm to generate hybrid explanations. Conseil is also the first algorithm to handle non-monotonic queries. Experiments on efficiency and explanation quality show that Conseil is comparable to and even outperforms previous algorithms.

Domaines: Base de données [cs.DB]

Melanie Herschel. Wondering why data are missing from query results? Ask Conseil Why-Not. International Conference on Information and Knowledge Management (CIKM), 2013, Burlingname, United States. ⟨hal-00909210⟩