发明名称 |
METHOD FOR EFFICIENTLY SEARCHING FREE SPACE IN A RELATIONAL DATABASE |
摘要 |
A method for efficiently searching free space in a relational database management system. The method limits the search to a finite number of space map pages in the free space map. If the configured number of space map pages in the free space map are searched and a page with free space is not found for the row, the row is inserted on the last page, or if no space is available on the last page a new page is created and the row is inserted on the new page. New rows are then appended until some predefined amount of space is filled before a search is done again. As a result, insertion of a row into the database management system does not incur the worst-case cost of searching the entire free space map.
|
申请公布号 |
CA2249080(C) |
申请公布日期 |
2001.12.04 |
申请号 |
CA19982249080 |
申请日期 |
1998.09.25 |
申请人 |
IBM CANADA LIMITED-IBM CANADA LIMITEE |
发明人 |
ROMANUFA, KERILEY K.;HURAS, MATTHEW A.;WINER, MICHAEL J.;GOSS, JEFFREY J.;HOP HING, NELSON;LINDSAY, BRUCE G. |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|