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.
bottom of page