Invention Grant
- Patent Title: Database query optimizer that takes network choice into consideration
-
Application No.: US13448483Application Date: 2012-04-17
-
Publication No.: US09934271B2Publication Date: 2018-04-03
- Inventor: Eric L. Barsness , David L. Darrington , Amanda Randles , John M. Santosuosso
- Applicant: Eric L. Barsness , David L. Darrington , Amanda Randles , John M. Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Martin & Associates, LLC
- Agent Derek P. Martin
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
In a networked computer system that includes multiple nodes and multiple networks interconnecting the nodes, a database query optimizer takes network choice into consideration when optimizing a query. The query optimizer logs historical information for queries that includes network information. A network monitor determines network characteristics of the multiple networks. The query optimizer then selects a network for a query based on the network characteristics, and optionally based on the historical information as well. The result is a query optimizer that takes network choice into consideration, thereby providing a query that is optimized according to the characteristics of the networks.
Public/Granted literature
- US20120203763A1 DATABASE QUERY OPTIMIZER THAT TAKES NETWORK CHOICE INTO CONSIDERATION Public/Granted day:2012-08-09
Information query