OBTAINING PARTIAL RESULTS FROM A DATABASE QUERY

摘要

A database query governor determines when a query cannot be executed within a defined time threshold, but still executes the query or some variant of the query so partial results for the query may be returned to the user after executing for less than the defined time threshold, instead of an error message indicating the query was not executed at all. The partial results provide information to the user that may be sufficient for some applications, or may indicate to the user how the query could be modified to run in less time.

主权项

1. An apparatus comprising:
at least one processor; a memory coupled to the at least one processor; a query to a database; and a query governor that determines the query cannot be executed in less time than a specified threshold value, and in response, executes the query in less time than the specified threshold value, and returns partial results for the query, wherein the partial results are less than all results that would have been returned for the query had the query been allowed to fully execute.