The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 21, 2025
Filed:
Sep. 26, 2023
Oracle International Corporation, Redwood Shores, CA (US);
Teck Hua Lee, Newark, CA (US);
Hariharan Lakshmanan, Brisbane, CA (US);
Sujatha Muthulingam, San Ramon, CA (US);
Andrew Witkowski, Foster City, CA (US);
Shasank Kisan Chavan, Menlo Park, CA (US);
You Jung Kim, Palo Alto, CA (US);
Sooyeon Jo, Redwood City, CA (US);
Yu Chieh Fu, Redmond, WA (US);
Vicente Hernandez Jimenez, Jalisco, MX;
Tirthankar Lahiri, Palo Alto, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.