• DocumentCode
    713912
  • Title

    Connected keywords

  • Author

    Smits, Gregory ; Pivert, Olivier ; Thion, Virginie

  • Author_Institution
    IRISA, Univ. of Rennes 1, Lannion, France
  • fYear
    2015
  • fDate
    13-15 May 2015
  • Firstpage
    112
  • Lastpage
    120
  • Abstract
    To improve the expressivity and accuracy of database query interfaces, a keyword-based constrained query language is introduced to let users explicitly express the intent of their search using keywords linked by meaningful grammatical connectives. Individually, keywords and connectives correspond to textual descriptions attached to components of the database graph schema, and as a whole, a so-called connected keywords query corresponds to a textual description of an SQL query. The translation process of such a query into SQL is mainly composed of two steps: first, the syntactic structure of the keyword query is analyzed to exhibit projection and selection statements using predefined graph patterns, then non explicit joins are deduced to obtain a complete translation of the keyword query as a meaningful connected subgraph. Experimentations show the relevance of the approach in terms of expressivity and efficiency.
  • Keywords
    SQL; graph theory; query processing; SQL query; connected keywords query; connected subgraph; database graph schema; database query interfaces; grammatical connectives; keyword-based constrained query language; predefined graph patterns; query translation process; Database languages; Databases; Joining processes; Motion pictures; Syntactics; Vocabulary;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Research Challenges in Information Science (RCIS), 2015 IEEE 9th International Conference on
  • Conference_Location
    Athens
  • Type

    conf

  • DOI
    10.1109/RCIS.2015.7128869
  • Filename
    7128869