This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
A Human Factors Experimental Comparison of SQL and QBE
April 1993 (vol. 19 no. 4)
pp. 390-409

SQL and QBE are compared in the same operating environment, and the effects of query language type and other variables on user performance and satisfaction are studied. The experimental design combined a factorial design and a counterbalanced design in an effort to compare SQL and QBE. The results indicated that query language type affects user performance in paper and pencil testing, with QBE users having higher scores than SQL users. In contrast, in online testing, query language type had no effect on user performance. In addition, under certain conditions, query complexity had a significant effect on user performance and user satisfaction was influenced by query language type. Moreover, order of exposure impacted user performance on the basis of interaction with query language type, query complexity, and programming experience.

[1] P. Reisner, R. F. Boyce, and D. C. Chamberlin, "Human factors evaluation of two database query languages--SQUARE and SEQUEL," IBM Res. Lab. San Jose, CA, inProc. Nat. Computer Conf., 1975, pp. 447-452.
[2] J. C. Thomas and J. D. Gould, "A psychological study of Query By Example," inProc. Nat. Computer Conf., 1975, pp. 439-445.
[3] D. Greenblatt and J. Waxman, "A study of three database query languages," inDatabases: Improving Usability and Responsiveness, B. Shneiderman, Ed. New York: Academic, 1978.
[4] D. Welty and D. W. Stemple, "Human factors comparison of procedural and nonprocedural query languages,"ACM Trans. Database Syst., vol. 6, no. 4, pp. 626-649, 1981.
[5] Y. Vassiliou, M. Jarke, E. A. Stohr, J. A. Turner, and N. White, "Natural language for data base queries: A laboratory study,"MIS Quart., vol. 7, no. 4, pp. 47-61, Dec. 1983.
[6] F. H. Lochovsky, "Database management system user performance," Ph.D. dissertation, Univ. Toronto, Canada, 1978.
[7] M. Jarke, J. A. Turner, E. A. Stohr, Y. Vassiliou, N. H. White, and K. Michielsen, "A field evaluation of natural language for data retrieval,"IEEE Trans. Software Eng., vol. SE-11, no. 1, pp. 97-114, Jan. 1985.
[8] C. Welty, "Human factors studies of database query languages: SQL as a metric,"J. Database Admin., vol. 1, no. 1, pp. 2-10, 1990.
[9] G. W. Hansen and J. V. Hansen, "Procedural and nonprocedural query languages revisited: A comparison of relational algebra and relational calculus"Int. J. Man-Machine Studies, vol. 26, pp. 683-694, 1987.
[10] G. W. Hansen and J. V. Hansen, "Human performance in relational algebra, tuple calculus, and domain calculus,"Int. J. Man-Machine Studies, vol. 29, pp. 503-516, 1988.
[11] J. M. Boyle, K. F. Bury, and J. E. Evey, "Two studies evaluating learning and use of QBE and SQL," inProc. 27th Annu. Meeting Human Factors Soc., 1983, pp. 663-667.
[12] P. Reisner, "Human factors studies of database query languages: A survey and assesment,ACM Computing Surv., vol. 13, no. 1, Mar. 1981.
[13] J. S. Davis, "Usability of SQL and menus for database query,"Int. J. Man-Machine Studies, vol. 30, pp. 447-455, 1989.
[14] M. Rusinkiewicz and B. Czejdo, "Request: A testbed relational database management system for instructional and research purposes,"Proc. Nat. Computer Conf., 1984, pp. 531-536.
[15] J. E. Bailey and S. W. Pearson, "Development of a tool for measuring and analyzing computer user satisfaction,"Management Sci., vol. 29, no. 5, pp. 503-545, May 1983.
[16] P. Reisner, "Use of psychological experimentation as an aid to development of a query language,"IEEE Trans. Software Eng., vol. SE-3, pp. 218-229, May 1977.
[17] Y. Vassiliou and M. Jarke, "Query language--A taxonomy," inHuman Factors and Interactive Computer Systems, Y. Vassiliou, Ed. Norwood, NJ: Ablex, 1984.
[18] Y. Vassiliou, "On the interactive use of database query languages,"J. Management Inform. Syst., vol. 1, no. 3, pp. 33-48, Winter 1984-1985.
[19] H. C. Lucas, "Empirical evidence for a descriptive model of implementation,"MIS Quart., vol. 2, no. 2, pp. 27-41, June 1978.
[20] D. Robey, "User attitudes and management information system use,"Acad. Management J., pp. 527-538, Sept. 1979.
[21] G. M. Weinberg and E. L. Schulman, "Goals and performance in computer programming,"Human Factors, vol. 16, pp. 70-77, Feb. 1974.
[22] R. W. Zmud, "Individual differences and MIS success,"Management Sci., vol. 25, no. 10, pp. 966-979, Oct. 1979.
[23] S. W. Kim, "High-level data language design: An investigation of human factors in database query," Ph.D. dissertation, Univ. Minnesota, 1979.
[24] M. Brosey and B. Shneiderman, "Two experimental comparisons of relational and hierarchical database models,"Int. J. Man-Machine Studies, vol. 10, 1978.
[25] A. Richardson, "Verbalizer-visualizer: A cognitive style dimension,"J. Mental Imagery, vol. 1, pp. 109-126, 1977.
[26] B. Ives, M. Olson, and J. Baroudi, "The Measurement of User Information Satisfaction,"Comm. ACM, Oct. 1983, pp. 785-793.
[27] J. Miller and B. A. Doyle, "Measuring the effectiveness of computer-based information systems in the financial sector,"MIS Quart., vol. 11, no. 1, pp. 107-124, Mar. 1987.
[28] R. A. Guillemette, "Development and validation of a reader-based documentation measure,"Int. J. Man-Machine Studies, vol. 30, pp. 551-574, 1989.
[29] A. M. Jenkins and J. A. Ricketts, "The development of an MIS satisfaction questionnaire: An instrument for evaluating user satisfaction with turnkey decision support systems," Indiana Univ. Working Paper, Dec. 1986.
[30] B. Shneiderman and R. Mayer, "Syntactic/semantic interaction in programmer behavior: A model and experimental results,"Int. J. Comput. Inform. Sci., vol. 8, no. 3, pp. 219-238, 1979.

Index Terms:
human factors experimental comparison; SQL; QBE; operating environment; query language type; user performance; factorial design; counterbalanced design; online testing; query complexity; human factors; query languages
Citation:
M.Y.-M. Yen, R.W. Scamell, "A Human Factors Experimental Comparison of SQL and QBE," IEEE Transactions on Software Engineering, vol. 19, no. 4, pp. 390-409, April 1993, doi:10.1109/32.223806
Usage of this product signifies your acceptance of the Terms of Use.