Document Type

Conference Proceeding

Publication Date

2022

Publication Title

The 27th ACM Annual Conference on Innovation and Technology in Computer Science Education (ITiCSE), Dublin, Ireland, 2022

Publisher Name

ITiCSE

Abstract

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.

Identifier

ISBN 978-1-4503-9200-6/22/07

Comments

Author Posting. © Yasin N Silva, Alexis Loza, Humberto Razente, 2022. This is the author's version of the work. It is posted here by permission of Association for Computing Machinery for personal use, not for redistribution. The definitive version will be published in Proceedings of 27th ACM Annual Conference on Innovation and Technology in Computer Science Education (ITiCSE), June 2022.

Creative Commons License

Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License.

Download

Share

COinS