Back to results
US 7,584,176 B2Granted
Methods and apparatuses to cancel query
AssigneeSiebel Systems, Inc.
InventorsJing Chen, Denis Tyrell, Tony Kam Wong, Qiang Sun, Jinghuan Jay Lu
Life of this patent
Estimating the term…
Abstract
Methods and apparatuses to cancel database queries from a web application user interface in a networked database application. In one embodiment, the method includes receiving a user request to cancel a query previously sent to a database and calling an application programming interface (API) provided by the database to terminate one or more statements running on the database, the one or more statements being related to the query.
Claims17
A machine readable storage medium containing executable computer program instructions which when executed by a digital processing system cause the system to perform a method, comprising:
- responsive to receiving a first request via a user interface for an application, starting to execute a query operation on a database;
- monitoring for an indication of cancellation during execution of the query operation on the database;
- responsive to receiving the indication of cancellation, determining whether the database accepts cancel query instructions during execution of the query operation on the database;
- in response to a determination that the database does not accept a cancel query instruction during execution of the query operation on the database,
- determining whether the indication of cancellation is a closing of a communication connection between the application and the database, and
- in response to the determining that the indication of cancellation is the closing of the communication connection between the application and the database,
- stopping the query operation, and
- re-establishing the communication connection;
- and
- in response to a determination that the database does accept the cancel query instruction during the execution of the query operation on the database, sending at least one cancellation instruction to the database to stop the execution of the query operation on the database.
7 more elements
A method, comprising:
- responsive to receiving a first request via a web application user interface, starting execution of a query operation on a database;
- monitoring for an indication of cancellation during execution of the query operation on the database;
- responsive to the indication of cancellation, determining whether the database accepts cancel query instructions during execution of the query operation on the database;
- in response to a determination that the database does not accept a cancel query instruction during execution of the query operation on the database,
- determining whether the indication of cancellation is a closing of a communication connection between the application and the database, and
- in response to the determining that the indication of cancellation is the closing of the communication connection between the application and the database,
- causing the database to terminate execution of one or more statements on the database, the one or more statements being related to the query by stopping the query, and
- re-establishing the communication connection;
- and
- in response to a determination that the database does accept the cancel query instruction during the execution of the query operation on the database, sending at least one cancellation instruction to the database to stop the query operation on the database.
7 more elements
A data processing system, comprising:
- a storage device, wherein
- the storage device is configured to store a database;
- a network interface device, wherein
- the network interface device and the storage device are coupled to one another;
- means for starting execution of a query operation on the database, wherein
- the means for starting execution is responsive to a first request received from a web application user interface at the network interface device;
- means for monitoring for an indication of cancellation during execution of the query operation on the database;
- means for determining whether the database accepts cancel query instructions during execution of the query operation on the database, wherein
- the means for determining is responsive to the indication of cancellation;
- means for determining whether the indication of cancellation is a closing of a communication connection between the application and the database, in response to determining that the database does not accept a cancel query instruction, wherein
- the means for determining whether the indication of cancellation is closing of the communication connection further comprises
- means for stopping the query operation, in response to the determining that the indication of cancellation is the closing of the communication between the application and the database, and
- means for re-establishing the communication connection, in response to the determining that the indication of cancellation is the closing of the communication between the application and the database;
- and
- means for sending at least one cancellation instruction to the database to stop the query operation execution at the database on which the query operation is being executed, in response to determining that the database does accept the cancel query instruction during execution of the query operation on the database.
12 more elements
Dependencies are inferred from the claim text.