Multiphase Database Maintenance via Data Synchronizer
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Database maintenance operations in production mode often result in significant offline time and performance issues due to the need to take portions of the database offline for extended periods, which is problematic for critical applications requiring 24/7 data availability.
Innovation Solution
A multiphase approach involving a data synchronizer that creates a new data layer while the original is locked, allowing concurrent access and updates, thereby reducing offline time by enabling maintenance while the database remains available to clients.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If traditional database maintenance operations are performed on production database systems, then maintenance tasks can be completed, but significant offline time and database unavailability occur
Solution Approach 1:
The patent segments the database into multiple data partitions and implements independent maintenance operations on each partition. The database system divides data into segments that can be maintained separately, allowing other segments to remain accessible during maintenance operations, thereby reducing overall offline time while maintaining data availability.
Solution Approach 2:
The patent performs preliminary actions by creating backup copies of data partitions and preparing maintenance environments before actual maintenance operations. Data is pre-copied to temporary structures, and maintenance operations are prepared in advance, allowing rapid switching between operational and maintenance modes without significant downtime.
2Reliability
If database maintenance operations are performed, then database performance issues can be addressed, but database performance problems occur during maintenance
Solution Approach 1:
The patent introduces intermediary components including temporary data structures, buffer zones, and mediation layers that facilitate maintenance operations without directly impacting production database operations. These intermediaries act as buffers between maintenance activities and production workloads, preventing performance degradation during maintenance.
Solution Approach 2:
The patent implements dynamic resource allocation and adaptive performance management during maintenance operations. The system dynamically adjusts resource allocation, query routing, and operation prioritization based on real-time conditions, ensuring that maintenance operations do not severely impact overall database productivity and performance.
Data Source
AI summary
Embodiments include a method, apparatus and computer program product for providing access to a database data source during database maintenance. The method includes initiating maintenance of the database data source and managing the database maintenance to allow concurrent access to the database data source.