Open POP
Next-generation LIS system construction project
Execution-based SQL standard check and automatic indexing through introduction of OpenPOP
In the next-generation LIS system (operator > Doosan), we are operating an early improvement system for inappropriate SQL through quality and performance inspection of SQL extracted from the development system, and we are resolving risks of performance degradation and failure issues by utilizing the Open-POP INDEX automatic design function through all SQL collected during the integrated test period, such as the tuning process for automatic selection of SQLs for performance improvement and performance optimization management through development SQL performance inspection, and the function to manage performance and history.
Building a stable system with various functions for improving SQL quality and performance
The solution
Index automatic design and optimization function
Execution-based SQL standard check
Analysis of the impact of SQL performance changes when objects are changed, etc.
Improvement process, performance, and history management for performance optimization management