DBSnap: Learning database queries by snapping blocks

Yasin Silva, Jaime Chon

Research output: Chapter in Book/Report/Conference proceedingConference contribution

3 Citations (Scopus)

Abstract

A significant amount of recent research in Computer Science Education has focused on studying block-based programming. In this approach, computer programs are created by connecting blocks and the blocks' shapes determine the permitted connections. The focus is on the program's logic instead of its syntax. This paper introduces DBSnap, a web-based application to build database queries, particularly relational algebra queries, by snapping blocks. DBSnap fully supports the construction of intuitive database query trees, which is one of the most effective approaches to teach database queries. DBSnap is also highly dynamic and shows the query results as the query is being built. The user can also inspect, at any time, the intermediate results of any query node. This paper presents DBSnap's design and implementation details, an evaluation of its effectiveness as a learning environment, and a thorough comparison with alternative ways to teach query languages. DBSnap is publicly available and aims to have the same transformational effect on database learning as previous block-based systems had on traditional programming learning.

Original languageEnglish (US)
Title of host publicationSIGCSE 2015 - Proceedings of the 46th ACM Technical Symposium on Computer Science Education
PublisherAssociation for Computing Machinery, Inc
Pages179-184
Number of pages6
ISBN (Print)9781450329668
DOIs
StatePublished - Feb 24 2015
Event46th SIGCSE Technical Symposium on Computer Science Education, SIGCSE 2015 - Kansas City, United States
Duration: Mar 4 2015Mar 7 2015

Other

Other46th SIGCSE Technical Symposium on Computer Science Education, SIGCSE 2015
CountryUnited States
CityKansas City
Period3/4/153/7/15

Fingerprint

programming
data processing program
computer science
syntax
learning
learning environment
Query languages
Computer programming
evaluation
Computer science
Algebra
Computer program listings
education
Education
time

Keywords

  • Databases curricula
  • Query languages
  • Relational algebra

ASJC Scopus subject areas

  • Education
  • Computer Science (miscellaneous)

Cite this

Silva, Y., & Chon, J. (2015). DBSnap: Learning database queries by snapping blocks. In SIGCSE 2015 - Proceedings of the 46th ACM Technical Symposium on Computer Science Education (pp. 179-184). Association for Computing Machinery, Inc. https://doi.org/10.1145/2676723.2677220

DBSnap : Learning database queries by snapping blocks. / Silva, Yasin; Chon, Jaime.

SIGCSE 2015 - Proceedings of the 46th ACM Technical Symposium on Computer Science Education. Association for Computing Machinery, Inc, 2015. p. 179-184.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Silva, Y & Chon, J 2015, DBSnap: Learning database queries by snapping blocks. in SIGCSE 2015 - Proceedings of the 46th ACM Technical Symposium on Computer Science Education. Association for Computing Machinery, Inc, pp. 179-184, 46th SIGCSE Technical Symposium on Computer Science Education, SIGCSE 2015, Kansas City, United States, 3/4/15. https://doi.org/10.1145/2676723.2677220
Silva Y, Chon J. DBSnap: Learning database queries by snapping blocks. In SIGCSE 2015 - Proceedings of the 46th ACM Technical Symposium on Computer Science Education. Association for Computing Machinery, Inc. 2015. p. 179-184 https://doi.org/10.1145/2676723.2677220
Silva, Yasin ; Chon, Jaime. / DBSnap : Learning database queries by snapping blocks. SIGCSE 2015 - Proceedings of the 46th ACM Technical Symposium on Computer Science Education. Association for Computing Machinery, Inc, 2015. pp. 179-184
@inproceedings{7e70e7f5573b4bea9dafe5519f157601,
title = "DBSnap: Learning database queries by snapping blocks",
abstract = "A significant amount of recent research in Computer Science Education has focused on studying block-based programming. In this approach, computer programs are created by connecting blocks and the blocks' shapes determine the permitted connections. The focus is on the program's logic instead of its syntax. This paper introduces DBSnap, a web-based application to build database queries, particularly relational algebra queries, by snapping blocks. DBSnap fully supports the construction of intuitive database query trees, which is one of the most effective approaches to teach database queries. DBSnap is also highly dynamic and shows the query results as the query is being built. The user can also inspect, at any time, the intermediate results of any query node. This paper presents DBSnap's design and implementation details, an evaluation of its effectiveness as a learning environment, and a thorough comparison with alternative ways to teach query languages. DBSnap is publicly available and aims to have the same transformational effect on database learning as previous block-based systems had on traditional programming learning.",
keywords = "Databases curricula, Query languages, Relational algebra",
author = "Yasin Silva and Jaime Chon",
year = "2015",
month = "2",
day = "24",
doi = "10.1145/2676723.2677220",
language = "English (US)",
isbn = "9781450329668",
pages = "179--184",
booktitle = "SIGCSE 2015 - Proceedings of the 46th ACM Technical Symposium on Computer Science Education",
publisher = "Association for Computing Machinery, Inc",

}

TY - GEN

T1 - DBSnap

T2 - Learning database queries by snapping blocks

AU - Silva, Yasin

AU - Chon, Jaime

PY - 2015/2/24

Y1 - 2015/2/24

N2 - A significant amount of recent research in Computer Science Education has focused on studying block-based programming. In this approach, computer programs are created by connecting blocks and the blocks' shapes determine the permitted connections. The focus is on the program's logic instead of its syntax. This paper introduces DBSnap, a web-based application to build database queries, particularly relational algebra queries, by snapping blocks. DBSnap fully supports the construction of intuitive database query trees, which is one of the most effective approaches to teach database queries. DBSnap is also highly dynamic and shows the query results as the query is being built. The user can also inspect, at any time, the intermediate results of any query node. This paper presents DBSnap's design and implementation details, an evaluation of its effectiveness as a learning environment, and a thorough comparison with alternative ways to teach query languages. DBSnap is publicly available and aims to have the same transformational effect on database learning as previous block-based systems had on traditional programming learning.

AB - A significant amount of recent research in Computer Science Education has focused on studying block-based programming. In this approach, computer programs are created by connecting blocks and the blocks' shapes determine the permitted connections. The focus is on the program's logic instead of its syntax. This paper introduces DBSnap, a web-based application to build database queries, particularly relational algebra queries, by snapping blocks. DBSnap fully supports the construction of intuitive database query trees, which is one of the most effective approaches to teach database queries. DBSnap is also highly dynamic and shows the query results as the query is being built. The user can also inspect, at any time, the intermediate results of any query node. This paper presents DBSnap's design and implementation details, an evaluation of its effectiveness as a learning environment, and a thorough comparison with alternative ways to teach query languages. DBSnap is publicly available and aims to have the same transformational effect on database learning as previous block-based systems had on traditional programming learning.

KW - Databases curricula

KW - Query languages

KW - Relational algebra

UR - http://www.scopus.com/inward/record.url?scp=84942422924&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84942422924&partnerID=8YFLogxK

U2 - 10.1145/2676723.2677220

DO - 10.1145/2676723.2677220

M3 - Conference contribution

AN - SCOPUS:84942422924

SN - 9781450329668

SP - 179

EP - 184

BT - SIGCSE 2015 - Proceedings of the 46th ACM Technical Symposium on Computer Science Education

PB - Association for Computing Machinery, Inc

ER -