Blogs (3) >>

This program is tentative and subject to change.

Sat 1 Mar 2025 10:45 - 11:03 at Meeting Rooms 302-303 - Systems [Online]

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 Mar

Displayed time zone: Eastern Time (US & Canada) change

10:45 - 12:00
Systems [Online]Papers at Meeting Rooms 302-303
10:45
18m
Talk
Experience Report on Using LANTERN in Teaching Relational Query ProcessingOnlineGlobal
Papers
Sourav S Bhowmick Nanyang Technological University, Hui Li Xiamen University
11:03
18m
Talk
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
18m
Talk
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
18m
Talk
LLM-Driven Feedback for Enhancing Conceptual Design Learning in Database Systems CoursesOnline
Papers
Sara Riazi University of Illinois Chicago, Rooshenas University of Illinois Chicago