An investigation of the roles of individual differences and user interface on database usability

Abstract

This research seeks to understand to what extent leveraging the graphical user interface's ability to convey spatial information can improve a user's ability to write effective database queries. This capability is believed to be especially important when nontechnical individuals, with diverse backgrounds and cognitive abilities, are expected to interact directly with these systems in the query formulation process.This study makes use of recent developments in graphical user interface technology to manipulate the level of spatial visualization support provided by the interface. A laboratory experiment was conducted to explore the influence of interface style and the spatial visualization ability of the user on the performance of the query development process. The application used in the experiment was a visual database query system developed for this study. One hundred sixty-two volunteers participated in the experiment. Spatial visualization ability was assessed using a paper-folding test. The results indicate that both spatial visualization support of the system and spatial visualization ability of the user are important components of database usability.

References

1. Alter, S. (1992). Information Systems: A Management Perspective, Reading, MA: Addison-Wesley, pp. 19-31.
2. Batra, D., Hoffer, J., and Bostrom, R. (1990). "Comparing Representations with Relational and EER Models," Communications of the ACM, Vol. 33, No. 2, pp. 126-139.
3. Borgman, C. L. (1989). "All Users of Information Retrieval Systems Are Not Created Equal: An Exploration of Individual Differences," Information Processing & Management, Vol. 25 No. 3, pp. 237-251.
4. Carroll, J. (1974). "Psychometric Tests as Cognitive Tasks: A New 'Structure of Intellect'," Research Bulletin, Vol. 74 No. 16, Princeton, NJ: Educational Testing Service.
5. 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-459.
6. Davis, S. A., and Bostrom, R. P. (1993). "Training End-Users: An Experimental Investigation of the Roles of the Computer Interface and Training Methods," MIS Quarterly, Vol. 17, No. 1, pp. 61-85.
7. Dumais, S. T., and Wright, A. L. (1986). "Reference by Name vs. Location in a Computer Filing System," Proceedings of the Human Factors Society, pp. 824-828.
8. Egan, D. E. (1988). "Individual Differences in Human-Computer Interaction," in M. Helander (Ed.), Handbook of Human-Computer Interaction. New York: Elsevier Science Publishers B.V.
9. Ekstrom, R. B., French, J. W., Harman, H. H., and Dermen, D. (1976). Manual for Kit of Factor-Referenced Cognitive Tests, Princeton, NJ: Educational Testing Service.
10. Greene, S. L., Gomez, L. M., and Devlin, S. J. (1986). "A Cognitive Analysis of Database Query Production," Proceedings of the Human Factors Society, pp. 9-13.
11. Helander, M. (Ed.) (1988). Handbook of Human-Computer Interaction, North-Holland: Elsevier Science Publishers.
12. Hutchins, E. L., Hollan, J. D., and Norman, D. A. (1986). "Direct Manipulation Interfaces," in D. A. Norman and S. W. Draper (Eds.), User Centered System Design --- New Perspectives on Human-Computer Interaction, Hillsdale, NJ: Lawrence Erlbaum and Associates, pp. 87-124.
13. Jih, W., Bradbard, D., Snyder, C., and Thompson, N. (1989). "The Effects of Relational and Entity-Relationship Data Models on Query Performance of End Users," International Journal of Man-Machine Studies, Vol. 31, pp. 257-267.
14. Kirk, J. (1982). Experimental Design: Procedures for the Behavioral Sciences, 2nd Edition, Belmont, CA: Brooks Cole Publishing.
15. Klerer, M. (1984). "Experimental Study of A Two-Dimensional Language vs Fortran for First Course Programmers," International Journal of Man-Machine Studies, Vol. 20, pp. 445-467.
16. McKenney, J. L., and Keen, P. G. W. (1974). "How Managers' Minds Work," Harvard Business Review, pp. 79-90.
17. Salvendy, G. and Knight, J. L. (1982). "Psychomotor Work Capabilities," in G. Salvendy (Ed.), Handbook of Industrial Engineering, New York: Wiley.
18. Satzinger, John W. (1991). User Interface Consistency Across End User Applications: Effect on Learning and Satisfaction, Unpublished Doctoral Dissertation, The Claremont Graduate School.

Index Terms

• Human-centered computing

  • Human computer interaction (HCI)

• Information systems

  • Data management systems

    • Query languages

• Theory of computation

  • Theory and algorithms for application domains

    • Database theory

      • Database query languages (principles)