Virtual Database Lock Management via Global Coordinator
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Mainframe computers used for database systems are slow in startup due to redundant architecture and extensive throughput demands, making them impractical for testing new database configurations, and cloud platforms are not suitable for development and testing due to activation delays and resource constraints.
Innovation Solution
The use of virtual databases with containers to test database configurations, where a global coordinator manages page locking and data consistency across multiple virtual databases, allowing for rapid testing of various configurations without the need for physical mainframe resources.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If mainframe computers are used for database system testing, then reliability and fault tolerance are improved, but startup speed and testing efficiency deteriorate
Solution Approach 1:
The patent creates virtual database systems that are copies of the physical mainframe database system. These virtual copies replicate the mainframe's reliability and fault tolerance characteristics while running on standard cloud infrastructure, eliminating the need for slow mainframe startup while maintaining testing fidelity.
Solution Approach 2:
The patent segments the database system into multiple virtual instances that can run independently on cloud platforms. Each virtual database system is containerized and can be instantiated rapidly, allowing parallel testing of multiple configurations without the bottleneck of sequential mainframe startup.
2Ease of operation
If cloud platforms are used for database system testing, then startup speed and accessibility are improved, but resource constraints and activation delays worsen
Solution Approach 1:
The patent merges multiple virtual database instances onto shared cloud infrastructure with controlled resource allocation. The system manages resource constraints by implementing virtualization overhead management and resource sharing mechanisms that allow multiple testing environments to coexist without exhausting available resources.
Solution Approach 2:
The patent implements pre-configured virtual database templates and container images that are prepared in advance. When testing is needed, these pre-built artifacts can be rapidly instantiated without requiring resource-intensive setup procedures, thus overcoming activation delays while working within resource constraints.
3Productivity
If multiple virtual databases are used for configuration testing, then testing efficiency and productivity are improved, but data consistency and lock management complexity worsen
Solution Approach 1:
The patent introduces a global coordinator as an intermediary component that manages lock requests and data consistency across multiple virtual database systems. This coordinator acts as a central authority that receives lock requests from virtual databases, manages the locking protocol, and ensures consistency without requiring complex distributed consensus algorithms in each virtual instance.
4Loss of energy
If virtualization is implemented for database testing, then cost and resource utilization are improved, but system complexity and coordination overhead worsen
Solution Approach 1:
The patent implements a universal virtualization layer that provides multi-functional support for running different database configurations and versions on the same physical infrastructure. This universal platform handles resource allocation, isolation, and coordination through standardized interfaces, reducing the need for separate management systems for each virtual instance and thereby controlling complexity while maximizing resource utilization.
Data Source
AI summary
Methods, computer program products, and systems are presented. The methods include, for instance: receiving a request for a lock on a page from a virtual database amongst two or more virtual databases, the virtual database including a number of containers respectively corresponding to the same number of database components of the virtual database. A copy of the page is refreshed with a latest copy of the page in an overall cache prior to granting the lock based on ascertaining that the page is not locked by any other virtual database. The virtual database is granted with the lock and have an exclusive access to the page.