US Patent No: 6,546,403
Number of patents in Portfolio can not be more than 2000
Mechanism to resubmit queries in a parallel database system
Stats
-
Apr 8, 2003
Issued date -
Jan 19, 2000
filing date -
09/487,431
serial no -
In Force
status
Importance
Loading Importance Indicators...
Abstract
An apparatus, method and program product for resubmitting queries encompassed by a Query Management Subsystem (QMS) responsive to high availability recovery actions within itself and a database subsystem it is designed to serve. The invention includes a work queue, a database subsystem, and a first QMS server which invokes and tracks queries in the work queue (received through traditional client interface means) as delivered to the database subsystem. A Query Resubmittal Mechanism (QRM) in the QMS is responsive to the database, client, and high availability recovery actions for both the QMS and database subsystem. The QRM modifies the status of queries in the work queue depending on whether a query has been submitted to the database or a database query response has been received. Incoming client queries are placed in the work queue (with queued status Q). Completed queries from the database are removed from the work queue and answer sets returned to the originating client. The QRM modifies the status of the oldest queries in the work queue from queued (Q) to active (A) and submits them to the database if the number of queries marked as active (A) in the work queue are under a user-defined, adjustable limit. The QRM determines if reconfiguration of the database subsystem has been completed in response to high availability recovery actions. QRM then modifies the adjustable limit and/or job priorities of the uncompleted queries if the database subsystem is operating in a degraded state (or returning to a repaired state) due to said reconfiguration. The work queue becomes durable by making it accessible to a backup, second server, and implementing a high availability configuration to restart the QMS/QRM on the backup server. When the QMS/QRM is started (after an operator shutdown) or restarted on the backup server (in the high-availability configuration), the QRM interrogates the work queue to determine if it contains uncompleted queries and resubmits them, up to the adjustable limit.
Loading the Abstract Image...
First Claim
Related Publications
Loading Related Publications...
International Classification(s)
- [Classification Symbol]
- [Patents Count]
Cited Art
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 5,742,806 Apparatus and method for decomposing database queries for database management system including multiprocessor digital data processing system | 131 | 1994 | |
| 5,996,075 Method and apparatus for reliable disk fencing in a multicomputer system | 67 | 1995 | |
| 6,243,814 Method and apparatus for reliable disk fencing in a multicomputer system | 78 | 1998 | |
| 5,964,886 Highly available cluster virtual disk system | 83 | 1998 | |
| 6,161,191 Mechanism for reliable update of virtual disk device mappings without corrupting data | 41 | 1998 | |
| 6,173,413 Mechanism for maintaining constant permissions for multiple instances of a device within a cluster | 48 | 1998 | |
| 6,192,401 System and method for determining cluster membership in a heterogeneous distributed system | 129 | 1999 | |
|
|
|||
| 5,495,606 System for parallel processing of complex read-only database queries using master and slave central processor complexes | 102 | 1993 | |
| 5,437,032 Task scheduler for a miltiprocessor system | 116 | 1994 | |
| 5,692,174 Query parallelism in a shared data DBMS system | 56 | 1995 | |
| 5,675,791 Method and system for database load balancing | 78 | 1996 | |
|
|
|||
| 5,247,664 Fault-tolerant distributed database system and method for the management of correctable subtransaction faults by the global transaction source node | 92 | 1991 | |
|
|
|||
| 5,590,319 Query processor for parallel processing in homogenous and heterogenous databases | 119 | 1993 | |
|
|
|||
| 5,613,106 Method for processing and storing a transaction in a distributed database system | 29 | 1993 | |
|
|
|||
| 5,857,180 Method and apparatus for implementing parallel operations in a database management system | 131 | 1997 | |
|
|
|||
| 5,699,500 Reliable datagram service provider for fast messaging in a clustered environment | 56 | 1995 | |
Patent Citation Ranking
Maintenance Fees
| Fee | Large entity fee | small entity fee | micro entity fee | due date |
|---|---|---|---|---|
| 11.5 Year Payment | $7400.00 | $3700.00 | $1850.00 | Oct 8, 2014 |
| Fee | Large entity fee | small entity fee | micro entity fee |
|---|---|---|---|
| Surcharge - 11.5 year - Late payment within 6 months | $160.00 | $80.00 | $40.00 |
| Surcharge after expiration - Late payment is unavoidable | $700.00 | $350.00 | $175.00 |
| Surcharge after expiration - Late payment is unintentional | $1,640.00 | $820.00 | $410.00 |