Effects of query complexity and learning on novice user query performance with conceptual and logical database interfaces

IEEE Transactions on Systems, Man, and Cybernetics Part A:Systems and Humans.

Volumn 34, Issue 2, 2004, Pages 276-281

  Siau, Keng L ^a   Chan, Hock Chuan ^b   Wei, Kwok Kee ^c  

^a UNIVERSITY OF NEBRASKA LINCOLN   (United States)

^b NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

^c CITY UNIVERSITY OF HONG KONG   (Hong Kong)

Author keywords

Data models; Query languages; Relational database; User interfaces; Visual languages

Indexed keywords

ABSTRACTING; COMPUTATIONAL COMPLEXITY; DATA STRUCTURES; FORMAL LOGIC; INFORMATION TECHNOLOGY; QUERY LANGUAGES; SEMANTICS; USER INTERFACES;

LOGICAL DATABASE INTERFACES; LOGICAL LEVELS; RETENTION TEST; VISUAL LANGUAGES;

RELATIONAL DATABASE SYSTEMS;

EID: 1542500502     PISSN: 10834427     EISSN: None     Source Type: Journal    
DOI: 10.1109/TSMCA.2003.820581     Document Type: Letter

References (38)

1. D. D. Chamberlain, "A summary of user experience with the SQL data sublanguage," in Proc. Int. Conf. Data Bases, 1980, pp. 181-203.
2. R. Ramakrishnan, Database Management Systems. New York: McGraw-Hill, 1997.
3. J. H. Gerlach and F. Y. Kuo, "Understanding human-computer interaction for information systems design," MIS Quart., vol. 15, no. 4, pp. 526-549, 1991.
4. K. Siau, "A visual object-relationship query language for user-database interaction," Telemat. Informat., vol. 15, no. 1-2, pp. 103-119, 1998.
5. J. MacGregor, "A comparison of the effects of icons and descriptors in videotex menu retrieval," Int. J. Man-Mach. Stud., vol. 37, pp. 767-777, 1992.
6. T. Halpin, Conceptual Schema and Relational Database Design. Englewood Cliffs, NJ: Prentice-Hall, 1995.
7. S. B. Navathe, "Evolution of data modeling for databases," Commun. vol. 35, no. 9, pp. 112-123, 1992.
8. J. B. Smelcer, "User errors in database query composition," Int. J. Human-Comput. Stud., vol. 42, no. 4, pp. 353-381, 1995.
9. P. P. Chen, "The entity-relationship model: Toward a unified view of data," ACM Trans. Database Syst., vol. 1, no. 1, pp. 9-36, 1976.
10. D. D. Chamberlain and R. F. Boyce, "SEQUEL: A structured english query language," in Proc. ACM SIGMOD Workshop Data Description, Access, Control, Ann Arbor, MI, 1974.
11. D. Greenblatt and J. Waxman, "A study of three database query languages," In Databases: Improving Usability and Representativeness, B. Shneiderman, Ed. New York: Academic, 1978, pp. 76-87. pp. 76-87.
12. C. Welty and D. W. Stemple, "Human factors comparison of a procedural and nonprocedural query language," ACM Trans. Database Syst., vol. 6, no. 4, pp. 626-649, 1981.
13. H. J. Kim, H. F. Korth, and A. Silberschatz, "PICASSO: A graphical query language," Softw. - Pract. Exp., vol. 18, no. 3, pp. 169-203, 1998.
14. M. M. Zloof, "Query-By-Example: A data base language," IBM Syst. J., vol. 16, no. 4, pp. 324-343, 1977.
15. V. M. Markowitz and A. Shoshani, "Abbreviated query interpretation in entity-relationship oriented databases," in Proc. 8th Int. Conf. Entity-Relationship Approach, F.H Lochovsky, Ed., 1989, pp. 40-58.
16. H. C. Chan, K. K. Wei, and K. L. Siau, "User-Database interface: The effect of abstraction levels on query performance," MIS Quart., vol. 17, no. 4, pp. 441-464, 1993.
17. W. J. Jih, D. A. Bradbard, C. A. Snyder, and N. G. A. Thompson, "The effects of relational and entity-relationship data models on query performance of end-users," Int. J. Man-Mach. Stud., vol. 31, pp. 257-267, 1989.
18. J. S. Davis, "Experimental investigation of the utility of data structure and ER diagrams in database query," Int. J. Man-Mach. Stud., vol. 32, 449-459, 1990.
19. D. Batra, J. A. Hoffer, and R. P. Bostrom, "Comparing representations with relational and EER models," Commun. ACM, vol. 33, no. 2, pp. 1 26-139, 1990.
20. S. L. Jarvenpaa and J. J. Machesky, "Data analysis and learning: an experimental study of data modeling tools," Int. J. Man-Mach. Stud., vol. 31, pp. 367-391, 1989.
21. D. Batra, "A framework for studying human error behavior in conceptual database modeling," Inform. Manage., vol. 25, pp. 121-131, 1993.
22. D. Batra and M. K. Sein, "Improving conceptual database design through feedback," Int. J. Human-Comput. Stud., vol. 40, pp. 653-676, 1994.
23. P. Reisner, "Human factors studies of database query languages, a survey and assessment," Comput. Surv., vol. 13, no. 1 pp. 13-31, 1981.
24. H. C. Chan, K. K. Wei, and K. Siau, "The effect of a database feedback system on user performance," Behav. Inf. Technol., vol. 14, no. 3 pp. 152-162, May-June 1995.
25. H. C. Chan, K. K. Wei, and K. Siau, "A system for query comprehension," Inf. Softw. Technol., vol. 39, pp. 141-148, 1997.
26. H. Chan, K. Siau, and K. Wei, "The effect of data model, system and task characteristics on user query performance - An empirical study," DATA BASE Advances Inform. Syst., vol. 29, no. 1, pp. 31-49, Winter 1998.
27. K. L. Siau, K. P. Tan, and H. C. Chan, "A CASE tool for conceptual database design," Inform. Softw. Technol., vol. 34, no. 12, pp. 779-786, December 1992.
28. K. L. Siau, H. C. Chan, and K. P. Tan, "Visual knowledge query IEICE Trans. Inform. Syst. vol. E75-D, no. 5, pp. 697-703, 1992.
29. T. Connolly, C. Begg, and A. Strachan, Data Systems - A Practical Approach to Design, Implementation and Management. Reading, MA: Addison-Wesley, 1996.
30. J. Thomas and J. Gould, "A psychological study of query by example," in Proc. National Computer Conf., 1975, pp. 439-445.
31. H. C. Chan, K. K. Wei, and K. L. Siau, "An empirical study on end-users' update performance for different abstraction levels," Int. J. Human-Comput. Studies, vol. 41 pp. 309-328, 1994.
32. A. F. Borthick, P. L. Bowen, S. T. Liew, and F. H. Rohde, "The effects of normalization on end-user query errors: An experimental evaluation," Int. J. Accounting Inform. Syst., vol. 2, pp. 195-221, 2001.
33. J. M. Boyle, K. F. Bury, and R. J. Evey, "Two studies evaluating learning and use of QBE and SQL," in Proc. Human Factors Society 27th Annu. Meeting, 1982, pp. 663-667.
34. K. S. Suh and A. M. Jenkins, "A comparison of linear keyword and restricted natural language data base interfaces for novice users," Inf. Syst. Res., vol. 3, no. 3. pp. 252-272, 1992.
35. C. Liao and P. C. Palvia, "The impact of data models and task complexity on end-user performance: An experimental investigation," Int. J. Human-Comput. Studies, vol. 52, pp. 831-845, 2000.
36. K. Siau, "Informational and computational equivalence in comparing information modeling methods," J. Database Manage., vol. 15, no. 1, pp. 73-86, 2004.
37. D. George and P. Mallery, SPSS for Windows Step by Step. A Simple Guide and Reference. Boston, MA: Allyn & Bacon, 2001.
38. K. Siau, "Information modeling and method engineering: A psychological perspective," J. Database Manage., vol. 10, no. 4, pp. 44-50, 1999.