paper-with-me

홈 › Papers

Optimizing LLM Queries in Relational Data Analytics Workloads

2024-03-09 · Shu Liu, Asim Biswal, Amog Kamsetty, Audrey Cheng, Luis Gaspar Schroeder, Liana Patel, Shiyi Cao, Xiangxi Mo, Ion Stoica, Joseph E. Gonzalez, Matei Zaharia

Batch data analytics is a growing application for Large Language Models (LLMs). LLMs enable users to perform a wide range of natural language tasks, such as classification, entity extraction, and translation, over large datasets. However, LLM inference is highly costly and slow: for example, an NVIDIA L4 GPU running Llama3-8B can only process 6 KB of text per second, taking about a day to handle 15 GB of data; processing a similar amount of data costs around $10K on OpenAI's GPT-4o. In this paper, we propose novel techniques that can significantly reduce the cost of LLM calls for relational data analytics workloads. Our key contribution is developing efficient algorithms for reordering the rows and the fields within each row of an input table to maximize key-value (KV) cache reuse when performing LLM serving. As such, our approach can be easily applied to existing analytics systems and serving platforms. Our evaluation shows that our solution can yield up to 3.4x improvement in job completion time on a benchmark of diverse LLM-based queries using Llama 3 models. Our solution also achieves a 32% cost savings under OpenAI and Anthropic pricing models.

📄 PDF Abstract BibTeX arXiv:2403.05821

Code (0)

등록된 구현이 없습니다.

Tasks

GPU

Similar Papers 제목 키워드 기반

ARCADE: A Real-Time Data System for Hybrid and Continuous Query Processing across Diverse Data Modalities

2025-09-24 · Jingyi Yang, Songsong Mo, Jiachen Shi, Zihao Yu 외 arxiv

The explosive growth of multimodal data - spanning text, image, video, spatial, and relational modalities, coupled with the need for real-time semantic search and retrieval over these data - has outpaced the capabilities…

Sibyl: Forecasting Time-Evolving Query Workloads

2024-01-08 · Hanxian Huang, Tarique Siddiqui, Rana Alotaibi, Carlo Curino 외

Database systems often rely on historical query traces to perform workload-based performance tuning. However, real production workloads are time-evolving, making historical queries ineffective for optimizing future workl…

Decoder

MICRO: A Lightweight Middleware for Optimizing Cross-store Cross-model Graph-Relation Joins [Technical Report]

2026-03-14 · Xiuwen Zheng, Arun Kumar, Amarnath Gupta arxiv

Modern data applications increasingly involve heterogeneous data managed in different models and stored across disparate database engines, often deployed as separate installs. Limited research has addressed cross-model q…

Query2Vec: An Evaluation of NLP Techniques for Generalized Workload Analytics

2018-01-17 · Shrainik Jain, Bill Howe, Jiaqi Yan, Thierry Cruanes

We consider methods for learning vector representations of SQL queries to support generalized workload analytics tasks, including workload summarization for index selection and predicting queries that will trigger memory…

Feature EngineeringTransfer Learning

Optimizing video analytics inference pipelines: a case study

2025-12-07 · Saeid Ghafouri, Yuming Ding, Katerine Diaz Chito, Jesús Martinez del Rincón 외 arxiv

Cost-effective and scalable video analytics are essential for precision livestock monitoring, where high-resolution footage and near-real-time monitoring needs from commercial farms generates substantial computational wo…