Verfahren und Vorrichtung um eine verteilte Transaktion in einer verteilten Datenbank auszuführen

The present invention describes a method and apparatus that forces all parts of an update transaction to commit automatically using a two-phase commit. The present invention uses the two-phase commit messages to negotiate a system commit number (SCN) that is then recorded on each of the nodes as the...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: BAMFORD, ROGER, HALLMARK, GARY
Format: Patent
Sprache:ger
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator BAMFORD, ROGER
HALLMARK, GARY
description The present invention describes a method and apparatus that forces all parts of an update transaction to commit automatically using a two-phase commit. The present invention uses the two-phase commit messages to negotiate a system commit number (SCN) that is then recorded on each of the nodes as the logical point in time that the distributed transaction committed. The two-phase commit scheme of the present invention consists of a "prepare" phase and a "commit" phase. The transaction in the distributed database environment involves multiple participants (107A,...,107N) (databases). In the prepare phase, one of the N database participants (107N) is selected as the "commit point". The commit point (107N) includes the log (106N) into which the information is written that states the transaction has committed. The remaining N - 1 participants (107A,...,107N-1) enter a "prepare phase." In the prepare phase, the prepare participants lock their databases (105A,...,105N-1) and enter a state in which they are ready to roll back or commit to the transaction. The mid-point of the two-phase commit is the point at which the commit point database (105N) (nth participant) writes the commit transaction to its log (106N). In the second phase, the remaining participants (107A,...,107N-1) are informed to commit the transaction and release locks that have been set.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_DE69326186TT2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>DE69326186TT2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_DE69326186TT23</originalsourceid><addsrcrecordid>eNrjZEgKSy1KS8woSs1TKM1LUQjLLyrKTM4oKc1LVyjNVUjNzEtVKEstKknNzClJVQgpSswrTswuyczPU8jMA8sWIaTzFFwSgWRSYl62QmJpcVVp2uE9IIN5GFjTEnOKU3mhNDeDkptriLOHbmpBfnxqcUFicmpeakm8i6uZpbGRmaGFWUiIkTFRigB5ykBl</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Verfahren und Vorrichtung um eine verteilte Transaktion in einer verteilten Datenbank auszuführen</title><source>esp@cenet</source><creator>BAMFORD, ROGER ; HALLMARK, GARY</creator><creatorcontrib>BAMFORD, ROGER ; HALLMARK, GARY</creatorcontrib><description>The present invention describes a method and apparatus that forces all parts of an update transaction to commit automatically using a two-phase commit. The present invention uses the two-phase commit messages to negotiate a system commit number (SCN) that is then recorded on each of the nodes as the logical point in time that the distributed transaction committed. The two-phase commit scheme of the present invention consists of a "prepare" phase and a "commit" phase. The transaction in the distributed database environment involves multiple participants (107A,...,107N) (databases). In the prepare phase, one of the N database participants (107N) is selected as the "commit point". The commit point (107N) includes the log (106N) into which the information is written that states the transaction has committed. The remaining N - 1 participants (107A,...,107N-1) enter a "prepare phase." In the prepare phase, the prepare participants lock their databases (105A,...,105N-1) and enter a state in which they are ready to roll back or commit to the transaction. The mid-point of the two-phase commit is the point at which the commit point database (105N) (nth participant) writes the commit transaction to its log (106N). In the second phase, the remaining participants (107A,...,107N-1) are informed to commit the transaction and release locks that have been set.</description><edition>7</edition><language>ger</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2000</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20000427&amp;DB=EPODOC&amp;CC=DE&amp;NR=69326186T2$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25564,76547</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20000427&amp;DB=EPODOC&amp;CC=DE&amp;NR=69326186T2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>BAMFORD, ROGER</creatorcontrib><creatorcontrib>HALLMARK, GARY</creatorcontrib><title>Verfahren und Vorrichtung um eine verteilte Transaktion in einer verteilten Datenbank auszuführen</title><description>The present invention describes a method and apparatus that forces all parts of an update transaction to commit automatically using a two-phase commit. The present invention uses the two-phase commit messages to negotiate a system commit number (SCN) that is then recorded on each of the nodes as the logical point in time that the distributed transaction committed. The two-phase commit scheme of the present invention consists of a "prepare" phase and a "commit" phase. The transaction in the distributed database environment involves multiple participants (107A,...,107N) (databases). In the prepare phase, one of the N database participants (107N) is selected as the "commit point". The commit point (107N) includes the log (106N) into which the information is written that states the transaction has committed. The remaining N - 1 participants (107A,...,107N-1) enter a "prepare phase." In the prepare phase, the prepare participants lock their databases (105A,...,105N-1) and enter a state in which they are ready to roll back or commit to the transaction. The mid-point of the two-phase commit is the point at which the commit point database (105N) (nth participant) writes the commit transaction to its log (106N). In the second phase, the remaining participants (107A,...,107N-1) are informed to commit the transaction and release locks that have been set.</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2000</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZEgKSy1KS8woSs1TKM1LUQjLLyrKTM4oKc1LVyjNVUjNzEtVKEstKknNzClJVQgpSswrTswuyczPU8jMA8sWIaTzFFwSgWRSYl62QmJpcVVp2uE9IIN5GFjTEnOKU3mhNDeDkptriLOHbmpBfnxqcUFicmpeakm8i6uZpbGRmaGFWUiIkTFRigB5ykBl</recordid><startdate>20000427</startdate><enddate>20000427</enddate><creator>BAMFORD, ROGER</creator><creator>HALLMARK, GARY</creator><scope>EVB</scope></search><sort><creationdate>20000427</creationdate><title>Verfahren und Vorrichtung um eine verteilte Transaktion in einer verteilten Datenbank auszuführen</title><author>BAMFORD, ROGER ; HALLMARK, GARY</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_DE69326186TT23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>ger</language><creationdate>2000</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>BAMFORD, ROGER</creatorcontrib><creatorcontrib>HALLMARK, GARY</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>BAMFORD, ROGER</au><au>HALLMARK, GARY</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Verfahren und Vorrichtung um eine verteilte Transaktion in einer verteilten Datenbank auszuführen</title><date>2000-04-27</date><risdate>2000</risdate><abstract>The present invention describes a method and apparatus that forces all parts of an update transaction to commit automatically using a two-phase commit. The present invention uses the two-phase commit messages to negotiate a system commit number (SCN) that is then recorded on each of the nodes as the logical point in time that the distributed transaction committed. The two-phase commit scheme of the present invention consists of a "prepare" phase and a "commit" phase. The transaction in the distributed database environment involves multiple participants (107A,...,107N) (databases). In the prepare phase, one of the N database participants (107N) is selected as the "commit point". The commit point (107N) includes the log (106N) into which the information is written that states the transaction has committed. The remaining N - 1 participants (107A,...,107N-1) enter a "prepare phase." In the prepare phase, the prepare participants lock their databases (105A,...,105N-1) and enter a state in which they are ready to roll back or commit to the transaction. The mid-point of the two-phase commit is the point at which the commit point database (105N) (nth participant) writes the commit transaction to its log (106N). In the second phase, the remaining participants (107A,...,107N-1) are informed to commit the transaction and release locks that have been set.</abstract><edition>7</edition><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language ger
recordid cdi_epo_espacenet_DE69326186TT2
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Verfahren und Vorrichtung um eine verteilte Transaktion in einer verteilten Datenbank auszuführen
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-25T06%3A14%3A51IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=BAMFORD,%20ROGER&rft.date=2000-04-27&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EDE69326186TT2%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true