Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
This lecture covers query processing with relational operations, focusing on simple and index nested loops joins, as well as the cost comparison between different join methods. It also explains the two-pass hash join algorithm, hybrid hash join, and the benefits of sort-merge join over hash join. The lecture concludes with a summary of general join conditions, set operations, aggregate operations, and the impact of buffering on query processing.