Author List: Chan, Hock Chuan; Wei, Kwok-Kee; Siau, Keng Leng;
MIS Quarterly, 1993, Volume 17, Issue 4, Page 441-464.
A common classification of data models is based on their abstraction levels: physical, logical and conceptual. The user-database interaction can be similarly classified. For the conceptual-level interaction, the user and the database exchange information on the user's world, e.g., information of entities, relationships, and attributes. For the logical-level interaction, the user and the database communicate based on concepts in the database system, e.g.. relations and join operations. We expect users to be familiar with concepts in their world but not the concepts in the database system. This is especially so for infrequent or naive database users. The conceptual level should therefore be easier because it is semantically closer to the user. This deduction was tested in an experiment using the entity-relationship (ER) model for the conceptual-level model and the relational model for the logical-level model. The results were affirmative. The users at the conceptual level had 38 percent higher accuracy and 16 percent higher confidence than users at the logical level. The conceptual-level users took 65 percent less time than the logical-level users, and it took 33 percent less time to train them. The differences were statistically significant with p < 0.003. The huge differences indicate that noticeable improvements can be made by switching from the relational model to the ER model. The experiment also provided valuable data on errors commonly made by users.
Keywords: abstraction levels; conceptual level; Data resource utilization; entity relationship model; experimental study; logical level; query languages; relational model; user performance; user-database interface
Algorithm:

List of Topics

#216 0.269 conceptual model modeling object-oriented domain models entities representation understanding diagrams schema semantic attributes represented representing object relationships concepts classes entity-relationship
#254 0.159 level levels higher patterns activity results structures lower evolution significant analysis degree data discussed implications stable cluster exist relationships identify
#281 0.138 database language query databases natural data queries relational processing paper using request views access use matching automated semantic based languages
#25 0.131 relationships relationship relational information interfirm level exchange relations perspective model paper interpersonal expertise theory study effects literature role social identify
#9 0.117 using subjects results study experiment did conducted task time used experienced use preference experimental presented decision-making empirical significantly effects better
#283 0.083 interface user users interaction design visual interfaces human-computer navigation human need cues studies guidelines laboratory functional developed restricted know guided