Self-Healing Service for Data Analytics Systems

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Data analytics systems experience performance degradation due to increased workload, leading to deteriorating response times and resource insufficiency, which is often addressed by adding resources after performance issues arise, resulting in delayed resolution.

Innovation Solution

Implement a self-healing mechanism that monitors server performance using threshold scores based on metrics like report size, request rate, and CPU cores, automatically adjusts parameters, and notifies administrators of consecutive performance violations to proactively alleviate degradation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If additional servers are added to the data analytics system, then system capacity and performance are improved, but response time deteriorates during the implementation period and resource costs increase

Engineering Contradiction:
Improvesystem capacityVSAvoidresponse time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system performs preliminary actions by continuously monitoring server performance metrics and detecting performance degradation trends before they critically impact user experience. The self-healing service proactively identifies when servers are approaching capacity limits and triggers automated responses (such as load balancing adjustments or resource allocation changes) to prevent performance collapse, thereby maintaining response time while avoiding the need for immediate server addition that would cause implementation delays

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The data analytics system implements self-service through automated performance monitoring and self-healing mechanisms. The system autonomously detects performance degradation, analyzes root causes, and executes corrective actions without manual intervention. This self-service capability allows the system to maintain optimal performance and capacity utilization dynamically, preventing the need for reactive server additions that would temporarily worsen response time during deployment

Inventive Principle:
Principle #25Self-service

2Reliability

If resources are added after performance issues arise, then system performance is restored, but the resolution is delayed and user experience deteriorates

Engineering Contradiction:
Improvesystem performanceVSAvoidresolution time
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system implements continuous feedback loops by monitoring server performance metrics (CPU utilization, memory usage, response time, throughput) in real-time. When performance degradation is detected, the feedback mechanism triggers automated diagnostic and corrective actions. This closed-loop feedback system enables the system to maintain performance within acceptable thresholds continuously, preventing the accumulation of performance issues that would require delayed resource addition and subsequent user experience deterioration

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The self-healing service performs preliminary diagnostic and corrective actions before performance issues significantly impact users. By continuously analyzing performance trends and predicting potential failures, the system proactively adjusts resource allocation, redistributes workloads, or scales components to prevent performance collapse, thereby maintaining restored performance levels without requiring delayed reactive resource addition

Inventive Principle:
Principle #10Preliminary action

3Reliability

If manual resource addition is implemented, then system capacity increases, but automation level decreases and operational complexity increases

Engineering Contradiction:
Improvesystem capacityVSAvoidmanual intervention level
Core Design Contradiction:
ReliabilityVSExtent of automation

Solution Approach 1:

The system achieves self-service through automated performance monitoring, analysis, and self-healing capabilities. The self-healing service autonomously detects performance degradation, diagnoses root causes, and executes corrective actions including resource allocation adjustments and load balancing modifications without manual intervention. This automation maintains system capacity and performance while eliminating the need for manual resource addition, thereby increasing the extent of automation rather than decreasing it

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The automated feedback mechanism continuously monitors system performance and triggers appropriate responses based on predefined thresholds and policies. When performance degradation is detected, the feedback loop automatically initiates diagnostic procedures and executes corrective actions, maintaining system capacity without requiring manual intervention. This feedback-driven automation increases the extent of automation while managing operational complexity through standardized, rule-based responses

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS10684933B2Smart self-healing service for data analytics systems
Publication Date: 2020.06.16 SAP SE
  • US10684933B2 patent drawing
  • US10684933B2 patent drawing
  • US10684933B2 patent drawing

AI summary

Methods, systems, and computer-readable storage media for automatically detecting potential performance degradation in a data analytics system including multiple servers, actions include determining a threshold performance score for each server of the multiple servers during an initial period, the threshold performance scores being determined at least partially based on a report generated by a respective server, and, after the initial period, and for each server: intermittently calculating a performance score, comparing the performance score to the threshold performance score to determine whether a violation indicating performance degradation occurs, and transmitting a notification to report consecutive violations.