Intelligent query re-execution
AssigneeInternational Business Machines Corporation
InventorsRichard D. Dettinger, Richard J. Stevens, Jeffrey W. Tenner
Life of this patent
Estimating the term…
Abstract
A method, apparatus and article of manufacture for accessing data in a database. One embodiment comprises providing a query against the database, the query being associated with a re-execution indication; initially executing the query; providing an initial query result; determining at least one re-execution time from the re-execution indication; and re-executing the query at the at least one determined re-execution time.
Claims42
A computer-readable medium containing a program which, when executed on a computer system, performs an operation of accessing data in a database, the operation comprising:
- receiving a query against the database, the query being associated with a re-execution indication;
- initially executing the query;
- providing an initial query result;
- determining at least one re-execution time from the re-execution indication;
- and
- re-executing the query at the at least one determined re-execution time.
A computer-readable medium containing a program which, when executed on a computer system, performs an operation of accessing data in a database, the operation comprising:
- receiving an initial query against the database, the initial query comprising a first and a second condition;
- executing the initial query;
- providing an initial query result comprising at least one first data record satisfying the initial query;
- generating a first query using the first condition and a second query using the second condition;
- and
- executing the first and second queries to determine whether the database comprises at least one second data record satisfying the initial query.
A computer-readable medium containing a program which, when executed on a computer system, performs an operation of accessing data in a database, the operation comprising:
- receiving an initial query against the database, the initial query comprising a first and a second condition and being associated with a re-execution indication;
- executing the initial query;
- providing an initial query result comprising at least one first data record satisfying the initial query;
- generating a first query using the first condition and a second query using the second condition;
- determining at least one re-execution time from the re-execution indication;
- and
- executing the first and second queries at the at least one determined re-execution time to determine whether the database comprises at least one second data record satisfying the initial query.
A method of accessing data in a database, the method comprising:
- issuing a query against the database, the query being associated with a re-execution indication;
- initially executing the query;
- providing an initial query result;
- determining at least one re-execution time from the re-execution indication;
- and
- re-executing the query at the at least one determined re-execution time.
A method of accessing data in a database, the method comprising:
- issuing an initial query against the database, the initial query comprising a first and a second condition;
- executing the initial query;
- providing an initial query result comprising at least one first data record satisfying the initial query;
- generating a first query using the first condition and a second query using the second condition;
- and
- executing the first and second queries to determine whether the database comprises at least one second data record satisfying the initial query.
A method of accessing data in a database, the method comprising:
- issuing an initial query against the database, the initial query comprising a first and a second condition and being associated with a re-execution indication;
- executing the initial query;
- providing an initial query result comprising at least one first data record satisfying the initial query;
- generating a first query using the first condition and a second query using the second condition;
- determining at least one re-execution time from the re-execution indication;
- and
- executing the first and second queries at the at least one determined re-execution time to determine whether the database comprises at least one second data record satisfying the initial query.
Dependencies are inferred from the claim text.