EUVIMEDEUVIMED entdecken
Crossref

100x Cost & Latency Reduction: Performance Analysis of AI Query Approximation using Lightweight Proxy Models: [Experiments & Analysis]

Yeounoh Chung, Rushabh Desai, Jian He, Yu Xiao, Thibaud Hottelier, Yves-Laurent Kom Samo, Pushkar Khadilkar, Xianshun Chen, Sam Idicula, Fatma Ozcan, Alon Halevy, Yannis Papakonstantinou

Proceedings of the ACM on Management of Data · 18.05.2026 · 4 (3) · 1-23

DOI: 10.1145/3802002 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Proceedings of the ACM on Management of Data, online erschienen am 18.05.2026. Verfasst von Yeounoh Chung und 11 weiteren Autor:innen. Die Arbeit nennt 38 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

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 evaluated by LLMs, thereby broadening significantly the kinds of queries one can express over the combination of structured and unstructured data. LLMs offer remarkable semantic reasoning capabilities, making them an essential tool for complex and nuanced queries that blend structured and unstructured data. While extremely powerful, these AI queries can become prohibitively costly when invoked thousands of times. This paper provides an extensive evaluation of a recent AI query approximation approach that enables low cost analytics and database applications to benefit from AI queries. The approach delivers >100x cost and latency reduction for the semantic filter (AI.IF) operator and also important gains for semantic ranking (AI.RANK). The cost and performance gains come from utilizing cheap and accurate proxy models over embedding vectors. We show that despite the massive gains in latency and cost, these proxy models preserve accuracy and occasionally improve accuracy across various benchmark datasets, including the extended Amazon reviews benchmark that has 10M rows. We present an OLAP-friendly architecture within Google BigQuery for this approach for purely online (ad hoc) queries, and a low-latency HTAP database-friendly architecture in AlloyDB that could further improve the latency by moving the proxy model training offline. We present techniques that accelerate the proxy model training.

Zitieren

APA

Chung, Y., Desai, R., He, J., Xiao, Y., Hottelier, T., Samo, Y. K., Khadilkar, P., Chen, X., Idicula, S., Ozcan, F., Halevy, A., & Papakonstantinou, Y. (2026). 100x Cost & Latency Reduction: Performance Analysis of AI Query Approximation using Lightweight Proxy Models: [Experiments & Analysis]. Proceedings of the ACM on Management of Data, 4(3), 1-23. https://doi.org/10.1145/3802002

Vancouver

Chung Y, Desai R, He J, Xiao Y, Hottelier T, Samo YK, et al. 100x Cost & Latency Reduction: Performance Analysis of AI Query Approximation using Lightweight Proxy Models: [Experiments & Analysis]. Proceedings of the ACM on Management of Data. 2026;4(3):1-23. doi:10.1145/3802002

BibTeX
@article{Chung2026,
  author = {Chung, Yeounoh and Desai, Rushabh and He, Jian and Xiao, Yu and Hottelier, Thibaud and Samo, Yves-Laurent Kom and Khadilkar, Pushkar and Chen, Xianshun and Idicula, Sam and Ozcan, Fatma and Halevy, Alon and Papakonstantinou, Yannis},
  title = {100x Cost & Latency Reduction: Performance Analysis of AI Query Approximation using Lightweight Proxy Models: [Experiments & Analysis]},
  journal = {Proceedings of the ACM on Management of Data},
  year = {2026},
  volume = {4},
  number = {3},
  pages = {1--23},
  doi = {10.1145/3802002}
}
Kostenlos starten →