公开(公告)号：US12287784B2

公开(公告)日：2025-04-29

申请号：US18138242

申请日：2023-04-24

Applicant: Oracle International Corporation

Inventor： Teck Hua Lee ,  Yu Chieh Fu ,  Sujatha Muthulingam ,  Vicente Hernandez Jimenez

IPC: G06F16/30 ,  G06F16/11 ,  G06F16/21 ,  G06F16/2453 ,  G06F16/28

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.

公开(公告)号：US20240354299A1

公开(公告)日：2024-10-24

申请号：US18138242

申请日：2023-04-24

Applicant: Oracle International Corporation

Inventor： Teck Hua Lee ,  Yu Chieh Fu ,  Sujatha Muthulingam ,  Vicente Hernandez Jimenez

IPC: G06F16/2453 ,  G06F16/11 ,  G06F16/21 ,  G06F16/28

CPC classification number: G06F16/2453 ,  G06F16/113 ,  G06F16/214 ,  G06F16/282

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.

公开(公告)号：US20240111790A1

公开(公告)日：2024-04-04

申请号：US18373082

申请日：2023-09-26

Applicant: Oracle International Corporation

Inventor： Teck Hua Lee ,  Hariharan Lakshmanan ,  Sujatha Muthulingam ,  Andrew Witkowski ,  Shasank Kisan Chavan ,  You Jung Kim ,  Sooyeon Jo ,  Yu Chieh Fu ,  Vicente Hernandez Jimenez ,  Tirthankar Lahiri

IPC: G06F16/28 ,  G06F16/22 ,  G06F16/25

CPC classification number: G06F16/285 ,  G06F16/2219 ,  G06F16/258

Abstract: Techniques are provided for optimizing storage of database records in segments using sub-segments. A base segment is a container used for storing records that belong to a database object. A database management system receives a request to load, into the database object, a first set of records that are in a first state. In response to receiving the request, the system generates a new sub-segment, which is a container that is separate from the base segment. The system stores the first set of records, in their first state, within the sub-segment. The system then monitors one or more characteristics of the database system. In response to the one or more characteristics satisfying criteria, the system performs a migration of one or more records of the first set of records from the sub-segment to the base segment. During the migration, the system converts the one or more records from the first state to a second state and stores the one or more records, in their second state, in the base segment.