Unified Query OptimizerStudents: Bowei Chen, Chen Luo, Patrick Huang
This project adds a new Cascades-style query optimizer to Peloton. It supports SQL-92 aggregations, multi-way joins, and basic optimizations (e.g., predicate pushdown).
User Defined FunctionsStudents: Haoran Wang, Nasrin Jaleel, Prashasthi Prabhakar
Basic implementation of a PL/pgSQL parser and interpreter.
LLVM Compilation for UpdatesStudents: Zhixun Tan, Shuyao Bi, Xinlyu Huang, Wei Cui
We extended support in Peloton's LLVM-based query compiler to support INSERT and UPDATE queries.
LLVM Multi-threaded QueriesStudents: Tianqi Wu, Yang Liu, Hao Li
HyPer-style multi-threading support for SELECT queries.
In-memory Database CompressionStudents: Rohit Agrawal, Pooja Nilangekar
Tile-based delta compression for cold data. Supports modifications.
SQL FeaturesStudents: Shuxin Lin, Yuan Luo
Adds new support for SQL-92 query functionality, including ARRAY types and the IN clause.
Networking Layer EnhancementsStudents: Han Li, Yilei Chu, Shaokun Zou
Postgres-wire protocol fixes and enhancements for the Peloton front-end layer.
Transactional System CatalogsStudents: Mengran Wang, Ang Li, Yixin Luo
ACID in-memory system catalogs based on Postgres.
Statistics + Cost ModelStudents: Allison Wang, Xiaoyou Wang, Xian Zhang
Asynchronous database statistics collection and sampling with a basic query optimizer cost model.
Table ConstraintsStudents: Tianhe Wu, Xin Zhang, Matthew Oresky
Basic table integrity and referential constraint support (e.g., DEFAULT, NOT NULL, CHECK, REFERENCES).
TriggersStudents: Tao Lin, Min Huang, Mengxi Chen
Postgres-style table triggers.