@inproceedings{c9e0aaf7a5c3496e9d4f6eb555cfed00,
title = "DBSnap-Eval: Identifying Database Query Construction Patterns",
abstract = "Learning to construct database queries can be a challenging task because students need to learn the specific query language syntax as well as properly understand the effect of each query operator and how multiple operators interact in a query. While some previous studies have looked into the types of database query errors students make and how the availability of expected query results can help to increase the success rate, there is very little that is known regarding the patterns that emerge while students are constructing a query. To be able to look into the process of constructing a query, in this paper we introduce DBSnap-Eval, a tool that supports tree-based queries (similar to SQL query plans) and a block-based querying interface to help separate the syntax and semantics of a query. DBSnap-Eval closely monitors the actions students take to construct a query such as adding a dataset or connecting a dataset with an operator. This paper presents an initial set of results about database query construction patterns using DBSnap-Eval. Particularly, it reports identified patterns in the process students follow to answer common database queries.",
keywords = "block-based system, database queries, database systems, relational algebra, sql",
author = "Silva, {Yasin N.} and Alexis Loza and Humberto Razente",
note = "Publisher Copyright: {\textcopyright} 2022 ACM.; 27th ACM Conference on Innovation and Technology in Computer Science Education, ITiCSE 2022 ; Conference date: 08-07-2022 Through 13-07-2022",
year = "2022",
month = jul,
day = "7",
doi = "10.1145/3502718.3524822",
language = "English (US)",
series = "Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE",
publisher = "Association for Computing Machinery",
pages = "131--137",
booktitle = "ITiCSE 2022 - Proceedings of the 27th ACM Conference on Innovation and Technology in Computer Science Education",
}