Three important determinants of user performance for database retrieval

Three important factors that determine user performance during database retrieval are representation realism, expressive ease, and task complexity. Representation realism is the level of abstraction used when formulating queries. Expressive ease is the syntactic flexibility permitted when formulating queries. Task complexity is the level of difficulty of queries. A controlled laboratory experiment was conducted to assess the effects of these three factors on user productivity during database retrieval. The independent variables were representation realism (high versus low), expressive ease (high versus low), and query complexity (simple versus complex). The dependent variables were query accuracy and query time. Results show that all these three factors significantly affected user performance during database retrieval. However, their relative impact on query accuracy and query time differed. Moreover, these factors interacted in unique ways to moderate query accuracy and query time. Besides verifying prior empirical findings, these results offer several suggestions for future research and development work in the area of database retrieval.

[1]  Lorne Olfman,et al.  An investigation of the roles of individual differences and user interface on database usability , 1997, DATB.

[2]  ChenPeter Pin-Shan The entity-relationship modeltoward a unified view of data , 1976 .

[3]  Timothy Paul Cronan,et al.  End-user Training and Computing Effectiveness in Public Agencies: An Empirical Study , 1990, J. Manag. Inf. Syst..

[4]  Sirkka L. Jarvenpaa,et al.  End User Learning Behavior in Data Analysis and Data Modeling Tools , 1986, ICIS.

[5]  Shamkant B. Navathe,et al.  Conceptual Database Design: An Entity-Relationship Approach , 1991 .

[6]  William Kent,et al.  Limitations of record-based information models , 1979, TODS.

[7]  Keng Siau,et al.  An empirical study on end-users' update performance for different abstraction levels , 1994, Int. J. Hum. Comput. Stud..

[8]  Thomas P. Moran,et al.  Guest Editor's Introduction: An Applied Psychology of the User , 1981, CSUR.

[9]  Dinesh Batra,et al.  Improving conceptual database design through feedback , 1994, Int. J. Hum. Comput. Stud..

[10]  Gerti Kappel,et al.  Object-Oriented Database , 1999, ECOOP Workshops.

[11]  Peter P. Chen The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[12]  Phyllis Reisner,et al.  Human Factors Studies of Database Query Languages: A Survey and Assessment , 1981, CSUR.

[13]  Matthias Jarke,et al.  A Field Evaluation of Natural Language for Data Retrieval , 1983, IEEE Transactions on Software Engineering.

[14]  David W. Stemple,et al.  Human factors comparison of a procedural and a nonprocedural query language , 1981, TODS.

[15]  Charles Welty,et al.  Correcting User Errors in SQL , 1985, Int. J. Man Mach. Stud..

[16]  Clifford G. Burgess,et al.  A Graphical, Database-Querying Interface for Casual, Naive Computer Users , 1990, Int. J. Man Mach. Stud..

[17]  T. Hassard,et al.  Applied Linear Regression , 2005 .

[18]  David A. Bradbard,et al.  The Effects of Relational and Entity-Relationship Data Models on Query Performance of End Users , 1989, Int. J. Man Mach. Stud..

[19]  Albrecht Blaser,et al.  Enduser Systems and Their Human Factors , 1983, Lecture Notes in Computer Science.

[20]  Kil-Soo Suh,et al.  A Comparison of Linear Keyword and Restricted Natural Language Data Base Interfaces for Novice Users , 1992, Inf. Syst. Res..

[21]  Matthias Jarke,et al.  Using Restricted Natural Language for Data Retrieval: A Plan for Field Evaluation , 1982 .

[22]  Richard W. Scamell,et al.  A Human Factors Experimental Comparison of SQL and QBE , 1993, IEEE Trans. Software Eng..

[23]  Jacob Cohen Statistical Power Analysis for the Behavioral Sciences , 1969, The SAGE Encyclopedia of Research Design.

[24]  Linda J. Weldon,et al.  An Experimental Comparison of Natural and Structured Query Languages , 1983 .

[25]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[26]  Clifton L. Barbary A database primer on natural language , 1987 .

[27]  Keng Siau,et al.  The effect of a database feedback system on user performance , 1995, Behav. Inf. Technol..

[28]  Chetan S. Sankar,et al.  Tailoring Database Training for End Users , 1993, MIS Q..

[29]  Robert P. Bostrom,et al.  Comparing representations with relational and EER models , 1990, Commun. ACM.

[30]  Dinesh Batra,et al.  Effects of data model and task characteristics on designer performance: a laboratory study , 1994, Int. J. Hum. Comput. Stud..

[31]  Hock Chuan Chan,et al.  Database Interfaces: A Conceptual Framework and a Meta-Analysis on Natural Language Studies , 1998, J. Database Manag..

[32]  Keng Siau,et al.  User-Database Interface: The Effect of Abstraction Levels on Query Performance , 1993, MIS Q..

[33]  Magdalena Zoeppritz,et al.  Human factors of a "Natural Language" enduser system , 1983, Enduser Systems and Their Human Factors.

[34]  Phyllis Reisner,et al.  Use of Psychological Experimentation as an Aid to Development of a Query Language , 1977, IEEE Transactions on Software Engineering.

[35]  Matthias Jarke,et al.  Natural Language for Database Queries: A Laboratory Study , 1983, MIS Q..

[36]  William C. Ogden IMPLICATIONS OF A COGNITIVE MODEL OF DATABASE QUERY: COMPARISON OF A NATURAL LANGUAGE, FORMAL LANGUAGE AND DIRECT MANIPULATION INTERFACE , 1986, SGCH.

[37]  Keng Siau,et al.  The effect of data model, system and task characteristics on user query performance: an empirical study , 1997, DATB.