Query Execution and Optimization with Autonomic Error Recovery from Network Failures in a Parallel Computer System with Multiple Networks

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.

Description

RELATED APPLICATIONS[0001]This application is related to a co-filed application to Barsness, et. al., Query Execution And Optimization Utilizing A Combining Network In A Parallel Computer System, Ser. No. ______ filed on ______, which is incorporated herein by reference.[0002]This application is related to a co-filed application to Barsness, et. al., Query Optimization In A Parallel Computer System To Reduce Network Traffic, Ser. No. ______ filed on ______, which is incorporated herein by reference.[0003]This application is related to a co-filed application to Barsness, et. al., Query Optimization In A Parallel Computer System With Multiple Networks, Ser. No. ______ filed on ______, which is incorporated herein by reference.BACKGROUND[0004]1. Technical Field[0005]This disclosure generally relates to database query execution and optimization, and more specifically relates to query execution and optimization with autonomic error recovery from network failures in a parallel computer sy...

AI Technical Summary

Benefits of technology

[0012]In a networked computer system that includes multiple nodes and multiple networks interconnecting the nodes, a database query execution monitor determines if a network error or low performance condition exists and then where possible modifies the query. The query optimizer 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. When a query encounters problems on a given network, the query can be restarted using a different network in the topology without user intervention for a seamless execution of the query. Thus, the query execution monitor allows autonomic error recovery for network failures where the query optimizer determines an alternate query execution plan. The alternate query execution could also be determined at the initial optimization time and then the alternate plan used to execute a query in the case of a particular network failure.

Problems solved by technology

On parallel computer systems in the prior art, the database and query optimizer are not able to effectively overcome a failure of a network while executing a query.

Without a way to more effectively execute and optimize queries, multiple network computer systems will continue to suffer from inefficient utilization of system resources to overcome network failures and process database queries.

Images