WIPO logo
Mobile | Deutsch | Español | Français | 日本語 | 한국어 | Português | Русский | 中文 | العربية |
PATENTSCOPE

Search International and National Patent Collections
World Intellectual Property Organization
Search
 
Browse
 
Translate
 
Options
 
News
 
Login
 
Help
 
Machine translation
1. (WO2005013155) ONE-PHASE COMMIT IN A SHARED-NOTHING DATABASE SYSTEM
Latest bibliographic data on file with the International Bureau   

Pub. No.:    WO/2005/013155    International Application No.:    PCT/US2004/024451
Publication Date: 10.02.2005 International Filing Date: 28.07.2004
Chapter 2 Demand Filed:    25.05.2005    
IPC:
G06F 9/50 (2006.01), G06F 17/30 (2006.01)
Applicants: ORACLE INTERNATIONAL CORPORATION [US/US]; 500 Oracle Parkway, Redwood Shores, CA 94065 (US) (For All Designated States Except US).
BAMFORD, Roger [US/US]; (US) (For US Only).
CHANDRASEKARAN, Sashikanth [IN/US]; (US) (For US Only).
PRUSCINO, Angelo [IT/US]; (US) (For US Only)
Inventors: BAMFORD, Roger; (US).
CHANDRASEKARAN, Sashikanth; (US).
PRUSCINO, Angelo; (US)
Agent: HICKMAN, Brian, D.; Hickman Palermo Truong & Becker LLP, Suite 550, 2055 Gateway Place, San Jose, CA 95110-1089 (US).
DENDORFER, Claus; Wachtershauser & Hartz, Weinstrasse 8, 80333 München (DE)
Priority Data:
60/492,019 01.08.2003 US
10/831,401 23.04.2004 US
Title (EN) ONE-PHASE COMMIT IN A SHARED-NOTHING DATABASE SYSTEM
(FR) EXECUTION MONOPHASE DANS UN SYSTEME DE BASE DE DONNEES SANS PARTAGE
Abstract: front page image
(EN)Techniques are provided for handling distributed transaction in shared-nothing database system where one or more of the nodes have access to a shared persistent storage. Rather than coordinate the distributed transaction using a two-phase commit protocol, the coordinator of the distributed transaction uses a one-phase commit protocol with those participants that have access to the transaction status information maintained by the coordinator. The transaction status information may reside, for example, in the redo log of the coordinator. In case that the coordinator fails, those participants can determine the state of the distributed transaction based on information stored on the shared disk. In addition, the coordinator is able to determine whether it is possible to commit the distributed transaction based on information that is stored on the shared disk by the participants, without those participants entering a formal 'prepared ' state.
(FR)L'invention concerne des techniques pour le traitement de transactions distribuées dans des systèmes de base de données sans partage, un ou plusieurs noeuds ayant accès à une mémoire persistante partagée. Plutôt que de coordonner la transaction distribuée avec un protocole d'exécution biphasé, le coordinateur de ladite transaction utilise un protocole d'exécution monophasé, avec les participants accédant à l'information d'état de transaction maintenue par le coordinateur. L'information en question peut résider par exemple dans les fichiers redo-log du coordinateur. Si le coordinateur échoue, ces participants peuvent déterminer l'état de la transaction distribuée sur la base de l'information enregistrée dans le disque partagé par les participants, sans obligation pour eux d'établir un état «préparé» formel.
Designated States: AE, AG, AL, AM, AT, AU, AZ, BA, BB, BG, BR, BW, BY, BZ, CA, CH, CN, CO, CR, CU, CZ, DE, DK, DM, DZ, EC, EE, EG, ES, FI, GB, GD, GE, GH, GM, HR, HU, ID, IL, IN, IS, JP, KE, KG, KP, KR, KZ, LC, LK, LR, LS, LT, LU, LV, MA, MD, MG, MK, MN, MW, MX, MZ, NA, NI, NO, NZ, OM, PG, PH, PL, PT, RO, RU, SC, SD, SE, SG, SK, SL, SY, TJ, TM, TN, TR, TT, TZ, UA, UG, US, UZ, VC, VN, YU, ZA, ZM, ZW.
African Regional Intellectual Property Organization (BW, GH, GM, KE, LS, MW, MZ, NA, SD, SL, SZ, TZ, UG, ZM, ZW)
Eurasian Patent Organization (AM, AZ, BY, KG, KZ, MD, RU, TJ, TM)
European Patent Office (AT, BE, BG, CH, CY, CZ, DE, DK, EE, ES, FI, FR, GB, GR, HU, IE, IT, LU, MC, NL, PL, PT, RO, SE, SI, SK, TR)
African Intellectual Property Organization (BF, BJ, CF, CG, CI, CM, GA, GN, GQ, GW, ML, MR, NE, SN, TD, TG).
Publication Language: English (EN)
Filing Language: English (EN)