Invention Grant
- Patent Title: Free space management in a database
-
Application No.: US15261899Application Date: 2016-09-10
-
Publication No.: US09892145B2Publication Date: 2018-02-13
- Inventor: Charles R. Bonner , John J. Campbell , Frances H. Villafuerte , Maryela E. Weihrauch
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Anthony V. S. England; Erik K. Johnson
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A row is inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for adding data to the inserted row, wherein reserving the second space includes reserving the second space on the page responsive to inserting the row, so that the amount of space reserved for adding data to inserted rows grows as more rows are inserted. The page is marked full for the second space independently of whether the first space is full for inserting new rows. Data is added to rows on the page, responsive to detecting that the second space is full, by adding the data to one or more new pages, even though rows may still be inserted on the page using any remaining room in the first space on the page.
Public/Granted literature
- US20160378779A1 FREE SPACE MANAGEMENT IN A DATABASE Public/Granted day:2016-12-29
Information query