Relational Playground: Teaching the Duality of Relational Algebra and SQL

Fuente: arXiv
Salvato in:
Dettagli Bibliografici
Autore principale: Mior, Michael
Natura: Preprint
Pubblicazione: 2023
Soggetti:
Accesso online:
Tags: Aggiungi Tag
Nessun Tag, puoi essere il primo ad aggiungerne!!
_version_ 1866909137422516224
author Mior, Michael
author_facet Mior, Michael
contents Students in introductory data management courses are often taught how to write queries in SQL. This is a useful and practical skill, but it gives limited insight into how queries are processed by relational database engines. In contrast, relational algebra is a commonly used internal representation of queries by database engines, but can be challenging for students to grasp. We developed a tool we call Relational Playground for database students to explore the connection between relational algebra and SQL.
format Preprint
id arxiv_https___arxiv_org_abs_2306_13486
institution arXiv
publishDate 2023
record_format arxiv
spellingShingle Relational Playground: Teaching the Duality of Relational Algebra and SQL
Mior, Michael
Databases
Students in introductory data management courses are often taught how to write queries in SQL. This is a useful and practical skill, but it gives limited insight into how queries are processed by relational database engines. In contrast, relational algebra is a commonly used internal representation of queries by database engines, but can be challenging for students to grasp. We developed a tool we call Relational Playground for database students to explore the connection between relational algebra and SQL.
title Relational Playground: Teaching the Duality of Relational Algebra and SQL
topic Databases
url https://arxiv.org/abs/2306.13486