
Query Delta
Construction of U2L conversion of main computer system
Cloud deployment and U2L business performance improvement/tuning
In this project to replace Gwangju Bank's Unix-based core computing system with a Linux-based one in response to the increase in online transaction volume and the discontinuation of product sales and technical support from manufacturers, LGCNS adopted and applied OpenPOP Query Delta—which has been verified through use in projects such as Jeonbuk Bank's next-generation system, Suhyup Bank's DW enhancement, and Hana Bank's next-generation system—to prepare for and support various variables arising from changes in Gwangju Bank's accounting system operating platform and database operating environment. LGCNS is proactively checking, comparing, analyzing, and improving SQL performance changes, and providing support to ensure stable DB/SQL performance in the new database environment.
The solution
Selecting SQL change targets according to DB Version (19C) Upgrade
Full check of SQL execution errors in 19C environment
Support for SQL performance comparison verification and performance optimization in the current operating DB (11g) and new operating DB (19c) environments
Early performance verification of APP/SQL on new operating DB
SQL Performance Optimization Process and Performance/History Management