Hybrid Storage Configuration via Priority Matching
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In a hybrid storage environment, manual configuration of storage devices by database administrators is prone to security risks, requires high skill levels, and is inefficient, especially when managing multiple database objects across various servers and operating systems, leading to increased maintenance costs and energy consumption.
Innovation Solution
A method and system that automatically configure storage devices by acquiring attribute parameters, calculating priorities, and matching data objects with suitable storage devices, reducing the need for manual intervention and standardizing configuration across different systems.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If manual configuration of storage devices is performed by database administrators, then configuration can be customized according to specific needs, but security risks increase and requires high skill levels
Solution Approach 1:
The system performs self-configuration of storage devices automatically without requiring manual intervention from database administrators. The configuration management module autonomously discovers storage devices, evaluates their attributes, and assigns them to appropriate databases based on predefined policies, thereby eliminating security risks associated with manual configuration while maintaining adaptability through policy-based customization
Solution Approach 2:
A configuration management module is introduced as an intermediary between database administrators and storage devices. This module receives high-level configuration requirements from administrators, translates them into detailed storage assignments, and executes the configuration automatically, thereby reducing security risks while preserving the ability to customize configurations according to specific needs
2Adaptability or versatility
If manual configuration of storage devices is performed, then specific storage needs can be addressed, but maintenance costs increase and energy consumption rises
Solution Approach 1:
The system automatically performs storage device configuration, discovery, and assignment without requiring manual maintenance interventions. The configuration management module continuously monitors storage resources and dynamically adjusts assignments based on changing conditions, thereby reducing maintenance costs and energy consumption while maintaining storage configuration flexibility through policy-based management
3Productivity
If automatic configuration is implemented, then security risks are reduced and productivity improves, but configuration customization capability may be limited
Solution Approach 1:
The system implements dynamic configuration policies that can adapt to different scenarios automatically. The configuration management module uses evaluators to assess storage device attributes and database requirements in real-time, adjusting assignments dynamically based on current system state, thereby achieving both high productivity through automation and adaptability through policy-based customization
Solution Approach 2:
The system changes configuration parameters automatically based on evaluated attributes of storage devices and databases. The configuration management module adjusts storage assignments by modifying parameters such as storage device selection, database placement, and resource allocation based on predefined policies and real-time conditions, thereby achieving efficient automatic configuration while maintaining customization capability through parameter-based control
Data Source
Figure 1
Figure 2~3
Figure 4
AI summary
Embodiments of the present invention provide a method of a system for configuring a storage device in a hybrid storage environment. The method includes: acquiring a plurality of attribute parameters of each storage device in a plurality of storage devices; performing calculation according to the attribute parameters to obtain a priority of each storage device; acquiring a storage priority of each data object; and performing matching according to the storage priority of each data object and the priority of each storage device, so as to store each data object into a storage device with a priority corresponding to the storage priority of the data object. By using the method and system for configuring a storage device in a hybrid storage environment according to the embodiments of the present invention, configuration of a plurality of storage devices and a plurality of data objects in a hybrid storage environment can be implemented, which avoids manual involvement, thereby reducing security risks, improving performance of the system, and reducing energy consumption of the system.