Self-optimizing database objects using virtual segments
US12287784B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 24, 2023 |
| Grant date | Apr 29, 2025 |
| Priority date | — |
| Expiry date | Apr 24, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/282
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques are provided for optimizing storage of database data records in segments using sub-segments. A segment may be comprised of a plurality of extents that contain data blocks and a plurality of references to sub-segments. Sub-segments are containers that contain other extents. A request to insert a set of records into a segment may be received by a database management system. Upon receiving the request, a particular sub-segment is selected to temporarily store the set of records. The set of records are inserted into data blocks belonging to an extent of the sub-segment. Access frequency for the set of records is monitored to determine whether the access frequency is less than a first threshold. When the access frequency of a subset of records is less than a first threshold, the subset of records is compressed and inserted into a particular extent of a particular segment.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.