Experience Report on Using LANTERN in Teaching Relational Query ProcessingOnlineGlobal
This program is tentative and subject to change.
The database systems course in an undergraduate computer science degree program has gained increasing importance due to the widespread usage of relational databases (RDBMS) in the real world as well as the rise of Data Science. A key learning goal for students taking such a course is to understand how SQL queries are executed in an RDBMS in practice. An off-the-shelf RDBMS typically exposes a query execution plan (QEP) in a visual or textual format, which describes the execution steps for a given query. However, it is often daunting for a student to comprehend these QEPs containing vendor-specific implementation details. In this paper, we discuss our experience of using a state-of-the-art tool called LANTERN in teaching QEPs to two cohorts of students taking database systems course in our academic institution. Specifically, LANTERN generates a natural language (NL)-based description of the execution strategy (i.e., QEP) chosen by the underlying RDBMS to process a user-specified query. We emphasize on how LANTERN is used as a supplementary tool to facilitate students to explore and learn about QEPs for their queries. In addition, we correlate the academic performance of the students with their LANTERN usage. Drawing on our experiences, we discuss future directions of LANTERN-augmented learning of relational query processing.
This program is tentative and subject to change.
Sat 1 MarDisplayed time zone: Eastern Time (US & Canada) change
10:45 - 12:00 | |||
10:45 18mTalk | Experience Report on Using LANTERN in Teaching Relational Query ProcessingOnlineGlobal Papers | ||
11:03 18mTalk | Experience Report: Using the FABRIC Testbed to teach a Graduate Computer Networking courseOnlineGlobal Papers Alexander Wolosewicz Illinois Institute of Technology, Prajwal Venkateshmurthy Illinois Institute of Technology, Nik Sultana Illinois Institute of Technology | ||
11:22 18mTalk | KernelVM: Teaching Linux Kernel Programming through a Browser-Based Virtual MachineOnlineGlobal Papers Elliott Wen , Sean Ma The University of Auckland, Paul Denny The University of Auckland, Ewan Tempero The University of Auckland, Gerald Weber The University of Auckland, Zongcheng Yue The University of Auckland | ||
11:41 18mTalk | LLM-Driven Feedback for Enhancing Conceptual Design Learning in Database Systems CoursesOnline Papers |