Publication
Large language model for querying databases in Portuguese
| dc.contributor.author | Figueiredo, Lourenço | |
| dc.contributor.author | Pinheiro, Paulo | |
| dc.contributor.author | Cavique, Luís | |
| dc.contributor.author | Marques, Nuno | |
| dc.date.accessioned | 2025-10-14T10:56:04Z | |
| dc.date.available | 2025-10-14T10:56:04Z | |
| dc.date.issued | 2024 | |
| dc.description.abstract | This study introduces a system that helps non-expert users find information easily without knowing database languages or asking technicians for help. A specific domain is explored, focusing on a subscription-based sports facility, which serves as an open-source version of a real case study. Utilizing the star schema, the available data in the database is structured to provide accessibility through Portuguese Natural Language queries. Using a Large Language Model (LLM), SQL queries are generated based on the question and the provided star schema. We created a dataset with 115 highly challenging questions drawn from real-world usage scenarios to validate the correctness of the system. Challenges found during testing, like attribute value interpretation, out-of-scope questions, and temporal interval adequacy issues, highlight the insufficiency of the star schema alone in providing the needed context for generating accurate SQL queries by the LLM. Addressing these challenges through enhanced contextual information shows significant improvement in query correctness, with validation results increasing from 57.76% to 88.79%. This study shows the potential and limitations of LLMs in generating SQL queries from Portuguese Natural Language queries. | eng |
| dc.identifier.doi | 10.1007/978-3-031-73503-5_1 | |
| dc.identifier.uri | http://hdl.handle.net/10400.2/20360 | |
| dc.language.iso | eng | |
| dc.peerreviewed | yes | |
| dc.rights.uri | http://creativecommons.org/licenses/by/4.0/ | |
| dc.subject | Natural language processing | |
| dc.subject | Natural Language to SQL | |
| dc.subject | Large language model | |
| dc.subject | GPT-4 Turbo | |
| dc.subject | Sports facility management | |
| dc.subject | Databases | |
| dc.title | Large language model for querying databases in Portuguese | eng |
| dc.type | conference object | |
| dspace.entity.type | Publication | |
| oaire.citation.conferenceDate | 2024 | |
| oaire.citation.conferencePlace | Viana do Castelo | |
| oaire.citation.title | 23rd Conference on Artificial Intelligence. EPIA 2024. Progress in Artificial Intelligence | |
| oaire.version | http://purl.org/coar/version/c_970fb48d4fbd8a85 | |
| person.familyName | Figueiredo | |
| person.familyName | Pinheiro | |
| person.familyName | Cavique | |
| person.familyName | Marques | |
| person.givenName | Lourenço | |
| person.givenName | Paulo | |
| person.givenName | Luís | |
| person.givenName | Nuno | |
| person.identifier.ciencia-id | 061A-9AE9-D804 | |
| person.identifier.ciencia-id | 911E-84AC-3956 | |
| person.identifier.orcid | 0009-0009-6906-4495 | |
| person.identifier.orcid | 0000-0002-8912-2244 | |
| person.identifier.orcid | 0000-0002-5590-1493 | |
| person.identifier.orcid | 0000-0002-3019-3304 | |
| relation.isAuthorOfPublication | 7129e25b-7de7-41a0-8d79-498088e723ab | |
| relation.isAuthorOfPublication | d222d7a3-c125-4f1f-ab1b-ae2f97606f81 | |
| relation.isAuthorOfPublication | 40906a16-46a2-42f1-b26d-7db7012294ee | |
| relation.isAuthorOfPublication | 3133abcb-e445-4ae0-bacc-a69f6a524f48 | |
| relation.isAuthorOfPublication.latestForDiscovery | d222d7a3-c125-4f1f-ab1b-ae2f97606f81 |