Ingeniería en Sistemas, Electrónica e Industrial
URI permanente para esta comunidadhttp://repositorio.uta.edu.ec/handle/123456789/1
Examinar
5 resultados
Resultados de la búsqueda
Item type:Ítem, Api restful para la gestión del mantenimiento predictivo de bombas hidráulicas en la producción de crudo(2026-01) ;Villacrés Espin Jaime Marcelo ;Álvarez Mayorga Edison HomeroUniversidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Tecnologías de la InformaciónThis project addresses the need to improve the maintenance management of hydraulic pumps in crude oil production, where operational and maintenance data are scattered across Excel files, isolated reports, and external platforms such as ABB, hindering historical analysis and decision-making. As a solution, a RESTful API tailored to maintenance requirements is designed and implemented, conceived as the backbone of an AI-based predictive maintenance system within the Technical University of Ambato. The methodology is structured in three phases: first, an analysis of the current data logging and usage process, identifying limitations in traceability, access, and the link between operating conditions and maintenance events; second, the design of the API's components, functions, and data model, defining functional and non-functional requirements, as well as key entities such as ingestions, raw measurements, clean measurements with preprocessing indicators, and characteristics; and third, implementation using FastAPI and PostgreSQL, integrating sources such as MQTT and OPC UA, and validating the system with real data exported from ABB. The results show a significant improvement in data centralization, quality, and availability, as well as optimized endpoints for bulk uploads and trend, dispersion, and histogram analytics modules with filters for quality, time, and variable. It is concluded that the developed API meets the stated objectives and provides a solid foundation for integration with predictive maintenance models in real-world industrial environments.Item type:Ítem, Sistema de preprocesamiento de datos sensoriales utilizando Python en la gestión de mantenimiento predictivo de bombas hidraúlicas en la producción de crudo(2026-01) ;Rea Ramírez Carmen Alexandra ;Álvarez Mayorga Edison HomeroUniversidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Tecnologías de la InformaciónPredictive maintenance management in the oil industry heavily depends on the quality, consistency, and reliability of sensor data, which often appear as raw streams with temporal irregularities, information loss, and uncontrolled variations that hinder analysis. To address this challenge, the purpose of this work was to implement a sensor data preprocessing system using Python to support predictive maintenance of hydraulic pumps in crude oil production. The CRISP-DM methodology was adopted, structuring the process from problem understanding to the final preparation of data for integration into predictive models. The developed system comprises three main phases: quality diagnosis and labeling, temporal reconstruction with controlled imputation, and statistical feature generation. Each phase produces and stores its results in independent tables, ensuring traceability and organized use of information. As a result, the system significantly improved the quality and usefulness of sensor data. The impact of data quality was demonstrated by training two models on the Phase 1 dataset, where Logistic Regression achieved an accuracy of 34.92%, showing its limited ability to handle noise, outliers, and temporal variability, while Random Forest reached 99.57%, confirming that higher data quality directly influences model learning and performance. The final system is available for use by the research team and for future extension in subsequent work.Item type:Ítem, Base de datos Time-Series para la gestión de datos sensoriales en el mantenimiento predictivo de equipos de bombeo hidráulico en la producción de crudo.(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Tecnologías de la Información., 2026-01) ;Alomaliza LLamuca, Steven Xavier ;Álvarez Mayorga, Edison HomeroUniversidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Tecnologías de la Información.Industrial monitoring systems create large amounts of sensor data with precise timestamps, high frequency, and the need to store information for a long time. This project presents a Time Series Database (TSDB) architecture using PostgreSQL and the TimescaleDB extension to store, process, and analyze data from ABB sensors installed in hydraulic pumping motors. These sensors collect 22 mechanical, thermal, and electrical variables every 15 minutes, producing more than 64,000 records per month. The proposed model separates raw data using the raw and iot schemas, which helps with efficient ingestion, normalization, and organization of sensor information. TimescaleDB hypertables offer automatic partitioning and optimized indexing, allowing fast queries even on large historical datasets. Compression policies, retention rules, and duplication control reduce storage costs. The extraction, transformation, and loading (ETL) pipeline created in this project automates timestamp normalization, variable cataloging, and incremental loading. It ensures that each measurement is stored only once and validated correctly. The results show that a time series database is a scalable and reliable solution for managing industrial sensor data, providing query responses in milliseconds.Item type:Ítem, Sistema Iot con análisis predictivo para el monitoreo de la salud de sistemas de bombeo de campos petroleros(2026) ;Bonilla Bonilla Erick Bladimir ;Ayala Baño Elizabeth PaulinaUniversidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de TelecomunicacionesThe operation of electric submersible pumps (ESPs) in oil fields is impacted by failures, downtime, and the limited use of digital tools for condition monitoring. To address this challenge, an IoT system with predictive analytics was developed to monitor the health of ESPs, with the aim of supporting maintenance decision-making and reducing the occurrence of critical failures in continuous production environments. To develop the solution, the CRISP-DM methodology was applied, defining a predictive analytics workflow based on historical data. In this stage, operational records were integrated, structured, and refined using electrical, hydraulic, mechanical, and thermal variables, and a preprocessing pipeline was implemented—including validation, cleaning, and feature transformation—to ensure data consistency and quality. On this basis, a multi-label dataset with five classification targets was built, enabling the joint execution of diagnostic and prognostic tasks. Subsequently, ensemble models based on decision trees were compared, and a multi-label Random Forest approach was adopted due to its balance of performance, robustness, and generalization capability across multiple classes and operational variability. During controlled-environment testing, the system achieved an approximate overall weighted precision of 85%, with per-label accuracies of 82% for failure variable, 83% for subcomponent, 82% for severity, 83% for pump state, and 91% for 24-hour failure prediction. Finally, deployment was carried out using Docker, a FastAPI inference service, InfluxDB, and Grafana dashboards, enabling visualization of process variables and estimated operating status, and demonstrating the technical feasibility of the proposed solution for predictive maintenance.Item type:Ítem, Revisión sistemática de metodologías de mantenimiento de oleoductos basadas en Industria 4.0(Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Maestría en Producción y Operaciones Industriales, 2022) ;López Vargas, Nancy FabiolaGarcía Sánchez, Marcelo VladimirThe fourth industrial revolution was a milestone at the industrial level. It forced most industries to evolve technically and for their collaborators to prepare and advance together with technology; the oil industry was no exception. It develops its activities in dangerous and dynamic environments and needs to protect its human resources, equipment and infrastructure. This article presents a scoping review, based on the PRISMA guidelines, of pipeline maintenance methodologies based on industry 4.0. From the first collection of 123 articles from prestigious databases such as SpringerLink, MDPI, Scopus, IEEEXplore and ACM, a final sample of 31 articles was obtained. Here, technologies that enhance preventive and predictive maintenance systems are discussed. The results show that predictive maintenance compared to preventive maintenance has a percentage difference in upkeep time optimization of 38% in the last five years. This difference was corroborated with a T-Student for independent samples, with a significance of 0.023. Likewise, the most used technologies were analyzed, with artificial intelligence standing out with 45.16%.
