top of page
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

Next Item
Previous Item
bottom of page