Title
Learning relational algebra by snapping blocks
Abstract
Relational algebra provides a theoretical foundation for how modern database management systems optimize and execute queries. Its main concepts are based on set theory and first order logic, which can be challenging for students to learn due to their abstract nature. This paper presents Bags, a new type of visual programming environment (inspired by Snap!) for the teaching of relational operations and data analysis. Students formulate algebraic queries by snapping together graphical blocks that represent data sets and relational operators, resulting in an interactive visualization of the underlying concepts. The outcomes of this work will not only enhance university-level database courses, but also provide an engaging computational thinking resource for K-12 teachers in content areas outside of science and engineering.
Year
DOI
Venue
2014
10.1145/2538862.2538961
SIGCSE
Keywords
Field
DocType
algebraic query,k-12 teacher,data analysis,modern database management system,university-level database course,relational algebra,relational operation,relational operator,abstract nature
Relational calculus,Programming language,Relational database,Statistical relational learning,Computer science,Database design,Relational algebra,Relational operator,Relational model,Entity–relationship model
Conference
Citations 
PageRank 
References 
3
0.65
8
Authors
3
Name
Order
Citations
PageRank
Jason Gorman17510.97
Sebastian Gsell230.65
Chris Mayfield333518.86