???jsp.display-item.social.title??? |
|
Please use this identifier to cite or link to this item:
https://tede.ufam.edu.br/handle/tede/7815
???metadata.dc.type???: | Dissertação |
Title: | Supporting Schema References in Keyword Queries over Relational Databases |
Other Titles: | Suporte a referências de esquema em consultas de palavras-chave em Bancos de dados relacionais |
???metadata.dc.creator???: | Martins, Paulo Rodrigo Oliveira |
???metadata.dc.contributor.advisor1???: | Silva, Altigran Soares da |
???metadata.dc.contributor.referee1???: | Moura, Edleno Silva de |
???metadata.dc.contributor.referee2???: | Cavalcanti, João Marcos Bastos |
???metadata.dc.description.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. |
Abstract: | 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. |
Keywords: | Relational keyword search system Relational databases Database schema elements Query languages Keyword query |
???metadata.dc.subject.cnpq???: | CIÊNCIAS EXATAS E DA TERRA: CIÊNCIA DA COMPUTAÇÃO |
???metadata.dc.subject.user???: | Keyword Search Relational Databases Schema References Candidate Networks |
Language: | eng |
???metadata.dc.publisher.country???: | Brasil |
Publisher: | Universidade Federal do Amazonas |
???metadata.dc.publisher.initials???: | UFAM |
???metadata.dc.publisher.department???: | Instituto de Computação |
???metadata.dc.publisher.program???: | Programa de Pós-graduação em Informática |
Citation: | 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. |
???metadata.dc.rights???: | Acesso Aberto |
???metadata.dc.rights.uri???: | http://creativecommons.org/licenses/by-nc-sa/4.0/ |
URI: | https://tede.ufam.edu.br/handle/tede/7815 |
Issue Date: | 27-Mar-2020 |
Appears in Collections: | Mestrado em Informática |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
Dissertação_PauloRodrigo_PPGI.pdf | Dissertação_PauloRodrigo_PPGI | 1.89 MB | Adobe PDF | Download/Open Preview |
This item is licensed under a Creative Commons License