Loading...
Please wait, while we are loading the content...
Similar Documents
A observing sql queries in their natural habitat.
| Content Provider | CiteSeerX |
|---|---|
| Author | Grust, Torsten Rittinger, Jan |
| Abstract | We describe 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 mark SQL subexpressions of arbitrary size and then observe whether these evaluate as expected. Habitat understands query nesting and free row variables in correlated subqueries, and generally aims to not constrain users while suspect subexpressions are marked for observation. 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 and are derived from the original data: Habitat does not require prior data extraction or extra debugging middleware. Experiments with TPC-H database instances indicate that observations impose a runtime overhead sufficiently low to allow for interactive debugging sessions. |
| File Format | |
| Access Restriction | Open |
| Subject Keyword | Natural Habitat Observing Sql Query Declarative Observational Debugger Target Sql Database Host Extra Debugging Middleware Prior Data Extraction Query Nesting Free Row Variable Yield Unexpected Result Sql Subexpressions Correlated Subqueries Original Data New Query Runtime Overhead Arbitrary Size Algebraic Compiler Interactive Debugging Session Desired Observation True Language-level Suspect Subexpressions Marked Sql Text Tpc-h Database Instance |
| Content Type | Text |
