Query Delta
Improvement of the compensation system
Replacement of aging equipment and software upgrade of the insurance system
This is a hardware replacement and software upgrade project due to the aging of the operating resources of the mutual aid system, which is an important task of the National Credit Union Federation. It is a hardware replacement, data transfer, Oracle DBMS (11g → 19c) upgrade, and software upgrade project for a system that has been used stably for many years.
The solution
In this project, OpenPOP Query Delta successfully completed the project by having the client directly verify and implement the solution.
OpenPOP Query Delta supported the successful execution of Oracle DBMS Upgrade operations and DB stabilization by automatically analyzing the impact of SQL performance changes and facilitating rapid performance stabilization through early optimization of SQL expected to degrade due to plan changes.