Supporting Schema References in Keyword Queries over Relational Databases

Martins, Paulo Rodrigo Oliveira; http://lattes.cnpq.br/5060411621848198

Dissertação

Supporting Schema References in Keyword Queries over Relational Databases

Relational Keyword Search (R-KwS) systems enable naive/informal users to retrieve information from relational databases without any knowledge about schema details or query languages. Roughly, R-KwS systems must determine which pieces of information to retrieve from the database and how to connect th...

ver descrição completa

Autor principal:	Martins, Paulo Rodrigo Oliveira
Outros Autores:	http://lattes.cnpq.br/5060411621848198
Grau:	Dissertação
Idioma:	eng
Publicado em:	Universidade Federal do Amazonas 2020
Assuntos:	Relational keyword search system Relational databases Database schema elements Query languages Keyword query CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Keyword Search Relational Databases Schema References Candidate Networks
Acesso em linha:	https://tede.ufam.edu.br/handle/tede/7815

id	oai:https:--tede.ufam.edu.br-handle-:tede-7815
recordtype	dspace
spelling	oai:https:--tede.ufam.edu.br-handle-:tede-78152020-06-14T05:03:50Z Supporting Schema References in Keyword Queries over Relational Databases Suporte a referências de esquema em consultas de palavras-chave em Bancos de dados relacionais Martins, Paulo Rodrigo Oliveira Silva, Altigran Soares da http://lattes.cnpq.br/5060411621848198 http://lattes.cnpq.br/3405503472010994 Moura, Edleno Silva de http://lattes.cnpq.br/4737852130924504 Cavalcanti, João Marcos Bastos http://lattes.cnpq.br/3537707069694606 Relational keyword search system Relational databases Database schema elements Query languages Keyword query CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Keyword Search Relational Databases Schema References Candidate Networks Relational Keyword Search (R-KwS) systems enable naive/informal users to retrieve information from relational databases without any knowledge about schema details or query languages. Roughly, R-KwS systems must determine which pieces of information to retrieve from the database and how to connect them to generate a relevant answer for the user. For instance, the keywords from the query may refer either to instance values or to database schema elements, such as relations and attributes names. Unfortunately, most of the R-KwS systems do not support references to the database schema. In this work, we propose a new method to generate an adequate SQL query from an input keyword query, taking advantage of references to the content of the database as well as references to the database schema. Our experiments indicate that schema references can help to improve the quality of the ranking the answers for the user. Relational Keyword Search (R-KwS) systems enable naive/informal users to retrieve information from relational databases without any knowledge about schema details or query languages. Roughly, R-KwS systems must determine which pieces of information to retrieve from the database and how to connect them to generate a relevant answer for the user. For instance, the keywords from the query may refer either to instance values or to database schema elements, such as relations and attributes names. Unfortunately, most of the R-KwS systems do not support references to the database schema. In this work, we propose a new method to generate an adequate SQL query from an input keyword query, taking advantage of references to the content of the database as well as references to the database schema. Our experiments indicate that schema references can help to improve the quality of the ranking the answers for the user. 2020-06-14T02:37:56Z 2020-03-27 Dissertação MARTINS, Paulo Rodrigo Oliveira. Supporting Schema References in Keyword Queries over Relational Databases. 2020. 70 f. Dissertação (Mestrado em Informática) - Universidade Federal do Amazonas, Manaus, 2020. https://tede.ufam.edu.br/handle/tede/7815 eng Acesso Aberto http://creativecommons.org/licenses/by-nc-sa/4.0/ application/pdf Universidade Federal do Amazonas Instituto de Computação Brasil UFAM Programa de Pós-graduação em Informática
institution	TEDE - Universidade Federal do Amazonas
collection	TEDE-UFAM
language	eng
topic	Relational keyword search system Relational databases Database schema elements Query languages Keyword query CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Keyword Search Relational Databases Schema References Candidate Networks
spellingShingle	Relational keyword search system Relational databases Database schema elements Query languages Keyword query CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Keyword Search Relational Databases Schema References Candidate Networks Martins, Paulo Rodrigo Oliveira Supporting Schema References in Keyword Queries over Relational Databases
topic_facet	Relational keyword search system Relational databases Database schema elements Query languages Keyword query CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO Keyword Search Relational Databases Schema References Candidate Networks
description	Relational Keyword Search (R-KwS) systems enable naive/informal users to retrieve information from relational databases without any knowledge about schema details or query languages. Roughly, R-KwS systems must determine which pieces of information to retrieve from the database and how to connect them to generate a relevant answer for the user. For instance, the keywords from the query may refer either to instance values or to database schema elements, such as relations and attributes names. Unfortunately, most of the R-KwS systems do not support references to the database schema. In this work, we propose a new method to generate an adequate SQL query from an input keyword query, taking advantage of references to the content of the database as well as references to the database schema. Our experiments indicate that schema references can help to improve the quality of the ranking the answers for the user.
author_additional	Silva, Altigran Soares da
author_additionalStr	Silva, Altigran Soares da
format	Dissertação
author	Martins, Paulo Rodrigo Oliveira
author2	http://lattes.cnpq.br/5060411621848198
author2Str	http://lattes.cnpq.br/5060411621848198
title	Supporting Schema References in Keyword Queries over Relational Databases
title_short	Supporting Schema References in Keyword Queries over Relational Databases
title_full	Supporting Schema References in Keyword Queries over Relational Databases
title_fullStr	Supporting Schema References in Keyword Queries over Relational Databases
title_full_unstemmed	Supporting Schema References in Keyword Queries over Relational Databases
title_sort	supporting schema references in keyword queries over relational databases
publisher	Universidade Federal do Amazonas
publishDate	2020
url	https://tede.ufam.edu.br/handle/tede/7815
_version_	1831969877188935680
score	11.753735

Supporting Schema References in Keyword Queries over Relational Databases

Registros relacionados