Semantic errors in SQL queries: A quite complete list

Proceedings - Fourth International Conference on Quality Software, QSIC 2004

Volumn , Issue , 2004, Pages 250-257

  Brass, Stefan ^a   Goldberg, Christian ^a  

^a MARTIN LUTHER UNIVERSITY HALLE WITTENBERG   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

SCHEMA INFORMATION; SEMANTIC ERRORS; SQL QUERIES;

ALGORITHMS; DATABASE SYSTEMS; ERROR ANALYSIS; PROGRAM COMPILERS; SEMANTICS; THEOREM PROVING;

SOFTWARE ENGINEERING;

EID: 14044250170     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/QSIC.2004.1357967     Document Type: Conference Paper

References (14)

1. Stefan Brass, Christian Goldberg. Detecting Logical Errors in SQL Queries. Technical Report, University of Halle, 2004.
2. Qi Cheng, Jarek Gryz, Fred Koo, Cliff Leung, Linqi Liu, Xiaoyan Qian, Bernhard Schiefer. Implementation of Two Semantic Query Optimization Techniques in DB2 Universal Database. Proceedings of the 25th VLDB Conference, 687-698, 1999.
3. U. S. Chakravarthy, J. Grant, and J. Minker. Logic-based approach to semantic query optimization. ACM Transactions on Database Systems, 15:162-207, 1990.
4. Hock C. Chan. The relationship between user query accuracy and lines of code. Int. Journ. Human Computer Studies 51, 851-864, 1999.
5. Wesley W. Chu, M.A. Merzbacher and L. Berkovich. The design and implementation of CoBase. In Proc. of ACM SIGMOD, 517-522, 1993.
6. Hock C. Chan, Bernard C.Y. Tan and Kwok-Kee Wei. Three important determinants of user performance for database retrieval. Int. Journ. Human-Computer Studies 51, 895-918, 1999.
7. Wesley W. Chu, Hua Yang, Kuorong Chiang, Michael Minock, Gladys Chow and Chris Larson. Cobase: A scalable and extensible cooperative information system. Journal of Intelligent Information Systems, 1996.
8. Terry Gaasterland, Parke Godfrey and Jack Minker. An Overview of Cooperative Answering. Journal of Intelligent Information Systems 21:2, 123-157, 1992.
9. Chun-Nan Hsu and Craig A. Knoblock. Using inductive learning to generate rules for semantic query optimization. In Advances in Knowledge Discovery and Data Mining, pages 425-445. AAAI/MIT Press, 1996.
10. W.J. Kenny Jih, David A. Bradbard, Charles A. Snyder, Nancy G.A. Thompson. The effects of relational and entity-relationship data models on query performance of end users. Int. Journ. Man-Machine Studies, 31:257-267, 1989.
11. A. Mitrovic. A knowledge-based teaching system for SQL. In ED-MEDIA 98, pages 1027-1032, 1998.
12. Antonija Mitrovic, Brent Martin, and Michael Mayo. Using evaluation to shape its design: Results and experiences with SQL-Tutor. User Modeling and User-Adapted Interaction, 12:243-279, 2002.
13. A. Rizzo, S. Bagnara and Michele Visciola. Human error detecting processes. Int. Journ. Man-Machine Studies 27, 555-570, 1987.
14. C. Welty. Correcting user errors in SQL. International Journal of Man-Machine Studies 22:4, 463-477, 1985.