Skip to content
aiqbench takeAI Products

aiqbench analysis

This research introduces KathDB-FAO, a novel subsystem within the KathDB multimodal DBMS that synthesizes query execution plans directly from natural language inputs. By generating custom functions for specific operators during evaluation, the system achieves significant performance gains, reducing average execution costs by 58.8% on benchmark datasets while maintaining high accuracy. The work represents a substantial advancement in bridging natural language interfaces with optimized database internals through dynamic program synthesis.
Source coveringarXiv
What this isA model's reading of the article and related coverage, written for aiqbench. Not the publisher's words.

KathDB-FAO: Synthesized Query Plans in a Multimodal DBMS

arXiv2 min read

arXiv:2609.28761v1 Announce Type: cross Abstract: We design, implement, and evaluate KathDB-FAO, a new query evaluation subsystem for our KathDB multimodal DBMS. KathDB-FAO takes as input a query in natural language (NL) and converts it into a query execution plan where each operator is a function whose body is synthesized during query evaluation, which allows powerful query-specific optimizations. To generate accurate and efficient plans from NL, KathDB-FAO first extracts fine-grained atomic actions for correctness, then establishes contracts on the inputs and outputs of those actions and groups them for efficiency, and finally synthesizes the function for each group on the fly. On SemBench, KathDB-FAO cuts execution cost by 58.8% on average across scenarios compared with the next best system, at comparable or better quality.

Abstract:We design, implement, and evaluate KathDB-FAO, a new query evaluation subsystem for our KathDB multimodal DBMS. KathDB-FAO takes as input a query in natural language (NL) and converts it into a query execution plan where each operator is a function whose body is synthesized during query evaluation, which allows powerful query-specific optimizations. To generate accurate and efficient plans from NL, KathDB-FAO first extracts fine-grained atomic actions for correctness, then establishes contracts on the inputs and outputs of those actions and groups them for efficiency, and finally synthesizes the function for each group on the fly. On SemBench, KathDB-FAO cuts execution cost by 58.8% on average across scenarios compared with the next best system, at comparable or better quality.

Databases (cs.DB); Artificial Intelligence (cs.AI)

arXiv:2609.28761 [cs.DB]

(or arXiv:2609.28761v1 [cs.DB] for this version)

https://doi.org/10.48550/arXiv.2609.28761 Focus to learn more arXiv-issued DOI via DataCite (pending registration)

arXivLabs is a framework that allows collaborators to develop and share new arXiv features directly on our website.

Both individuals and organizations that work with arXivLabs have embraced and accepted our values of openness, community, excellence, and user data privacy. arXiv is committed to these values and only works with partners that adhere to them.

Have an idea for a project that will add value for arXiv's community? Learn more about arXivLabs.

Full text under the publisher's open licence · 214 words

Related coverage