ERIC Number: EJ1228478
Record Type: Journal
Publication Date: 2019
Pages: 13
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-1055-3096
EISSN: N/A
Available Date: N/A
Query Structure and Data Model Mapping Errors in Information Retrieval Tasks
Casterella, Gretchen I.; Vijayasarathy, Leo
Journal of Information Systems Education, v30 n3 p178-190 Sum 2019
SQL query writing is a challenging task for novices, even after considerable training. Query writing is a programming task and a translation task where the writer must translate a user's request for information into code that conforms to the structure, constraints, and syntax of an SQL SELECT statement and that references specific tables and columns from a database. This paper investigates the impact of two instructional interventions on query errors under conditions of low and high query complexity. Data was collected from an experimental study of 63 undergraduate students nearing completion of a 15-week database course. Our analysis reveals specific areas of query writing where each of the interventions helped, and hindered, task performance. We discuss the implications of these findings for improving SQL training and for future research on SQL training effectiveness.
Descriptors: Information Retrieval, Programming Languages, Programming, Coding, Databases, Error Patterns, Undergraduate Students, Computer Science Education, Difficulty Level
Journal of Information Systems Education. e-mail: editor@jise.org; Web site: http://www.jise.org
Publication Type: Journal Articles; Reports - Research
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A
Author Affiliations: N/A