Explaining Structured Queries in Natural Language

被引:29
|
作者
Koutrika, Georgia [1 ]
Simitsis, Alkis [2 ]
Ioannidis, Yannis E. [3 ]
机构
[1] Stanford Univ, Dept Comp Sci, Stanford, CA 94305 USA
[2] HP Labs, Palo Alto, CA USA
[3] Univ Athens, Dept Informat & Telecom, Athens, Greece
关键词
D O I
10.1109/ICDE.2010.5447824
中图分类号
TP301 [理论、方法];
学科分类号
081202 ;
摘要
Many applications offer a form-based environment for naive users for accessing databases without being familiar with the database schema or a structured query language. User interactions are translated to structured queries and executed. However, as a user is unlikely to know the underlying semantic connections among the fields presented in a form, it is often useful to provide her with a textual explanation of the query. In this paper, we take a graph-based approach to the query translation problem. We represent various forms of structured queries as directed graphs and we annotate the graph edges with template labels using an extensible template mechanism. We present different graph traversal strategies for efficiently exploring these graphs and composing textual query descriptions. Finally, we present experimental results for the efficiency and effectiveness of the proposed methods.
引用
收藏
页码:333 / 344
页数:12
相关论文
共 50 条
  • [31] Inspecting Data Using Natural Language Queries
    Bacci, Franscesca
    Cau, Federico Maria
    Spano, Lucio Davide
    [J]. COMPUTATIONAL SCIENCE AND ITS APPLICATIONS - ICCSA 2020, PT VI, 2020, 12254 : 771 - 782
  • [32] Analysing natural language queries at INEX 2004
    Tannier, X
    Girardot, JJ
    Mathieu, M
    [J]. ADVANCES IN XML INFORMATION RETRIEVAL, 2005, 3493 : 395 - 409
  • [33] A Movie Search System with Natural Language Queries
    Wang, Xin
    Zhan, Huayi
    Yang, Lan
    Li, Zonghai
    Zhong, Jiying
    Zhao, Liang
    Sun, Rui
    Tan, Bin
    [J]. DATABASE SYSTEMS FOR ADVANCED APPLICATIONS (DASFAA 2018), PT II, 2018, 10828 : 791 - 796
  • [34] Natural Language for Database Queries: A Laboratory Study
    Vassiliou, Yannis
    Jarke, Matthias
    Stohr, Edward A.
    Turner, Jon A.
    White, Norman H.
    [J]. MIS QUARTERLY, 1983, 7 (04) : 47 - 61
  • [35] Goal Detection from Natural Language Queries
    He, Yulan
    [J]. NATURAL LANGUAGE PROCESSING AND INFORMATION SYSTEMS, 2010, 6177 : 157 - 168
  • [36] Retrieving Videogame Moments with Natural Language Queries
    Zhang, Xiaoxuan
    Smith, Adam M.
    [J]. PROCEEDINGS OF THE 14TH INTERNATIONAL CONFERENCE ON THE FOUNDATIONS OF DIGITAL GAMES (FDG'19), 2019,
  • [37] TiQi: Towards Natural Language Trace Queries
    Pruski, Piotr
    Lohar, Sugandha
    Aquanette, Rundale
    Ott, Greg
    Amornborvornwong, Sorawit
    Rasin, Alexander
    Cleland-Huang, Jane
    [J]. 2014 IEEE 22ND INTERNATIONAL REQUIREMENTS ENGINEERING CONFERENCE (RE), 2014, : 123 - 132
  • [38] Searching cross-language metadata with automatically structured queries
    Peinado, V
    López-Ostenero, F
    Gonzalo, J
    Verdejo, F
    [J]. RESEARCH AND ADVANCED TECHNOLOGY FOR DIGITAL LIBRARIES, 2005, 3652 : 529 - 530
  • [39] SKDQL: A structured language to specify knowledge discovery processes and queries
    Silva, MPD
    Robin, J
    [J]. ADVANCES IN ARTIFICIAL INTELLIGENCE - SBIA 2004, 2004, 3171 : 326 - 335
  • [40] Generating Keyword Queries for Natural Language Queries to Alleviate Lexical Chasm Problem
    Liu, Xiaoyu
    Pan, Shunda
    Zhang, Qi
    Jiang, Yu-Gang
    Huang, Xuanjing
    [J]. CIKM'18: PROCEEDINGS OF THE 27TH ACM INTERNATIONAL CONFERENCE ON INFORMATION AND KNOWLEDGE MANAGEMENT, 2018, : 1163 - 1172