What Teaching Databases Taught Us about Researching Databases: Extended Talk Abstract

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

doi:10.1145/3663649.3664375

What Teaching Databases Taught Us about Researching Databases: Extended Talk Abstract

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

The Rachel and Selim Benin School of Engineering and Computer Science

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

Abstract

Declarative querying is a cornerstone of the success and longevity of database systems, yet it is challenging for novice learners accustomed to different coding paradigms. The transition is further hampered by a lack of query debugging tools compared to the plethora available for programming languages. The paper samples several systems that we build at Duke University to help students learn and debug database queries. These systems have not only helped scale up teaching and improve learning, but also inspired interesting research on databases. Furthermore, with the rise of generative AI, we argue that there is a heightened need for skills in scrutinizing and debugging AI-generated queries, and we outline several ongoing and future work directions aimed at addressing this challenge.

Original language	English
Title of host publication	Proceedings of the 3rd ACM SIGMOD International Workshop on Data Systems Education
Subtitle of host publication	Bridging Education Practice with Education Research, DataEd 2024
Editors	Daphne Miedema, Sourav S. Bhowmick, Michael Liut
Publisher	Association for Computing Machinery
Pages	1-6
Number of pages	6
ISBN (Electronic)	9798400706783
DOIs	https://doi.org/10.1145/3663649.3664375
State	Published - 9 Jun 2024
Event	3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024 - Santiago, Chile Duration: 9 Jun 2024 → 9 Jun 2024

Publication series

Name	ACM International Conference Proceeding Series

Conference

Conference	3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024
Country/Territory	Chile
City	Santiago
Period	9/06/24 → 9/06/24

Bibliographical note

Publisher Copyright:
Copyright © 2024 held by the owner/author(s). Publication rights licensed to ACM.

Keywords

Database Education
Query Debugging
Query Verification
Relational Algebra
SQL

Access to Document

10.1145/3663649.3664375

Cite this

Yang, J., Gilad, A., Hu, Y., Meng, H., Miao, Z., Roy, S., & Stephens-Martinez, K. (2024). What Teaching Databases Taught Us about Researching Databases: Extended Talk Abstract. In D. Miedema, S. S. Bhowmick, & M. Liut (Eds.), Proceedings of the 3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024 (pp. 1-6). (ACM International Conference Proceeding Series). Association for Computing Machinery. https://doi.org/10.1145/3663649.3664375

Yang, Jun ; Gilad, Amir ; Hu, Yihao et al. / What Teaching Databases Taught Us about Researching Databases : Extended Talk Abstract. Proceedings of the 3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024. editor / Daphne Miedema ; Sourav S. Bhowmick ; Michael Liut. Association for Computing Machinery, 2024. pp. 1-6 (ACM International Conference Proceeding Series).

@inproceedings{bb1756b725ab4f0986ef4ec5ba4823c8,

title = "What Teaching Databases Taught Us about Researching Databases: Extended Talk Abstract",

abstract = "Declarative querying is a cornerstone of the success and longevity of database systems, yet it is challenging for novice learners accustomed to different coding paradigms. The transition is further hampered by a lack of query debugging tools compared to the plethora available for programming languages. The paper samples several systems that we build at Duke University to help students learn and debug database queries. These systems have not only helped scale up teaching and improve learning, but also inspired interesting research on databases. Furthermore, with the rise of generative AI, we argue that there is a heightened need for skills in scrutinizing and debugging AI-generated queries, and we outline several ongoing and future work directions aimed at addressing this challenge.",

keywords = "Database Education, Query Debugging, Query Verification, Relational Algebra, SQL",

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

note = "Publisher Copyright: Copyright {\textcopyright} 2024 held by the owner/author(s). Publication rights licensed to ACM.; 3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024 ; Conference date: 09-06-2024 Through 09-06-2024",

year = "2024",

month = jun,

day = "9",

doi = "10.1145/3663649.3664375",

language = "אנגלית",

series = "ACM International Conference Proceeding Series",

publisher = "Association for Computing Machinery",

pages = "1--6",

editor = "Daphne Miedema and Bhowmick, {Sourav S.} and Michael Liut",

booktitle = "Proceedings of the 3rd ACM SIGMOD International Workshop on Data Systems Education",

}

Yang, J, Gilad, A, Hu, Y, Meng, H, Miao, Z, Roy, S & Stephens-Martinez, K 2024, What Teaching Databases Taught Us about Researching Databases: Extended Talk Abstract. in D Miedema, SS Bhowmick & M Liut (eds), Proceedings of the 3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024. ACM International Conference Proceeding Series, Association for Computing Machinery, pp. 1-6, 3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024, Santiago, Chile, 9/06/24. https://doi.org/10.1145/3663649.3664375

What Teaching Databases Taught Us about Researching Databases: Extended Talk Abstract. / Yang, Jun; Gilad, Amir; Hu, Yihao et al.
Proceedings of the 3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024. ed. / Daphne Miedema; Sourav S. Bhowmick; Michael Liut. Association for Computing Machinery, 2024. p. 1-6 (ACM International Conference Proceeding Series).

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

TY - GEN

T1 - What Teaching Databases Taught Us about Researching Databases

T2 - 3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024

AU - Yang, Jun

AU - Gilad, Amir

AU - Hu, Yihao

AU - Meng, Hanze

AU - Miao, Zhengjie

AU - Roy, Sudeepa

AU - Stephens-Martinez, Kristin

PY - 2024/6/9

Y1 - 2024/6/9

N2 - Declarative querying is a cornerstone of the success and longevity of database systems, yet it is challenging for novice learners accustomed to different coding paradigms. The transition is further hampered by a lack of query debugging tools compared to the plethora available for programming languages. The paper samples several systems that we build at Duke University to help students learn and debug database queries. These systems have not only helped scale up teaching and improve learning, but also inspired interesting research on databases. Furthermore, with the rise of generative AI, we argue that there is a heightened need for skills in scrutinizing and debugging AI-generated queries, and we outline several ongoing and future work directions aimed at addressing this challenge.

AB - Declarative querying is a cornerstone of the success and longevity of database systems, yet it is challenging for novice learners accustomed to different coding paradigms. The transition is further hampered by a lack of query debugging tools compared to the plethora available for programming languages. The paper samples several systems that we build at Duke University to help students learn and debug database queries. These systems have not only helped scale up teaching and improve learning, but also inspired interesting research on databases. Furthermore, with the rise of generative AI, we argue that there is a heightened need for skills in scrutinizing and debugging AI-generated queries, and we outline several ongoing and future work directions aimed at addressing this challenge.

KW - Database Education

KW - Query Debugging

KW - Query Verification

KW - Relational Algebra

KW - SQL

UR - http://www.scopus.com/inward/record.url?scp=85198709132&partnerID=8YFLogxK

U2 - 10.1145/3663649.3664375

DO - 10.1145/3663649.3664375

M3 - ???researchoutput.researchoutputtypes.contributiontobookanthology.conference???

AN - SCOPUS:85198709132

T3 - ACM International Conference Proceeding Series

SP - 1

EP - 6

BT - Proceedings of the 3rd ACM SIGMOD International Workshop on Data Systems Education

A2 - Miedema, Daphne

A2 - Bhowmick, Sourav S.

A2 - Liut, Michael

PB - Association for Computing Machinery

Y2 - 9 June 2024 through 9 June 2024

ER -

Yang J, Gilad A, Hu Y, Meng H, Miao Z, Roy S et al. What Teaching Databases Taught Us about Researching Databases: Extended Talk Abstract. In Miedema D, Bhowmick SS, Liut M, editors, Proceedings of the 3rd ACM SIGMOD International Workshop on Data Systems Education: Bridging Education Practice with Education Research, DataEd 2024. Association for Computing Machinery. 2024. p. 1-6. (ACM International Conference Proceeding Series). doi: 10.1145/3663649.3664375

What Teaching Databases Taught Us about Researching Databases: Extended Talk Abstract

Abstract

Publication series

Conference

Bibliographical note

Keywords

Access to Document

Other files and links

Fingerprint

Cite this