3 citations · 7 across the 8 of their papers we have counts for
10 papers
Query Performance Tuning with Optimal Exploration of Optimizer Cost Model Parameter Space
Wentao Wu, Xiaoying Wang, Vivek Narasayya +1
Modern query optimizers use analytical cost models to estimate the cost of a given query plan. Such cost models are typically functions of a set of "cost units" that specify unit C…
Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server
Xiaoying Wang, Wentao Wu, Vivek Narasayya +1
Indexes are crucial for database performance. Index tuning, i.e., selecting appropriate indexes for a database workload, is an important problem. The state-of-the-art index tuning…
Esc: An Early-stopping Checker for Budget-aware Index Tuning
Xiaoying Wang, Wentao Wu, Vivek Narasayya +1
Index tuning is a time-consuming process. One major performance bottleneck in existing index tuning systems is the large amount of "what-if" query optimizer calls that estimate the…
Wii: Dynamic Budget Reallocation In Index Tuning
Xiaoying Wang, Wentao Wu, Chi Wang +2
Index tuning aims to find the optimal index configuration for an input workload. It is often a time-consuming and resource-intensive process, largely attributed to the huge amount…
MINT: Multi-Vector Search Index Tuning
Jiongli Zhu, Yue Wang, Bailu Ding +3
Vector search plays a crucial role in many real-world applications. In addition to single-vector search, multi-vector search becomes important for multi-modal and multi-feature sce…
COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics
Tarique Siddiqui, Surajit Chaudhuri, Vivek Narasayya
Data analysis often involves comparing subsets of data across many dimensions for finding unusual trends and patterns. While the comparison between subsets of data can be expressed…
Bitvector-aware Query Optimization for Decision Support Queries (extended version)
Bailu Ding, Surajit Chaudhuri, Vivek Narasayya
Bitvector filtering is an important query processing technique that can significantly reduce the cost of execution, especially for complex decision support queries with multiple jo…
Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques
Jiexing Li, Arnd Christian König, Vivek Narasayya +1
The ability to estimate resource consumption of SQL queries is crucial for a number of tasks in a database system such as admission control, query scheduling and costing during que…
A Statistical Approach Towards Robust Progress Estimation
Arnd Christian König, Bolin Ding, Surajit Chaudhuri +1
The need for accurate SQL progress estimation in the context of decision support administration has led to a number of techniques proposed for this task. Unfortunately, no single o…
Compression Aware Physical Database Design
Hideaki Kimura, Vivek Narasayya, Manoj Syamala
Modern RDBMSs support the ability to compress data using methods such as null suppression and dictionary encoding. Data compression offers the promise of significantly reducing sto…