FANDA: A Novel Approach to Perform Follow-up Query Analysis

Published:

[PAPER] [DATA] [SLIDES]

Introduction

Natural Language Interfaces to Databases (NLIDB, a.k.a. NL-To-SQL, Semantic Parsing) allows users to search databases using natural language instead of SQL-like query languages. While saving the users from having to learn query languages, multi-turn interaction with NLIDB usually involves multiple queries where contextual information is vital to understand the users’ query intents. In this paper, we address a typical contextual understanding problem, termed as follow-up query analysis. Our work summarizes typical follow-up query scenarios and provides the new FollowUp dataset with 1000 query triples on 120 tables(Below).

ScenarioExample
AnalyticaPrecedent : In 1995, is there any network named CBC?
Follow-up : Any TSN?
Fused : In 1995, is there any network named TSN?
ComparePrecedent : How much money has Smith earned?
Follow-up : Compare it with Bill Collins.
Fused : Compare money Smith earned with Bill Collins.
Calc & StatsPrecedent : List all universities founded before 1855.
Follow-up : Show their number.
Fused : Show the number of all universities founded before 1855.
ExtremumPrecedent : Which stadium has the most capacity?
Follow-up : Which get the highest attendance?
Fused : Which stadium get the highest attendance?
FilterPrecedent : How many roles are from studio paramount?
Follow-up : List all titles produced by that studio.
Fused : List all titles produced by studio paramount.
GroupPrecedent : Show the industry which has the most companies?
Follow-up : Show in different countries.
Fused : Show the industry which has the most companies in different countries.
SortPrecedent : Show all chassis produced after the year 1990.
Follow-up : Sort them by year.
Fused : Show all chassis produced after the year 1990 and sort by year.
SearchPrecedent : What position did Sid O’Neill play?
Follow-up : Which players else are in the same position?
Fused : Which players play in the position of Sid O’Neill excluding Sid O’Neill?

Cite

@inproceedings{liu2019fanda,
  title={\textsc{FAnDa}: A Novel Approach to Perform Follow-up Query Analysis},
  author={Liu, Qian and Chen, Bei and Lou, Jian-Guang and Jin, Ge and Zhang, Dongmei},
  booktitle ={AAAI},
  year={2019}
}