Project Showcase

Unified Query Optimizer

Students: Bowei Chen, Chen Luo, Patrick Huang
Repository: https://github.com/cmu-db/peloton/pull/640

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 Functions

Students: Haoran Wang, Nasrin Jaleel, Prashasthi Prabhakar
Repository: https://github.com/cmu-db/peloton/pull/658

Basic implementation of a PL/pgSQL parser and interpreter.

LLVM Compilation for Updates

Students: Zhixun Tan, Shuyao Bi, Xinlyu Huang, Wei Cui
Repository: https://github.com/cmu-db/peloton/pull/656

We extended support in Peloton's LLVM-based query compiler to support INSERT and UPDATE queries.

LLVM Multi-threaded Queries

Students: Tianqi Wu, Yang Liu, Hao Li
Repository: https://github.com/cmu-db/peloton/pull/653

HyPer-style multi-threading support for SELECT queries.

In-memory Database Compression

Students: Rohit Agrawal, Pooja Nilangekar
Repository: https://github.com/rohit-cmu/compression-peloton

Tile-based delta compression for cold data. Supports modifications.

SQL Features

Students: Shuxin Lin, Yuan Luo
Repository: https://github.com/cmu-db/peloton/pull/669

Adds new support for SQL-92 query functionality, including ARRAY types and the IN clause.

Networking Layer Enhancements

Students: Han Li, Yilei Chu, Shaokun Zou
Repository: https://github.com/hanli32/peloton

Postgres-wire protocol fixes and enhancements for the Peloton front-end layer.

Transactional System Catalogs

Students: Mengran Wang, Ang Li, Yixin Luo
Repository: https://github.com/cmu-db/peloton/pull/592

ACID in-memory system catalogs based on Postgres.

Statistics + Cost Model

Students: Allison Wang, Xiaoyou Wang, Xian Zhang
Repository: https://github.com/cmu-db/peloton/pull/619

Asynchronous database statistics collection and sampling with a basic query optimizer cost model.

Table Constraints

Students: Tianhe Wu, Xin Zhang, Matthew Oresky
Repository: https://github.com/cmu-db/peloton/pull/660

Basic table integrity and referential constraint support (e.g., DEFAULT, NOT NULL, CHECK, REFERENCES).

Triggers

Students: Tao Lin, Min Huang, Mengxi Chen
Repository: https://github.com/cmu-db/peloton/pull/650

Postgres-style table triggers.