FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool
IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC), July 2024
Yuyan Zhou, Dave Towey, Matthew Pike. 2024. FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool. In IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC). DOI:https://doi.org/10.1109/COMPSAC61105.2024.00219
Yuyan Zhou and Dave Towey and Matthew Pike. (2024). FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool. IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC). https://doi.org/10.1109/COMPSAC61105.2024.00219
Yuyan Zhou and Dave Towey and Matthew Pike. "FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool." IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC), 2024. https://doi.org/10.1109/COMPSAC61105.2024.00219
Yuyan Zhou, Dave Towey, Matthew Pike. 2024. FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool. IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC). doi:10.1109/COMPSAC61105.2024.00219
Yuyan Zhou and Dave Towey and Matthew Pike, "FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool," IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC), 2024. doi: 10.1109/COMPSAC61105.2024.00219
@inproceedings{compsac-2024-4,
title={FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool},
author={Yuyan Zhou and Dave Towey and Matthew Pike},
booktitle={IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC)},
year={2024},
doi={10.1109/COMPSAC61105.2024.00219}
}
Visualization;Semantics;Education;Open, Educational, Resources;Syntactics;Software;Visual, databases;Open, Educational, Resource;SQL;Query, Plan, Visualisation;SQLite;Web-based, System
Abstract
We introduce a web-based SQL query visualisation tool aimed at improving students' understanding of SQL query execution. The tool, available as an Open Educational Resource (OER), allows users to visualise the stages of a SQL query on an uploaded SQLite database. The web interface enables students to interactively explore each stage of the query and view results in a dynamically updated table. This initial version of the tool is intended to inspire further development and enhancement while providing educators with a valuable resource for teaching SQL concepts.