25 citations · 48 across the 11 of their papers we have counts for
13 papers
Enzyme: Incremental View Maintenance for Data Engineering
Ritwik Yadav, Supun Abeysinghe, Min Yang +16
Materialized views are a core construct in database systems, used to accelerate analytical queries and optimize batch pipelines for extract-transform-load (ETL) workflows. Maintain…
100x Cost & Latency Reduction: Performance Analysis of AI Query Approximation using Lightweight Proxy Models
Yeounoh Chung, Rushabh Desai, Jian He +9
Several data warehouse and database providers have recently introduced extensions to SQL called AI Queries, enabling users to specify functions and conditions in SQL that are evalu…
An In-Depth Study of Filter-Agnostic Vector Search on a PostgreSQL Database System: [Experiments and Analysis]
Duo Lu, Helena Caminal, Manos Chatzakis +4
Filtered Vector Search (FVS) is critical for supporting semantic search and GenAI applications in modern database systems. However, existing research most often evaluates algorithm…
BIRD-INTERACT: Re-imagining Text-to-SQL Evaluation for Large Language Models via Lens of Dynamic Interactions
Nan Huo, Xiaohan Xu, Jinyang Li +21
Large language models (LLMs) have demonstrated remarkable performance on single-turn text-to-SQL tasks, but real-world database applications predominantly require multi-turn intera…
SWE-SQL: Illuminating LLM Pathways to Solve User SQL Issues in Real-World Applications
Jinyang Li, Xiaolong Li, Ge Qu +17
Resolution of complex SQL issues persists as a significant bottleneck in real-world database applications. Current Large Language Models (LLMs), while adept at text-to-SQL translat…
DARTH: Declarative Recall Through Early Termination for Approximate Nearest Neighbor Search
Manos Chatzakis, Yannis Papakonstantinou, Themis Palpanas
Approximate Nearest Neighbor Search (ANNS) presents an inherent tradeoff between performance and recall (i.e., result quality). Each ANNS algorithm provides its own algorithm-depen…
Index-based, High-dimensional, Cosine Threshold Querying with Optimality Guarantees
Yuliang Li, Jianguo Wang, Benjamin Pullman +2
Given a database of vectors, a cosine threshold query returns all vectors in the database having cosine similarity to a query vector above a given threshold θ. These queries arise…
Plato: Approximate Analytics over Compressed Time Series with Tight Deterministic Error Guarantees
Chunbin Lin, Etienne Boursier, Yannis Papakonstantinou
Plato provides fast approximate analytics on time series, by precomputing and storing compressed time series. Plato's key novelty is the delivery of tight deterministic error guara…
Efficient Approximate Query Answering over Sensor Data with Deterministic Error Guarantees
Jaqueline Brito, Korhan Demirkaya, Boursier Etienne +3
With the recent proliferation of sensor data, there is an increasing need for the efficient evaluation of analytical queries over multiple sensor datasets. The magnitude of such da…
Data Compression for Analytics over Large-scale In-memory Column Databases
Chunbin Lin, Jianguo Wang, Yannis Papakonstantinou
Data compression schemes have exhibited their importance in column databases by contributing to the high-performance OLAP (Online Analytical Processing) query processing. Existing…
Fast In-Memory SQL Analytics on Graphs
Chunbin Lin, Benjamin Mandel, Yannis Papakonstantinou +1
We study a class of graph analytics SQL queries, which we call relationship queries. Relationship queries are a wide superset of fixed-length graph reachability queries and of tree…
The SQL++ Query Language: Configurable, Unifying and Semi-structured
Kian Win Ong, Yannis Papakonstantinou, Romain Vernoux
NoSQL databases support semi-structured data, typically modeled as JSON. They also provide limited (but expanding) query languages. Their idiomatic, non-SQL language constructs, th…
Declarative Ajax Web Applications through SQL++ on a Unified Application State
Yupeng Fu, Kian Win Ong, Yannis Papakonstantinou
Implementing even a conceptually simple web application requires an inordinate amount of time. FORWARD addresses three problems that reduce developer productivity: (a) Impedance mi…