Database Diagnostic Program for KPI Misconfiguration Detection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current performance analytics software applications face issues with data corruption, inefficiencies, and misconfigurations, leading to incorrect data presentation and resource exhaustion, which hinders effective visualization and management of key performance indicators (KPIs) in managed networks.
Innovation Solution
A diagnostic program is employed within the remote network management platform to execute pre-defined tests from a diagnostic database, checking consistency, configuration, and performance rules for KPIs and visualizations, and writing results to a diagnostic database for rapid identification and correction of misconfigurations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If scripts are used to collect KPI data, then data collection capability is improved, but data corruption and misconfiguration issues worsen
Solution Approach 1:
The patent implements diagnostic tests that are executed before KPI data collection to verify script correctness, database table existence, and configuration validity. This preliminary validation prevents corrupted or misconfigured scripts from collecting erroneous data, thereby maintaining both productivity and reliability.
Solution Approach 2:
The system continuously monitors KPI data collection processes and executes diagnostic tests to detect issues. When problems are detected through feedback from the diagnostic system, the platform can alert users and prevent further data corruption, maintaining data accuracy while preserving collection capability.
2Manufacturing precision
If diagnostic tests are executed to verify KPI and visualization consistency, then configuration accuracy is improved, but system complexity worsens
Solution Approach 1:
The diagnostic program serves multiple functions: it validates KPI configurations, checks visualization settings, verifies database table existence, and detects script errors. By consolidating these diverse diagnostic functions into a single multi-functional system, the patent improves configuration accuracy without proportionally increasing system complexity.
Solution Approach 2:
The network management platform performs self-diagnosis through automated diagnostic tests that verify its own configuration. This self-service approach allows the system to maintain high configuration accuracy through continuous validation without requiring external diagnostic tools or significantly increasing operational complexity.
3Adaptability or versatility
If database tables are modified or deleted over time, then adaptability is improved, but data integrity worsens
Solution Approach 1:
Before allowing database table modifications or deletions, the system executes diagnostic tests to verify that such changes will not compromise data integrity. This preliminary check ensures that adaptive modifications maintain reliability by preventing operations that would corrupt essential KPI data structures.
Solution Approach 2:
The diagnostic system continuously monitors database table integrity and alerts users when modifications or deletions threaten data integrity. This feedback mechanism allows the system to maintain adaptability for necessary changes while preventing integrity-compromising operations, thus resolving the contradiction between flexibility and reliability.
Data Source
AI summary
A system may include a performance analytics database defining key performance indicators (KPIs) associated with the managed network and defining dashboards that are configured to specify, on a performance analytics graphical user interface (GUI) within a managed network, graphical representations of the KPIs. The system may also include a diagnostic database containing representations of a plurality of tests configured to determine whether the KPIs and the dashboards comply with pre-defined rules. The system may also include a computing device operational to execute a diagnostic software program configured to: obtain a representation of a particular test that includes a plurality of rules; apply each of the rules to the KPIs and the dashboards stored in the performance analytics database; and write, when applying at least one of the rules indicates a problem, an associated severity, problem description, and solution description to the diagnostic database as output of the particular test.