Semi-automatic SQL Debugging and Fixing to solve the Missing-Answers Problem - Inria - Institut national de recherche en sciences et technologies du numérique
Conference Papers Year : 2014

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

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.
Fichier principal
Vignette du fichier
p1280-tzompanaki.pdf (135.49 Ko) Télécharger le fichier
Origin Files produced by the author(s)
Loading...

Dates and versions

hal-01095488 , version 1 (15-12-2014)

Identifiers

  • HAL Id : hal-01095488 , version 1

Cite

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⟩
250 View
168 Download

Share

More