Please use this identifier to cite or link to this item:
Title: User-database interface: The effect of abstraction levels on query performance
Authors: Chan, H.C. 
Wei, K.K. 
Siau, K.L.
Keywords: Abstraction levels
Conceptual level
Data resource utilization
Entity-relationship model
Experimental study
Logical level
Query languages
Relational model
User performance
User-database interface
Issue Date: Dec-1993
Citation: Chan, H.C.,Wei, K.K.,Siau, K.L. (1993-12). User-database interface: The effect of abstraction levels on query performance. MIS Quarterly: Management Information Systems 17 (4) : 441-459. ScholarBank@NUS Repository.
Abstract: 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
Source Title: MIS Quarterly: Management Information Systems
ISSN: 02767783
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

Page view(s)

checked on Feb 28, 2021

Google ScholarTM


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.