DBSnap++

Creating data-driven programs by snapping blocks

Yasin Silva, Thomas G. Schenk, Anthony Nieuwenhuyse, Alaura Symons

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

Abstract

A key development in Computer Science Education has been the introduction of block-based programming environments where programs are created by connecting blocks and the focus is on the program’s logic instead of its syntax. Most of these environments support conventional (imperative) programming instructions. More recently, some systems have been proposed to enable the specification of database queries. While these two types of environments have been independently studied, there is significantly less work on the development and study of integrated environments that allow the creation of complete data-driven programs (real-world like programs that integrate conventional instructions and database queries). This paper introduces DBSnap++, a web-based environment that enables the specification of dynamic data-driven programs. DBSnap++ supports the specification of intuitive database query trees, a new type of list that dynamically gets its content executing a database query, and programs that generate different results when the underlying data changes. This paper presents DBSnap++’s design and implementation details, an array of programs to demonstrate how it can be effectively used as a learning tool, and a thorough comparison with other environments. DBSnap++ is publicly available and aims to enable learners to fully understand and utilize the capabilities of data-driven programs.

Original languageEnglish (US)
Title of host publicationITiCSE 2018 - Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education
EditorsPanayiotis Andreou, Michal Armoni, Janet C. Read, Irene Polycarpou
PublisherAssociation for Computing Machinery
Pages170-175
Number of pages6
ISBN (Electronic)9781450357074
DOIs
StatePublished - Jul 2 2018
Event23rd Annual ACM Conference on Innovation and Technology in Computer Science Education, ITiCSE 2018 - Larnaca, Cyprus
Duration: Jul 2 2018Jul 4 2018

Other

Other23rd Annual ACM Conference on Innovation and Technology in Computer Science Education, ITiCSE 2018
CountryCyprus
CityLarnaca
Period7/2/187/4/18

Fingerprint

Specifications
Computer science
programming
Education
instruction
computer science
syntax
Data base
Query
learning
education
Programming

Keywords

  • Data-driven programs
  • Databases curricula
  • Query languages

ASJC Scopus subject areas

  • Management of Technology and Innovation
  • Education

Cite this

Silva, Y., Schenk, T. G., Nieuwenhuyse, A., & Symons, A. (2018). DBSnap++: Creating data-driven programs by snapping blocks. In P. Andreou, M. Armoni, J. C. Read, & I. Polycarpou (Eds.), ITiCSE 2018 - Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education (pp. 170-175). Association for Computing Machinery. https://doi.org/10.1145/3197091.3197114

DBSnap++ : Creating data-driven programs by snapping blocks. / Silva, Yasin; Schenk, Thomas G.; Nieuwenhuyse, Anthony; Symons, Alaura.

ITiCSE 2018 - Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education. ed. / Panayiotis Andreou; Michal Armoni; Janet C. Read; Irene Polycarpou. Association for Computing Machinery, 2018. p. 170-175.

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

Silva, Y, Schenk, TG, Nieuwenhuyse, A & Symons, A 2018, DBSnap++: Creating data-driven programs by snapping blocks. in P Andreou, M Armoni, JC Read & I Polycarpou (eds), ITiCSE 2018 - Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education. Association for Computing Machinery, pp. 170-175, 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education, ITiCSE 2018, Larnaca, Cyprus, 7/2/18. https://doi.org/10.1145/3197091.3197114
Silva Y, Schenk TG, Nieuwenhuyse A, Symons A. DBSnap++: Creating data-driven programs by snapping blocks. In Andreou P, Armoni M, Read JC, Polycarpou I, editors, ITiCSE 2018 - Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education. Association for Computing Machinery. 2018. p. 170-175 https://doi.org/10.1145/3197091.3197114
Silva, Yasin ; Schenk, Thomas G. ; Nieuwenhuyse, Anthony ; Symons, Alaura. / DBSnap++ : Creating data-driven programs by snapping blocks. ITiCSE 2018 - Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education. editor / Panayiotis Andreou ; Michal Armoni ; Janet C. Read ; Irene Polycarpou. Association for Computing Machinery, 2018. pp. 170-175
@inproceedings{da10987d29214286af03eb61478fad6c,
title = "DBSnap++: Creating data-driven programs by snapping blocks",
abstract = "A key development in Computer Science Education has been the introduction of block-based programming environments where programs are created by connecting blocks and the focus is on the program’s logic instead of its syntax. Most of these environments support conventional (imperative) programming instructions. More recently, some systems have been proposed to enable the specification of database queries. While these two types of environments have been independently studied, there is significantly less work on the development and study of integrated environments that allow the creation of complete data-driven programs (real-world like programs that integrate conventional instructions and database queries). This paper introduces DBSnap++, a web-based environment that enables the specification of dynamic data-driven programs. DBSnap++ supports the specification of intuitive database query trees, a new type of list that dynamically gets its content executing a database query, and programs that generate different results when the underlying data changes. This paper presents DBSnap++’s design and implementation details, an array of programs to demonstrate how it can be effectively used as a learning tool, and a thorough comparison with other environments. DBSnap++ is publicly available and aims to enable learners to fully understand and utilize the capabilities of data-driven programs.",
keywords = "Data-driven programs, Databases curricula, Query languages",
author = "Yasin Silva and Schenk, {Thomas G.} and Anthony Nieuwenhuyse and Alaura Symons",
year = "2018",
month = "7",
day = "2",
doi = "10.1145/3197091.3197114",
language = "English (US)",
pages = "170--175",
editor = "Panayiotis Andreou and Michal Armoni and Read, {Janet C.} and Irene Polycarpou",
booktitle = "ITiCSE 2018 - Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education",
publisher = "Association for Computing Machinery",

}

TY - GEN

T1 - DBSnap++

T2 - Creating data-driven programs by snapping blocks

AU - Silva, Yasin

AU - Schenk, Thomas G.

AU - Nieuwenhuyse, Anthony

AU - Symons, Alaura

PY - 2018/7/2

Y1 - 2018/7/2

N2 - A key development in Computer Science Education has been the introduction of block-based programming environments where programs are created by connecting blocks and the focus is on the program’s logic instead of its syntax. Most of these environments support conventional (imperative) programming instructions. More recently, some systems have been proposed to enable the specification of database queries. While these two types of environments have been independently studied, there is significantly less work on the development and study of integrated environments that allow the creation of complete data-driven programs (real-world like programs that integrate conventional instructions and database queries). This paper introduces DBSnap++, a web-based environment that enables the specification of dynamic data-driven programs. DBSnap++ supports the specification of intuitive database query trees, a new type of list that dynamically gets its content executing a database query, and programs that generate different results when the underlying data changes. This paper presents DBSnap++’s design and implementation details, an array of programs to demonstrate how it can be effectively used as a learning tool, and a thorough comparison with other environments. DBSnap++ is publicly available and aims to enable learners to fully understand and utilize the capabilities of data-driven programs.

AB - A key development in Computer Science Education has been the introduction of block-based programming environments where programs are created by connecting blocks and the focus is on the program’s logic instead of its syntax. Most of these environments support conventional (imperative) programming instructions. More recently, some systems have been proposed to enable the specification of database queries. While these two types of environments have been independently studied, there is significantly less work on the development and study of integrated environments that allow the creation of complete data-driven programs (real-world like programs that integrate conventional instructions and database queries). This paper introduces DBSnap++, a web-based environment that enables the specification of dynamic data-driven programs. DBSnap++ supports the specification of intuitive database query trees, a new type of list that dynamically gets its content executing a database query, and programs that generate different results when the underlying data changes. This paper presents DBSnap++’s design and implementation details, an array of programs to demonstrate how it can be effectively used as a learning tool, and a thorough comparison with other environments. DBSnap++ is publicly available and aims to enable learners to fully understand and utilize the capabilities of data-driven programs.

KW - Data-driven programs

KW - Databases curricula

KW - Query languages

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

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

U2 - 10.1145/3197091.3197114

DO - 10.1145/3197091.3197114

M3 - Conference contribution

SP - 170

EP - 175

BT - ITiCSE 2018 - Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education

A2 - Andreou, Panayiotis

A2 - Armoni, Michal

A2 - Read, Janet C.

A2 - Polycarpou, Irene

PB - Association for Computing Machinery

ER -