Open POP
Building next-generation systems
Next-generation project execution-based development SQL quality and performance check
In the ongoing next-generation project (executor > LG CNS),
We are operating an early improvement system for SQL with poor quality through real-time quality checks on development SQL.
We are utilizing various functions required for development, such as performance check of development SQL, automatic index design through SQL analysis, automatic selection of SQL to be improved on, tuning process for performance optimization management, and functions to manage performance and history.
The solution
Development SQL quality check and status management
Development SQL Performance Check
Automatically extract target SQL for 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.
Batch verification of SQL performance for transfer of operations