arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2407.09522cs.DBcs.AIcs.LGstat.ML
收藏

UQE:面向非结构化数据库的查询引擎

UQE: A Query Engine for Unstructured Databases

Google DeepMind(谷歌DeepMind);Google Cloud(谷歌云);University of Alberta(阿尔伯塔大学);Georgia Institute of Technology(佐治亚理工学院)

Hanjun Dai, Bethany Yixin Wang, Xingchen Wan, Bo Dai, Sherry Yang, Azade Nova, Pengcheng Yin, Phitchaya Mangpo Phothilimthana, Charles Sutton, Dale Schuurmans

AI总结:

提出通用查询引擎UQE,利用LLMs和SQL方言UQL直接对图像、对话等非结构化数据进行高效查询与分析。

摘要:

结构化数据分析是一个成熟的领域,拥有许多成功的方法。然而,大多数现实世界的数据以非结构化形式存在,例如图像和对话。我们研究了大型语言模型(LLMs)在实现非结构化数据分析方面的潜力。具体而言,我们提出了一种新的通用查询引擎(UQE),能够直接对非结构化数据集合进行查询并提取洞察。该引擎接受以通用查询语言(UQL)编写的查询,UQL是SQL的一种方言,在指定条件和运算符时提供完全的自然语言灵活性。新引擎利用LLMs分析非结构化数据的能力,同时允许我们利用采样和优化技术的进步来实现高效且准确的查询执行。此外,我们借鉴经典编译器理论中的技术,以更好地协调采样方法与基础模型调用之间的工作流。我们在跨不同模态的数据分析中展示了UQE的效率,包括图像、对话和评论,涵盖了一系列有用的查询类型,包括条件聚合、语义检索和抽象聚合。

英文摘要:

Analytics on structured data is a mature field with many successful methods. However, most real world data exists in unstructured form, such as images and conversations. We investigate the potential of Large Language Models (LLMs) to enable unstructured data analytics. In particular, we propose a new Universal Query Engine (UQE) that directly interrogates and draws insights from unstructured data collections. This engine accepts queries in a Universal Query Language (UQL), a dialect of SQL that provides full natural language flexibility in specifying conditions and operators. The new engine leverages the ability of LLMs to conduct analysis of unstructured data, while also allowing us to exploit advances in sampling and optimization techniques to achieve efficient and accurate query execution. In addition, we borrow techniques from classical compiler theory to better orchestrate the workflow between sampling methods and foundation model calls. We demonstrate the efficiency of UQE on data analytics across different modalities, including images, dialogs and reviews, across a range of useful query types, including conditional aggregation, semantic retrieval and abstraction aggregation.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑