top of page
Open POP

Building the next generation i-LIS (integrated system)

Advanced inspection system, automatic index design

In order to build a new integrated inspection system, OpenPOP was introduced a month before the opening due to performance issues, and the risk of performance degradation and failure issues was resolved through automatic index design work for all tables in a short period of time. After the opening, the SQL PLAN was changed and a pre-inspection function for new SQL was implemented to provide early warning of service delays and take automatic measures before they lead to failures.

The solution
  • Index automatic design and optimization function

  • PLAN CHANGE REAL TIME ALERT

  • Malicious New SQL Real-Time ALERT

  • Analysis of the impact of SQL performance changes when objects are changed, etc.

Next Item
Previous Item
bottom of page