Sistema de gestión y análisis de redes de fibra óptica para la identificación de clientes y puntos críticos de la red.

Abstract

This paper addresses the design and implementation of a centralized system for the comprehensive management of clients in optical fiber networks, integrating the functionalities of geoespacial information systems (GIS) and a robust SQL-based database.The growing demand for high-quality telecommunications services has highlighted the need for advanced technological tools that enable efficient tracking of network infrastructure and precise, agile management of connected users.This challenge is intensified by the complexity of integrating different platforms and ensuring constant monitoring of network elements. The methodology adopted was based on a systematic approach that ranged from conceptualization and data structure modeling to the implementation of optimized SQL queries for extracting and analyzing detailed information about client connections, network elements, and failure points. Additionally, geospatial tools were integrated, enabling the graphical representation of the fiber optic network, allowing not only intuitive visualization but also data-driven decision-making. The results revealed that the system is able to perform real-time mapping of connections between nodes, optical splitters, and clients, improving supervision and maintenance, and optimizing operational management. It also facilitates strategic planning by identifying critical areas and expansion opportunities. In summary, this study underscores the importance of integrating advanced technologies and scalable databases in telecommunications network monitoring, constituting a significant contribution to the field of modern telecommunications. As a recommendation for future developments, the implementation of web applications is suggested to allow end-users to enter, query, and manage data, as well as to extend the system's interoperability with different areas of an organization to maximize its utility and strategic reach. Keywords: Fiber Optics, System, Geoprocessing, GIS, SQL