3,558 Hits in 3.6 sec

Observing SQL queries in their natural habitat

Torsten Grust, Jan Rittinger
2013 ACM Transactions on Database Systems  
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

Zhengjie Miao, Tiangang Chen, Alexander Bendeck, Kevin Day, Sudeepa Roy, Jun Yang
2020 Proceedings of the VLDB Endowment  
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

Lars Schütze, Claas Wilke, Birgit Demuth
2013 ACM/IEEE International Conference on Model Driven Engineering Languages and Systems  
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]

Rafael Caballero, Yolanda García-Ruiz, Fernando Sáenz-Pérez
2012 Lecture Notes in Computer Science  
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

Vassilios Karakoidas, Diomidis Spinellis
2009 2009 13th Panhellenic Conference on Informatics  
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]

Xingliang Chen, Antonija Mitrovic, Moffat Mathews
2016 Lecture Notes in Computer Science  
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


Petar Jovanovic, Alkis Simitsis, Kevin Wilkinson
2014 Proceedings of the 2014 ACM SIGMOD international conference on Management of data - SIGMOD '14  
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

Nicolas Bruno
2010 Proceedings of the 13th International Conference on Extending Database Technology - EDBT '10  
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]

Christopher Ré, Amir Abbas Sadeghian, Zifei Shan, Jaeho Shin, Feiran Wang, Sen Wu, Ce Zhang
2014 arXiv   pre-print
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

Fernando Sáenz-Pérez
2011 Electronical Notes in Theoretical Computer Science  
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


Kristi Morton, Nicolas Bruno
2011 Proceedings of the Fourth International Workshop on Testing Database Systems - DBTest '11  
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


Azza Abouzied, Joseph Hellerstein, Avi Silberschatz
2012 Proceedings of the 25th annual ACM symposium on User interface software and technology - UIST '12  
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]

Benjamin Sowell, Alan Demers (Cornell University), Johannes Gehrke, Nitin Gupta (Cornell University), Haoyuan Li, Walker White (Cornell University)
2009 arXiv   pre-print
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

Bahareh Sadat Arab, Su Feng, Boris Glavic, Seokki Lee, Xing Niu, Qitian Zeng
2018 IEEE Data Engineering Bulletin  
., 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

Moritz Sichert, Thomas Neumann
2022 Proceedings of the VLDB Endowment  
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