Unified Database Cluster Configuration Model
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Configuring networked database clusters for high availability is complex and error-prone due to differences in cluster manager models and terminology, requiring a unified modeling system that specifies configurations independently of third-party cluster managers and supports easy version-to-version migrations.
Innovation Solution
A method and system generate a single logical model of a database cluster, using a unified model diagram to define hardware and software objects, which is then transformed into a format understandable by various cluster managers, allowing for visualization, editing, and deployment across multiple managers.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a unified modeling system is implemented to specify cluster configurations independently of third-party cluster managers, then ease of operation and usability are improved, but device complexity increases due to the need for transformation layers between the unified model and different cluster manager models
Solution Approach 1:
The patent introduces a unified configuration model as an intermediary layer between the user and different cluster manager tools. This intermediary model uses familiar hardware and database objects as abstraction layers, translating user specifications into cluster manager-specific configurations through transformation mechanisms, thereby improving ease of operation while managing complexity through standardized interfaces
Solution Approach 2:
The unified configuration model serves multiple functions by accommodating different cluster manager models (Oracle RAC, IBM Tivoli, Sun Cluster) within a single abstraction framework. It provides universal access to various cluster management systems using consistent terminology and object models, reducing the need for administrators to learn multiple different configuration paradigms
2Adaptability or versatility
If separate tools are used for hardware configuration and database configuration in tightly coupled systems, then adaptability to different cluster managers is improved, but ease of operation deteriorates due to fragmented configuration processes
Solution Approach 1:
The patent merges hardware configuration, software configuration, and database configuration into a single unified model. This integration allows administrators to specify all configuration parameters through one consistent interface rather than switching between separate tools, thereby improving ease of operation while maintaining adaptability through the model's ability to represent different cluster manager architectures
3Manufacturing precision
If detailed configuration specifications are provided for each cluster manager, then manufacturing precision of cluster configurations is improved, but loss of time increases due to the extensive data specification required
Solution Approach 1:
The unified configuration model creates a simplified copy or abstraction of the complex cluster manager configuration models. Instead of requiring administrators to specify detailed cluster manager-specific parameters, the system uses a simplified unified model that automatically transforms into the appropriate detailed configurations for each cluster manager, thereby reducing time to prepare configurations while maintaining precision through automated transformation
Data Source
AI summary
Generating in a computer system and deploying a data model of a plurality of database cluster configuration availability solutions over a computer network by creating a database cluster configuration modeling specification including objects contained in a unified model language diagram providing a definition of a database cluster configuration data model. Creating the database cluster configuration data model using the database cluster configuration modeling specification and upon receiving signals from a graphical user interface or from XML batch data files or from application programming interfaces, indicating the definition of the cluster configuration model. After creating the graphical database cluster configuration data model, constraints that specify a valid logical configuration are validated and the solution is transformed into data understandable by database cluster manager software applications and then transmitted over a network to multiple cluster manager targets to be incorporated as database cluster configuration availability solutions.