An Exploratory Analysis of Semantic Network Complexity for Data Modeling Performance

Database modeling performance varies across different constructs. For example, it is usually easier to model a binary relationship than a ternary relationship. Based upon the empirical performance data, ternary relationships are thought to be more complex than binary ones. This paper investigates the relationship between user modeling performance and the complexity of the data model constructs. A complexity estimate is proposed that measures complexity based on three different aspects: component, coordinative and coupling complexity. The aggregation of the three provides the total complexity estimate. Two semantic network variations that users might use are suggested, and their complexity values compared against known user performance. Regression results show reasonable R square values. This analysis suggests that using semantic networks could be a practical way to estimate modeling complexity and user performance. Future research can consider more refined variations of the semantic network, to account for training, experience, and different data models.

[1]  Hock Chuan Chan,et al.  The relationship between user query accuracy and lines of code , 1999, Int. J. Hum. Comput. Stud..

[2]  R. Wood Task complexity: Definition of the construct , 1986 .

[3]  Allan Collins,et al.  A spreading-activation theory of semantic processing , 1975 .

[4]  Christof Ebert Tracing complexity through the software process , 1995, Proceedings of First IEEE International Conference on Engineering of Complex Computer Systems. ICECCS'95.

[5]  Chechen Liao,et al.  The impact of data models and task complexity on end-user performance: an experimental investigation , 2000, Int. J. Hum. Comput. Stud..

[6]  Hossein Saiedian,et al.  An evaluation of extended entity-relationship model , 1997, Inf. Softw. Technol..

[7]  Robert P. Bostrom,et al.  Comparing Representations wit Relational and EER Models h , 1990 .

[8]  Dov Te'eni,et al.  Modeling as constrained problem solving: an empirical study of the data modeling process , 1995 .

[9]  Bernard C. Y. Tan,et al.  Three important determinants of user performance for database retrieval , 1999, Int. J. Hum. Comput. Stud..

[10]  P. Corning Complexity Is Just a Word , 1998 .

[11]  Peretz Shoval,et al.  Entity-Relationship and Object-Oriented Data Modeling-an Experimental Comparison of Design Quality , 1997, Data Knowl. Eng..

[12]  Douglas B. Bock,et al.  Accuracy in Modeling with Extended Entity Relationship and Object Oriented Data Models , 1993 .

[13]  QuillianM. Ross The teachable language comprehender , 1969 .

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