Database Data Allocation by Access Frequency
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing technologies face challenges in accurately monitoring and estimating access frequencies for physical storage areas in database systems, making it difficult to optimize database data allocation across these areas for improved performance.
Innovation Solution
A computer system with an access frequency obtaining module and a data allocation module that divides database data based on estimated access frequencies for each value range of a reference item, allowing for informed allocation across physical storage areas.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If database data is allocated across multiple physical storage areas, then storage capacity and flexibility are improved, but accurate monitoring and estimation of access frequencies becomes difficult
Solution Approach 1:
The patent segments the database data into multiple data sets based on access frequency characteristics, and assigns each data set to specific physical storage areas. This segmentation enables the system to monitor and manage access frequencies more accurately by dividing the complex data storage structure into manageable units that can be individually tracked and optimized.
2Productivity
If data access performance is optimized by considering access frequencies, then DBMS processing performance is improved, but device complexity increases
Solution Approach 1:
The patent implements a data allocation management method that automatically monitors access frequencies and adjusts data allocation without requiring manual intervention. The system self-adjusts by identifying high-access-frequency data sets and assigning them to appropriate physical storage areas, thereby improving DBMS processing performance while reducing the operational complexity of data allocation management.
3Adaptability or versatility
If access frequencies are estimated using allocation information and history information, then data allocation optimization is enabled, but measurement precision deteriorates due to variations in data storage density and access frequency
Solution Approach 1:
The patent changes the parameters used for data allocation from static allocation information to dynamic access frequency measurements. By continuously monitoring actual access frequencies and adjusting allocation decisions based on real-time data, the system overcomes the inaccuracies of estimation and achieves more precise data allocation optimization despite variations in storage density.
Data Source
AI summary
A computer is used in a computer system including multiple physical storage areas for storing database data. The database includes component information having a reference item having plural value ranges. The database data is dividable according to value ranges of the reference item. The computer comprises an access frequency obtaining module and a data allocation module. The access frequency obtaining module obtains, for each value range of the reference item in the component information, an estimated access frequency for data of the component information. The data allocation module allocates, based on the obtained estimated access frequency, data of the component information divided according to the value ranges of the reference item to the physical storage areas to be stored.