Database Performance Degradation Detection via Anomaly Scoring
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database systems face performance degradation due to anomalous events, which existing technologies struggle to effectively identify and address, leading to potential component failures and user experience issues.
Innovation Solution
A system that monitors database system parameters, determines anomalous states, generates user experience assessments, identifies affected components, and adjusts system features to mitigate performance degradation by using a combination of monitoring, anomaly detection methods like S-H-ESD, and adaptive scoring to produce a user experience score and generate reports for remediation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If existing monitoring technologies are used to detect performance degradation, then system operation continues, but anomalous events are not effectively identified leading to component failures
Solution Approach 1:
The patent segments the monitoring approach by dividing database operations into discrete traceable events and separating anomaly detection into independent scoring components (anomaly score, severity score, user experience score) that can be evaluated independently and combined to identify performance degradation
Solution Approach 2:
The patent introduces intermediary scoring mechanisms that act as mediators between raw monitoring data and failure detection. Multiple scores (anomaly detection score, severity score, user experience score) serve as intermediate evaluation layers that transform complex monitoring data into actionable degradation identification
2Reliability
If comprehensive monitoring of all database parameters is implemented, then anomalous events can be detected, but system complexity and resource consumption increase
Solution Approach 1:
The patent applies local quality by focusing monitoring efforts on specific critical parameters and operations rather than uniformly monitoring all database components. The trace logging and scoring mechanisms concentrate computational resources on evaluating particular database operations that are most indicative of performance degradation
Solution Approach 2:
The patent transforms monitoring data through parameter changes by converting raw operational data into standardized scoring parameters (anomaly scores, severity scores). This transformation enables complex multi-parameter monitoring to be reduced to comparable score-based evaluations that simplify analysis while maintaining detection comprehensiveness
Data Source
AI summary
Among other things, embodiments of the present disclosure relate to detecting performance degradation in database systems. For example, some embodiments of the present disclosure help to identify events associated with anomalous database system parameter states and assess the severity of such anomalous events. Other embodiments may be described and/or claimed.