Research direction
ARCADE is an open-source RocksDB/MySQL system for real-time hybrid and continuous queries over relational, vector, spatial, text, and image data. It brings multimodal indexing, cost-based optimisation, and incremental query processing into one implemented system.
Storage and indexing
ARCADE integrates disk-based secondary indexes for vector, spatial, and text data with LSM-tree storage. This allows relational filters and specialised similarity or spatial predicates to operate over the same stored data rather than through separate systems.
Query processing
The cost-based optimiser combines multiple access paths for hybrid search and hybrid nearest-neighbour queries, including vector, spatial, text, and relational operators. It connects system statistics and heterogeneous indexes with MySQL plan selection.
As co-first author, I led the design and implementation of the query-optimisation component. I contributed to technical discussions across the broader system; other team members held primary ownership of storage, indexing, and continuous-query processing.
Continuous workloads
ARCADE supports time-based and event-driven continuous queries through incremental materialised views. Intermediate results are reused as data changes, allowing the system to maintain fresh answers without repeatedly executing each query from scratch.
The ICDE 2026 evaluation reports improvements of up to 7.4× in read-heavy settings and 1.4× in write-heavy settings over the best-performing evaluated baseline.