Mainframe Database Parameter Update System
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional methods for updating parameters in relational database management systems are cumbersome, error-prone, and lack effective error detection and tracking, particularly in mainframe environments, increasing the risk of data corruption and cyber threats.
Innovation Solution
A parameter-updating system for mainframe relational database management software that includes a processor-controlled interface for user input, exception handling, and machine-readable program code to ensure syntactic compliance, generate change logs, and implement secure updates, utilizing features like wildcard searches and biometric verification.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If conventional parameter updating procedures are used, then database updates can be performed, but error detection and tracking capabilities are limited
Solution Approach 1:
The system performs preliminary actions by generating syntax validation rules and change log structures before the actual parameter update occurs. The exception handling framework is pre-configured with syntax rules that automatically validate incoming update requests, preventing errors before they corrupt the database.
Solution Approach 2:
The system implements feedback mechanisms through change logs that automatically record all parameter updates with timestamps, user identifiers, and syntax validation results. This creates a traceable feedback loop that enables error detection and tracking without adding manual complexity to the updating procedure.
2Reliability
If manual parameter updates are performed by database programmers, then updates can be implemented, but unintentional errors such as fat-fingering and incorrect insertions may occur
Solution Approach 1:
The system performs self-service through automatic syntax validation and exception handling. The exception handling framework automatically validates parameter syntax against predefined rules, detects errors, and prevents incorrect insertions without requiring manual review by database programmers, thereby maintaining data accuracy while preserving ease of operation.
Solution Approach 2:
The system replaces manual mechanical verification processes with automated electronic validation. The syntax validation rules and exception handling mechanisms automatically check parameter updates for correctness, substituting the need for careful manual entry and review with automated error prevention.
3Reliability
If conventional updating methods are used, then parameter updates can be performed, but the risk of intentional and unintentional corruption of database entries increases
Solution Approach 1:
The system implements preliminary protective actions by pre-configuring exception handling frameworks and syntax validation rules before updates occur. Change logs are pre-structured to capture validation results and update metadata, creating a defensive layer that prevents corruption without significantly increasing system complexity.
Solution Approach 2:
The exception handling framework acts as an intermediary between parameter update requests and the database. This intermediary layer validates syntax, detects exceptions, and controls the flow of updates, preventing corrupt data from reaching the database while maintaining a relatively simple updating interface.
4Difficulty of detecting and measuring
If conventional database management methods are used, then database operations can be performed, but the ability to detect, trace or track errors is limited
Solution Approach 1:
The system implements continuous feedback through change logs that automatically record all parameter updates with detailed metadata including timestamps, user identifiers, syntax validation results, and exception information. This automated feedback mechanism enables immediate error detection and efficient tracking without requiring manual monitoring, thereby improving detection capability while minimizing time loss.
Solution Approach 2:
The system performs preliminary structuring of change logs to include all necessary error detection and tracking information from the moment an update occurs. By pre-defining the log structure to capture validation results and update metadata, the system enables immediate error detection and efficient tracing without requiring subsequent manual analysis.
Data Source
AI summary
Systems, architecture and methods for updating parameters in relational database management software of a mainframe computing system is provided. Methods and apparatus are provided for streamlining the updating of the parameters. Methods and apparatus for reducing errors in the updating of the parameters are also provided, as well as for reducing risk of malicious corruption of data stored in an enterprise database. Also provided are methods and apparatus for detecting and/or tracking database parameter updates and/or errors.