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
Link To Document