Semi-automatic SQL Debugging and Fixing to solve the Missing-Answers Problem

Katerina Tzompanaki 1, 2, 3, 4, *
* Corresponding author
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 : Asking questions is the driving force for scientific progress. But as important as it is to ask questions, so important is to be able to understand the obtained answers. In this way, we are able to verify the sanity of the question itself and if necessary refine it. In the same spirit, in this PhD we focus on SQL queries over re-lational databases with the aim to (1) pinpoint the reasons on the SQL query that led to missing-answers (tuples that were expected but not obtained in the query result), (2) fix the SQL query so that it best fits the user's expectations, and (3) do both efficiently so as to be of practical use.
Document type :
Conference papers
Complete list of metadatas

Cited literature [37 references]  Display  Hide  Download

https://hal.inria.fr/hal-01095488
Contributor : Aikaterini Tzompanaki <>
Submitted on : Monday, December 15, 2014 - 4:34:20 PM
Last modification on : Monday, May 28, 2018 - 2:38:02 PM
Long-term archiving on : Monday, March 16, 2015 - 12:21:34 PM

File

p1280-tzompanaki.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-01095488, version 1

Collections

Citation

Katerina Tzompanaki. Semi-automatic SQL Debugging and Fixing to solve the Missing-Answers Problem. Very Large Databases (VLDB'14) PhD Workshop, Sep 2014, Hangzhou, China. ⟨hal-01095488⟩

Share

Metrics

Record views

353

Files downloads

168