Project Showcase

[PRESENTATION] Unified Query Optimizer

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).

[PRESENTATION] User Defined Functions

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.

[PRESENTATION] LLVM Compilation for Updates

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.

[PRESENTATION] LLVM Multi-threaded 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.

[PRESENTATION] In-memory Database Compression

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.

[PRESENTATION] SQL Features

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.

[PRESENTATION] Networking Layer Enhancements

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.

[PRESENTATION] Transactional System Catalogs

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.

[PRESENTATION] Statistics + Cost Model

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.

[PRESENTATION] Table Constraints

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).

[PRESENTATION] Triggers

Triggers

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

Postgres-style table triggers.