Performance effects of formal modeling language differences: A combined abstraction level and construct complexity analysis

IEEE Transactions on Professional Communication

Volumn 49, Issue 2, 2006, Pages 160-175

  Teo, Hock Hai ^a   Chan, Hock Chuan ^a,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

Construct complexity; Data model; Human factors; Modeling performance

Indexed keywords

ABSTRACTING; COMPUTATIONAL COMPLEXITY; DATABASE SYSTEMS; FORMAL LANGUAGES; INFORMATION THEORY;

CONSTRUCT COMPLEXITY; FORMAL MODELING LANGUAGE; LANGUANGE COMMUNICATIONS; MODELING PERFORMANCE;

DATA STRUCTURES;

EID: 33744800022     PISSN: 03611434     EISSN: None     Source Type: Journal    
DOI: 10.1109/TPC.2006.875079     Document Type: Article

References (81)

1. Y. Wand and R. Weber, "Reflection: Ontology in information systems," J. Database Manage., vol. 15, no. 2, pp. iii-vi, 2004.
2. C. Batini, S. Ceri, and S. B. Navathe, Conceptual Database Design: An Entity Relationship Approach. New York: Benjamin Cummings, 1992.
3. D. Batra, J. A. Hoffer, and R. P. Bostrom, "Comparing representations with relational and EER models," Commun. ACM, vol. 33, no. 2, pp. 126-139, 1990.
4. D. B. Bock and T. Ryan, "Accuracy in modeling with extended entity relationship and object oriented data model," J. Database Manage., vol. 4, no. 4, pp. 30-39, 1993.
5. F. Bodart, M. Sim, A. Patel, and R. Weber, "Should optional properties be used in conceptual modeling? A theory and three empirical tests," Inf. Syst. Res., vol. 12, no. 4, pp. 384-405, 2001.
6. P. L. Bowen, F. H. Rohde, and J. Basford, "Ex ante evaluations of alternate data structures for end user queries: Theory and experiment test," J. Database Manage., vol. 15, no. 4, pp. 45-70, 2004.
7. 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.
8. H. C. Chan, H. H. Teo, and X. H. Zeng, "An evaluation of novice end-user computing performance: Data modeling, query writing, and comprehension," J. Amer. Soc. Inf. Sci. Tech., vol. 56, no. 8, pp. 843-853, 2005.
9. 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. Stud., vol. 52, no. 5, pp. 831-845, 2000.
10. P. Shoval and I. Frumermann, "OO and EER conceptual schemas: A comparison of user comprehension," J. Database Manage., vol. 5, no. 4, pp. 28-38, 1994.
11. K. Siau, W. Yair, and I. Benbasat, "The relative importance of structural constraints and surface semantics in information modeling," Inf. Syst., vol. 22, no. 2-3, pp. 155-170, 1995.
12. K. L. Siau, H. C. Chan, and K. K. Wei, "Effects of query complexity and learning on novice user query performance with conceptual and logical database interfaces," IEEE Trans. Syst., Man Cybern. A, Syst. Humans, vol. 34, no. 2, pp. 276-281, Mar. 2004.
13. K. Siau, F. Nah, and Q. Cao, "A meta-analysis: Comparing relational and semantic models," IEEE Trans. Syst., Man, Cybern., to be published.
14. H. Topi and V. Ramesh, "Human factors research on data modeling: A review of prior research, an extended framework and future research directions," J. Database Manage., vol. 13, no. 2, pp. 3-19, 2002.
15. I. Vessey and S. A. Conger, "Requirements specification: Learning object, process and data methodologies," Commun. ACM, vol. 37, no. 5, pp. 102-113, 1994.
16. A. Gemino and Y. Wand. (2004) A framework for empirical evaluation of conceptual modeling techniques. Requirements Eng. [Online]. Available: http://www.springerlink.com
17. R. Weber, "Are attributes entities? A study of database designers' memory structures," Inf. Syst. Res., vol. 7, no. 2, pp. 137-162, 1996.
18. J. Cohen, Statistical Power Analysis for the Behavioral Sciences. New York: Academic, 1976.
19. R. Elmasri, J. Weeldreyer, and A. Hevner, "The category concept: An extension to the entity relationship model," Data Knowl. Eng., vol. 1, no. 11, pp. 75-116, 1985.
20. G. Booch, I. Jacobson, and J. Rumbaugh, The Unified Modeling Language User Guide. Reading, MA: Addison-Wesley, 1998.
21. W. Kim, Introduction to Object-Oriented Databases. Cambridge, MA: MIT Press, 1990.
22. D. Kroenke, Database Management, 4th ed. New York: MacMillan, 1991.
23. J. Rumbaugh, M. Blaha, W. Premerlani, F. Eddy, and W. Lorensen, Object-Oriented Modeling and Design. Englewood Cliffs, NJ: Prentice-Hall, 1991.
24. J. Peckham and F. Maryanski, "Semantic data models," ACM Comput. Surveys, vol. 20, no. 3, pp. 153-189, 1998.
25. M. L. Brodie, "On the development of data models," in On Conceptual Modeling, M. L. Brodie, J. Mylopoulos, and W. J. Schmidt, Eds. New York: Springer-Verlag, 1984.
26. J. M. Smith and D. C. P. Smith, "Database abstractions: Aggregation and generalization," ACM Trans. Database Syst., vol. 20, no. 2, pp. 105-133, 1977.
27. R. Weber, "Conceptual modeling and ontology: Possibilities and pitfalls," J Database Manag., vol. 14, no. 3, pp. 1-20, 2003.
28. H. Topi, J. S. Valacich, and J. A. Hoffer, "The effects of task complexity and time availability limitations on human performance in database query tasks," Int. J Human-Comput. Stud., vol. 62, no. 3, pp. 349-379, 2005.
29. D. Batra and N. A. Wishart, "Comparing a rule-based approach with a pattern-based approach at different levels of complexity of conceptual data modeling tasks," Int. J Human-Comput. Stud., vol. 61, no. 4, pp. 397-419, 2004.
30. S. Anotony, D. Batra, and R. Santhanam, "The use of a knowledge-based system in conceptual data modeling," Decision Support Syst., vol. 4 1, no. 1, pp. 176-188, 2005.
31. H. L. Yang, "Comparing relational database designing approaches: Some managerial implications for database training," Ind. Manage. Data Syst., vol. 103, no. 3/4, pp. 150-166, 2003.
32. A. F. Borthick, P. L. Bowen, D. R. Jones, and M. H. K. Tse, "The effects of information request ambiguity and construct incongruence on query development," Decision Support Syst., vol. 32, no. 1, pp. 3-25, 2001.
33. P. L. Bowen, R. A. O'Farrell, and F. H. Rohde, "Analysis of competing data structures: Does ontological clarity produce better end-user query performance?," in Proc. 25th Int. Conf. Information Systems, 2004, pp. 141-155.
34. A. F. Borthick, P. L. Bowen, and D. A. Robb, "The effect of base rate sensitization on end-user query performance moderated by conscientiousness," in Proc. 24th Int. Conf. Information Systems, 2003, pp. 774-781.
35. H. C. Chan and L. H. Lim, "A review of experiments on natural language interfaces," in Advanced Topics in Database Research, K. Siau, Ed. Hershey, PA: IDEA Group Pub., 2003, vol. 2, pp. 55-72.
36. Q. Cao, F. F.-H. Nah, and K. Siau, "A meta-analysis on relationship modeling accuracy: Comparing relational and semantic models," in Americas Conf. Inf. Syst., 2000, pp. 470-473.
37. D. Batra and J. G. Davis, "Conceptual database design by novice and expert database designers," in Proc. 10th Int. Conf. Inf. Syst., 1989, pp. 91-99.
38. P. C. Palvia, C. Liao, and P. To, "The impact of conceptual data models on end user performance," J. Database Manage., vol. 3, no. 4, pp. 4-15, 1992.
39. Y. G. Kim and S. T. March, "Comparing data modeling formalisms," Commun. ACM, vol. 38, no. 6, pp. 103-116, 1995.
40. B. C. Hardgrave and N. P. Dalal, "Comparing object-oriented and extended-entity-relationship data models," J. Database Manage., vol. 6, no. 3, pp. 15-21, 1995.
41. C. W. Bachman, "The programmer as navigator," Commun. ACM, vol. 16, no. 1, pp. 653-658, 1973.
42. M. Blaha and W. Premerlani, Object-Oriented Modeling and Design for Database Applications. Upper Saddle River, NJ: Prentice-Hall, 1998.
43. R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 4th ed. Reading, MA: Addison-Wesley, 2003.
44. P. M. D. Gray, K. G. Kulkarni, and N. W. Paton, Object Oriented Databases: A Semantic Data Model Approach. London, UK: Prentice-Hall, 1992.
45. J. L. Harrington, Object-Oriented Database Design Clearly Explained. San Diego, CA: Morgan Kaufmann, 2000.
46. I. T. Hawryszkiewycz, Relational Database Design. Sydney, Australia: Prentice Hall, 1990.
47. J. G. Hughes, Object-Oriented Databases. Upper Saddle River, NJ: Prentice-Hall, 1991.
48. J. L. Johnson, Database: Models, Languages, Design. New York: Oxford Univ. Press, 1997.
49. A. Silberschatz, H. F. Korth, and S. Sudarshan, Database System Concepts. New York: McGraw-Hill, 1997.
50. T. Teorey, D. Yang, and J. P. Fry, "A logical design methodology for relational databases using the extended entity-relationship model," ACM Comput. Surveys, vol. 18, no. 2, pp. 197-222, 1986.
51. H. C. Chan, "The relationship between user query accuracy and lines of code," Int. J. Human Comput. Stud., vol. 51, pp. 851-864, 1999.
52. M. Halstead, Elements of Software Science. North-Holland: Elsevier, 1977.
53. K. Siau and Q. Cao, "Unified modeling language (UML) - A complexity analysis," J. Database Manage., vol. 12, no. 1, pp. 26-34, 2001.
54. R. E. Wood, "Task complexity: Definition of the construct," Org. Behavior Human Decision Processes, vol. 37, no. 1, pp. 60-82, 1986.
55. E. L. Hutchins, J. D. Hollan, and D. A. Norman, "Direct manipulation interfaces," Hum. Comput. Interaction, vol. 1, no. 1, pp. 311-338, 1985.
56. 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.
57. W. Kent, "Limitations of the record-based information models," ACM Trans. Database Syst., vol. 4, no. 1, pp. 107-131, 1979.
58. H. A. Schmid and J. R. Swenson, "On the semantics of the relational data model," in Proc. 1975 SIGMOD Conf., 1975, pp. 211-223.
59. W. J. K. 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-Machine Stud., vol. 31, no. 3, pp. 257-267, 1989.
60. R. L. Leitheiser and S. T. March, "The influence of database structure representation on database system learning and use," J. Manage. Inf. Syst., vol. 12, no. 4, pp. 187-213, 1996.
61. H. C. Chan, B. C. Y. Tan, and K. K. Wei, "Three important determinants of user performance for database retrieval," Int. J. Hum.-Comput. Stud., vol. 51, no. 5, pp. 895-918, 1999.
62. C. Z. Wu, H. C. Chan, H. H. Teo, and K. K. Wei, "An experimental study of object-oriented query language and relational query language for novice users," J. Database Manage., vol. 5, no. 4, pp. 16-27, 1994.
63. H. C. Chan, K. K. Wei, and K. L. Siau, "An empirical study on end users' update performance for different abstraction levels," Int. J. Hum.-Comput. Stud., vol. 41, no. 3, pp. 309-328, 1994.
64. M. Rossi and S. Brinkkemper, "Complexity metrics for systems development methods and techniques," Inf. Syst., vol. 21, no. 2, pp. 209-227, 1996.
65. J. Erickson and K. Siau, "Theoretical and practical complexity of unified modeling language: Delphi study and metrics analyzes," in Proc. 25th Int. Conf. Information Systems, 2004, pp. 183-194.
66. J. B. Smelcer, "User errors in database query composition," Int. J. Hum.-Comput. Stud., vol. 42, no. 3, pp. 353-381, 1995.
67. F. Borthick, P. Bowen, and R. Diery, "Complexity and errors in SQL queries: Development and empirical comparison of complexity measures," presented at the Workshop Information Technology, Dec. 9-11, 1997.
68. P. De, A. P. Sinha, and I. Vessey, "An empirical investigation of factors influencing object oriented database querying," Inf. Tech. Manage., vol. 2, no. 1, pp. 71-93, 2001.
69. H. A. Spier and M. G. Morris, "The influence of query interface design on decision-making performance," MIS Quart., vol. 27, no. 3, pp. 397-423, 2003.
70. V. C. Storey, R. C. Goldstein, and J. Ding, "Common sense reasoning in automated database design: An empirical test," J. Database Manage., vol. 13, no. 1, pp. 3-14, 2002.
71. H. A. Simon, Models of Thought. New Haven, CT: Yale Univ. Press, 1979.
72. A. M. Jenkins, MIS Decision Variables and Decision Making Performance. Ann Arbor, MI: UMI Research Press, 1982.
73. P. Reisner, "Human factors studies of database query languages: A survey and assessment," ACM Comput. Surveys, vol. 13, no. 1, pp. 13-31, 1981.
74. F. N. Kerlinger, Foundations of Behavioral Research, 3rd ed. Orlando, FL: Holt, Rinehart and Winston, 1986.
75. F. R. McFadden and J. A. Hoffer, Database Management Systems. New York: Benjamin Cummings, 1991.
76. G. Eckert and P. Golder, "Improving object oriented analysis," Inf. Software Tech., vol. 36, no. 2, pp. 67-86, 1994.
77. C. J. Date, An Introduction to Database Systems, 8th ed. Reading, MA: Addison-Wesley, 2003.
78. S. Ram and V. Ramesh, "Collaborative conceptual schema design: A process model and prototype system," ACM Trans. Inf. Syst., vol. 16, no. 4, pp. 347-371, 1998.
79. H. C. Chan and K. K. Wei, "The effect of grading schemes on outcomes in query writing experiments," Interacting with Comput., vol. 8, no. 1, pp. 7-12, 1996.
80. J. Neter, W. Wasserman, and M. H. Kutner, Applied Linear Statistic Models: Regression, Analysis of Variance, and Experiment Designs. Homewood, IL: Irwin, 1990.
81. J. E. McGrath, Groups: Interaction and Performance. Englewood Cliffs, NJ: Prentice-Hall, 1984.