An evaluation of novice end-user computing performance: Data modeling, query writing, and comprehension

Journal of the American Society for Information Science and Technology

Volumn 56, Issue 8, 2005, Pages 843-853

  Chan, H C ^a   Teo, H H ^a   Zeng, X H ^b  

^a NATIONAL UNIVERSITY OF SINGAPORE   (Singapore)

^b UNIVERSITY OF BRITISH COLUMBIA   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

DATA MODELING; END-USER COMPUTING; QUERY WRITING; STRUCTURAL EQUATION MODELING (SEM) TECHNIQUES;

COMPUTATIONAL COMPLEXITY; COMPUTATIONAL METHODS; COMPUTER SIMULATION; MATHEMATICAL MODELS; OBJECT ORIENTED PROGRAMMING; SEMANTICS; USER INTERFACES;

DATABASE SYSTEMS;

EID: 20444462384     PISSN: 15322882     EISSN: None     Source Type: Journal    
DOI: 10.1002/asi.20178     Document Type: Article

References (67)

1. Aggarwal, A. (1994). Trends in end-user computing: A professional's perspective. Journal of End User Computing, 6(3), 32-33.
2. Ardent Software Inc. (1998, September). O2 ODMG Database system tutorial, release 5.0. Westboro, MA.
3. Aversano, L., Canfora, G., De Lucia, A., & Stefanucci, S. (2002). Understanding SQL through iconic interfaces. In G. Canfora & A. De Lucia (Eds.), Proceedings of the 26th International Conference on Computer Software and Application (pp. 703-708). Oxford, England: IEEE Computer Society Press.
4. Baltagi, B.H. (2002). Econometrics (3rd ed.). New York: Springer-Verlag.
5. Batra, D., Hoffer, J.A., & Bostrom, R.P. (1990). Comparing representations with relational and EER models. Communications of the ACM, 33(2), 126-139.
6. Batra, D., & Antony, S.R. (1994). Effects of data model and task characteristics on designer performance: A laboratory study. International Journal of Human-Computer Studies, 41(4), 481-508.
7. Blili, S., Raymond, L., & Rivard, S. (1996). Definition and measurement of enduser computing sophistication. Journal of End User Computing, 8(2), 3-12.
8. Bock, D.B., & Ryan, T. (1993). Accuracy in modeling with extended entity relationship and object-oriented data models. Journal of Database Management, 4(4), 30-39.
9. Borthick, A.F., Bowen, P.L., Jones, D.R., & Tse, M.H.K. (2001). The effects of information request ambiguity and construct incongruence on query development. Decision Support Systems, 32(1), 3-25.
10. Bowen, P.L., & Rohde, F.H. (2002). Further evidence of the effects of normalization on end-user query errors: an experimental evaluation. International Journal of Accounting Information Systems, 3(4), 255-290.
11. Burnett, M., Aggarwal, A., & Zee, P.V. (2000). Exception handling in the spreadsheet paradigm. IEEE Transactions on Software Engineering, 26(10), 923-942.
12. Chan, H.C., Siau, K.L., & Wei, K.K. (1998). The effect of data model, system, and task characteristics on user query performance-An empirical study. Data Base, 29(1), 31-49.
13. Chan, H.C., Tan, B.C.Y., & Wei, K.K. (1999). Three important determinants of user performance for database retrieval. International Journal of Human-Computer Studies, 51(5), 895-918.
14. Chan, H.C., Wei, K.K., & Siau, K.L. (1993). User-database interface: The effect of abstraction levels on query performance. MIS Quarterly, 17(4), 441-464.
15. Chen, P.S. (1976). The entity-relationship model: Toward a unified view of data. ACM Transactions on Database Systems, 1(1), 9-36.
16. Chin, W.W. (1998). Issues and opinions on structural equation modeling. MIS Quarterly, 22(1), 7-16.
17. Cowan, D.D., & Lucena, C.J.P. (1995). Abstract data views: An interface specification concept to enhance design for reuse. IEEE Transactions on Software Engineering, 21(3), 229-243.
18. Date, C.J. (1989). A guide to the SQL standard: A user's guide to the standard relational language SQL. Reading, MA: Addison-Wesley.
19. Date, C.J. (2000). An introduction to database systems. Reading, MA: Addison-Wesley.
20. Demurjuan, S.A., & Hsiao, D.K. (1988), Towards a better understanding of data models through the multilingual database system. IEEE Transactions on Software Engineering, 14(7), 946-958.
21. Fornell, C., & Bookstein, F.L. (1982). Two structural equation models: LISREL and PLS applied to customer exit-voice theory. Journal of Marketing Research, 19(4), 440-452.
22. Frick, M., & Fallis, D. (2004). Indicators of accuracy for answers to ready reference questions on the Internet. Journal of the American Society Information Science and Technology, 55(3), 238-246.
23. Gefen, D., Straub, D.W., & Boudreau, M.C. (2000). Structural equation modeling and regression: Guidelines for research practice. Communications of the AIS, 4, 1-77.
24. Gerbing, D.W., & Anderson, J.C. (1988). An updated paradigm for scale development incorporating unidimensionality and its assessment. Journal of Marketing Research, 25(2), 186-192.
25. Greenblatt, D., & Waxman, J. (1978). A study of three database query languages. In B. Shneiderman (Ed.), Databases: Improving usability and representativeness (pp. 76-87). New York: Academic Press.
26. Guimaraes, T., & Igbaria, M. (1996). Exploring the relationship between EUC problems and success. Journal of Information Resources Management, 9(2), 5-15.
27. George, D., & Mallery, P. (2001). SPSS for Windows step by step, a simple guide and reference. Allyn & Bacon, Needham Heights, MA.
28. Hardgrave, B.C., & Dalal, N.P. (1995). Comparing object-oriented and extended-entity-relationship data models. Journal of Database Management, 6(3), 15-21.
29. Hutchins, E.L., Hollan, J.D., & Norman, D.A. (1985). Direct manipulation interfaces. Human-Computer Interaction, 1, 311-338.
30. Jarvenpaa, S.L., & Machesky, J.J. (1989). Data analysis and learning: An experimental study of data modeling tools. International Journal of Man-Machine Studies, 31(4), 367-391.
31. Jih, W.J.K., Bradbard, D.A., Snyder, C.A., & Thompson, N.G.A. (1989). The effects of relational and entity-relationship data models on query performance of end-users. International Journal of Man-Machine Studies, 31(3), 257-267.
32. Juhn, S.H., & Naumann, J.D. (1985). The effectiveness of data representation characteristics on user validation. In L. Gallegos, R. Welke, & J. Wetherbe (Eds.), Proceedings of the 6th International Conference on Information Systems (pp. 212-226).
33. Kang, I.-S., Bae, J.-H.J., & Lee, J.-H. (2002). Database semantics representation for natural language access. In Proceedings of the 1st International Symposium on Cyber Worlds (pp. 127-133). Tokyo, Japan: IEEE Computer Society Press.
34. Kappelman, L.A., Thompson, J.P., & McLean, E.R. (1993). Converging end-user and corporate computing. Communications of the ACM, 36(12), 79-92.
35. Kent, W. (1979). Limitations of the record based information models. ACM Transactions on Database Systems, 4(1), 107-131.
36. Lee, H., & Choi, B.G. (1998). A comparative study of conceptual data modeling techniques. Journal of Database Management, 9(2), 26-35.
37. Liao, C., & Palvia, P.C. (2000). The impact of data models and task complexity on end-user performance: An experimental investigation. International Journal of Human-Computer Studies, 52(5), 831-845.
38. Martin, J. (1983). Managing the data-base environment. Englewood Cliffs, NJ: Prentice-Hall.
39. Niemi, T., Hirvonen, L., & Järvelin, K. (2003). Multidimensional data model and query language for informetrics. Journal of the American Society Information Science and Technology, 54(10), 939-952.
40. Nijssen, G.M. (1981). An architecture for knowledge based systems. In Proceedings of the SPOT-2 Conference.
41. Ogden, W.C. (1986). Implications of a cognitive model of database query: Comparison of a natural language, a formal language, and direct manipulation interface. ACM SIGCHI Bulletin, 18(2), 51-54.
42. Owei, V. (2000). Natural language querying of databases: An information extraction approach in the conceptual query language. International Journal of Human-Computer Studies, 53(4), 439-492.
43. Owei, V., & Navathe, S.B. (2001). Enriching the conceptual basis for query formulation through relationship semantics in databases. Information Systems, 26(6), 445-475.
44. Palvia, P., Liao, C., & To, P.L. (1992). The impact of conceptual models on end-user performance. Journal of Database Management, 3(4), 4-15.
45. Powell, A., & Moore, J.E. (2002). The focus of research in end user computing: Where have we come since the 1980s? Journal of End User Computing, 14(1), 3-22.
46. Purchase, H.C., Colpoys, L., McGill, M., Carrington, D., & Britton, C. (2001). UML class diagram syntax: An empirical study of comprehension. In P. Eades & T. Pattison (Eds.), Proceedings of the Australian Symposium on Information Visualization (Sect. 9, pp. 113-120). Sydney, Australia: Australian Computer Society, Inc.
47. Reisner, P. (1977). Use of psychological experimentation as an aid to development of a query language. IEEE Transactions on Software Engineering, 3(3), 218-229.
48. Reisner, P. (1981). Human factors studies of database query languages: A survey and assessment. ACM Computing Surveys, 13(1), 13-31.
49. Rumbaugh, J., Blaha, M., Premerlani, W., Eddy, F., & Lorensen, W. (1991). Object-oriented modeling and design. Englewood Cliffs: NJ: Prentice-Hall.
50. Rumbaugh, J., Jacobson, I., & Booch, G. (1999). The unified modeling language reference manual. Reading, MA: Addison-Wesley.
51. Santhanam, R., & Batra, D. (1998). The human-computer interface in information system design. Data Base, 29(1), 25-30.
52. Schmid, H.A., & Swenson, J.R. (1975, May). On the semantics of the relational model. Paper presented at the ACM-SIGMOD Conference (pp. 211-233), San Jose, CA.
53. Shneiderman, B. (1997). Direct manipulation for comprehensible, predictable and controllable user interfaces. In J. Moore, E. Edmonds, & A. Puerta (Eds.), Proceedings of the 2nd International Conference on Intelligent User Interfaces (pp. 33-39). Orlando, FL: ACM Press.
54. Shoval, P., & Even-Chaime, M. (1987). Database schema design: An experimental comparison between normalization and information analysis. Data Base, 18(3), 30-39.
55. Shoval, P., & Frumermann, I. (1994). OO and EER conceptual schemas: A comparison of user comprehension. Journal of Database Management, 5(4), 28-38.
56. Shoval, P., & Shiran, S. (1995). An experimental comparison of entity-relationship and object-oriented model on quality of design. In A. Motro & M. Tennenholtz (Eds.), Proceedings of the Second International Workshop on Next Generation Information Technologies and Systems (pp. 27-29).
57. Siau, K.L., Chan, H.C., & Wei, K.K. (1995). The effects of conceptual and logical interfaces on visual query performance of end users. In J.I. DeGross, G. Arlav, C. Beath, R. Hoyer, & C. Kernerer (Eds.), Proceedings of the 16th International Conference on Information Systems (pp. 225-235).
58. Siau, K., Wand, Y., & Benbasat, I. (1997). The relative importance of structural constraints and surface semantics in information modeling. Information Systems, 22(2), 155-170.
59. Sinha, A.P., & Vessey, I. (1999). An empirical investigation of entity-based and object-oriented data modeling: A development life cycle approach. In P. De & J.I. DeGross (Eds.), Proceedings of the 20th International Conference on Information Systems (pp. 229-244).
60. Smelcer, J.B. (1995). User errors in database query composition. International Journal of Human Computer Studies, 42(4), 353-381.
61. Stone, E. (1978). Research methods in organization behavior. Glenview, IL: Scott, Foresman and Co.
62. Suh, K.S., & Perkins, W.C. (1994). The effects of a system echo in a restricted natural language database interface for novice users. In J.F. Nunamaker & R.H. Sprague (Eds.), Proceedings of the 27th Annual Hawaii International Conference on System Sciences (pp. 594-599).
63. Underwood, J., Spavold, J., & Underwood, G. (1990). Novice use of a relational database: A case study of a local history data file. Computers & Education, 15(3), 227-232.
64. Watterson, K. (1998). When it comes to choosing a database, the object is value. Datamation, 100-107.
65. Weber, R. (1996). Are attributes entities? A study of database designers' memory structures. Information Systems Research, 7(2), 137-162.
66. Wu, C.Z., Chan, H.C., Teo, H.H., & Wei, K.K. (1994). An experimental study of object-oriented query language and relational query language for novice users. Journal of Database Management, 5(4), 16-27.
67. Yen, M., & Scamell, R.W. (1993). A human factors experimental comparison of SQL and QBE. IEEE Transactions on Software Engineering, 19(4), 390-409.