Custom Database Engine Validation in Shared Management Environments
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing managed database services restrict users from customizing database and operating system settings, requiring users to resort to self-hosting solutions that demand substantial expertise and resources, leading to increased system failure risks due to user errors.
Innovation Solution
A managed database service that automates administrative tasks and allows privileged access to the database and underlying OS, enabling users to install custom patches, unsupported database versions, and perform customizations while being monitored and validated to ensure a valid state.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If users are allowed to perform customizations and privileged access to database and OS settings, then adaptability and customization capability are improved, but system reliability and stability deteriorate due to increased risk of user errors
Solution Approach 1:
The patent introduces an automated validation service as an intermediary between the user and the database system. This service validates user customizations before applying them, ensuring that changes meet stability requirements while preserving user adaptability. The validation service acts as a mediator that filters out potentially harmful configurations while allowing beneficial customizations.
Solution Approach 2:
The system implements feedback mechanisms where the automated validation service provides information about the validity and potential impact of user customizations. This feedback loop allows users to understand the consequences of their changes and make informed decisions, while the system maintains stability by preventing invalid configurations from being applied.
2Reliability
If users are restricted from customizing database and operating system settings, then system reliability and stability are improved, but adaptability and user control deteriorate
Solution Approach 1:
The patent implements a dynamic approach where the level of customization allowed is not fixed but adapts based on validation results. The system can dynamically adjust what customizations are permitted depending on whether they pass validation checks, allowing flexibility while maintaining stability. This dynamic control mechanism resolves the contradiction by making restrictions conditional rather than absolute.
3Adaptability or versatility
If users resort to self-hosting solutions to perform customizations, then customization capability is improved, but device complexity and resource requirements worsen
Solution Approach 1:
The patent implements self-service through automated validation that users can access through the managed database service interface. Instead of requiring users to set up complex self-hosting infrastructure, the system provides self-service validation capabilities that work within the existing managed environment, reducing complexity while maintaining customization ability.
4Adaptability or versatility
If users resort to self-hosting solutions to perform customizations, then customization capability is improved, but system failure risks worsen due to user errors
Solution Approach 1:
The patent applies preliminary action by performing automated validation of user customizations before they are applied to the database system. This advance validation prevents erroneous configurations from reaching the production environment, thereby reducing failure risks while preserving user customization capabilities. The validation occurs in advance, catching potential issues before they cause system failures.
Data Source
AI summary
Techniques for building, validating, and utilizing custom database software in a shared management environment are described. A database customization service allows users to provide database installation files as part of a configuration to generate a custom database engine version. The creation of custom database engine versions may be governed by policy, and the database customization service may provide recommendations for creating custom database engine versions according to various criteria. The custom database engine version can be built, and its functionality and correctness verified. Users may launch database instances using these custom database engine versions that can be managed under a shared management scheme where both users and the database customization service can perform host-level management.


