Patent Document ID: 10108665
Application ID: 14734503

Base Claim:
1. A method comprising: determining, by an optimizer of a first database management system (DBMS) running on a first computer system having a first set of computing resources, that with respect to the first set of computing resources a first query access plan configured for executing a query satisfies a set of query optimization criteria; determining, in preparation for the first computer system being unavailable for use in responding to future requests to execute the query, that with respect to a second set of computing resources of an alternative, second computer system the first query access plan fails a set of preliminary criteria; generating, in response to the failure determination, a second query access plan configured for executing the query; determining, prior to receiving, by a second DBMS running on the second computer system having the second set of computing resources, a first request to execute the query, that with respect to the second set of computing resources the second query access plan satisfies the set of query optimization criteria; and storing, in response the second query access plan satisfaction determination, the second query access plan such that the second query access plan can be executed by the second computer system in an event that the first computer system is unavailable to use in responding to the first request to execute the query.

---

Claim 10:
10. The method of claim 1 wherein, prior to receiving, by the second DBMS running on the second computer system having the second set of computing resources, the first request to execute the query, the first DBMS running on the first computer system having the first set of computing resources performs the generating the second query access plan, the failure determination, and the second query access plan satisfaction determination.