The 27th ACM Annual Conference on Innovation and Technology in Computer Science Education (ITiCSE), Dublin, Ireland, 2022
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.
Silva, Yasin N.; Loza, Alexis; and Razente, Humberto. DBSnap 2: New Features to Construct Database Queries by Snapping Blocks. The 27th ACM Annual Conference on Innovation and Technology in Computer Science Education (ITiCSE), Dublin, Ireland, 2022, , : , 2022. Retrieved from Loyola eCommons, Computer Science: Faculty Publications and Other Works, http://dx.doi.org/doi.org/10.1145/3502717.3532156
Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License.
© Yasin N Silva, Alexis Loza, Humberto Razente, 2022