The database systems course is offered as part of an undergraduate computer science degree program in many major universities. A key learning goal of learners taking such a course is to understand how SQL queries are processed in an RDBMS in practice. To this end, comprehension of the impact of various physical operators on the selected query execution plan (QEP) of a query is paramount. In this video, we present a novel system called MOCHA that facilitates exploration and visualization of the impact of alternative physical operator choices on a selected QEP for a given SQL query.
数据库系统课程是许多主要大学提供的本科计算机科学学位课程的一部分。学习这门课程的一个关键学习目标是在实践中理解在RDBMS中如何处理SQL查询。为此，理解各种物理操作符对查询的所选查询执行计划(QEP)的影响是至关重要的。在本视频中，我们介绍了一个名为MOCHA的新系统，它有助于探索和可视化替代物理运算符选择对给定SQL查询的选定QEP的影响。
