Ingeniería en Sistemas, Electrónica e Industrial

URI permanente para esta comunidadhttp://repositorio.uta.edu.ec/handle/123456789/1

Examinar

Filtros

2009 - 200912020 - 20266

Ajustes

Tipo de acceso: Acceso abiertoTema: search.filters.subject.POSTGRESQL

Resultados de la búsqueda

Mostrando 1 - 7 de 7
  • Miniatura
    Item type:Ítem,
    Sistema para el registro y control de procesos de abastecimiento en Ciauto
    (Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Software, 2026-07-03)
    Lizano Muñoz, Alex Santiago
    ;
    Chicaiza Castillo, Dennis Vinicio
    ;
    Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas Electrónica e Industrial. Carrera de Software
    This project proposes the development of a system for the registration and control of processes at CIAUTO Cía. Ltda. The need arose from difficulties identified at the supply station, responsible for unloading and assigning vehicle lots, where the use of physical records and manual transcription of information resulted in duplication of tasks, an excessive administrative burden, and risks associated with data dispersion, hindering the availability and traceability of information. The methodology combined applied and field research, adopting a qualitative approach through interviews and a quantitative approach through a staff survey for subsequent analysis. BPMN diagrams and risk matrices were also used to diagnose and model processes. To address this problem, the technological solution was built using a stack composed of PostgreSQL, ASP.NET Core, and Angular, based on the principles of Clean Architecture and the CQRS pattern. The system centralized information, digitized activity logs, and automated form generation. It included a control panel for viewing key indicators such as container status, opening progress, tracking of new developments, supply progress, and operator performance, thus optimizing decision-making. As a result, the system’s implementation reduced processing times by 57,04 percent in operations and 83,1 percent in administration compared to the manual model, achieving a reduction in human error and unnecessary administrative burden.
  • Miniatura
    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 Homero
    ;
    Universidad 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.
  • Miniatura
    Item type:Ítem,
    Aplicación multiplataforma para la gestión de fichas clínicas y el monitoreo de la evolución de la agudeza visual en Óptica Sudamericana
    (2025-08)
    Naranjo López Anahí de los Ángeles
    ;
    Carrillo Ríos Sandra Lucrecia
    ;
    Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Software
    Clinical records are essential documents for clinical follow-up and checking the positive or negative evolution of applied treatments. In the visual health sector, is crucial to keep a comprehensive and complete historical record to figure out whether each prescription for corrective lenses is functional, effective, and delays the expected deterioration of visual acuity. This research focuses on the development and implementation of a cross-platform application for managing clinical records and monitoring visual evolution at Óptica Sudamericana, which was designed to access and record consultation from any digital environment, thereby improving the quality of patient care both inside and outside the optical practice. The application, developed in Flutter, due to its cross-platform performance, and supported by APIs built with Python through the FastAPI framework, allows for the merged and secure registration, consultation, and updating of each patient’s information. Furthermore, PostgreSQL was chosen as the database engine for its open-source nature and robustness. Rapid Application Development (RAD) methodology was adopted due to its iterative, adaptable, and user-centric approach. Finally, the result was an application that ensures data integrity, adapts to the specific needs of the visual health sector, and eases access in any digital environment. This empowers optometrist to improve the quality of services for patients, promoting more precise and prompt care.
  • Miniatura
    Item type:Ítem,
    Aplicación web progresiva para la automatización de procesos de catequesis en la parroquia Juan Montalvo
    (2025-08)
    Guevara Bayas Fernando Vinicio
    ;
    Chicaiza Castillo Dennis Vinicio
    ;
    Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Software
    Many parishes still face challenges in efficiently managing catechetical processes due to the use of manual methods, resulting in delays in information access and hindering pastoral organization. This project aimed to implement a digital system based on Progressive Web App (PWA) architecture for the Montalvo Parish in Ambato canton, with the goal of optimizing the administration and monitoring of catechesis. The research followed an applied approach and was developed using the agile methodology Extreme Programming (XP), with data gathered through semi-structured interviews and direct observation of existing processes. The system was built using modern technologies such as React and Next.js for the frontend, Node.js with Express for the backend, and Supabase with PostgreSQL as the database system. As a result, information related to catechists, students, and sacramental processes was centralized, enabling real-time access, improved attendance tracking, meeting scheduling, and automated report generation. The implementation of the system proved to be an effective solution to strengthen the parish's organizational management, streamline administrative tasks, and support informed decision-making by catechetical coordinators.
  • Miniatura
    Item type:Ítem,
    Implementación de un sistema web para mejorar la eficiencia en los procesos operativos en la cafetería Kafos
    (2025-07)
    Brito Hallo Rafael Alejandro
    ;
    Ibarra Torres Oscar Fernando
    ;
    Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Software
    Manual order and inventory management continues to undermine the competitiveness of small food-service businesses. Statista (2024) reports that 74% of fast-food outlets in Latin America still record sales on paper forms, lengthening service times and causing stock-outs that erode profit. This study addresses that gap at Kafos, a specialty coffee shop whose notebooks and spreadsheets impeded accurate stock control and customer tracking. The project designed and deployed an integrated web system that optimises sales, inventory and loyalty while requiring only low-cost infrastructure. An MVC stack—Laravel, Vue 3 and PostgreSQL—was containerised with Docker for local deployment. Development followed a Kanban workflow, iterating on a minimum viable product comprising four modules: orders, inventory, finance and a points-based loyalty programme. After two months of uninterrupted use the shop recorded clear gains: order turnaround times fell markedly, stock-related cancellations became rare events, and the share of customers who returned within the same month almost doubled. Automated birthday greetings also encouraged most recipients to visit again. The solution demonstrably raises daily efficiency and strengthens customer relationships, offering a replicable path for micro-enterprises seeking digital transformation on a limited budget.
  • Miniatura
    Item type:Ítem,
    Implantación de una aplicación web para la gestión de información académica de estudiantes de la Unidad Educativa Fiscomisional PCEI Tungurahua
    (2025-02)
    Ojeda Carrasco José Luis
    ;
    Ibarra Torres Oscar Fernando
    ;
    Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera de Software
    In Ecuador, the educational sector faces significant challenges in academic and administrative management due to the reliance on manual processes and limited IT tools. These issues directly impact operational efficiency and the experience of students, teachers, and administrative staff. During the 2023-2024 period, the Unidad Educativa Fiscomisional PCEI Tungurahua experienced these difficulties, particularly in managing grades, enrollment processes, and academic reports. This project focuses on the implementation and deployment of a web system named ACADEXUS, designed to optimize academic and administrative management within the institution. This system enables the decentralization of key tasks, such as grade entry by teachers, and the automation of critical processes, including report generation and academic year promotion. The main features include user management, grade management, academic periods, and enrollment processes, as well as a scalable module that allows for future expansions. The system was developed using a layered architecture with Next.js in the frontend and PostgreSQL as the database manager. The Kanban development methodology was applied, enabling rapid and adaptive iterations to facilitate the continuous delivery of functionalities. Additionally, a thorough usability analysis was conducted using the SUS scale, achieving a score above 75, validating the system's effectiveness from the users' perspective. This project represents a significant step toward modernizing educational management in the institution, contributing to the digital transformation of the educational sector
  • Miniatura
    Item type:Ítem,
    Desarrolo de un sistema de rentas para agilitar los trámites de alcabalas, plusvalías, rodajes, títulos de mercados, multas y derechos de instalación de agua potable en el Ilustre Municipio del Cantón Quero.
    (Universidad Técnica de Ambato. Facultad de Ingeniería en Sistemas, Electrónica e Industrial. Carrera Ingeniería en Sistemas Informáticos y Computacionales, 2009)
    Sánchez Villacrés, Jorge Augusto
    ;
    Aldás Flores, Clay Fernando
    El I. Municipio del Cantón Quero, al no poseer ningún tipo de automatización en sus procesos de manejo de trámites y atención a sus usuarios, ha venido realizando un manejo de manera manual con todos los problemas que esto conlleva. Es por eso que el presente proyecto tiene como objetivo solucionar tales problemas mediante el desarrollo de un sistema que automatice el manejo de trámites de alcabalas, plusvalías, rodajes, títulos de mercados, multas y derechos de instalación de agua potable. Para llevar a cabo el desarrollo de dicho sistema, primeramente se procedió a estudiar cuál era la situación actual en los departamentos de Avalúos y Catastros, Rentas y Tesorería. Entonces se determinó los requerimientos del sistema. Se realizó el análisis del sistema, de sus factibilidades, requerimientos y alcance, para luego comenzar con el proceso de diseño. Posteriormente se procedió al desarrollo del sistema y realización de pruebas. Finalmente el sistema se puso en funcionamiento. Cabe mencionar que el software que se utilizó en el desarrollo de la aplicación así como el motor de base de datos son software libre que no requiere el pago de ninguna licencia. Esto es muy positivo para la institución ya que puede hacer uso de un software de calidad sin costo alguno. El sistema funciona de manera correcta y cumple con los objetivos propuestos: mantener la información íntegra y disponible, facilitar el trabajo al personal y mejorar la atención a los usuarios del cantón.