How Database Theory Helps Teach Relational Queries in Database Education

Sudeepa Roy, Yihao Hu, Zhengjie Miao, Jun Yang, Amir Gilad, Hanze Meng, Kristin Stephens-Martinez

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

Data analytics skills have become an indispensable part of any education that seeks to prepare its students for the modern workforce. Essential in this skill set is the ability to work with structured relational data. Relational queries are based on logic and may be declarative in nature, posing new challenges to novices and students. Manual teaching resources being limited and enrollment growing rapidly, automated tools that help students debug queries and explain errors are potential game-changers in database education. We present a suite of tools built on the foundations of database theory that has been used by over 1600 students in database classes at Duke University, showcasing a high-impact application of database theory in database education.

Original languageEnglish
Title of host publication27th International Conference on Database Theory, ICDT 2024
EditorsGraham Cormode, Michael Shekelyan
PublisherSchloss Dagstuhl- Leibniz-Zentrum fur Informatik GmbH, Dagstuhl Publishing
ISBN (Electronic)9783959773126
DOIs
StatePublished - Mar 2024
Event27th International Conference on Database Theory, ICDT 2024 - Paestum, Italy
Duration: 25 Mar 202428 Mar 2024

Publication series

NameLeibniz International Proceedings in Informatics, LIPIcs
Volume290

Conference

Conference27th International Conference on Database Theory, ICDT 2024
Country/TerritoryItaly
CityPaestum
Period25/03/2428/03/24

Keywords

  • Boolean Provenance
  • Database Education
  • Query Debugging
  • Relational Algebra
  • Relational Calculus
  • SQL

All Science Journal Classification (ASJC) codes

  • Software

Cite this