Open POP
Collection integration/elderly care
Prevent operational DB failures through preemptive DB inspection and diagnosis
The National Health Insurance Corporation is actively utilizing OpenPop's daily DB inspection, periodic comprehensive DB diagnosis, and SQL quality inspection functions to prevent failures of approximately 90 Oracle DBs in operation (Ssangyong Information & Communications).
We are operating a proactive DB failure prevention activity system.
The solution
Operation DB daily check dashboard operation
Action function(s) based on operational DB inspection results
Operation DB Comprehensive Diagnosis (DB Operation Status)
Comprehensive diagnostics of SQL performance in execution
Automatically extract SQL target for performance degradation tuning
Check and extract SQL that is expected to cause failure