Database Snapshot Copy-on-Write Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional snapshot technologies impair performance and increase storage space by modifying unused or free data extents during write operations, leading to fragmentation and unnecessary data copying.
Innovation Solution
The method identifies utilized and empty storage locations in a database, creates a point-in-time representation by flagging empty locations, and refrains from performing copy-on-write operations on empty locations, ensuring only utilized storage locations are shared between the primary database and the snapshot.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If conventional snapshot technology modifies unused and free data extents during write operations, then the snapshot maintains consistency with the primary database, but this causes performance impairment, increased storage space consumption, and fragmentation
Solution Approach 1:
The patent applies local quality by treating used data extents differently from unused and free data extents. The system identifies and flags empty storage locations, then applies copy-on-write operations only to used data extents while allowing direct writes to unused and free extents. This localized differentiation resolves the contradiction by maintaining snapshot consistency for actual data while eliminating unnecessary operations on empty spaces, thereby improving write performance without sacrificing reliability
2Reliability
If conventional snapshot technology performs copy-on-write operations on all data extents including unused and free extents, then the snapshot captures a complete point-in-time representation, but this increases storage space requirements and causes fragmentation
Solution Approach 1:
The patent extracts unused and free data extents from the set of data extents that undergo copy-on-write operations. By identifying and flagging empty storage locations, the system separates these extents from used data extents, applying snapshot consistency mechanisms only where necessary. This extraction eliminates wasteful storage consumption on empty spaces while preserving the completeness of the point-in-time representation for actual data
3Reliability
If conventional snapshot technology shares all data extents between primary database and snapshot, then the snapshot provides comprehensive backup capability, but this leads to unnecessary data copying and performance degradation
Solution Approach 1:
The patent implements local quality by creating a differentiated sharing arrangement between primary database and snapshot. Used data extents are shared with copy-on-write protection to ensure backup reliability, while unused and free data extents are excluded from sharing and allow direct writes. This localized approach reduces data copying overhead and complexity while maintaining comprehensive backup capability for actual data
Data Source
AI summary
The disclosed computer-implemented method for improving the efficiency of point-in-time representations of databases may include (1) identifying a database that includes (A) one or more utilized storage locations that store substantive data and (B) one or more empty storage locations that are not currently storing any substantive data, (2) creating a point-in-time representation of the database by (A) identifying the empty storage locations and (B) flagging the empty storage locations in connection with the point-in-time representation of the database, (3) detecting a request to write certain substantive data to at least one of the empty storage locations, and then in response to detecting the request, (4) satisfying the request while refraining from performing a copy-on-write operation on the empty storage location due at least in part to the empty storage location not currently storing any substantive data. Various other methods, systems, and computer-readable media are also disclosed.