Bill Sun - Home Page

Yinqi Sun (Bill) is a passionate researcher interested in Database Systems, Data Science and Visualization. I also write compilers and databases. Author of AQuery++, a columnstore database.

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.

WatchOS Player: A standalone local music player for WatchOS 9+, sync with your computer via HTTP protocol.

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:

Vexless: A Serverless Vector Data Management System Using Cloud Functions SIGMOD 2024

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 (Early Draft)

Forgetful Forests: Data Structures for Machine Learning on Streaming Data under Concept Drift MDPI Algorithms 2023

Useful Tools:

Self Hosted Compiler Explorer by Matt Godbolt

Self Hosted Git Server powered by Gitea

Romanticize: A pinyin/kana-like romanization-based input tool for non-latin script languages (wip).

Miscellaneous:

Cooking

Photography