The Effect of User View Characteristics on Database Design Performance of Novices

The Effect of User View Characteristics on Database Design Performance of Novices

Dinesh Batra
Copyright: © 1997 |Pages: 10
DOI: 10.4018/jdm.1997070103
OnDemand:
(Individual Articles)
Available
$37.50
Current Special Offers
No Current Special Offers
TOTAL SAVINGS: $37.50

Abstract

Database design is a complex task for end users and novice designers. User views are an excellent input source for database design. This research investigates the effect of certain characteristics of user views on designer performance in the logical database design task. The study examines the extent to which performance of nonexpert designers engaged in normalizing user views and eliminating derived relationships can be predicted by examining the structure of user views. Two constructs that capture the complexity of a user view are defined - degree of nesting and derivation span. User views which varied on these parameters were included in a case. Subjects, who were enrolled in a database class and had learned the view decomposition approach, were asked to conduct logical database design of the case. Each view was graded using a predefined scheme. For each subject, there was a set of scores obtained for each user view. A multiple regression analysis using scores as the dependent variable indicated that both independent variables - degree of nesting and derivation span - significantly explained designer performance in normalizing the user views. Further, subjects had considerable difficulty in detecting derived relationships. The findings suggest that the degree of nesting and derivation distance cause complexity in database design tasks and lower designer performance.

Complete Article List

Search this Journal:
Reset
Volume 35: 1 Issue (2024)
Volume 34: 3 Issues (2023)
Volume 33: 5 Issues (2022): 4 Released, 1 Forthcoming
Volume 32: 4 Issues (2021)
Volume 31: 4 Issues (2020)
Volume 30: 4 Issues (2019)
Volume 29: 4 Issues (2018)
Volume 28: 4 Issues (2017)
Volume 27: 4 Issues (2016)
Volume 26: 4 Issues (2015)
Volume 25: 4 Issues (2014)
Volume 24: 4 Issues (2013)
Volume 23: 4 Issues (2012)
Volume 22: 4 Issues (2011)
Volume 21: 4 Issues (2010)
Volume 20: 4 Issues (2009)
Volume 19: 4 Issues (2008)
Volume 18: 4 Issues (2007)
Volume 17: 4 Issues (2006)
Volume 16: 4 Issues (2005)
Volume 15: 4 Issues (2004)
Volume 14: 4 Issues (2003)
Volume 13: 4 Issues (2002)
Volume 12: 4 Issues (2001)
Volume 11: 4 Issues (2000)
Volume 10: 4 Issues (1999)
Volume 9: 4 Issues (1998)
Volume 8: 4 Issues (1997)
Volume 7: 4 Issues (1996)
Volume 6: 4 Issues (1995)
Volume 5: 4 Issues (1994)
Volume 4: 4 Issues (1993)
Volume 3: 4 Issues (1992)
Volume 2: 4 Issues (1991)
Volume 1: 2 Issues (1990)
View Complete Journal Contents Listing