Database Free Space Tracking via Change Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods for determining free space in a database require significant time and computing resources, as they involve periodically examining all data files in a tablespace, even if only a few have changed since the last assessment.
Innovation Solution
A database management system that stores and updates space usage data based on changes, allowing for efficient determination of free space by only accessing data that has changed since the last evaluation, thereby reducing unnecessary data access and improving efficiency.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If the database server periodically examines all data files to determine free space, then the amount of free space is accurately determined, but a significant amount of time and computing resources are consumed
Solution Approach 1:
The patent segments the database monitoring task by separating changed data files from unchanged ones. The system identifies only those data files that have experienced changes (allocations or deallocations) since the last monitoring cycle, and examines only these segmented portions rather than the entire database. This segmentation maintains measurement accuracy for free space determination while dramatically reducing the time and resources required by limiting the scope of examination to only the necessary segments.
2Loss of information
If the database server examines all data files to determine free space, then complete information is obtained, but computing resources are significantly consumed
Solution Approach 1:
The patent extracts and tracks only the essential information needed for free space determination - specifically, metadata about data file changes (allocations and deallocations). By extracting and maintaining this minimal necessary information separately, the system can determine free space without re-examining all data files. This extraction approach ensures complete space information is captured while minimizing computing resource consumption by avoiding redundant examinations of unchanged files.
Solution Approach 2:
The system performs preliminary actions by pre-tracking changes to data files (allocations and deallocations) as they occur. This preliminary tracking of change events allows the system to have ready information about which files have changed, eliminating the need to re-examine unchanged files during the free space determination process. This preliminary action ensures complete information is available while reducing computing resources needed at the time of assessment.
3Quantity of substance
If the database administrator increases the size of the tablespace, then the amount of free space is increased, but the device complexity increases
Solution Approach 1:
The patent implements a feedback mechanism that continuously monitors free space levels in tablespaces and provides information about when free space falls below thresholds. This feedback loop enables automated or informed decision-making regarding tablespace expansion, reducing the complexity of manual monitoring and management. The system tracks changes in data files and automatically updates free space information, providing feedback that simplifies the overall management process while maintaining adequate free space levels.
Data Source
AI summary
A method and apparatus for determining the usage of space in a database is provided. A first set of space usage data that reflects the amount of free space associated with one or more tablespaces of a database is stored at a first database server. A second set of space usage data is retrieved from one or more other database servers. The first set of space usage data and the second set of space usage data are both updated based on changes made to the database by the particular database server storing the space usage data. The first set of space usage data is updated at the first database server with the second set of space usage data. The first database server may evaluate the usage of space in the database based on the updated first set of space usage data.