Open POP, SPS
Infrastructure advancement (Life One System)
SQL quality check and performance verification & optimization for building KB Life integrated system
In the integrated system construction project for the merger of Prudential Life Insurance & KB Life Insurance, the quality and performance of the SQL developed based on the shape are being checked, and in the integrated system construction project currently in progress, the early improvement system for inappropriate SQL is being operated through the quality and performance check of the developed SQL extracted from the distribution and shape management system. Through the performance check of the developed SQL, a stable system is being built through various functions for improving the quality and performance of SQL, such as the tuning process for automatic selection of target SQL for performance improvement and performance optimization management, and the function to manage the performance and history.
The solution
Development SQL quality check and status management
Automatically extract target SQL for development SQL performance check and performance improvement
Improvement process, performance, and history management for performance optimization management
Index automatic design and optimization function
Analysis of the impact of SQL performance changes when objects are changed, etc.