How "How" Explains What "What" Computes — How-Provenance for SQL and Query Compilers

Authors: 

Daniel O’Grady, Tobias Müller, and Torsten Grust,Universität Tübingen

Abstract: 

SQL emphasizes the What, the declarative specification of complex computations over a database. How exactly the individual parts of an intricate query interact and contribute to the result, often remains in the dark, however. How-provenance helps to understand queries and build trust in their results. We propose a new approach that derives how-provenance for SQL at a fine granularity: (1) every single piece of the result provides information on how exactly it did get there, and (2) the contribution of any query construct to the overall output can be assessed—from entire subqueries down to the subexpression leaf level. The method applies to real-world dialects of SQL and, more generally, to the modern breed of database systems that pursue a compilation-based approach to query processing.

Open Access Media

USENIX is committed to Open Access to the research presented at our events. Papers and proceedings are freely available to everyone once the event begins. Any video, audio, and/or slides that are posted after the event are also free and open to everyone. Support USENIX and our commitment to Open Access.

BibTeX
@inproceedings {220325,
author = {Daniel O{\textquoteright}Grady and Tobias M{\"u}ller and Torsten Grust},
title = {How "How" Explains What "What" Computes {\textemdash} How-Provenance for {SQL} and Query Compilers},
booktitle = {10th {USENIX} Workshop on the Theory and Practice of Provenance (TaPP 2018)},
year = {2018},
address = {London},
url = {https://www.usenix.org/conference/tapp2018/presentation/o{\textquoteright}grady},
publisher = {{USENIX} Association},
}