Publication Type

Journal Article

Version

publishedVersion

Publication Date

9-1994

Abstract

Recent laboratory experiments have shown a strong tendency that database users can perform better at the conceptual level than at the logical level. The experiments measured users’ performance for the tasks of database design and database retrieval. Besides database design and retrieval, the third major database task is update. User performance for updates has not been measured. With the widespread availability of databases, updates will be done frequently by end-users. This task is gaining in importance as a measure of the usability of a database system. An experiment was conducted to measure the effect of different abstraction levels on user performance for updates. A conceptual level group used the entity relationship model with an entity relationship query language KQL, while a logical level group used the relational model with the standard relational language SQL. Performance was primarily measured by the accuracy of the update query. Secondary measures of time and confidence were also taken. The results showed that updates at the conceptual level were 15.4% more accurate and required only 57.8% of the time taken for logical level updates. The differences were statistically significant with p values of less than 0.03.

Keywords

Laboratory experiments, Database users, Database design, Relational language (SQL)

Discipline

Databases and Information Systems

Research Areas

Cybersecurity; Information Systems and Management

Publication

International Journal of Human-Computer Studies

Volume

41

Issue

3

First Page

309

Last Page

328

ISSN

1071-5819

Identifier

10.1006/ijhc.1994.1061

Publisher

Elsevier

Additional URL

https://doi.org/10.1006/ijhc.1994.1061

Download

Share

COinS