Advanced search options

Advanced Search Options 🞨

Browse by author name (“Author name starts with…”).

Find ETDs with:

in
/  
in
/  
in
/  
in

Written in Published in Earliest date Latest date

Sorted by

Results per page:

You searched for subject:(Schema References). One record found.

Search Limiters

Last 2 Years | English Only

No search limiters apply to these results.

▼ Search Limiters

1. Martins, Paulo Rodrigo Oliveira. Supporting Schema References in Keyword Queries over Relational Databases.

Degree: 2020, Universidade Federal do Amazonas

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.

Advisors/Committee Members: 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.

Subjects/Keywords: 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

Record DetailsSimilar RecordsGoogle PlusoneFacebookTwitterCiteULikeMendeleyreddit

APA · Chicago · MLA · Vancouver · CSE | Export to Zotero / EndNote / Reference Manager

APA (6th Edition):

Martins, P. R. O. (2020). Supporting Schema References in Keyword Queries over Relational Databases. (Masters Thesis). Universidade Federal do Amazonas. Retrieved from https://tede.ufam.edu.br/handle/tede/7815

Chicago Manual of Style (16th Edition):

Martins, Paulo Rodrigo Oliveira. “Supporting Schema References in Keyword Queries over Relational Databases.” 2020. Masters Thesis, Universidade Federal do Amazonas. Accessed November 28, 2020. https://tede.ufam.edu.br/handle/tede/7815.

MLA Handbook (7th Edition):

Martins, Paulo Rodrigo Oliveira. “Supporting Schema References in Keyword Queries over Relational Databases.” 2020. Web. 28 Nov 2020.

Vancouver:

Martins PRO. Supporting Schema References in Keyword Queries over Relational Databases. [Internet] [Masters thesis]. Universidade Federal do Amazonas; 2020. [cited 2020 Nov 28]. Available from: https://tede.ufam.edu.br/handle/tede/7815.

Council of Science Editors:

Martins PRO. Supporting Schema References in Keyword Queries over Relational Databases. [Masters Thesis]. Universidade Federal do Amazonas; 2020. Available from: https://tede.ufam.edu.br/handle/tede/7815

.