A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
Filters
Observing SQL queries in their natural habitat
2013
ACM Transactions on Database Systems
Preserved Fulltext
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. ...
In this work, we apply the principles of observational debugging to SQL. ...
In the context of this work, we define language-level debugging as a process that supports all debugging activity on the level of the user-facing SQL syntax and semantics: users mark fragments of their ...
doi:10.1145/2445583.2445586
fatcat:6hz4d6wc4rb6fg62basq6l23eq
I-Rex: An Interactive Relational Query Explainer for SQL
2020
Proceedings of the VLDB Endowment
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
First, unlike debugging for procedural languages, it is not clear how to trace a declarative SQL query, because its execution plan often differs from how it was originally written. ...
We demonstrate I-REX 1 , a system designed to help users understand SQL query evaluation and debug SQL queries. ...
However, learning and debugging SQL can be challenging, even for people with considerable experience with procedural programming languages, partly because of the declarative nature of 1 A video and other ...
dblp:journals/pvldb/MiaoCBDR020
fatcat:ijqwxsvotbbqdpkh3jvcgb2dym
Tool-Supported Step-By-Step Debugging for the Object Constraint Language
2013
ACM/IEEE International Conference on Model Driven Engineering Languages and Systems
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
languages. ...
Although originally designed as an extension for the Unied Modeling Language (UML), the Object Constraint Language (OCL) has been broadly adopted in the context of UML as well as other modeling and domain-specic ...
Apart from debuggers for OCL, debuggers for other declarative languages exist. Cabellero et al. present a debugging framework for SQL views [13] . ...
dblp:conf/models/SchutzeWD13
fatcat:xbakb3wqsjhopkbvtzgjaol6bi
Declarative Debugging of Wrong and Missing Answers for SQL Views
[chapter]
2012
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
This paper presents a debugging technique for diagnosing errors in SQL views. ...
Although based on the ideas of declarative debugging, the proposed technique does not use computation trees explicitly. ...
Given the high-abstraction level of SQL, usual techniques like trace debugging are difficult to apply. ...
doi:10.1007/978-3-642-29822-6_9
fatcat:2bxwhqbha5g2pl52zs7wa6fe64
J%: Integrating Domain-Specific Languages with Java
2009
2009 13th Panhellenic Conference on Informatics
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
J% (J-mod), is a Java language extension that supports integration with Domain-Specific Languages. The integration is realized through an architecture that permits external modules to support DSLs. ...
Jeannie [23] addresses the intermixing of Java and C at the programming language level. ...
The any_character rule must accept any character as input, because at grammar level we cannot predict the syntax of the embedded DSL language. ...
doi:10.1109/pci.2009.26
dblp:conf/pci/KarakoidasS09
fatcat:adnlu2lysnhwxemkwnidmbfpe4
Do Erroneous Examples Improve Learning in Addition to Problem Solving and Worked Examples?
[chapter]
2016
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
Explaining and correcting erroneous examples also leads to improved debugging and problem-solving skills. ...
SQL-Tutor For this study, we modified SQL-Tutor [16] , a constraint-based ITS for teaching the Structured Query Language (SQL) by developing three distinct modes to correspond to TPS, WEs and ErrExs. ...
Our study demonstrated that an improved instructional strategy, WPEP, resulted in improved problem solving, and that it also benefitted students with various levels of prior knowledge in SQL-Tutor. ...
doi:10.1007/978-3-319-39583-8_2
fatcat:vilsfajstjgndcld5hryf4wuue
BabbleFlow
2014
Proceedings of the 2014 ACM SIGMOD international conference on Management of data - SIGMOD '14
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
To address this problem, we present BabbleFlow, a system for enabling flow design at a logical level and automatic translation to physical flows. ...
However, as the number and variety of these engines grow, developing and maintaining hybrid flows at the physical level becomes increasingly challenging. ...
Debugging. A db-A user may have a complicated, nested SQL query that is hard to read and comprehend. ...
doi:10.1145/2588555.2594534
dblp:conf/sigmod/0001SW14
fatcat:ekuvom7odvgtzapeb5suwuzyji
Minimizing database repros using language grammars
2010
Proceedings of the 13th International Conference on Extending Database Technology - EDBT '10
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2011; you can also visit the original URL.
The file type is application/pdf.
This issue prevents developers reacting quickly to new bugs, since usually a long manual "repro-minimization" phase occurs before the actual debugging takes place. ...
In this paper we present a fully automated technique to minimize database repros that leverages underlying language grammars and thus is significantly more focused than previous approaches. ...
SQL Server We now describe some scenarios using SIMP in the context of the SQL language and Microsoft SQL Server. ...
doi:10.1145/1739041.1739088
dblp:conf/edbt/Bruno10
fatcat:5gfwzofiuvaxpdbgbd4fouu6lm
Feature Engineering for Knowledge Base Construction
[article]
2014
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
Other Versions
KBC is based on joint probabilistic inference and learning, but we do not see inference as either a panacea or a magic bullet: inference is a tool that allows us to be systematic in how we construct, debug ...
However, for scalability reasons, bulk operations are written in SQL. Debugging. In Section 4, we describe our approach to debugging. ...
(b) Generate labels using distant supervision with SQL; (c) Integrate constraints with SQL and logic functions; (d) Extract features with SQL and script languages (e.g., Python). ...
arXiv:1407.6439v3
fatcat:uwbsndqym5h5vdmscrlipmai2m
DES: A Deductive Database System
2011
Electronical Notes in Theoretical Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
In particular, it embodies both Datalog and SQL query languages, where the same database can be queried. ...
Datalog Declarative Debugger In [4] , an approach to debug Datalog programs anchored to the semantic level instead of the computation level is proposed. ...
On the one hand, this allows to change its behaviour and add new features much more easily than either using a lower-abstraction-level language or using several languages. ...
doi:10.1016/j.entcs.2011.02.011
fatcat:bx3xzotnrbhofmnxke5zxghqcq
FlexMin
2011
Proceedings of the Fourth International Workshop on Testing Database Systems - DBTest '11
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2015; you can also visit the original URL.
The file type is application/pdf.
Debugging a database engine is an arduous task due to the complexity of the query workloads and systems. ...
FlexMin builds on previous repro minimization techniques, SIMP and delta-debugging, and makes two key contributions. ...
EVALUATION We implemented all techniques in C# and use the same code base for different target languages, specifically SQL and MDX. ...
doi:10.1145/1988842.1988843
dblp:conf/sigmod/MortonB11
fatcat:ajajwzxjyzfglcf3bu2tfyse5e
DataPlay
2012
Proceedings of the 25th annual ACM symposium on User interface software and technology - UIST '12
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
Writing complex queries in SQL is a challenge for users. ...
We remedy these issues with DataPlay, a query tool with an underlying graphical query language, a unique data model and a graphical interface. ...
For example: Grade = A Area = Systems
Example tuples
True
True
[A, Systems]
True
False
[A, Design]
False
True
[B, Systems]
False
False
[C, Theory]
!
!
! ...
doi:10.1145/2380116.2380144
dblp:conf/uist/AbouziedHS12
fatcat:vehrq7irvbhb7jfihazzpnuxxy
From Declarative Languages to Declarative Processing in Computer Games
[article]
2009
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
We discuss several research ideas for novel language features to support atomic actions and reactive programming. ...
We also explore challenges for main-memory query processing in games and simulations including adaptive query plan selection, support for parallel architectures, debugging simulation scripts, and extensions ...
Debugging Regardless of how well a language is designed, developers need some mechanisms for debugging and reasoning about their programs. ...
arXiv:0909.1770v1
fatcat:o5gtcl4nrzetdkmelcyt6oh4ai
GProM - A Swiss Army Knife for Your Provenance Needs
2018
IEEE Data Engineering Bulletin
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
., compiling a declarative frontend language with provenance-specific features into the query language of a backend database system. ...
Furthermore, by means of the example of post-mortem debugging of transactions, we demonstrate how novel applications of provenance are made possible by GProM. • Exploiting backend databases for provenance ...
Figure 2 shows the high-level architecture of GProM. ...
dblp:journals/debu/ArabFGLNZ17
fatcat:ndr6mcq2kva6nj6brotrwa6u3y
User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases
2022
Proceedings of the VLDB Endowment
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
Users can write idiomatic code in the programming language of their choice, which is then directly integrated into existing database systems. ...
The main reason why RDBMS are not used is that SQL is di cult to work with due to its declarative and set-oriented nature, and is not easily extensible. ...
Usability and Debugging. ...
dblp:journals/pvldb/SichertN22
fatcat:p2fb67igvbfuhlcrh62zo6zt4y
« Previous
Showing results 1 — 15 out of 3,558 results