TY - GEN
T1 - DBSnap 2
T2 - 27th ACM Conference on Innovation and Technology in Computer Science Education, ITiCSE 2022
AU - Silva, Yasin N.
AU - Loza, Alexis
AU - Razente, Humberto
N1 - Publisher Copyright:
© 2022 Owner/Author.
PY - 2022/7/7
Y1 - 2022/7/7
N2 - Block-based environments for creating computer programs have become very useful learning tools in computer science as they enable focusing on the logic of a program rather than on its syntactical details. While most block-based environments support conventional (imperative) instructions, a few tools have been proposed to create database queries. One of these tools is DBSnap, a highly dynamic and open-source tool to create database query trees by dragging and connecting visual blocks representing datasets and database operators. In this paper, we introduce DBSnap 2, an extension of DBSnap that provides a set of improvements to facilitate the creation of simple and complex queries. The improvements include the support of database views (a key database concept), saving and importing queries, inserting, updating, and deleting data, the creation of charts, and various visual improvements. The demonstration of DBSnap 2 will show how the new features simplify the creation of queries and enable the graphical visualization of query results.
AB - Block-based environments for creating computer programs have become very useful learning tools in computer science as they enable focusing on the logic of a program rather than on its syntactical details. While most block-based environments support conventional (imperative) instructions, a few tools have been proposed to create database queries. One of these tools is DBSnap, a highly dynamic and open-source tool to create database query trees by dragging and connecting visual blocks representing datasets and database operators. In this paper, we introduce DBSnap 2, an extension of DBSnap that provides a set of improvements to facilitate the creation of simple and complex queries. The improvements include the support of database views (a key database concept), saving and importing queries, inserting, updating, and deleting data, the creation of charts, and various visual improvements. The demonstration of DBSnap 2 will show how the new features simplify the creation of queries and enable the graphical visualization of query results.
KW - block-based system
KW - database queries
KW - relational algebra
KW - sql
UR - http://www.scopus.com/inward/record.url?scp=85134544005&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=85134544005&partnerID=8YFLogxK
U2 - 10.1145/3502717.3532156
DO - 10.1145/3502717.3532156
M3 - Conference contribution
AN - SCOPUS:85134544005
T3 - Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE
SP - 601
EP - 602
BT - ITiCSE 2022 - Proceedings of the 27th ACM Conference on Innovation and Technology in Computer Science Education
PB - Association for Computing Machinery
Y2 - 8 July 2022 through 13 July 2022
ER -