发明申请
- 专利标题： OPTIMIZING THE EXECUTION OF A QUERY IN A MULTI-DATABASE SYSTEM
- 专利标题（中）： 优化多数据库系统中查询的执行
-
申请号： US13271867申请日： 2011-10-12
-
公开(公告)号： US20120265751A1公开(公告)日： 2012-10-18
- 发明人: Douglas Brown , John Mark Morris
- 申请人： Douglas Brown , John Mark Morris
- 主分类号： G06F17/30
- IPC分类号： G06F17/30
摘要：
Optimizing the execution of a query in a multi-database system includes identifying a region within a table, the table being referenced in the query. The region is stored on data-storage devices on first and second system databases in the multi-database system. A first access plan for the query is developed, the first access plan comprising accessing the version of the region stored on the first system database. A second access plan for the query is developed, the second access plan comprising accessing the version of the region stored on the second system database. A selection is made between the first access plan and the second access plan to execute the query. The query is executed using the selected access plan to produce a result.