Pereira Pereira

Dr. Pereira Pereira


Research Focus & Metrics

Academic Career Length

3Years (2024-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
19 May 2025
Verified
Conference Paper
Open access
PDF file
BPBreno Carvalho Pedroso
Breno Carvalho Pedroso
PPPereira Pereira
Pereira Pereira
DPDenilson Alves Pereira
Denilson Alves Pereira
Context: The rising need for consulting data in industry and academic contexts has fueled Text-to-SQL development, where natural language queries are translated into SQL, making data access easier. Problem: Most research focuses on English Text-to-SQL, leaving Portuguese—a language spoken by over 260 million people— underrepresented, creating challenges for organizations reliant on accurate data retrieval in Portuguese. Solution: This study evaluates the effectiveness of various Large Language Models (LLMs) on Portuguese Text-to-SQL tasks using a validated translation of the Spider benchmark. IS Theory: This research applies Task-Technology Fit (TTF) Theory to assess how well LLMs meet the needs of Portuguese Text-to-SQL tasks. TTF evaluates the match between LLM capabilities and task requirements, including language understanding, schema recognition, and SQL generation. Proper alignment is key for effective data retrieval, particularly for Portuguese-language applications in organizational decisionmaking. Method: A comparative analysis of seven LLMs—tested on both Portuguese and English Spider benchmarks—was performed. Exact Match (EM) and Execution Accuracy (EX) metrics measured performance, and a zero-shot prompting approach maintained consistency. Results Summary: Larger LLMs and specialized code models excelled, showing less performance variance between Portuguese and English tasks. Generalist models, however, produced verbose outputs, which may limit practical use in production systems. Contributions and Impact on IS: This research establishes baseline Portuguese Text-to-SQL metrics and insights into language adaptability in LLMs, offering guidance for organizations seeking Portuguese-language data solutions. By bridging language gaps, it advances data-driven practices and fosters growth in Portuguese-speaking regions.

14 October 2024
Verified
Conference Paper
Open access
PDF file
JMJúlia M. P. Moreira
Júlia M. P. Moreira
RBRaphael W. Bettio
Raphael W. Bettio
AFAndré Pimenta Freire
André Pimenta Freire
LSLuciano M. Santos
Luciano M. Santos
PPPereira Pereira
Pereira Pereira
The constant progress of technology, especially in the area of health, brings numerous benefits, one of which is the increase in human life expectancy. However, problems that occur recurrently among the elderly age group are now on the radar of studies that also seek to improve the quality of life of these people. The number of cases of falls among elderly people is worrying, even more so as this is a portion of the population that tends to live alone. In the context of smart homes, several solutions have emerged for monitoring elderly people to increase safety and provide faster assistance, if necessary. One of these solutions is the use of wearable devices responsible for identifying the person’s movements. This work presents the study and development of a wearable device capable of detecting falls and, if they occur, automatically notifying the necessary people through alert messages via the Telegram application so that they can help the person who has suffered a fall. In this work, a Wi-Fi network, MQTT protocol, accelerometer and gyroscope inertial sensors and an ESP32 board programmed using the Arduino IDE were used. Preliminary tests indicated good performance in recognizing falls, based on tilt angle analysis, gyroscope readings and accelerometer readings. The proof of concept and preliminary tests carried out demonstrate the potential for using low-cost technologies for wearable resources for application in smart homes and monitoring the health of elderly people.

12 September 2025
Verified
Book Chapter
Closed access
PDF file
RARhaí André Arriel
Rhaí André Arriel
GOGabriel Moraes de Oliveira
Gabriel Moraes de Oliveira
MDMaurício Martins Damasceno
Maurício Martins Damasceno
MMMoacir Marocolo
Moacir Marocolo
AFAndré Pimenta Freire
André Pimenta Freire
PPPereira Pereira
Pereira Pereira

28 May 2025
Verified
Conference Paper
Open access
PDF file
EMElias J. Miranda
Elias J. Miranda
PPPereira Pereira
Pereira Pereira
Este trabalho apresenta uma abordagem para melhorar a eficiência energética de um cluster de baixo custo através do acionamento automático para ligar e desligar as máquinas. A infraestrutura do cluster utilizado para testar a solução inclui quatro máquinas com processadores Intel Celeron e rede cabeada, sistema operacional Alpine Linux e um microcontrolador ESP32 conectado à placa-mãe de cada nó. Um algoritmo Naive Bayes avalia a tendência das atividades de uso de CPU e memória em cada nó, permitindo ao ESP32 decidir ligar ou desligar nós do cluster, garantindo alta disponibilidade. Os resultados foram promissores para o conjunto de máquinas utilizado.

14 October 2024
Verified
Conference Paper
Open access
PDF file
FSFábio Ap. Cândido da Silva
Fábio Ap. Cândido da Silva
AFAndré Pimenta Freire
André Pimenta Freire
PPPereira Pereira
Pereira Pereira
The increasing demand for imaging tests has made radiology information systems crucial in medical practice, especially those based on web technology. These systems include Picture Archiving and Communication System (PACS), Radiology Information Systems (RIS), and Hospital Information System (HIS), generate and manipulate images through specialized software. To operate this complex software, require attention to detail and image manipulation techniques for accurate diagnoses. Usability issues in medical image manipulation software, given the process of adapting to new software and complex tasks, can result in inaccurate diagnoses with clinical impact. This is a qualitative study, which is based on the work routines of radiology professionals, focusing on issues of cognitive learning, interaction, and usability with radiology software. Moderate usability tests with radiology technicians were conducted to identify the difficulties and challenges they encounter while using medical image manipulation software. The analysis identified 64 problems grouped into 20 categories and organized under Visual Presentation, Content, Information Architecture, and Interactivity. The paper emphasizes violated heuristics and describes how these problem categories impact users in their medical activities and their influence on the clinical process. The obtained results provide insights to enhance usability practices and recommendations, aiming to support the development systems used in radiology practice.