TY - GEN
T1 - Teaching Data Models with TriQL
AU - Alawini, Abdussalam
AU - Zhou, Leyao
AU - Kang, Lujia
AU - Rao, Peilin
AU - Ho, Ping Che
N1 - Publisher Copyright:
© 2022 ACM.
PY - 2022/6/12
Y1 - 2022/6/12
N2 - With the abundance of database systems implementing various data models, such as the relational, graph, and document-oriented models, learners often find it challenging to understand the trade-offs between different data models and to decide which database system they should learn and why. Additionally, most introductory database courses focus on the predominant relational model for teaching database design and programming, and do not discuss other emerging databases. While the relational database systems still play a vital role in modern data systems, especially with the emergence of NewSQL, it is crucial to introduce students to databases implementing other data models. In this paper, we introduce TriQL, a system for helping novices learn the schema and query languages of three major database systems, including MySQL (a relational database), Neo4J (a graph database), and MongoDB (a document-oriented database). TriQL offers learners a graphical user interface to design and execute a query against a generic database schema without requiring them to have any database programming experience. TriQL follows an interactive approach to learning new database models, supporting a dynamic and agile learning environment that can be easily integrated into database labs and homework assignments.
AB - With the abundance of database systems implementing various data models, such as the relational, graph, and document-oriented models, learners often find it challenging to understand the trade-offs between different data models and to decide which database system they should learn and why. Additionally, most introductory database courses focus on the predominant relational model for teaching database design and programming, and do not discuss other emerging databases. While the relational database systems still play a vital role in modern data systems, especially with the emergence of NewSQL, it is crucial to introduce students to databases implementing other data models. In this paper, we introduce TriQL, a system for helping novices learn the schema and query languages of three major database systems, including MySQL (a relational database), Neo4J (a graph database), and MongoDB (a document-oriented database). TriQL offers learners a graphical user interface to design and execute a query against a generic database schema without requiring them to have any database programming experience. TriQL follows an interactive approach to learning new database models, supporting a dynamic and agile learning environment that can be easily integrated into database labs and homework assignments.
KW - MongoDB
KW - Neo4J
KW - SQL
KW - database education
UR - http://www.scopus.com/inward/record.url?scp=85133180115&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=85133180115&partnerID=8YFLogxK
U2 - 10.1145/3531072.3535320
DO - 10.1145/3531072.3535320
M3 - Conference contribution
AN - SCOPUS:85133180115
T3 - Proceedings of the 1st ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2022
SP - 16
EP - 21
BT - Proceedings of the 1st ACM SIGMOD International Workshop on Data Systems Education
A2 - Aivaloglou, Efthimia
A2 - Fletcher, George
A2 - Miedema, Daphne
PB - Association for Computing Machinery
T2 - 1st ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2022, co-located with the ACM SIGMOD Conference
Y2 - 17 June 2022
ER -