发明授权
- 专利标题: System and method for space management of multidimensionally clustered tables
- 专利标题(中): 多维集群表的空间管理系统和方法
-
申请号: US10425781申请日: 2003-04-29
-
公开(公告)号: US07765211B2公开(公告)日: 2010-07-27
- 发明人: Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Bruce G. Lindsay , Timothy R. Malkemus , Catherine S. McArthur , Sriram K. Padmanabhan , Michael J. Winer
- 申请人: Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Bruce G. Lindsay , Timothy R. Malkemus , Catherine S. McArthur , Sriram K. Padmanabhan , Michael J. Winer
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Kunzler Needham Massey & Thorpe
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
An information retrieval system and method are provided for minimizing the number of blocks searched in a cell before recording a new record in the table and determining which block can be assigned if a table has space available to store a new record in the case an additional block should be associated with a cell. Dimensions for a table are identified, and at least one block in the table is associated with a dimension value for each dimension, where each block comprises contiguous storage pages. The block can be further associated with a cell; this associated cell has a unique combination of dimension values comprising an dimension value for each of the dimensions. A unique associated bit list for each dimension value for each dimension has a unique corresponding list entry for each block associated with that dimension value, and a unique associated bit list for each cell has a unique corresponding list entry for each block associated with that cell.
公开/授权文献
信息查询