Keyword queries offer a convenient alternative to traditionalSQL in querying relational databases with large, often unknown,schemas and instances. The challenge in answering such queriesis to discover their intended semantics, construct the SQL queriesthat describe them and used them to retrieve the respective tuples.Existing approaches typically rely on indices built a-priori on thedatabase content. This seriously limits their applicability if a-prioriaccess to the database content is not possible. Examples include theon-line databases accessed through web interface, or the sources ininformation integration systems that operate behind wrappers withspecific query capabilities. Furthermore, existing literature has notstudied to its full extend the inter-dependencies across the ways thedifferent keywords are mapped into the database values and schemaelements. In this work, we describe a novel technique for translatingkeyword queries into SQL based on the Munkres (a.k.a. Hungarian)algorithm. Our approach not only tackles the above twolimitations, but it offers significant improvements in the identificationof the semantically meaningful SQL queries that describe theintended keyword query semantics. We provide details of the techniqueimplementation and an extensive experimental evaluation.
Keyword search over relational databases: a metadata approach / Bergamaschi, Sonia; Domnori, Elton; Guerra, Francesco; Raquel Trillo, Lado; Yannis, Velegrakis. - STAMPA. - (2011), pp. 565-576. ((Intervento presentato al convegno ACM SIGMOD International Conference on Management of Data tenutosi a Athens nel June 12-16, 2011.
Data di pubblicazione: | 2011 |
Titolo: | Keyword search over relational databases: a metadata approach |
Autore/i: | Bergamaschi, Sonia; Domnori, Elton; Guerra, Francesco; Raquel Trillo, Lado; Yannis, Velegrakis |
Autore/i UNIMORE: | |
Digital Object Identifier (DOI): | http://dx.doi.org/10.1145/1989323.1989383 |
Codice identificativo Scopus: | 2-s2.0-79959961081 |
Nome del convegno: | ACM SIGMOD International Conference on Management of Data |
Luogo del convegno: | Athens |
Data del convegno: | June 12-16, 2011 |
Pagina iniziale: | 565 |
Pagina finale: | 576 |
Citazione: | Keyword search over relational databases: a metadata approach / Bergamaschi, Sonia; Domnori, Elton; Guerra, Francesco; Raquel Trillo, Lado; Yannis, Velegrakis. - STAMPA. - (2011), pp. 565-576. ((Intervento presentato al convegno ACM SIGMOD International Conference on Management of Data tenutosi a Athens nel June 12-16, 2011. |
Tipologia | Relazione in Atti di Convegno |
File in questo prodotto:
File | Descrizione | Tipologia | |
---|---|---|---|
p565-bergamaschi.pdf | Articolo | Versione dell'editore (versione pubblicata) | Administrator Richiedi una copia |

I documenti presenti in Iris Unimore sono rilasciati con licenza Creative Commons Attribuzione - Non commerciale - Non opere derivate 3.0 Italia, salvo diversa indicazione.
In caso di violazione di copyright, contattare Supporto Iris