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.
Data resource utilization
|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||URI:||http://scholarbank.nus.edu.sg/handle/10635/99457||ISSN:||02767783|
|Appears in Collections:||Staff Publications|
Show full item record
Files in This Item:
There are no files associated with this item.
checked on Aug 17, 2019
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.