True language-level SQL debugging

11 years 3 months ago
True language-level SQL debugging
We demonstrate Habitat, a declarative observational debugger for SQL. Habitat facilitates true language-level (not: plan-level) debugging of, probably flawed, SQL queries that yield unexpected results. Users may mark arbitrary SQL subexpressions—ranging from literals, over fragments of predicates, to entire subquery blocks—to observe whether these evaluate as expected. From the marked SQL text, Habitat’s algebraic compiler derives a new query whose result represents the values of the desired observations. These observations are generated by the target SQL database host itself. Prior data extraction or extra debugging middleware is not required. Habitat merges multiple observations into a single (nested) tabular display, letting a user explore the relationship of various observations. Filter predicates furthermore ease the interpretation of large results. Categories and Subject Descriptors H.2.3 [Database Management]: Query languages; D.2.5 [Software Engineering]: Debugging aids...
Torsten Grust, Fabian Kliebhan, Jan Rittinger, Tom
Added 27 Aug 2011
Updated 27 Aug 2011
Type Journal
Year 2011
Where EDBT
Authors Torsten Grust, Fabian Kliebhan, Jan Rittinger, Tom Schreiber
Comments (0)