Query Structure and Data Model Mapping Errors in Information Retrieval Tasks

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 s...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:Journal of information systems education Ročník 30; číslo 3; s. 178 - 190
Hlavní autoři: Casterella, Gretchen I, Vijayasarathy, Leo
Médium: Journal Article
Jazyk:angličtina
Vydáno: West Lafayette Journal of Information Systems Education 22.06.2019
EDSIG
Témata:
Coding
College students
Columns (structural)
Computer Science Education
Curricula
Data analysis
Data mining
Data models
Database Design
Difficulty Level
Error Patterns
Errors
Information Retrieval
Information storage and retrieval
Information systems
Instructional Effectiveness
Intervention
Language
Mapping
Natural language
Novices
Programming
Programming Languages
Queries
Query formulation
Query languages
Retrieval
Scholarship
Skills
Structured Query Language-SQL
Syntactic structures
Syntax
Task performance
Training
Undergraduate Students
Writers
Writing
United Kingdom
ISSN:1055-3096, 2574-3872
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Popis
Shrnutí: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.
Bibliografie:ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
ISSN:1055-3096
2574-3872