Virtual Table Memory Reclamation for Database Schema Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In computing systems, particularly in cloud and traditional environments, memory usage is inefficient due to unused space in database schemas, leading to wasted resources and increased energy consumption, as predefined data lengths often result in allocated spaces not being fully utilized.
Innovation Solution
A method and system that track available space within defined tables, create a virtual table to map and utilize this space, and dynamically adjust field lengths to optimize memory usage, allowing unused space to be reassigned as needed.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If predefined data lengths are allocated in database schemas to ensure sufficient storage space, then data storage capacity is improved, but memory utilization efficiency deteriorates due to unused allocated space
Solution Approach 1:
The patent implements dynamic memory allocation where the database system continuously monitors actual data length in varchar fields and adjusts the allocated space accordingly. When a field contains less data than its predefined length, the system reclaims the unused portion and makes it available for other purposes, transforming static predefined allocation into dynamic adaptive allocation.
Solution Approach 2:
The system changes the parameter of allocated space from a fixed predefined value to a variable that adapts based on actual usage. By monitoring the actual data length and adjusting the allocated space parameter dynamically, the system optimizes memory utilization while maintaining sufficient storage capacity for data growth.
2Reliability
If unused memory space is maintained to ensure data storage requirements are met, then data storage reliability is improved, but energy consumption deteriorates due to continuous power required to maintain allocated space
Solution Approach 1:
The database system implements self-service memory management by automatically monitoring actual data usage in varchar fields and reclaiming unused space without external intervention. The system serves itself by detecting when allocated space exceeds actual needs and dynamically adjusting allocations, eliminating the need to maintain unnecessarily large memory reserves.
Solution Approach 2:
The patent implements a feedback mechanism where the system continuously monitors actual data length in fields and uses this information to adjust allocated space. This closed-loop control ensures that memory allocation responds to actual usage patterns, maintaining reliability by ensuring sufficient space while reducing energy waste from over-allocation.
3Productivity
If virtual tables are created to map and utilize unused space from defined tables, then memory utilization efficiency is improved, but system complexity increases due to additional mapping and tracking mechanisms
Solution Approach 1:
The patent introduces virtual tables as intermediary structures that map to unused space in defined tables. These virtual tables act as mediators between the physical storage structure and the logical data access layer, allowing the system to utilize fragmented unused space without requiring complex direct management of scattered memory regions.
Solution Approach 2:
The system segments the memory management problem by creating separate virtual tables that each map to specific unused space regions in defined tables. This segmentation allows independent management and tracking of different unused space portions, simplifying the overall complexity compared to managing a single large pool of fragmented space.
Data Source
AI summary
An approach for managing memory usage in cloud and traditional environments using usage analytics is disclosed. The approach may be implemented in a computer infrastructure including a combination of hardware and software. The approach includes determining that space is available within one or more tables which have schema definitions with string fields having a predefined length. The approach further includes creating a virtual table and mapping the available space to the virtual table for population by one or more records.