Allocating free space in a database
AssigneeInternational Business Machines Corporation
InventorsMin Fang, Di Jin, Zhenyu Shi, Nigel G. Slinger, Shu Wang, Li Fei Zheng, Wen Jie Zhu
Life of this patent
Estimating the term…
Abstract
Allocating free space in a database table. Statistics associated with records in a database are received, including an average record byte size for records stored in the database table. A primary free space byte size for record updates is determined, including comparing a preliminary free space byte size to the average record byte size and a byte size of a record subjected to a database operation. Based on the primary free space byte size, free space at the page level of the database table is allocated.
Claims1
A computer-implemented method for allocating free space in a database table, the method comprising:
- receiving statistics associated with records in a database table, including an average record byte size for records stored in the database table;
- receiving a database operation;
- determining a primary free space byte size for record updates based on the received database operation, wherein determining the primary free space byte size for record updates comprises comparing a preliminary free space byte size to the average record byte size and a byte size of a subject record, wherein determining the primary free space byte size further comprises modifying the preliminary free space byte size based on the average record byte size and the byte size of the subject record, wherein the subject record is subjected to a database operation, wherein determining the primary free space byte size is in response to commencing a database utility, and wherein the database utility is associated with at least one of a reorganization process and a page loading process;
- and
- allocating free space at a page level of the database table based on the primary free space byte size.
Dependencies are inferred from the claim text.