User-database interface: The effect of abstraction levels on query performance

• Main Authors: CHAN, Hock Chuan, WEI, Kwok Kee, SIAU, Keng
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 1993
• Subjects: Abstraction levels; Conceptual level; Data resource utilization; Entity-relationship model; Experimental study; Logical level; Query languages; Relational model; SQL; User performance; User-database interface; Databases and Information Systems
• Online Access: https://ink.library.smu.edu.sg/sis_research/9662; https://ink.library.smu.edu.sg/context/sis_research/article/10662/viewcontent/User_Database_Interface__The_Effect_of_Abstraction_Levels_on_Query_Performance.pdf
• Institution: Singapore Management University

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