Share your thoughts, 1 month free Claude Pro on usSee more
WorkDL logo mark

Is Table Retrieval a Solved Problem? Exploring Join-Aware Multi-Table Retrieval

About

Retrieving relevant tables containing the necessary information to accurately answer a given question over tables is critical to open-domain question-answering (QA) systems. Previous methods assume the answer to such a question can be found either in a single table or multiple tables identified through question decomposition or rewriting. However, neither of these approaches is sufficient, as many questions require retrieving multiple tables and joining them through a join plan that cannot be discerned from the user query itself. If the join plan is not considered in the retrieval stage, the subsequent steps of reasoning and answering based on those retrieved tables are likely to be incorrect. To address this problem, we introduce a method that uncovers useful join relations for any query and database during table retrieval. We use a novel re-ranking method formulated as a mixed-integer program that considers not only table-query relevance but also table-table relevance that requires inferring join relationships. Our method outperforms the state-of-the-art approaches for table retrieval by up to 9.3% in F1 score and for end-to-end QA by up to 5.4% in accuracy.

Peter Baile Chen, Yi Zhang, Dan Roth• 2024

Related benchmarks

TaskDatasetResultRank
Text-to-SQLSpider (test)--
213
Text-to-SQLSpider
Exec Acc (All)70.8
139
Text-to-SQLBIRD (test)--
46
Text-to-SQLSpider 2.0 (test)
Execution Accuracy (Spider 2.0 Test)6.9
27
SQL execution performanceBIRD n=1534
EM (1T)61.6
21
Text-to-SQLBird
Execution Accuracy (Llama-8B)26.8
21
Text-to-SQLSpider 2.0
Llama-8B Execution Accuracy1.1
21
Table RetrievalBIRD union (test)
Precision54.4
20
Table RetrievalSpider Lite 2.0 (test)
Precision29.4
20
Table RetrievalSpider union (test)
Precision (P)48.4
20
Showing 10 of 13 rows

Other info

Follow for update