Optimisation of the OTCM Application through Cloud Database Migration and Refactoring
Che, Tamanji (2024)
2024
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2024052315180
https://urn.fi/URN:NBN:fi:amk-2024052315180
Tiivistelmä
This thesis aimed to enhance the performance of the Operational Technology Condition Monitoring (OTCM) application through strategic cloud database migration and refactoring. It was carried out for the case company, Siemens Oy. The OTCM application, integral for monitoring industrial devices across various sites, experienced significant performance problems, particularly unresponsiveness in the user interface and latency issues with an external API. These limitations necessitated migrating from the existing external database to a more scalable internally managed PostgreSQL cloud database.
The methodology encompassed a comprehensive analysis of the existing system, identification of performance bottlenecks through performance testing tools such as Locust and Chrome DevTools, and subsequent database migration and source code refactoring. The new system architecture aimed to enhance data processing speeds, reduce latency, and improve overall application responsiveness and user experience.
The results indicated a significant improvement in performance metrics such as response time and system throughput. The successful migration and refactoring not only optimised the OTCM application but also enhanced the maintainability and scalability of the application, ensuring the reliable monitoring of operational technology devices.
This study demonstrates the effectiveness of cloud database migration and application refactoring in resolving performance issues, laying the groundwork for future improvements in similar industrial applications.
The methodology encompassed a comprehensive analysis of the existing system, identification of performance bottlenecks through performance testing tools such as Locust and Chrome DevTools, and subsequent database migration and source code refactoring. The new system architecture aimed to enhance data processing speeds, reduce latency, and improve overall application responsiveness and user experience.
The results indicated a significant improvement in performance metrics such as response time and system throughput. The successful migration and refactoring not only optimised the OTCM application but also enhanced the maintainability and scalability of the application, ensuring the reliable monitoring of operational technology devices.
This study demonstrates the effectiveness of cloud database migration and application refactoring in resolving performance issues, laying the groundwork for future improvements in similar industrial applications.