Automated Database Configuration Correction System
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Manual checking of database configuration settings in enterprise systems like SAP is expensive and inefficient due to the large number of parameters and interdependencies, leading to potential security and quality risks, especially with varying security zones and frequent business requirement changes.
Innovation Solution
A dynamic and automatic method for identifying and correcting quality and security violations in database configurations by measuring and analyzing configuration parameters, generating correction instructions, and applying them to satellite systems within the database system, using a central server and pre-defined quality policies.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual checking of database configuration settings is performed, then configuration quality and security can be verified, but the process becomes expensive and inefficient due to the large number of parameters and interdependencies
Solution Approach 1:
The patent replaces manual mechanical checking processes with an automated computer-based system that uses software agents to systematically analyze configuration parameters, security zones, and interdependencies, thereby maintaining reliability while dramatically improving productivity
Solution Approach 2:
The system enables self-service configuration analysis by automatically detecting defects, generating correction instructions, and providing remediation guidance without requiring manual expert intervention for each configuration check
2Measurement precision
If the number of configuration parameters to be checked is increased to cover all security zones, then detection precision improves, but the complexity of the checking process increases
Solution Approach 1:
The patent segments the database system into multiple security zones with different security requirements, allowing the checking process to be divided into zone-specific analyses. This maintains high detection precision for each zone while reducing overall process complexity through modular, targeted checking
Solution Approach 2:
The system applies local quality by tailoring the checking process to each security zone's specific requirements, using appropriate analysis methods and criteria for each zone rather than applying a uniform complex process to all parameters
3Adaptability or versatility
If frequent analysis of configuration state is performed to adapt to changing business requirements, then adaptability improves, but the time and resources required for repeated checks increase
Solution Approach 1:
The patent implements periodic automated analysis of configuration state that can be scheduled according to business needs, allowing the system to adapt to changing requirements through repeated checks while minimizing time loss through efficient automated execution rather than manual processes
Data Source
AI summary
The present invention refers to a system, a method and product for automatically identifying quality defects in configuration parameters of a database system and for automatically correcting them according to predefined quality procedures. The method is executed on a central server (12) and on several satellite systems (10) as well. The method may be integral part of an enterprise resource planning system.