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

Melanie Herschel 1, 2
2 OAK - Database optimizations and architectures for complex large data
LRI - Laboratoire de Recherche en Informatique, UP11 - Université Paris-Sud - Paris 11, Inria Saclay - Ile de France, CNRS - Centre National de la Recherche Scientifique : UMR8623
Abstract : 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.
Document type :
Conference papers
Complete list of metadatas

Cited literature [18 references]  Display  Hide  Download

https://hal.inria.fr/hal-00909210
Contributor : Melanie Herschel <>
Submitted on : Tuesday, November 26, 2013 - 9:36:25 AM
Last modification on : Monday, May 28, 2018 - 2:38:02 PM
Long-term archiving on : Monday, March 3, 2014 - 4:06:52 PM

File

db0184s-herschel.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-00909210, version 1

Collections

Citation

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⟩

Share

Metrics

Record views

230

Files downloads

277