Skip to main content
SpringerLink
Log in

A Conceptual Framework for Error Analysis in SQL Interfaces

  • Conference paper
Book cover Interfaces to Database Systems (IDS92)

Part of the book series: Workshops in Computing ((WORKSHOPS COMP.))

  • 53 Accesses

Abstract

SQL, a formal, non-procedural query language has become ubiquitous despite the demonstration of a variety of shortcomings. The inadequacies of database query languages like SQL reveal themselves by frequent errors in query formulation. Existing studies of query error tend to focus on specific types of error, or particular circumstances under which errors occur. Query formulation models constructed to analyse interaction behavior utilise incomplete models of the user. This paper introduces a framework powerful enough to analyse and respond to virtually all erroneous queries in a systematic way. The framework aids in understanding errors described in previous empirical studies, but also provides a basis for future research.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Tarek M. Anwar, Howard W. Beck, and Shamkant B. Navathe. Knowledge mining by imprecise querying: A classification-based approach. In Proceedings, IEEE Eighth International Conference on Data Engineering, pages 622-630, Tempe, Arizona, February 1992. IEEE Computer Society Press.

    Google Scholar 

  2. Deborah A. Boehm-Davis, Robert W. Holt, Matthew Koll, Gloria Yastrop, and Robert Peters. Effects of different data base formats on information retrieval. Human Factors, 31(5):579–592, 1989.

    Google Scholar 

  3. R. F. Boyce, D. D. Chamberlin, W. F. King III, and M. M. Hammer. Specifying queries as relational expressions. In J. W. Klimbie and K. L. Koffeman, editors, Data Base Management — Proceedings of the IFIP Working Conference on Data Base Management, pages 169-177. North-Holland, Cargèse, Corsica, France, April 1974.

    Google Scholar 

  4. Stuart K. Card, Thomas P. Moran, and Allen Newell. The model human processor. In Kenneth R. Boff, Lloyd Kaufman, and James P. Thomas, editors, Handbook of Perception and Human Performance, volume 2 — Cognitive Processes and Performance, pages 45–1: 45-35. John Wiley and Sons, New York, New York, 1986.

    Google Scholar 

  5. John M. Carroll and Jean McKendree. Interface design issues for advice-giving expert systems. Communications of the ACM, 30(1): 14–31, January 1987.

    Article  Google Scholar 

  6. John M. Carroll and John C. Thomas. Metaphor and the cognitive representation of computing systems. IEEE Transactions on Systems, Man, and Cybernetics, 12(2): 107–116, March/April 1982.

    Article  Google Scholar 

  7. Sang K. Cha. Kaleidoscope: A cooperative menu-guided query interface (SQL version). IEEE Transactions on Knowledge and Data Engineering, 3(1): 42–47, March 1991.

    Article  Google Scholar 

  8. Surajit Chaudhuri. Generalization and a framework for query modification. In Proceedings, IEEE Sixth International Conference on Data Engineering, pages 138-145, Los Angeles, California, February 1990. IEEE Computer Society Press.

    Google Scholar 

  9. E. F. Codd. A relational model of data for large shared data banks. Communications of the ACM, 13(6): 377–387, June 1970.

    Article  MATH  Google Scholar 

  10. J. Steve Davis. Usability of SQL and menus for database query. International Journal of Man-Machine Studies, 30: 447–455, 1989.

    Article  Google Scholar 

  11. J. Steve Davis. Experimental investigation of the utility of data structure and E-R diagrams in database query. International Journal of Man-Machine Studies, 32: 449–459, 1990.

    Article  Google Scholar 

  12. S. L. Ehrenreich. Query languages: Design recommendations derived from the human factors literature. Human Factors, 23(6): 709–725, 1981.

    Google Scholar 

  13. Valerie J. Gawron, Colin G. Drury, Sara J. Czaja, and Dawn M. Wilkins. A taxonomy of independent variables affecting human performance. International Journal of Man-Machine Studies, 31: 643–672, 1989.

    Article  Google Scholar 

  14. David Greenblatt and Jerry Waxman. A study of three database query languages. In Ben Shneiderman, editor, Databases: Improving Usability and Responsiveness, pages 77–97. Academic Press, New York, New York, 1978.

    Google Scholar 

  15. Gary W. Hansen and James V. Hansen. Procedural and nonprocedural query languages revisited: A comparison of relational algebra and relational calculus. International Journal of Man-Machine Studies, 26: 683–694, 1987.

    Article  Google Scholar 

  16. Gary W. Hansen and James V. Hansen. Human performance in relational algebra, tuple calculus, and domain calculus. International Journal of Man-Machine Studies, 29: 503–516, 1988.

    Article  Google Scholar 

  17. R. S. Hirsch. Procedures of the Human Factors Center at San Jose. IBM Systems Journal, 20(2): 123–171, 1981.

    Article  Google Scholar 

  18. Jürgen M. Janas. How not to say “NIL”: Improving answers to failing queries in database systems. In Proceedings of the Sixth International Joint Conference on Artificial Intelligence (IJCAI), pages 429-434, Tokyo, Japan, August 1979.

    Google Scholar 

  19. Jürgen M. Janas. Towards more informative user interfaces. In Proceedings of the 5th International Conference on Very Large Data Bases, pages 17-23, Rio de Janeiro, Brazil, October 1979. IEEE Computer Society Press.

    Google Scholar 

  20. Matthias Jarke, Jon A. Turner, Edward A. Stohr, et al. A field evaluation of natural language for data retrieval. IEEE Transactions on Software Engineering, 11(1): 97–113, January 1985.

    Article  Google Scholar 

  21. Aravind K. Joshi, S. Jerrold Kaplan, and Ronald M. Lee. Approximate responses from a data base query system: Applications of inferencing in natural language. In Proceedings of the Fifth International Joint Conference on Artificial Intelligence (IJCAI), pages 211-212, Boston, Massachusetts, August 1977.

    Google Scholar 

  22. Mimi Kao, Nick Cercone, and Wo-Shun Luk. Providing quality responses with natural language interfaces: The null value problem. IEEE Transactions on Software Engineering, 14(7): 959–984, July 1988.

    Article  Google Scholar 

  23. S. Jerrold Kaplan. Cooperative responses from a portable natural language query system. Artificial Intelligence, 19: 165–187, 1982.

    Article  Google Scholar 

  24. Cecilia Katzeff. Dealing with a database query language in a new situation. International Journal of Man-Machine Studies, 25: 1–17, 1986.

    Article  Google Scholar 

  25. Cecilia Katzeff. The effect of different conceptual models upon reasoning in a database query writing task. International Journal of Man-Machine Studies, 29: 37–62, 1988.

    Article  Google Scholar 

  26. Cecilia Katzeff. Strategies for testing hypotheses in database query writing. In F. Klix, N. A. Streitz, Y. Waern, and H. Wandke, editors, Man-Computer Interaction Research (MACINTER-II), pages 125–147. Elsevier North-Holland, New York, New York, 1989.

    Google Scholar 

  27. Kathleen F. McCoy. Correcting misconceptions: What to say when the user is mistaken. In Proceedings of the ACM SIGCHI Conference, pages 197-201, Boston, Massachusetts, December 1983.

    Google Scholar 

  28. Thomas P. Moran. An applied psychology of the user. ACM Computing Surveys, 13(1):1–11, March 1981.

    Article  Google Scholar 

  29. Amihai Motro. BAROQUE: A browser for relational databases. ACM Transactions on Office Information Systems, 4(2): 164–181, April 1986.

    Article  Google Scholar 

  30. Amihai Motro. Query generalization: A method for interpreting null answers. In Proceedings, First International Workshop on Expert Database Systems, October 24–27 1984, pages 597-616, Kiawah Island, South Carolina, 1986. Benjamin/Cummings Publishing Company.

    Google Scholar 

  31. Amihai Motro. SEAVE: A mechanism for verifying user presuppositions in query systems. ACM Transactions on Information Systems, 4(4): 312–330, October 1986.

    Article  Google Scholar 

  32. Amihai Motro. Using integrity constraints to provide intensional answers to relational queries. In Proceedings of the 15th International Conference on Very Large Data Bases, pages 237-246, Amsterdam, The Netherlands, August 1989.

    Google Scholar 

  33. Amihai Motro. FLEX: A tolerant and cooperative user interface to databases. IEEE Transactions on Knowledge and Data Engineering, 2(2): 231–246, June 1990.

    Article  Google Scholar 

  34. Amihai Motro and Qiuhui Yuan. Querying database knowledge. In ACM SIGMOD International Conference on Management of Data, pages 173-183, Atlantic City, New Jersey, May 1990.

    Google Scholar 

  35. Donald A. Norman. Design principles for human-computer interfaces. In Proceedings of the ACM SIGCHI Conference, pages 1-10, Boston, Massachusetts, December 1983.

    Google Scholar 

  36. Donald A. Norman. Design rules based on analyses of human error. Communications of the ACM, 26(4): 254–258, April 1983.

    Article  MathSciNet  Google Scholar 

  37. G. N. Paulley and W. B. Cowan. Getting the most (and the least) out of SQL. Research Report 92-03, University of Waterloo, Waterloo, Ontario, Canada, February 1992.

    Google Scholar 

  38. James Reason. Human Error. Cambridge University Press, Cambridge, United Kingdom, 1990.

    Google Scholar 

  39. Phyllis Reisner. Use of psychological experimentation as an aid to development of a query language. IEEE Transactions on Software Engineering, 3(3): 218–229, May 1977.

    Article  Google Scholar 

  40. Phyllis Reisner. Human factors studies of database query languages: A survey and assessment. ACM Computing Surveys, 13(1): 13–31, March 1981.

    Article  MathSciNet  Google Scholar 

  41. Elaine Rich. User modeling via stereotypes. Cognitive Science, 3: 329–354, 1979.

    Article  Google Scholar 

  42. Elaine Rich. Sterotypes and user modeling. In A. Kobsa and W. Wahlster, editors, User Models in Dialog Systems, pages 35-51. Springer-Verlag, Berlin, Germany, 1989. Contains the Proceedings of the First International Workshop on User Modeling, Maria Laach, Germany, 1986.

    Google Scholar 

  43. D. Sleeman, Doug Appelt, Kurt Konolige, et al. User modeling panel. In Proceedings of the Ninth International Joint Conference on Artificial Intelligence (IJCAI), pages 1298-1302, Los Angeles, California, August 1985.

    Google Scholar 

  44. Robert Sugden and Alan Williams. The Principles of Practical Cost-Benefit Analysis. Oxford University Press, Oxford, England, 1978.

    Google Scholar 

  45. Dov Te’eni. Perceived costs and benefits as determinants of user behaviour: An experiment with matchmaking. Behaviour and Information Technology, 9(1): 31–45, 1990.

    Article  Google Scholar 

  46. John C. Thomas. Quantifiers and question-asking. Research Report RC5866, IBM Corporation, Research Division, Yorktown Heights, New York, February 1976.

    Google Scholar 

  47. John C. Thomas. Psychological issues in data base management. In Proceedings of the 3rd International Conference on Very Large Data Bases, pages 169-185, Tokyo, Japan, October 1977. IEEE Computer Society Press.

    Google Scholar 

  48. John C. Thomas. Psychological issues on the design of database query languages. In M. E. Sime and M. J. Coombs, editors, Designing for Human-Computer Communication, pages 173–206. Academic Press, London, England, 1983.

    Google Scholar 

  49. John C. Thomas and J. M. Carroll. Human factors in communication. IBM Systems Journal, 20(2): 237–263, 1981.

    Article  Google Scholar 

  50. J[ohn] C. Thomas and John D. Gould. A psychological study of Query-by-Example. In Proceedings of the 44th National Computer Conference, pages 439-445, Montvale, New Jersey, May 1975. AFIPS Press.

    Google Scholar 

  51. John C. Thomas and Wendy A. Kellogg. Minimizing ecological gaps in interface design. IEEE Software, pages 78-86, January 1989.

    Google Scholar 

  52. Bonnie Lynn Webber and Eric Mays. Varieties of user misconceptions: Detection and correction. In Proceedings of the Eighth International Joint Conference on Artificial Intelligence (IJCAI), pages 650-652, Karlsruhe, West Germany, 1983.

    Google Scholar 

  53. C[harles] Welty. Correcting user errors in SQL. International Journal of Man-Machine Studies, 22: 463–477, 1985.

    Article  Google Scholar 

  54. Charles Welty and David W. Stemple. Human factors comparison of a procedural and a nonprocedural query language. ACM Transactions on Database Systems, 6(4): 626–649, December 1981.

    Article  Google Scholar 

  55. Michael David Williams. What makes RABBIT run? International Journal of Man-Machine Studies, 21: 333–352, 1984.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Waterloo, Waterloo, Ontario, Canada, N2L 3G1

    G. N. Paulley & W. B. Cowan

Authors
  1. G. N. Paulley
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. W. B. Cowan
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Computing Science Department, The University, Glasgow, G12 8RZ, Scotland

    Richard Cooper MSc, PhD

Rights and permissions

Reprints and permissions

Copyright information

© 1993 British Computer Society

About this paper

Cite this paper

Paulley, G.N., Cowan, W.B. (1993). A Conceptual Framework for Error Analysis in SQL Interfaces. In: Cooper, R. (eds) Interfaces to Database Systems (IDS92). Workshops in Computing. Springer, London. https://doi.org/10.1007/978-1-4471-3423-7_23

Download citation

  • DOI: https://doi.org/10.1007/978-1-4471-3423-7_23

  • Publisher Name: Springer, London

  • Print ISBN: 978-3-540-19802-4

  • Online ISBN: 978-1-4471-3423-7

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation