Reproduce “Research Challenges in Relational Database Management Systems for LLM Queries” on OpenResearch

Turn your favorite coding agents into research agents that review literature, develop hypotheses, and run experiments.

Universal app for Apple silicon and Intel. Requires macOS 11 or later.

About this paper

Kerem Akillioglu, Anurag Chakraborty, Sairaj Voruganti, M. Tamer Özsu

University of Waterloo researchers empirically analyzed functional and performance challenges when integrating Large Language Models directly into relational database management systems, especially for open-source and locally deployed solutions. Their study reveals core limitations in ensuring structured outputs, optimizing resource utilization, and developing LLM-aware query plans.

Key insights

  • Enforcing structured outputs from non-deterministic LLMs is critical for query correctness and requires robust constrained decoding mechanisms.
  • Efficient resource utilization, particularly for GPUs, necessitates advanced batching strategies and asynchronous request processing to overcome current inefficiencies.
  • Current DBMS query optimizers, treating LLM invocations as black boxes, must evolve to become LLM-aware, factoring in inference costs and characteristics like KV-cache reuse and prompt overlap.

Summary by alphaXiv.

Tip: change arxiv.org to autoarxiv.org in any arXiv abstract link to open the paper here.