DBSnap 2: New Features to Construct Database Queries by Snapping Blocks
Pages 601 - 602
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.
References
[1]
J. H. Maloney, K. Peppler, Y. Kafai, M. Resnick, and N. Rusk. Programming by choice: Urban youth learning programming with scratch. In ACM SIGCSE, 2008.
[2]
A. Marron, G. Weiss, and G. Wiener. A decentralized approach for programming interactive applications with javascript and blockly. In AGERE!, 2012.
[3]
C. North and B. Shneiderman. Snap-together visualization: Can users construct and operate coordinated visualizations? Int. J. Hum.-Comput. Stud., 53(5):715--739, 2000.
[4]
Eckart Modrow. 2014. SQLsnap! http://snapextensions.uni-goettingen.de. (2014).
[5]
Jonathon D. Hellmann. 2015. DataSnap: Enabling Domain Experts and Introductory Programmers to Process Big Data in a Block-Based Programming Language. Master's thesis. Virginia Tech, Virginia, USA.
[6]
J. Gorman, S. Gsell, and C. Mayfield. Learning relational algebra by snapping blocks. In ACM SIGCSE, 2014.
[7]
Y. N. Silva and J. Chon. 2015. DBSnap: Learning Database Queries by Snapping Blocks. In ACM SIGCSE.
[8]
Y. N. Silva and J. Chon. 2015. Querying databases by snapping blocks. In IEEE ICDE.
[9]
Y. N. Silva. 2022. DBSnap Project Website. Retrieved from https://ysilva.cs.luc.edu/dbsnap.
Index Terms
- DBSnap 2: New Features to Construct Database Queries by Snapping Blocks
Recommendations
DBSnap-Eval: Identifying Database Query Construction Patterns
ITiCSE '22: Proceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 1Learning to construct database queries can be a challenging task because students need to learn the specific query language syntax as well as properly understand the effect of each query operator and how multiple operators interact in a query. While ...
DBSnap: Learning Database Queries by Snapping Blocks
SIGCSE '15: Proceedings of the 46th ACM Technical Symposium on Computer Science EducationA 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 ...
Modeling MongoDB with Relational Model
EIDWT '13: Proceedings of the 2013 Fourth International Conference on Emerging Intelligent Data and Web TechnologiesRelational databases have been prevailing for the last two decades, with features of clear semantics and ease of use with SQL supported by the underlying theory, relational algebra. Relational databases provide good support for structural data ...
Comments
Information & Contributors
Information
Published In
July 2022
686 pages
ISBN:9781450392006
DOI:10.1145/3502717
- General Chairs:
- Brett A. Becker,
- Keith Quille,
- Mikko-Jussi Laakso,
- Program Chairs:
- Erik Barendsen,
- Simon
Copyright © 2022 Owner/Author.
Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.
Sponsors
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 07 July 2022
Check for updates
Author Tags
Qualifiers
- Abstract
Conference
ITiCSE 2022
Sponsor:
ITiCSE 2022: Innovation and Technology in Computer Science Education
July 8 - 13, 2022
Dublin, Ireland
Acceptance Rates
Overall Acceptance Rate 552 of 1,613 submissions, 34%
Upcoming Conference
ITiCSE '25
- Sponsor:
- sigcse
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 42Total Downloads
- Downloads (Last 12 months)2
- Downloads (Last 6 weeks)0
Reflects downloads up to 07 Mar 2025
Other Metrics
Citations
View Options
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in