Supporting Schema References in Keyword Queries over Relational Databases
Autor(a) principal: | |
---|---|
Data de Publicação: | 2020 |
Outros Autores: | |
Tipo de documento: | Dissertação |
Idioma: | eng |
Título da fonte: | Biblioteca Digital de Teses e Dissertações da UFAM |
Texto Completo: | https://tede.ufam.edu.br/handle/tede/7815 |
Resumo: | 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. |
id |
UFAM_4fc5624d3ebbd74bc2b3c1b087916fc4 |
---|---|
oai_identifier_str |
oai:https://tede.ufam.edu.br/handle/:tede/7815 |
network_acronym_str |
UFAM |
network_name_str |
Biblioteca Digital de Teses e Dissertações da UFAM |
repository_id_str |
6592 |
spelling |
Supporting Schema References in Keyword Queries over Relational DatabasesSuporte a referências de esquema em consultas de palavras-chave em Bancos de dados relacionaisRelational keyword search systemRelational databasesDatabase schema elementsQuery languagesKeyword queryCIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃOKeyword SearchRelational DatabasesSchema ReferencesCandidate NetworksRelational 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.Universidade Federal do AmazonasInstituto de ComputaçãoBrasilUFAMPrograma de Pós-graduação em InformáticaSilva, Altigran Soares dahttp://lattes.cnpq.br/3405503472010994Moura, Edleno Silva dehttp://lattes.cnpq.br/4737852130924504Cavalcanti, João Marcos Bastoshttp://lattes.cnpq.br/3537707069694606Martins, Paulo Rodrigo Oliveirahttp://lattes.cnpq.br/50604116218481982020-06-14T02:37:56Z2020-03-27info:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfMARTINS, 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/7815enghttp://creativecommons.org/licenses/by-nc-sa/4.0/info:eu-repo/semantics/openAccessreponame:Biblioteca Digital de Teses e Dissertações da UFAMinstname:Universidade Federal do Amazonas (UFAM)instacron:UFAM2020-06-14T05:03:50Zoai:https://tede.ufam.edu.br/handle/:tede/7815Biblioteca Digital de Teses e Dissertaçõeshttp://200.129.163.131:8080/PUBhttp://200.129.163.131:8080/oai/requestddbc@ufam.edu.br||ddbc@ufam.edu.bropendoar:65922020-06-14T05:03:50Biblioteca Digital de Teses e Dissertações da UFAM - Universidade Federal do Amazonas (UFAM)false |
dc.title.none.fl_str_mv |
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 |
title |
Supporting Schema References in Keyword Queries over Relational Databases |
spellingShingle |
Supporting Schema References in Keyword Queries over Relational Databases Martins, Paulo Rodrigo Oliveira 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 |
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 |
author |
Martins, Paulo Rodrigo Oliveira |
author_facet |
Martins, Paulo Rodrigo Oliveira http://lattes.cnpq.br/5060411621848198 |
author_role |
author |
author2 |
http://lattes.cnpq.br/5060411621848198 |
author2_role |
author |
dc.contributor.none.fl_str_mv |
Silva, Altigran Soares da http://lattes.cnpq.br/3405503472010994 Moura, Edleno Silva de http://lattes.cnpq.br/4737852130924504 Cavalcanti, João Marcos Bastos http://lattes.cnpq.br/3537707069694606 |
dc.contributor.author.fl_str_mv |
Martins, Paulo Rodrigo Oliveira http://lattes.cnpq.br/5060411621848198 |
dc.subject.por.fl_str_mv |
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 |
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 |
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. |
publishDate |
2020 |
dc.date.none.fl_str_mv |
2020-06-14T02:37:56Z 2020-03-27 |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/masterThesis |
format |
masterThesis |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
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 |
identifier_str_mv |
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. |
url |
https://tede.ufam.edu.br/handle/tede/7815 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.rights.driver.fl_str_mv |
http://creativecommons.org/licenses/by-nc-sa/4.0/ info:eu-repo/semantics/openAccess |
rights_invalid_str_mv |
http://creativecommons.org/licenses/by-nc-sa/4.0/ |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.publisher.none.fl_str_mv |
Universidade Federal do Amazonas Instituto de Computação Brasil UFAM Programa de Pós-graduação em Informática |
publisher.none.fl_str_mv |
Universidade Federal do Amazonas Instituto de Computação Brasil UFAM Programa de Pós-graduação em Informática |
dc.source.none.fl_str_mv |
reponame:Biblioteca Digital de Teses e Dissertações da UFAM instname:Universidade Federal do Amazonas (UFAM) instacron:UFAM |
instname_str |
Universidade Federal do Amazonas (UFAM) |
instacron_str |
UFAM |
institution |
UFAM |
reponame_str |
Biblioteca Digital de Teses e Dissertações da UFAM |
collection |
Biblioteca Digital de Teses e Dissertações da UFAM |
repository.name.fl_str_mv |
Biblioteca Digital de Teses e Dissertações da UFAM - Universidade Federal do Amazonas (UFAM) |
repository.mail.fl_str_mv |
ddbc@ufam.edu.br||ddbc@ufam.edu.br |
_version_ |
1809731998039670784 |