发明申请
US20060224594A1 Methods and systems for identifying highly contended blocks in a database
审中-公开
用于识别数据库中高度竞争的块的方法和系统
- 专利标题: Methods and systems for identifying highly contended blocks in a database
- 专利标题(中): 用于识别数据库中高度竞争的块的方法和系统
-
申请号: US11099272申请日: 2005-04-04
-
公开(公告)号: US20060224594A1公开(公告)日: 2006-10-05
- 发明人: Kiran Goyal , Tudor Bosman , Tirthankar Lahiri
- 申请人: Kiran Goyal , Tudor Bosman , Tirthankar Lahiri
- 申请人地址: US CA Redwood Shores 94065
- 专利权人: Oracle International Corporation
- 当前专利权人: Oracle International Corporation
- 当前专利权人地址: US CA Redwood Shores 94065
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A computer-implemented method of generating a list of K most frequently accessed ones of a plurality of data blocks in a database may include steps of selecting the number K; building the list of K blocks by storing an identification of and maintaining a running count for up to selected K ones of the data blocks by iteratively carrying out a single step for each of the plurality of data blocks, the single step being selected from an incrementing step to increment the count, a decrementing step to decrement the count, an adding step to add a data block to the list and to set a count of the added data block and a replacing step to replace an existing data block of the list with a new data block and to set a count of the new data block, and providing the list of K most frequently accessed blocks.
信息查询