Publication Type
Journal Article
Version
publishedVersion
Publication Date
12-1997
Abstract
With the proliferation of end-user computing and empowerment of end users in the organizations, the user-database interface is increasingly being recognized as an important research area. A user-database interface consists of two key components: the data model and the query language. Database management system designers can manipulate these two components to produce an effective database interface to maximize user task performance. However, in order to do this, the designers first need to know the effect of the two components on end users and the interaction effect of the two components. Despite the acknowledgment of user-database interface as a cornerstone in database utilization, there is still a paucity of research in this area.In this paper, we report on an empirical study that investigates the effect of entity-relationship versus relational models, and textual versus visual query languages for user-database interfaces. A good understanding of how the data models and query languages affect the user performance will enable the database developer to choose and design interfaces that can provide effective and efficient support for end users.
Keywords
user-database interface, entity-rela- tionship model, relational model, textual query lan- guage, visual query language
Discipline
Databases and Information Systems
Research Areas
Information Systems and Management
Areas of Excellence
Digital transformation
Publication
Data Base for Advances in Information Systems
Volume
29
Issue
1
First Page
31
Last Page
49
ISSN
0095-0033
Identifier
10.1145/506812.506820
Publisher
ACM Sigmis
Citation
CHAN, Hock; SIAU, Keng; and WEI, Kwok-Kee.
The effect of data model, system and task characteristics on user query performance – An empirical study. (1997). Data Base for Advances in Information Systems. 29, (1), 31-49.
Available at: https://ink.library.smu.edu.sg/sis_research/9937
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.
Additional URL
https://doi.org/10.1145/506812.506820
