Invention Grant
- Patent Title: Free space management in databases
- Patent Title (中): 数据库中的可用空间管理
-
Application No.: US15005304Application Date: 2016-01-25
-
Publication No.: US09576004B1Publication Date: 2017-02-21
- Inventor: Shuo Li , Heng Liu , Ke Wei Wei , Li Yang , Xin Ying Yang , Jian Wei Zhang
- 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 David Zwick
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Managing free space in a relational database. A data statistics history for the relational database is received, including a distribution of index key columns for a clustering index. Based on the data statistics history, increasing index key columns are identified. A rate of increase of the increasing index key columns is measured. Based on the measured rate of increase and on an estimate of database reorganization frequency, free space for the increasing index key columns is reserved.
Information query