- 专利标题: Generating multiple query access plans for multiple computing environments
-
申请号: US14734503申请日: 2015-06-09
-
公开(公告)号: US10108665B2公开(公告)日: 2018-10-23
- 发明人: Rafal P. Konik , Roger A. Mittelstadt , Brian R. Muras , Chad A. Olstad
- 申请人: International Business Machines Corporation
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理商 Nicholas D. Bowman
- 主分类号: G06F17/30
- IPC分类号: G06F17/30 ; G06F11/20
摘要:
A first database management system (DBMS) running on first computer having a first set of computing resources determines that with respect to the first set of computing resources a first query access plan for executing a query satisfies a set of query optimization criteria. A determination is then made that with respect to a second set of computing resources the first query access plan fails a set of preliminary criteria. In response to this failure determination, a second query access plan for executing the query is generated. Prior to having a second DBMS running on a second computer having the second set of computing resources receive a request to execute the query, a determination is made that with respect to the second set of computing resources the second query access plan satisfies the set query optimization criteria.
公开/授权文献
信息查询