首页>
外国专利>
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
展开▼
机译:在执行查询过程中共享的磁盘使用查询监视器来改善多流查询环境中的缓冲区缓存利用率
展开▼
页面导航
摘要
著录项
相似文献
摘要
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 retrieved and stored in a buffer cache for more efficient use when executing the queries. The database engine retrieves 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.
展开▼