• DocumentCode
    2080191
  • Title

    Explaining structured queries in natural language

  • Author

    Koutrika, Georgia ; Simitsis, Alkis ; Ioannidis, Yannis E.

  • Author_Institution
    Comput. Sci. Dept., Stanford Univ., Stanford, CA, USA
  • fYear
    2010
  • fDate
    1-6 March 2010
  • Firstpage
    333
  • Lastpage
    344
  • Abstract
    Many applications offer a form-based environment for nai¿ve 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.
  • Keywords
    SQL; database management systems; directed graphs; natural languages; query processing; database accessing; directed graphs; graph edges; graph traversal strategies; naive users; natural language; query translation problem; structured query language; template mechanism; textual query descriptions; user interactions; Automatic speech recognition; Computer science; Database languages; Informatics; Natural languages; Qualifications; Resource description framework; Speech analysis; Telecommunications; Visual databases;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Data Engineering (ICDE), 2010 IEEE 26th International Conference on
  • Conference_Location
    Long Beach, CA
  • Print_ISBN
    978-1-4244-5445-7
  • Electronic_ISBN
    978-1-4244-5444-0
  • Type

    conf

  • DOI
    10.1109/ICDE.2010.5447824
  • Filename
    5447824