Please use this identifier to cite or link to this item: https://doi.org/10.1006/ijhc.1999.0264
Title: Relationship between user query accuracy and lines of code
Authors: Chan, H.C. 
Issue Date: 1999
Source: Chan, H.C. (1999). Relationship between user query accuracy and lines of code. International Journal of Human Computer Studies 51 (5) : 851-864. ScholarBank@NUS Repository. https://doi.org/10.1006/ijhc.1999.0264
Abstract: In experimental studies on query languages, subjects are required to write queries using different query languages. User query performance is usually measured by query accuracy. There is no clearly defined objective method of applying findings to other queries. This study examines the suitability of using a software metric based on lines of code to estimate user query accuracy. Lines of code have been measured in various ways, such as physical source code lines, logical source code lines or compiled bytes. A method of counting line of code for database queries is proposed and applied to two query languages. The new method counts Boolean conditions as well as other statements. The relationship between lines of code and user query accuracy was examined with regression models. The results show that lines of code can explain a high percentage of the variance in accuracy, with R2>0.8 for the standard relational model query language SQL, and R2>0.9 for the entity relationship model query language KQL. The common assumption that more lines of code will lead to lower accuracy is only partly validated. The findings show a nonlinear relationship, with a possible recovery in accuracy for queries with many lines of code. The results indicate that lines of code can be usefully applied in the study of query languages.
Source Title: International Journal of Human Computer Studies
URI: http://scholarbank.nus.edu.sg/handle/10635/42402
ISSN: 10715819
DOI: 10.1006/ijhc.1999.0264
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

SCOPUSTM   
Citations

9
checked on Dec 11, 2017

WEB OF SCIENCETM
Citations

9
checked on Dec 11, 2017

Page view(s)

43
checked on Dec 9, 2017

Google ScholarTM

Check

Altmetric


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.