Effects of Graphical Versus Textual Representation of Database Structure on Query Performance

Effects of Graphical Versus Textual Representation of Database Structure on Query Performance

Wesley Jamison (University of Pittsburgh at Greensburg, USA) and James T.C. Teng (University of South Carolina, USA)
Copyright: © 1993 |Pages: 9
DOI: 10.4018/jdm.1993010102

Abstract

A graphical form of representation for database structure was designed to make explicit aspects of database structure that users must discover in order to compose successful queries. In a laboratory experiment, subjects wrote queries using the graphic style of representation as well as the less explicit textual style of documentation. Graphic and textual database representations were compared in both less complex (i.e., three-file) and more complex (i.e., six-file) databases. Results showed that subjects were faster, more accurate, and generally experience less difficulty in writing queries when using the graphic style of representation than when using the textual style of representation. Style of representation did not interact significantly with the complexity of the database in determining query writing performance. The findings from ratings on the difficulty of using the documentation showed that subjects rated the graphic documentation as more helpful only when it made explicit information for writing queries. Implications of the findings for database administration and directions for future research are discussed.

Complete Article List

Search this Journal:
Reset
Open Access Articles
Volume 31: 4 Issues (2020): 2 Released, 2 Forthcoming
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