Replacing an unavailable element in a query
View Patent ↗A method, apparatus, system, and signal-bearing medium that in an embodiment replace an element in a query with a backup if the element is not available, but the backup is available. An element may also be removed from the query if the element is not required. In various embodiments, the element may be a table or a user-defined function. In this way, the query may still execute even if the element is not available.
1. A method comprising:
determining whether a first element specified by a specification in a first query is available, wherein the first element comprises a method that manipulates an object data instance;
determining whether a first backup for the first element is available;
replacing the specification of the first element in the first query with a specification of the first backup if the first element is not available and the first backup is available;
refraining from replacing the specification of the first element if the first element is available or the first backup is not available;
removing the specification of the first element from the first query if the first element is specified by a user as not required, the first element is not available, and the first backup is not available;
refraining from removing the specification of the first element if the first element is specified by the user as required, the first element is available, or the first backup is available; and
executing the first query, which returns results.
2. The method of claim 1 , further comprising:
determining whether an elapsed time for the first query exceeds a threshold.
3. The method of claim 2 , further comprising:
creating a second query with a second backup substituted for a second element if the elapsed time exceeds the threshold.
4. The method of claim 2 , further comprising:
refraining from creating the second query if the elapsed time for the first query does not exceed the threshold.
5. The method of claim 3 , further comprising:
determining whether the second query is executing faster than the first query.
6. The method of claim 5 , further comprising:
stopping whichever of the first query and the second query is slower.