If a faculty member or an existing undergraduate research project you're working on is not listed below, you may still fill out the Google form on the course homepage, indicating the faculty member's name and a very brief description of the project. We will reach out to the faculty member to see if they are willing to host the project under the EL/R (Reesarch) program.
001 - PgAQP: a pluggable toolkit for approximate query processing in PostgreSQL
Mentor: Prof. Zhuoyue Zhao
Current Size/Total Capacity: 0/3
Keyword: database systems; PostgreSQL; C language; approximate algorithms; data structure
Description:
Approximate Query Processing (AQP) can speed up SQL queries with a trade-off in accuracy in relational database systems such as PostgreSQL. This is often useful for interactive data exploration and/or real-time data analysis workloads in real-world data intensive applications. This project aims to design a toolkit for providing AQP functionalities in PostgreSQL as a pluggable extension, pgAQP. In this project, you will work closely with other graduate students and gain hands-on experience with designing, prototyping and implementing new features or performance tuning for large codebases.
For more details, please refer to our VLDB 23 demo and the video below.