发明授权
US07349925B2 Shared scans utilizing query monitor during query execution to improve buffer cache utilization across multi-stream query environments
失效
在查询执行期间使用查询监视器进行共享扫描,以提高多流查询环境中的缓冲区缓存利用率
- 专利标题: Shared scans utilizing query monitor during query execution to improve buffer cache utilization across multi-stream query environments
- 专利标题(中): 在查询执行期间使用查询监视器进行共享扫描,以提高多流查询环境中的缓冲区缓存利用率
-
申请号: US10763752申请日: 2004-01-22
-
公开(公告)号: US07349925B2公开(公告)日: 2008-03-25
- 发明人: Kevin James Cherkauer , Scott David Lashley , Jason Christopher Young
- 申请人: Kevin James Cherkauer , Scott David Lashley , Jason Christopher Young
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Intellectual Property Law Offices
- 代理商 Robert O. Guillot
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A system for data base management using memory devices holding a database containing tables of data occupying extents. A database engine reviews each query to determine an extents list of extents containing the data needed by that said query. A query monitor then re-orders the extents lists so that extents are retreived and stored in a buffer cache for more efficient use when executing the queries. The database engine retreives needed extents from the memory devices, as ordered in the extents lists, and stores those extents in the buffer cache. The database engine then executes one or more queries on the data in the extents in the buffer cache to determine respective results.
公开/授权文献
信息查询