Patent ID: 9519649
Filing Date: 2016-12-13
CPC Classification: G06F

Claim Text:
1. A method for allocating space in a database, the method comprising: inserting, by a computer processor, a row in a database table on a page having a first space reserved for inserting rows of the database table; reserving, by a computer processor, a second space 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; and gathering real time statistics for reserving the second space on a dynamic basis, including gathering statistics indicating a first count of how many of an UPDATE operation changed data of rows of the database table and a second count of how many of an INSERT operation inserted new rows in the database table and wherein reserving the second space for adding data to the inserted row includes reserving the second space responsive to a ratio of the first and second counts.