Abstract
The database systems course is offered 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. Unfortunately, off-the-shelf RDBMS typically only expose the QEP to users without revealing information about the impact of alternative choices of various physical operators on it in a user-friendly manner to aid learning. In this demonstration, we present a novel system called MOCHA that facilitates exploration and visualization of the impact of alternative physical operator choices on the QEP of a given SQL query. MOCHA accepts an SQL query as input, and compares and visualizes the QEP and alternative plans which are selected based on learner-specified operator preferences. Furthermore, it intuitively explains why the key operators in a QEP are chosen by connecting them to established knowledge in the literature.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
