Method of applying changes to a standby database system

A method for applying changes to a standby system is described in which multiple apply tasks or "slaves" are scheduled to changes from redo logs, especially those changes in large transactions, in parallel and as soon as they are encountered in the logs. To foster data convergence, a parti...

Full description

Saved in:
Bibliographic Details
Main Authors Demers, Alan J, Stamos, James William, Kaplan, Lewis S, Arora, Nimar
Format Patent
LanguageEnglish
Published 27.12.2005
Online AccessGet full text

Cover

Abstract A method for applying changes to a standby system is described in which multiple apply tasks or "slaves" are scheduled to changes from redo logs, especially those changes in large transactions, in parallel and as soon as they are encountered in the logs. To foster data convergence, a partial ordering may be imposed on the transactions so that those transactions that actually depend on others are forced to wait on the transactions they are dependent upon commit. To foster read consistency, synchronization points may be periodically established, at which points a read consistent state of the standby database system can be obtained-all without adversely impact the throughput of the system.
AbstractList A method for applying changes to a standby system is described in which multiple apply tasks or "slaves" are scheduled to changes from redo logs, especially those changes in large transactions, in parallel and as soon as they are encountered in the logs. To foster data convergence, a partial ordering may be imposed on the transactions so that those transactions that actually depend on others are forced to wait on the transactions they are dependent upon commit. To foster read consistency, synchronization points may be periodically established, at which points a read consistent state of the standby database system can be obtained-all without adversely impact the throughput of the system.
Author Stamos, James William
Demers, Alan J
Arora, Nimar
Kaplan, Lewis S
Author_xml – sequence: 1
  givenname: Alan J
  surname: Demers
  fullname: Demers, Alan J
– sequence: 2
  givenname: James William
  surname: Stamos
  fullname: Stamos, James William
– sequence: 3
  givenname: Lewis S
  surname: Kaplan
  fullname: Kaplan, Lewis S
– sequence: 4
  givenname: Nimar
  surname: Arora
  fullname: Arora, Nimar
BookMark eNrjYmDJy89L5WQw900tychPUchPU0gsKMipzMxLV0jOSMxLTy1WKMlXSFQoLknMS0mqVEhJLElMSixOVSiuLC5JzeVhYE1LzClO5YXS3AwKbq4hzh66pcUFiSWpeSXF8elFiSDKwMzSwsDSwsKYCCUAgs8wcA
ContentType Patent
CorporateAuthor Oracle International Corporation
CorporateAuthor_xml – name: Oracle International Corporation
DBID EFH
DatabaseName USPTO Issued Patents
DatabaseTitleList
Database_xml – sequence: 1
  dbid: EFH
  name: USPTO Issued Patents
  url: http://www.uspto.gov/patft/index.html
  sourceTypes: Open Access Repository
DeliveryMethod fulltext_linktorsrc
ExternalDocumentID 06980988
GroupedDBID EFH
ID FETCH-uspatents_grants_069809883
IEDL.DBID EFH
IngestDate Sun Mar 05 22:31:08 EST 2023
IsOpenAccess true
IsPeerReviewed false
IsScholarly false
Language English
LinkModel DirectLink
MergedId FETCHMERGED-uspatents_grants_069809883
OpenAccessLink https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/6980988
ParticipantIDs uspatents_grants_06980988
PatentNumber 6980988
PublicationCentury 2000
PublicationDate 20051227
PublicationDateYYYYMMDD 2005-12-27
PublicationDate_xml – month: 12
  year: 2005
  text: 20051227
  day: 27
PublicationDecade 2000
PublicationYear 2005
References Rastogi et al. (6205449) 20010300
Ganesh et al. (2002/0103816) 20020800
Copending U.S. Appl. No. 09/156,548 (1997-011-02), filed Sep. 17, 1998.
Copending U.S. Appl. No. 09/748,408 (1997-011-05 CON), filed Dec. 22, 2000.
Parker (6289357) 20010900
Copending U.S. Appl. No. 09/156,557 (1997-011-05), filed Sep. 17, 1998.
Mohan et al. (5170480) 19921200
Satoh et al. (5530855) 19960600
References_xml – year: 19921200
  ident: 5170480
  contributor:
    fullname: Mohan et al.
– year: 20010300
  ident: 6205449
  contributor:
    fullname: Rastogi et al.
– year: 20020800
  ident: 2002/0103816
  contributor:
    fullname: Ganesh et al.
– year: 20010900
  ident: 6289357
  contributor:
    fullname: Parker
– year: 19960600
  ident: 5530855
  contributor:
    fullname: Satoh et al.
Score 2.6398056
Snippet A method for applying changes to a standby system is described in which multiple apply tasks or "slaves" are scheduled to changes from redo logs, especially...
SourceID uspatents
SourceType Open Access Repository
Title Method of applying changes to a standby database system
URI https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/6980988
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV1NawIxEB1UBNtTSyv1o2UOvcaublez5-KyFCweWvAmm2TXi90VN1L8951JRHqpt5DAZEhI3gyZ9wLwzJJ0cSFjUVBLcMjAj4RaRBkBjs7DidHMd158TNOv1_dVtGpAeubCfNMxEjvypR4d6p2tXHElXe9-44UXf2aNwJLVB37KbZWZpSleprEMYimb0JQBl_bNk_QaOmSCQrbS1n9AI7mB9tL13kIjL-9gtnCfNWNVIL8aM70IPe22Rlthhi6rV0fkok0GF_Qqy_eAyfzzLRXnWdabPVevrIOTN2EXWpTF5w-AhnBQKaMoI9DU4LUIIzXOxhNtFGVVPej9a6Z_YWwAV15NlFk2Q2jZ_SF_JJy06sktwi9x-XNu
link.rule.ids 230,309,783,805,888,64375
linkProvider USPTO
linkToPdf http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV07T8MwED6VUvGYilpEefUGVtNHSElmaBQerTKA1C2K7YQFkqpxhfrve2ejigU2y5bOli37u9Pd9xnghiXpwiIIRUEtwS4DJwmV8DMCHJV7Y62Y7zybT-L3u-eFv2hAvOPCfNE1EktaS327rpemssWV9Ly7gxdO_Jk1AktWH_guP6tMJ7oYTMJgGAbBHuxzKoqL-6ZRfAyHZIScttLUv2AjakMrsb0n0MjLDtzP7HfNWBXIeWMmGKEj3tZoKszQxvVyg1y2yfCCTme5CxhN3x5isZsl_Vhx_Uo6_FmPdwpNiuPzM0BNSCillhQTKGrwbni-HGWjsdKS4qoe9P40c_7PWB8OkscofX2av1zAkZMWZcrNJTTNap1fEWgaeW33YwtHQXZq
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Apatent&rft.title=Method+of+applying+changes+to+a+standby+database+system&rft.inventor=Demers%2C+Alan+J&rft.inventor=Stamos%2C+James+William&rft.inventor=Kaplan%2C+Lewis+S&rft.inventor=Arora%2C+Nimar&rft.number=6980988&rft.date=2005-12-27&rft.externalDBID=n%2Fa&rft.externalDocID=06980988