Authors: Hock Chuan Chan, Keng Leng Siau, Kwok Kee Wei
Tags: 1993, conceptual modeling
A common classification of data models is based on their abstraction levels: physicai, logical and conceptual. The user-database interaction can be similarly classified. For the conceptuat-tevet interaction, the user and the database exchange information on the user’s wortd. e.g., information of entities, relationships, and attributes. For the iogicat-tevel interaction, the user and the database communicate based on concepts in the database system, e.g.. reiations 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 tevet shoutd therefore be easier because it is semanticaily closer to the user. This deduction was tested in an experiment using the entityrelationship (ER) model for the conceptual-level model and the relational model for the logicallevel 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 logicai-level users, and it took 33 percent iess 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 retational modei to the ER model. The experiment also provided valuable data on errors commonly made by users.Read the full paper here: https://misq.org/
