Xiangyao Yu

Xiangyao Yu

Assistant Professor
Database Group
Computer Sciences Department, University of Wisconsin-Madison
yxy AT cs.wisc.edu
Room 7584, 1205 University Ave, Madison WI 53706
[C.V.] [Google Scholar]



I am an Assistant Professor in the Computer Sciences Department at University of Wisconsin-Madison.

Before joining UW-Madison, I was a Postdoctoral Associate in the database group at CSAIL, MIT working with Prof. Michael Stonebraker and Prof. Samuel Madden. I completed my Ph.D. in Computer Science at MIT in 2017 working with Prof. Srinivas Devadas. I earned my Bachelor of Science (B.S.) in 2012 from Institute of Microelectronics at Tsinghua University, Beijing, China.

I work on database systems and currently focus on (1) GPU-native analytics, (2) robust query processing, (3) cloud-native databases, and (4) transaction processing.

I am actively looking for Graduate/Undergraduate students interested in database systems. Please email me your CV if you are interested in working with me.




My group builds database systems, focusing on four thrusts: (1) GPU-native analytics, (2) robust query processing, (3) cloud-native databases, and (4) transaction processing. Selected projects in each thrust are highlighted below.

Thrust 1: GPU-Native Analytics

GPUs are a natural fit for data analytics due to their massive parallelism, but GPU query processing at scale remains challenging. We study how to build OLAP databases that run natively on GPUs.

Sirius logo This line of research has matured into Sirius, an open-source GPU-native SQL engine [code][website][NVIDIA Dev Blog][slack] · talks:[GTC'26][CMU DB seminar]. Sirius enables drop-in GPU acceleration for DuckDB and other SQL databases, without changing the user interface. Sirius supports CPU fallback for full compatibility. Below are related projects and publications.

Thrust 2: Robust Query Processing

OLAP databases lack robustness when executing complex multi-join queries—performance can degrade due to bad join order or data skew. We aim to improve query robustness by closing the gap between database theory and systems. This line of research has matured into robust, a DuckDB community extension [code].

Thrust 3: Cloud-Native Databases

Databases are moving to the cloud due to offered elasticity, high-availability, and cost competitiveness. Modern cloud-native databases adopt a unique storage-disaggregation architecture, where the computation and storage are decoupled. This architecture brings new challenges and opportunities in DBMS design.
Cloud-native data warehouse: Cloud-native transaction processing:

Thrust 4: Transaction Processing

Scalable transaction processing on multicore CPUs: Computer architectures are moving towards manycore machines with dozens or even hundreds of cores on a single chip. We develop new techniques for modern database management systems (DBMSs) to make transaction processing scalable for this level of massive parallelism. Scalable distributed transaction processing: Online transaction processing (OLTP) DBMSs are increasingly deployed on distributed machines. Compared to a centralized systems, distributed DBMSs face new challenges including extra network latency, requirements of high availability and distributed commitment.











Peer-Reviewed Publications

Thesis

PhD Students: Master Student: Undergraduate Students: PhD Alumni:





Here is a list of my teaching experiences at UW-Madison: