Bill Sun - Home Page

Yinqi (Bill) Sun is a passionate researcher interested in Data Science, Visualization and Computer Graphics. I also write compilers.

You may find my works in:

GitHub page Google Scholar Statement / CV / Blog

Contact me: sunyinqi0508@gmail.com

My Projects:

Computer Graphics Gallery

• Real-time Recursive Ray Tracing (NOT raycasting) on WebGL Shaders (see homework 4)
• Mouse trace from scratch (No external libraries), first implemented in homework 8
• Custom SVG Parser/Renderer
• Trace animation

AQuery++: A column-store, time-series database I wrote that compiles query into C++.

• Standalong Support for SQL92 queries, UDF, User Module Extension, Stored Procedure, Triggers, Built-in Aggregation functions.
• Can use embedded relational databases (e.g. MonetDB, SQLite, DuckDB) as datasource to extend functionality such as Transaction Control, Disk Storage and Indexes.

ChocoPy Compiler in Java: Compiles ChocoPy (subset of Python) into RISCV assembly (Availible Upon Request)

My first Compiler: A Pascal Compiler in C++, hand-coded SLR(1) parser

Report on Neural Rendering (Writing Sample): One of Machine Learning Homeworks for March 2021

A Hockey Game : Homework for Heurestic Problem Solving

Selected Publications:

Revisiting stress majorization as a unified framework for interactive constrained graph visualization IEEE VIS 2017

Structure-aware Fisheye Views for Efficient Large Graph Exploration IEEE VIS 2018

AQuery++: A high-performance, extensible Database for incremental analysis (In Progress, preparing for VLDB '23)

Forgetful Forests: high performance learning data structures for streaming data under concept drift (Early Draft)

Useful Tools:

Compiler Explorer (self hosted) by Matt Godbolt

Gitea (self hosted)