FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool

Yuyan Zhou; Dave Towey; Matthew Pike

doi:10.1109/COMPSAC61105.2024.00219

FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool

Yuyan Zhou
, Dave Towey
, Matthew Pike

Research output: Chapter in Book/Conference proceeding › Conference contribution › peer-review

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.

Original language	English
Title of host publication	2024 IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC)
Publisher	IEEE
Pages	1522-1523
Number of pages	2
ISBN (Electronic)	9798350376968
ISBN (Print)	9798350376975
DOIs	https://doi.org/10.1109/COMPSAC61105.2024.00219
Publication status	Published - 2024

Free Keywords

Open Educational Resource
SQL
Query Plan Visualisation
SQLite
Web-based System

Access to Document

10.1109/COMPSAC61105.2024.00219

Cite this

@inproceedings{d6ca9c8e02f4448b86366bb2098790d0,

title = "FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool",

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.",

keywords = "Open Educational Resource, SQL, Query Plan Visualisation, SQLite, Web-based System",

author = "Yuyan Zhou and Dave Towey and Matthew Pike",

year = "2024",

doi = "10.1109/COMPSAC61105.2024.00219",

language = "English",

isbn = "9798350376975",

pages = "1522--1523",

booktitle = "2024 IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC)",

publisher = "IEEE",

address = "United States",

}

TY - GEN

T1 - FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool

AU - Zhou, Yuyan

AU - Towey, Dave

AU - Pike, Matthew

PY - 2024

Y1 - 2024

N2 - 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.

AB - 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.

KW - Open Educational Resource

KW - SQL

KW - Query Plan Visualisation

KW - SQLite

KW - Web-based System

U2 - 10.1109/COMPSAC61105.2024.00219

DO - 10.1109/COMPSAC61105.2024.00219

M3 - Conference contribution

SN - 9798350376975

SP - 1522

EP - 1523

BT - 2024 IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC)

PB - IEEE

ER -

FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool

Abstract

Free Keywords

Access to Document

Fingerprint

Cite this