Automatização de operações de registros de banco de dados em equipamentos do setor de telecomunicações

Saved in:
Bibliografiske detaljer
Hovedforfatter: Giaretta, Jean Francisco
Publication Date: 2024
Format: Bachelor thesis
Sprog: por
Source: Repositório Institucional da UPF
Download full: https://repositorio.upf.br/handle/123456789/7500
Summary: This article presents the development of an automated script for massive insertion and deletion of records of damaged equipment in an Oracle database, applied to the telecommunications sector. The solution, developed in Python using SQLPlus, aims to optimize the management of large volumes of data, ensuring integrity, consistency, and scalability of operations. The tests conducted demonstrated a reduction of up to 99.67% in execution time compared to the manual method for volumes of up to 10,000 records. In addition to increasing operational efficiency, the script significantly reduces the likelihood of human errors and ensures high-quality data processing, providing a robust and adaptable solution to the growing demand for real-time data management in telecommunications networks.