The Effect of Data Model, System and Task on User Query Performance - An Empirical Study

Data Base for Advances in Information Systems

Volumn 29, Issue 1, 1997, Pages 31-49

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

^a NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

^b UNIVERSITY OF BRITISH COLUMBIA   (Canada)

^c CITY UNIVERSITY OF HONG KONG   (Hong Kong)

Author keywords

entity rela tionship model; relational model; textual query language; user database interface; visual query language

Indexed keywords

EID: 85008934902     PISSN: 00950033     EISSN: None     Source Type: Journal    
DOI: 10.1145/506812.506820     Document Type: Article

References (68)

1. Angelaccio, M., Catarci, T, and Santucci, G. (October 1990). “QBD: A Graphical Query Language with Recursion,” IEEE Transaction on Software Engineering, Vol. 16, No. 10, pp. 1150–1163.
2. Auddino, A., Dennebouy, Y., Dupont, Y., Fontana, E., Spaccapietra, S., and Tari, Z. (1992). “SUPER: A Comprehensive Approach to Database Visual Interfaces,” in Knuth, E., and Wegner, L.M. (Eds.), Visual Database Systems II, North-Holland.
3. Bachman, C.W. (1973). ‘The Programmer as Navigator,” Communications of the ACM, Vol. 16, No. 1, pp. 653–658.
4. Batini, C., Ceri, S., and Navathe, S.B., (1992). Conceptual Database Design, An Entity Relationship Approach, The Benjamin/Cummings Publishing Company Inc.
5. Batra, D. (1993). “A Framework for Studying Human Error Behavior in Conceptual Database Modeling,” Information & Management, Vol. 25, pp. 121–131.
6. Batra, D., and Kirs, P.J. (1993). ‘The Quality of Data Representations Developed by NonExpert Designers: An Experimental Study,” Journal of Database Management, Vol. 4, No. 4, pp. 1729.
7. Batra, D., Hotter, J.A., and Bostrom, R.R. (1990). “Comparing Representations with Relational and ER Models,” Communications of the ACM, Vol. 33, No. 2, pp. 126–139.
8. Batra, D., and Sein, M.K. (1994). “Improving Conceptual Database Design Through Feedback,” International Journal of Human- Computer Studies, Vol. 40, pp. 653–676.
9. Bell, J.E. (1990). A Case Study of Ad Hoc Query Interfaces to Databases, Ph.D. Dissertation, Berkeley, CA: University of California.
10. Boyle, J.M., Bury, K.F., and Evey, R.J. (1983).‘Two Studies Evaluating Learning and Use of QBE and SQL,” Proceedings of the Human Factor Society 27th Annual Meeting, Santa Monica, CA: Human Factors Society, pp. 663–667.
11. Brancheau, J.C., and Wetherbe, J.C. (1987). “Key Issues in Information Systems Management,” MIS Quarterly, pp. 23–45.
12. Bryer, J. K. (1991). The Relative Effectiveness of a Direct Manipulation Interface versus Command- Based Interface in a Database Query Task Environment, Ph.D. Dissertation, Indiana University.
13. Burgess, C.G. (1991). “A Graphical Database- Querying Interface for Casual, Naive Computer Users,” International Journal of Man-Machine Studies, pp. 34, 23–47.
14. Burns, L.M., Archibald, J.L. and Molhotra, A. (1988). “A Graphical Entity-Relationship Database Browser,” in B.D. Shriver (Ed.), Proceedings of the 21st Annual Hawaii International Conference on System Sciences, Vol. II, pp. 694–704.
15. Campbell, D.M., Embley, D.W., and Czejdo, B. (1987). “Graphical Query Formulation for an Entity-Relationship Model,” Data & Knowledge Engineering 2, pp. 89–121, North-Holland.
16. Cardenas, A.F., and Wang, G.R. (1985).‘Translation of SQliDS Data Access/Update into Entity Relationship Data Access/Update,” the 4th International Conference on Entity-Relationship Approach, IEEE Computer Society Press, pp. 256–267.
17. Catarci, T. and Santucci, G. (1989). “Query by Diagram: A Graphic Query System,” in C. Batini (Ed.), Entity-Relationship Approach: A Bridge to the User, Proceedings of the Seventh International Conference on Entity Relationship Approach, Rome, pp. 291–308.
18. Chan H.C. (1989). A Knowledge Level User Interface Using the Entity-Relationship Model, Ph.D. Dissertation, The University of British Columbia.
19. Chan H.C. (1991). “An Entity-Relationship Enhanced Logic System,” The Second International Symposium on Database Systems for Advanced Applications, Tokyo, pp. 401–410.
20. Chan, H.C., Wei, K.K., and Siau, K.L. (1993). “User-Database Interface: The Effect of Abstraction Levels on Query Performance,” MIS Quarterly, Vol. 17, No. 4, pp. 441–464.
21. Chan, H.C., and Wei, K.K. (1996). Effect of Grading Schemes on Outcomes in Query Writing Experiments, Interacting with Computer, Vol. 8, No. 1, pp. 7–12.
22. Czejdo, B., Elmasri, R., Rusinkiewicz, M., and Embley, D.W. (1990). “A Graphical Data Manipulation Language for an Extended Entity- Relationship Model,” Computer, pp. 26–36.
23. Date, C.J. (1987). A Guide to the SQL Standard, USA: Addison-Wesley.
24. Date, C.J. (1990). An Introduction to Database Systems, Vol. I, Fifth Edition, Addison-Wesley.
25. Dogac, A., Eyupoglu, F., and Arkun, E. (1987). “VERS - A Vector Based Entity Relationship Database Management System,” S. Spaccapietra (Ed.), Entity-Relationship Approach, Elsevier Sciences Publishers.
26. Elmasri, R., and Navathe, S.B., (1989). Fundamentals of Database Systems, Addison Wesley.
27. Elmasri, R.A., and Larson, J.A. (1985). “A Graphical Query Facility for ER Databases,” The Fourth International Conference on Entity- Relationship Approach, IEEE Computer Society Press, pp. 236–245.
28. Gimnich, R., Kunkel, K., and Strothotte, T. (1990). “Human Factors of Database Systems,” in A. Blaser (Ed.), Database Systems of the 90s, Springer-Verlag, pp. 115–134.
29. Gogolla, M., and Hohenstein, U. (1991). ‘Towards a Semantic View of an Extended Entity- Relationship Model,” ACM Transactions on Database Systems, Vol. 16, No. 3, pp. 369–416.
30. Gould, J.D., and Ascher, R. (1975). “Use of an IQF-like Query Language by Non-Programmers,” IBM Research Report, RC-5279.
31. Gray, P.M.D., Kulkarni, K.G., and Paton, N.W. (1992). Qbject-Qriented Databases, A Semantic Data Model Approach, Prentice-Hall.
32. Greenblatt, D., and Waxman (1978). “A Study of Three Database Query Languages,” in B. Shneiderman (Ed.), Databases: Improving Usability and Representativeness, New York: Academic Press.
33. Groette, I.P., and Nilsson, E.G. (1988–1989). “SICON, an Iconic Presentation Module for an Entity-Relationship Database,” in C. Batini (Ed), Entity-Relationship Approach: A Bridge to the User, Proceedings of the Seventh International Conference on Entity-Relationship Approach, Rome, pp. 271–289.
34. Grover, V. and Goslar, M. (1993). “Information Technologies for the 1990s: The Executive View,” Technical Correspondence, Communication of the ACM, Vol. 36, No. 3.
35. Hawryszkiewycz, I.T. (1990). Relational Database Design, Australia: Prentice-Hall.
36. Hohenstein, U, (1989). “Automatic Transformation of an Entity-Relationship Query Language into SQL,” Proceedings of the Eighth International Conference on Entity-Relationship Approach, pp. 309–327.
37. Hughes, J.G. (1991). Qbject-Qriented Databases, UK: Prentice-Hall.
38. Hutchins, E.L., Hollan, J.D., and Norman, D.A. (1985). “Direct Manipulation Interfaces,” Human Computer Interaction, Vol. 1, pp. 311–338.
39. Jarvenpaa. S.L., and Machesky, J.J. (1986). “End User Learning Behavior in Data Analysis and Data Modeling Tools,” Proceedings of the Seventh International Conference on Information Systems, San Diego, CA, pp. 152167.
40. Kenny Jih, W.J., Bradbard, D.A., Snyder, C.A., and Thompson, N.G.A. (1989). ‘The Effects of Relational and Entity-Relationship Data Models on Query Performance of End-Users,” International Journal on Man-Machine Studies, pp. 257–267.
41. Katzeff, C., “Strategies for Testing Hypotheses in Database Query Writing,” in Klix et el. (Eds), Man-Computer interaction Research, Elsevier, Amsterdam pp. 125–147.
42. Kunkel, K., and Strothotte, T. (1988). “Visualization and Direct Manipulation in User Interfaces: Are We Qverdoing it?,” in P. Gorny and M.J. Tauber (Eds). Visualization in Human- Computer Interaction, Springer-Verlag, pp. 183193.
43. Kuntz, M., and Melchert, R. (1989). “Pasta-3's Graphical Query Language: Direct Manipulation, Cooperative Queries, Full Expressive Power,” in P.M.G. Apers and G. Wiederhold (Eds.), Proceedings of the 15th International Conference on Very Large Data Bases, pp. 97–105, Amsterdam.
44. Larkin, J.H., and Simon, H.A. (1987). “Why a Diagram is (Sometimes) Worth Ten Thousand Words,” Cognitive Science, Vol. 11, pp. 65–69.
45. McCormick, J.J. (1991). “CIOs reassess Priorities,” Information Week, p. 13.
46. Negri, M., Pelagatti, G., and Sbattella, L. (1991). “Formal Semantics of SQL Queries,” ACM Transactions on Database Systems, Vol. 17, No. 3, pp. 513–534.
47. Niederman, F, Brancheau, J.C., and Wetherbe, J.C. (1991). “Information Systems Management Issues for the 1990s,” MIS Quarterly, pp. 475–500.
48. Ogden, W.C. (1985). “Implications of a Cognitive Model of Database Query: Comparison of a Natural Language, a Formal Language, and Direct Manipulation Interface,” ACM SIGCHI Bulletin, Vol. 18, No. 2, pp. 51–54.
49. Reisner, R, Boyce, R., and Chamberlain, D. (1974). “Human Factors Evaluation of Two Data-Base Query Languages: SQUARE and SEQUEL,” IBM Research Report, RJ 1478.
50. Reisner, P. (1981). “Human Factors Studies of Database Query Languages, a Survey and Assessment”, Computing Surveys, Vol. 13.
51. Roesner, W. (1985). “DESPATH: An Entity Relationship Manipulation Language,” The Fourth international Conference on Entity- Relationship Approach, IEEE Computer Society Press.
52. Schneider, M., and Trepied, C. (1989). “A Graphical Query Language for Semantic Data Models,” in J.l. DeGross, J.C. Henderson, and B. R. Konsynski (Eds.), Proceedings of the Tenth International Conference on Information Systems, Boston, pp. 153–164.
53. Siau, K.L., Chan, H.C., and Tan K.P. (1991). “Visual Knowledge Query Language as a Front- End to Relational Systems,” Proceedings of the 15th Annual International Computer Software and Applications Conference, pp. 373–378, Tokyo: IEEE Computer Society Press.
54. Siau, K.L., Chan, H.C., and Tan K.P. (1992). “Visual Knowledge Query Language,” lEICE Transactions on Information and Systems, Vol. E75-D, No. 5, pp. 697–703.
55. Siau, K.L., Chan, H.C., Wei, K.K. (1995). ‘The Effects of Conceptual and Logical Interfaces on Visual Query Performance of End Users,” Proceedings of the 16th Internationai Conference on information Systems, pp. 225–235, Amsterdam.
56. Subieta K., and Missala, M. (1987). “Semantics of Query Languages for the Entity Relationship Model,” in S. Spaccapietra (Ed.), Proceedings of the Internationai Conference on Entity Reiationship Approach, pp. 197–216.
57. Suh, K.S., and Jenkins, M. (1992). “A Comparison of Linear Keyword Language and Restricted Natural Language Data Base Interfaces for Novice Users,” Information Systems Research, Vol. 3, No. 3, pp. 252–272.
58. Teorey, T. (1990). Database Modeling and Design: The Entity-Reiationship Approach, Morgan Kaufmann Publishers, Inc.
59. Thomas, J., and Gould, J. (1975). “A psychological Study of Query By Example,” National Computer Conference Proceedings, Vol. 44, pp. 439–445, New York: AFIPS Press.
60. Thomas, J.C. (1983). “Psychological Issues in the Design of Database Query Languages,” in M.E. Sime and M.J. Coombs (Eds.), Designing For Human-Computer Communication, London
61. Ursprung, R, and Zehnder, C.A. (1983). “HIQUEL An Interactive Query Language to Define and Use Hierarchies,” in C.G. Davies et al. (Eds.), Entity Relationship Approach to Software Engineering, North-Holland; Elsevier Science Publishers B.V., pp. 299–314.
62. Velez, F. (1985). “LAMBDA: An Entity-Relationship-Based Query Language for the Retrieval of Structured Documents,” The 4th International Conference on Entity-Relationship Approach, IEEE Computer Society Press.
63. Vossen, G. (1991). Data Models, Database Languages, and Database Management Systems, UK; Addison-Wesley.
64. Welty C., and Stemple, D.W. (1981). “Human Factors Comparison of a Procedural and a Nonprocedural Query Language,” ACM Transactions on Database Systems, Vol. 6, No. 4, pp. 626–649.
65. Whang, K.Y., Malhotra, A., Sockut, G.H., Burns, L., and Choi, K.S. (1992). “Two-Dimensional Specification of Universal Quantification in a Graphical Database Query Language,” IEEE Transactions on Software Engineering, Vol. 18, No. 3, pp. 216–224.
66. Zhang, Z.Q., and Mendeizon, A.O. (1983). “A Graphical Query Language for Entity- Relationship Databases,” in P.A.B. Ng and R.T. Yah (Eds.), Entity-Relationship Approach to Software Engineering, North-Holland, pp. 441448.
67. Ziegler, J.E., and Fahnrich, K.P. (1988). “Direct Manipulation,” Handbook of Human-Computer Interaction, North Holland; Elsevier Science Publisher, pp. 123–133.
68. Zloof, M.M. (1978). “Design Aspects of the Query- By-Exampie Data Base Manipulation Language,” in B. Shneiderman (Ed.), Databases: Improving Usability and Representativeness, New York: Academic Press.