Diseño de un sistema de gestión de cirugías hospitalarias utilizando Python y PostgreSQL
Loading...
Date
2026-04-05
Journal Title
Journal ISSN
Volume Title
Publisher
Universidad Tecnológica Centroamericana UNITEC
Abstract
La trazabilidad y viabilidad de la información quirúrgica son elementos fundamentales para una gestión hospitalaria eficiente y segura. En diversos hospitales públicos de Honduras, el proceso de programación, registro y seguimiento de cirugías actualmente se realiza con métodos manuales, lo que dificulta el acceso oportuno a datos relevantes, limita la coordinación entre los distintos departamentos y reduce la capacidad de respuesta ante situaciones de emergencia. La falta de integración hace que la eficiencia operativa y la toma de decisiones se vean comprometidas.
Ante dicha problemática, el presente proyecto de investigación tuvo como objetivo desarrollar y validar un sistema de gestión de quirófano como apoyo a la toma de decisiones, enfocado en fortalecer la trazabilidad y viabilidad de la información relacionada con el proceso quirúrgico. El sistema fue diseñado para integrar varios criterios, como la disponibilidad de quirófano, programación diaria, asignación de recursos y carga operativa, lo que ofrece una visualización detallada y clara, en tiempo real, del bloque quirúrgico.
Para evaluar la funcionalidad, se utilizaron datos reales del Hospital Nacional Mario Catarino Rivas (HNMCR) y se realizaron encuestas y entrevistas dirigidas al personal de salud y personal administrativo involucrado en la gestión de cirugías. Los resultados reflejaron una aceptación positiva del sistema desarrollado y resaltaron su funcionalidad al organizar de manera clara la información, reducir tiempos de espera y mejorar la coordinación entre áreas.
El personal encuestado destacó el beneficio de contar con funciones de visualización de disponibilidad de quirófanos y la trazabilidad de cirugías canceladas, mencionando que el sistema facilita la toma de decisiones y permite el seguimiento de información relevante. En comparación con los métodos manuales, el sistema reduce errores y la duplicidad de registros, lo que fortalece la transparencia operativa.
El sistema propuesto es una herramienta innovadora para el entorno hospitalario, ya que permite digitalizar procesos clave, garantizando la trazabilidad de las etapas quirúrgicas. Su implementación promueve una gestión eficiente y orientada a datos clave en el bloque quirúrgico, con potencial de escalabilidad en distintos contextos hospitalarios.
A system with data traceability and visibility of surgical information is essential for effective and safe hospital management. In diverse public hospitals in Honduras, surgical scheduling, documentation, and follow-ups are still conducted through manual methods or fragmented digital platforms. The lack of system integration limits access to critical data, interferes with coordination among departments, and reduces the ability to respond effectively to unforeseen situations, which affects operational efficiency and clinical decision-making. In order to address this issue, the objective of this study was to develop and validate a digital decision support system aimed at enhancing the traceability and visibility of the surgical process. The proposed system integrates key variables such as operating room availability, daily surgical schedules, procedural workload, and resource distribution, which provides a visualization of the operating room and surgery status. The system was tested by simulating data from Hospital Nacional Mario Catarino Rivas. Operational simulations, surveys, and interviews with medical, technical, and administrative staff were conducted to assess usability, functionality, and perceived value. The results demonstrated a positive acceptance of the developed system and highlighted its functionality in organizing information clearly, reducing waiting times, and improving coordination between departments. The surveyed personnel emphasized the benefits of having features such as the visualization of the availability of operating rooms and the traceability of canceled surgeries, noting that the system facilitates decision-making and enables the tracking of relevant information for the hospital. Compared to the manual methods currently used, the developed system reduces errors and duplicated records, thereby strengthening operational transparency. This tool represents an innovative approach for hospital environments, enabling the digitalization of surgical management processes and ensuring traceability. Its implementation encourages more efficient, transparent, and data-driven hospital operations, with potential scalability to similar healthcare settings across the country.
A system with data traceability and visibility of surgical information is essential for effective and safe hospital management. In diverse public hospitals in Honduras, surgical scheduling, documentation, and follow-ups are still conducted through manual methods or fragmented digital platforms. The lack of system integration limits access to critical data, interferes with coordination among departments, and reduces the ability to respond effectively to unforeseen situations, which affects operational efficiency and clinical decision-making. In order to address this issue, the objective of this study was to develop and validate a digital decision support system aimed at enhancing the traceability and visibility of the surgical process. The proposed system integrates key variables such as operating room availability, daily surgical schedules, procedural workload, and resource distribution, which provides a visualization of the operating room and surgery status. The system was tested by simulating data from Hospital Nacional Mario Catarino Rivas. Operational simulations, surveys, and interviews with medical, technical, and administrative staff were conducted to assess usability, functionality, and perceived value. The results demonstrated a positive acceptance of the developed system and highlighted its functionality in organizing information clearly, reducing waiting times, and improving coordination between departments. The surveyed personnel emphasized the benefits of having features such as the visualization of the availability of operating rooms and the traceability of canceled surgeries, noting that the system facilitates decision-making and enables the tracking of relevant information for the hospital. Compared to the manual methods currently used, the developed system reduces errors and duplicated records, thereby strengthening operational transparency. This tool represents an innovative approach for hospital environments, enabling the digitalization of surgical management processes and ensuring traceability. Its implementation encourages more efficient, transparent, and data-driven hospital operations, with potential scalability to similar healthcare settings across the country.
Keywords
Gestión de Quirófanos, ORMS, Sistemas Hospitalarios, Trazabilidad Quirúrgica