发明授权
- 专利标题: Compressibility estimation of non-unique indexes in a database management system
- 专利标题(中): 数据库管理系统中非唯一索引的压缩性估计
-
申请号: US12057055申请日: 2008-03-27
-
公开(公告)号: US07895171B2公开(公告)日: 2011-02-22
- 发明人: Bishwaranjan Bhattacharjee , Lipyeow Lim , George A. Mihaila
- 申请人: Bishwaranjan Bhattacharjee , Lipyeow Lim , George A. Mihaila
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Fleit Gibbons Gutman Bongini & Bianco PL
- 代理商 Jon A. Gibbons
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A method, information processing system, and computer readable storage product estimate a compression factor. A set of key values within an index are analyzed. Each key value is associated with a record identifier (“RID”) list comprising a set of RIDs. The index is in an uncompressed format and includes a total byte length. A number of RIDs associated with each key value is estimated for each key value in the set of key values. A total byte length for all RID deltas between each at least two consecutive RIDs within a RID list is estimated for each RID list based on the number of RIDs that have been determined. The total byte length estimated for each RID list is accumulated. A compression factor associated with the index is determined by dividing the total byte length that has been accumulated by the byte length of the index.
公开/授权文献
信息查询