US6205449B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for providing hot spare redundancy and recovery for a very large database management system
Assignee: Alcatel Lucent SAS
•
Filing: 1998-03-20
•
Granted: 2001-03-20
•
Expires: 2018-03-20
Abstract
Abstract For use with a primary database residing on a primary computer, the primary computer being couplable to a secondary computer having a secondary database, a system for, and method of, allowing the secondary computer to operate as a hot spare for the primary computer and a database management system employing the system or the method. In one embodiment, the system includes: (1) a transaction logger, associated with the primary database, that maintains log records of transactions involving persistent data in the primary database, (2) a transaction processor, associated with the primary database, that transmits at least a portion of the log records to the secondary computer to allow the secondary computer to commit the at least the portion of the log records to the secondary database and (3) parameters, associated with the primary and secondary databases, that designate a state of the primary and secondary computers and indicate relative synchronization of the primary and secondary databases.
Inventors
- 👤 Rajeev Rastogi
- 👤 Abraham Silberschatz
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-31 08:41
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/07; G06F11/14; G06F11/1471; G06F2201/00; G06F2201/80; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 22
Claim 1
Independent Claim
142 words
For use with a primary database residing on a primary computer, said primary computer being couplable to a secondary computer having a secondary database, a system for allowing said secondary computer to operate as a hot spare for said primary computer, comprising: a transaction logger, associated with said primary database, that maintains log records of transactions involving persistent data in said primary database; and a transaction processor, associated with said primary database, that transmits a portion of said log records to said secondary computer to allow said secondary computer to commit said portion of said log records to said secondary database, said secondary database being able to, upon failure of said primary database, automatically redesignate to function in a primary database mode, said primary database being able to, upon resolution of said failure, automatically redesignate to function in a secondary database mode.
Claim 2
Dependent Claim
142 words
For use with a primary database residing on a primary computer, said primary computer being couplable to a secondary computer having a secondary database, a system for allowing said secondary computer to operate as a hot spare for said primary computer, comprising: a transaction logger, associated with said primary database, that maintains log records of transactions involving persistent data in said primary database; and a transaction processor, associated with said primary database, that transmits a portion of said log records to said secondary computer to allow said secondary computer to commit said portion of said log records to said secondary database, said secondary database being able to, upon failure of said primary database, automatically redesignate to function in a primary database mode, said primary database being able to, upon resolution of said failure, automatically redesignate to function in a secondary database mode.
Claim 3
Dependent Claim
46 words
The system as recited in claim 1 wherein said transaction processor transmits all of said log records to said secondary computer to allow said secondary computer to commit said all of said log records to said secondary database, said secondary database thereby mirroring said primary database.
Claim 4
Dependent Claim
33 words
The system as recited in claim 1 wherein said transaction processor commits one of said log records without waiting until said secondary computer has acknowledged having committed said one of said log records.
Claim 5
Dependent Claim
33 words
The system as recited in claim 1 wherein said transaction processor waits to commit one of said log records until said secondary computer has acknowledged having committed said one of said log records.
Claim 6
Dependent Claim
31 words
The system as recited in claim 1 wherein said transaction logger maintains said log records in a primary stable log, said secondary computer capable of synchronizing to said primary stable log.
Claim 7
Dependent Claim
17 words
The system as recited in claim 1 wherein a computer network couples said primary and secondary computers.
Claim 8
Dependent Claim
141 words
For use with a primary database residing on a primary computer, said primary computer being couplable to a secondary computer having a secondary database, a method of allowing said secondary computer to operate as a hot spare for said primary computer, comprising the steps of: maintaining log records of transactions involving persistent data in said primary database; transmitting a portion of said log records to said secondary computer to allow said secondary computer to commit said portion of said log records to said secondary database; designating a state of said primary and secondary computers with a first parameter associated with said primary and secondary databases; automatically redesignating said secondary database to function in a primary database mode upon failure of said primary database; and automatically redesignating said primary database to function in a secondary database mode upon resolution of said failure.
Claim 9
Dependent Claim
141 words
For use with a primary database residing on a primary computer, said primary computer being couplable to a secondary computer having a secondary database, a method of allowing said secondary computer to operate as a hot spare for said primary computer, comprising the steps of: maintaining log records of transactions involving persistent data in said primary database; transmitting a portion of said log records to said secondary computer to allow said secondary computer to commit said portion of said log records to said secondary database; designating a state of said primary and secondary computers with a first parameter associated with said primary and secondary databases; automatically redesignating said secondary database to function in a primary database mode upon failure of said primary database; and automatically redesignating said primary database to function in a secondary database mode upon resolution of said failure.
Claim 10
Dependent Claim
51 words
The method as recited in claim 7 wherein said step of transmitting comprises the step of transmitting all of said log records to said secondary computer to allow said secondary computer to commit said all of said log records to said secondary database, said secondary database thereby mirroring said primary database.
Claim 11
Dependent Claim
34 words
The method as recited in claim 7 further comprising the step of committing one of said log records without waiting until said secondary computer has acknowledged having committed said one of said log records.
Claim 12
Dependent Claim
34 words
The method as recited in claim 7 further comprising the step of waiting to commit one of said log records until said secondary computer has acknowledged having committed said one of said log records.
Claim 13
Dependent Claim
29 words
The method as recited in claim 7 further comprising the step of automatically redesignating said primary database to function in a secondary database mode upon resolution of said failure.
Claim 14
Dependent Claim
32 words
The method as recited in claim 7 further comprising the step of maintaining said log records in a primary stable log, said secondary computer capable of synchronizing to said primary stable log.
Claim 15
Dependent Claim
25 words
The method as recited in claim 7 wherein said step of transmitting is carried out over a computer network coupling said primary and secondary computers.
Claim 16
Dependent Claim
149 words
A database management system (DBMS), comprising: a primary database residing on a primary computer; a secondary database residing on a secondary computer coupled to said primary computer; and a system that allows said secondary database to mirror said primary database, including: a transaction logger, associated with said primary database, that maintains log records of transactions involving persistent data in said primary database, and a transaction processor, associated with said primary database, that transmits a portion of said log records to said secondary computer to allow said secondary computer to commit said portion of said log records to said secondary database, said secondary database thereby mirroring said primary database, said secondary database being able to, upon failure of said primary database, automatically redesignate to function in a primary database mode, said primary database being able to, upon resolution of said failure, automatically redesignate to function in a secondary database mode.
Claim 17
Dependent Claim
149 words
A database management system (DBMS), comprising: a primary database residing on a primary computer; a secondary database residing on a secondary computer coupled to said primary computer; and a system that allows said secondary database to mirror said primary database, including: a transaction logger, associated with said primary database, that maintains log records of transactions involving persistent data in said primary database, and a transaction processor, associated with said primary database, that transmits a portion of said log records to said secondary computer to allow said secondary computer to commit said portion of said log records to said secondary database, said secondary database thereby mirroring said primary database, said secondary database being able to, upon failure of said primary database, automatically redesignate to function in a primary database mode, said primary database being able to, upon resolution of said failure, automatically redesignate to function in a secondary database mode.
Claim 18
Dependent Claim
33 words
The DBMS as recited in claim 14 wherein said transaction processor commits one of said log records without waiting until said secondary computer has acknowledged having committed said one of said log records.
Claim 19
Dependent Claim
33 words
The DBMS as recited in claim 14 wherein said transaction processor waits to commit one of said log records until said secondary computer has acknowledged having committed said one of said log records.
Claim 20
Dependent Claim
31 words
The DBMS as recited in claim 14 wherein said transaction logger maintains said log records in a primary stable log, said secondary computer capable of synchronizing to said primary stable log.
Claim 21
Dependent Claim
17 words
The DBMS as recited in claim 14 wherein a computer network couples said primary and secondary computers.
Claim 22
Dependent Claim
46 words
The DBMS as recited in claim 14 wherein said transaction processor transmits all of said log records to said secondary computer to allow said secondary computer to commit said all of said log records to said secondary database, said secondary database thereby mirroring said primary database.
References Cited (Backward Citations)
US5257367A
Cited
US5140685A
Cited
US5212789A
Cited
US5388256A
Cited
US5499337A
Cited
US5555404A
Cited
US5504879A
Cited
US5933839A
Cited
US5963634A
Cited
US5651133A
Cited
US5720027A
Cited
US5924094A
Cited
US5991804A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-03-19 | 2004-09-18 | 2005-03-20 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-03-19 | 2008-09-18 | 2009-03-20 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-03-19 | 2012-09-18 | 2013-03-20 | $7700.00 | Window Closed / Lapsed |