Human error detection processes
International Journal of Man-Machine Studies - Special Issue: Cognitive Engineering in Dynamic Worlds
The effects of relational and entity-relationship data models on query performance of end users
International Journal of Man-Machine Studies
Logic-based approach to semantic query optimization
ACM Transactions on Database Systems (TODS)
The design and implementation of CoBase
SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
CoBase: a scalable and extensible cooperative information system
Journal of Intelligent Information Systems - Special issue on intelligent integration of information
Using inductive learning to generate rules for semantic query optimization
Advances in knowledge discovery and data mining
The relationship between user query accuracy and lines of code
International Journal of Human-Computer Studies
Three important determinants of user performance for database retrieval
International Journal of Human-Computer Studies
Using Evaluation to Shape ITS Design: Results and Experiences with SQL-Tutor
User Modeling and User-Adapted Interaction
Implementation of Two Semantic Query Optimization Techniques in DB2 Universal Database
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Proving the Safety of SQL Queries
QSIC '05 Proceedings of the Fifth International Conference on Quality Software
| Hi-index | 0.00 |
We investigate classes of SQL queries which are syntactically correct, but certainly not intended, no matter for which task the query was written. For instance, queries that are contradictory, i.e. always return the empty set, are obviously not intended. However, current database management systems execute such queries without any warning. In this paper, we give an extensive list of conditions that are strong indications of semantic errors. Of course, questions like the satisfiability are in general undecidable, but a significant subset of SQL queries can actually be checked. We believe that future database management systems will perform such checks and that the generated warnings will help to develop code with fewer bugs in less time.