发明申请
- 专利标题: Query optimization via a partitioned environment
- 专利标题(中): 通过分区环境进行查询优化
-
申请号: US10660144申请日: 2003-09-11
-
公开(公告)号: US20050060285A1公开(公告)日: 2005-03-17
- 发明人: Eric Barsness , John Santosuosso
- 申请人: Eric Barsness , John Santosuosso
- 申请人地址: US NY Armonk 10504
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk 10504
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Systems, methods, and articles of manufacture for improving the efficiency of executing a query are provided. Queries frequently issued in a primary processing environment (e.g., a primary logical partition) may be run in a background processing environment (e.g., a background logical partition) with different access plans to determine the access plan that results in the least execution time. For some embodiments, in an effort to avoid executing queries that may have an adverse system-wide impact, selected queries may be analyzed in the background processing environment prior to being executed. This analysis may be performed to ensure the execution time of the query will not exceed a specified threshold, and/or will not result in excessive contention when executed in the primary processing environment.
公开/授权文献
- US07130838B2 Query optimization via a partitioned environment 公开/授权日:2006-10-31
信息查询