Systems translating keyword queries into SQL queries over relational databases are usually referred to in the literature as schema-based approaches. These techniques exploit the information contained in the database schema to build SQL queries that express the intended meaning of the user query. Besides, typically, they perform a preliminary step that associates keywords in the user query with database elements (names of tables, attributes and domain attributes). In this paper, we present a probabilistic approach based on a Hidden Markov Model to provide such mappings. In contrast to most existing techniques, our proposal does not require any a-priori knowledge of the database extension.

Using a HMM based approach for mapping keyword queries into database terms / Bergamaschi, Sonia; Guerra, Francesco; M., Interlandi; S., Rota; R., Trillo; Y., Velegrakis. - ELETTRONICO. - (2013), pp. 239-246. (Intervento presentato al convegno 21st Italian Symposium on Advanced Database Systems, SEBD 2013 tenutosi a Roccella Jonica, Reggio Calabria, ita nel June 30th -July 04th, 2013).

Using a HMM based approach for mapping keyword queries into database terms

BERGAMASCHI, Sonia;GUERRA, Francesco;
2013

Abstract

Systems translating keyword queries into SQL queries over relational databases are usually referred to in the literature as schema-based approaches. These techniques exploit the information contained in the database schema to build SQL queries that express the intended meaning of the user query. Besides, typically, they perform a preliminary step that associates keywords in the user query with database elements (names of tables, attributes and domain attributes). In this paper, we present a probabilistic approach based on a Hidden Markov Model to provide such mappings. In contrast to most existing techniques, our proposal does not require any a-priori knowledge of the database extension.
2013
21st Italian Symposium on Advanced Database Systems, SEBD 2013
Roccella Jonica, Reggio Calabria, ita
June 30th -July 04th, 2013
239
246
Bergamaschi, Sonia; Guerra, Francesco; M., Interlandi; S., Rota; R., Trillo; Y., Velegrakis
Using a HMM based approach for mapping keyword queries into database terms / Bergamaschi, Sonia; Guerra, Francesco; M., Interlandi; S., Rota; R., Trillo; Y., Velegrakis. - ELETTRONICO. - (2013), pp. 239-246. (Intervento presentato al convegno 21st Italian Symposium on Advanced Database Systems, SEBD 2013 tenutosi a Roccella Jonica, Reggio Calabria, ita nel June 30th -July 04th, 2013).
File in questo prodotto:
Non ci sono file associati a questo prodotto.
Pubblicazioni consigliate

Licenza Creative Commons
I metadati presenti in IRIS UNIMORE sono rilasciati con licenza Creative Commons CC0 1.0 Universal, mentre i file delle pubblicazioni sono rilasciati con licenza Attribuzione 4.0 Internazionale (CC BY 4.0), salvo diversa indicazione.
In caso di violazione di copyright, contattare Supporto Iris

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11380/959291
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 0
  • ???jsp.display-item.citation.isi??? ND
social impact