Query Execution and Optimization with Autonomic Error Recovery from Network Failures in a Parallel Computer System with Multiple Networks
First Claim
Patent Images
1. ) A computer apparatus comprising:
- a plurality of nodes each having a memory and at least one processor;
a database residing in the memory;
a plurality of networks connecting the plurality of nodes;
a query optimizer and a query to the database residing in the memory; and
a query execution monitor residing in the memory and executed by the at least one processor, wherein the query execution monitor detects a network failure during execution of the query and invokes the query optimizer to re-optimize the query to use a different network resource to execute the query.
1 Assignment
0 Petitions
Accused Products
Abstract
An apparatus and method for a database query execution monitor determines if an network error or low performance condition exists and then where possible modifies the query. The query execution monitor then determines an alternate query execution plan to continue execution of the query. The query optimizer can re-optimize the query to use a different network or node. Thus, the query execution monitor allows autonomic error recovery for network failures using an alternate query execution. The alternate query execution could also be determined at the initial optimization time and then this alternate plan used to execute a query in the case of a particular network failure.
-
Citations
19 Claims
-
1. ) A computer apparatus comprising:
-
a plurality of nodes each having a memory and at least one processor; a database residing in the memory; a plurality of networks connecting the plurality of nodes; a query optimizer and a query to the database residing in the memory; and a query execution monitor residing in the memory and executed by the at least one processor, wherein the query execution monitor detects a network failure during execution of the query and invokes the query optimizer to re-optimize the query to use a different network resource to execute the query. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. ) A computer implemented method for optimizing a query on a parallel computer system comprising the steps of:
-
receiving a query to a database; optimizing the query; initiating the query execution; monitoring the query execution; detecting a network failure; and in response to the detected network failure, optimizing to re-optimize the query to use a different network resource to execute the query. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. ) An article of manufacture for executing on a parallel computer system with a plurality of compute nodes comprising:
-
a query execution monitor performing the steps of; receiving a query to a database; optimizing the query; initiating the query execution; monitoring the query execution; detecting a network failure; in response to the detected network failure, re-optimizing the query to use a different network resource to execute the query; and computer-readable medium in which computer instructions are stored, which instructions, when read by a computer, cause the computer to perform the steps of the query execution monitor. - View Dependent Claims (15, 16, 17, 18, 19)
-
Specification