
Open POP
Establishment of DB performance/quality management system
Establishing an operational DB failure prevention system
Daishin Securities is conducting DB failure prevention activities by utilizing Openpop's dashboard to automatically identify and manage performance changes for important SQL and new SQL, as well as check daily DB status and real-time detection/action for plan change SQL for failure prevention activities for operational DB. In addition, it is operating a proactive DB failure prevention activity system by actively utilizing functions such as periodic comprehensive DB diagnosis and SQL quality inspection.
Developers can also use OpenPop to check the quality and performance of their development SQL on their own.
We are actively utilizing OpenPOP to prevent performance problems by improving the quality of SQL.
We are operating with a gradual plan to expand the various functions of OpenPop.
The solution
Dashboard operation for DB failure prevention
Analysis of important SQL performance changes
DB operation status diagnosis
Comprehensive diagnostics of SQL execution performance and quality
Development SQL quality and performance checks
Analysis of SQL performance change impact, etc.