<html version="-//w3c//dtd html 4.01 transitional//en"><body lang=en>﻿ <meta content="text/html; charset=utf-8"http-equiv=Content-Type><meta content=width=device-width,initial-scale=1.0 name=viewport><link href=http://common.sensagent.eu/online-2010/css/all.2013-05.wide.css rel=stylesheet><link href=http://common.sensagent.eu/online-2010/css/wiki.css rel=stylesheet><link href=http://common.sensagent.eu/online-2010/css/print.css media=print rel=stylesheet><script src=http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js></script><script src=http://common.sensagent.eu/_static/js/jquery.cookie.js></script><title>
   DATABASE TRANSACTION : definition of DATABASE TRANSACTION and synonyms of DATABASE TRANSACTION (English)
  </title><meta content="Definitions of DATABASE TRANSACTION, synonyms, antonyms, derivatives of DATABASE TRANSACTION, analogical dictionary of DATABASE TRANSACTION (English)"name=description><meta content=all name=robots><link href="http://dictionary.sensagent.com/DATABASE TRANSACTION/en-en/"rel=canonical><link href="http://m.sensagent.com/en/definition-synonym/define.xhtml?w=DATABASE TRANSACTION&sl=en&tl1=en"media=handheld rel=alternate><link href="http://dictionnaire.sensagent.com/DATABASE TRANSACTION/en-en/"hreflang=fr rel=alternate type=text/html><link href="http://dictionary.sensagent.com/DATABASE TRANSACTION/en-en/"hreflang=en rel=alternate type=text/html><link href="http://diccionario.sensagent.com/DATABASE TRANSACTION/en-en/"hreflang=es rel=alternate type=text/html><link href="http://dicionario.sensagent.com/DATABASE TRANSACTION/en-en/"hreflang=pt rel=alternate type=text/html><link href="http://dictionary.sensagent.com/DATABASE TRANSACTION/en-en/"hreflang=x-default rel=alternate type=text/html><meta content=en name=language><meta content=en http-equiv=content-Language><meta content="Yann Picand, Dominique Dutoit"name=author><meta content="sensagent - 2005-2015"name=copyright><meta content="60 days"name=revisit-after><meta content=sensagent name=publisher><meta content=general name=rating><meta content=dictionary name=category><meta content=01012005 name=Date-Creation-ddmmyyyy><style>#C_DAT_menu .item {line-height:22px;}</style><script>function popUp(URL) { day = new Date(); id = day.getTime(); eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=628,left = 62,top = 62');");}
function show ( nElement ) { if (nElement) { nElement.style.display="block"; nElement.style.visibility = "visible"; } }
function showById ( nId ) { try { show ( document.getElementById(nId) ); } catch (e) { alert ( "showById() : " + nId ); } }
function hide ( nElement ) { if ( nElement ) { nElement.style.display="none"; nElement.style.visibility = "hidden"; } }
function hideById ( nId ) { try { hide ( document.getElementById(nId) ); } catch (e) { alert ( "hideById() : " + nId ); } }
function getOffsetLeft(nElement) { if (!nElement) return 0; return nElement.offsetLeft + getOffsetLeft(nElement.offsetParent); }
function getOffsetTop(nElement) { if (!nElement) return 0; return nElement.offsetTop + getOffsetTop(nElement.offsetParent); }
var myOpenDlg  = '';
var bDisplayed = false;
//var mouseUpCount = 0;
//function mouseUpHandler() { mouseUpCount++; document.status = "mouseUpHandler : " + mouseUpCount; return hideOpenedDlg(); }
function hideOpenedDlg() { if ( bDisplayed ) { hide(document.getElementById(myOpenDlg)); bDisplayed = false; myOpenDlg  = ''; } return false; }
function showDlg ( nId, nX, nY, nMove ) { var d=document.getElementById(nId); if (d) { if (nMove) { d.style.top  = "115px";  d.style.top  = nY+"px"; d.style.left = nX+"px"; }; show(d); bDisplayed = true; myOpenDlg  = nId; }; return false; }
// Navigator 4.0x
//if (window.Event) document.captureEvents(Event.MOUSEUP); 
//if ( document.addEventListener ) document.addEventListener("mouseup", mouseUpHandler, false);
document.onmouseup = mouseUpHandler;
function closeOpenDlg(nId,nMove,nParent) { if (!bDisplayed) {showDlg ( nId, getOffsetLeft(nParent), getOffsetTop(nParent)+20, nMove );} else { if ( nId != myOpenDlg ) { hideOpenedDlg(); showDlg(nId, getOffsetLeft(nParent), getOffsetTop(nParent)+20, nMove ); } else hideOpenedDlg(); }; return false; }

//function setAdd() { var addif = document.getElementById("ptRAdd"); if ( addif ) addif.src='http://www.sensagent.com/alexandria-advertising/managed/getAddAlexandria.jsp?p=SQU-300x250-DICO&bgc=%FFFFFF&w=FRAMBOISIER&amp;sl=fr&amp;c=FR'; }</script><script src=http://common.sensagent.eu/online-2010/scripts/alexandria-dictionary.en.js></script><script src=http://common.sensagent.eu/online-2010/scripts/alexandria-dictionary.en.js></script><style>body, div, h1, p { margin: 0; padding: 0;}
body { background: none repeat scroll 0 0 #FFFFFF; font-size: 12px;}
#C_ {width:800px;margin:0px auto;}

#C_TOP_MN_CONF { background-color: #883333; color: #FFFFFF; font-size: 90%; font-weight: bold; margin: 10px 0; padding: 2px 0; text-align: left; font-family: Arial,Helvetica,sans-serif;}
#C_TOP_MN_CONF .item { color: #FFFFFF; margin-right: 3px; padding: 0 3px;}
#C_TOP_MN_CONF .item a { color: #FFFFFF;}
#C_TOP_MN_CONF .arrowr { margin-right: 3px;}

#LOGO { font-family: Arial,Helvetica,sans-serif; font-size: 50px; font-variant: small-caps; line-height: 80px; text-align: center;}
.sensA, .sensAB { color: #7494B2; font-size: 152%; font-variant: normal;}

#socialnetdiv {margin:0px auto;width:60%;padding:0px auto;font-size:12px;padding:0px auto;text-align:center;}

#C_SF { border: 1px solid #888888;font-family: Arial,Helvetica,sans-serif;margin-top:10px;}
#C_SF_b2 { background-color: #E9E9E9; border: 1px solid #F4F3F3; padding: 3px 20px; text-align: left;}
#C_SF form { padding: 5px;}
td.SFinput {width:90%;}
table.SF {width:100%;}
#SF_wording { color: #030028; font-size: 18px; font-weight: bold; height: 25px; margin: 0 6px 6px 0; padding: 1px 2px; text-align: left; vertical-align: 0; width: 455px;}
button.language { cursor: pointer; width: 140px;}
td.SFbutton {width:30%;}
#SF_button { float: right; font-size: 18px; height: 60px;font-family:inherit;}
#SF_ .SF_arrow {float:none;}

#SLList, #TLList {display:none}
div.languages span { float:left;margin-right:10px;width:80px; border: 1px solid #FFFFFF;color: #515198;cursor: pointer;font-family: Arial,Helvetica,sans-serif;padding: 2px 30px 2px 6px;}
div.languages span.highlighted { background-color: #FFFF00; border: 1px solid #FFFF00;}
.languages span:hover {border:1px dotted #808080;}
.languages span.selectedsl, .languages span.selectedtl {background-color:yellow;font-weight:bold;color:black}

.blockset {padding-top:5px;float:left;width:45%}
.blockset .block {border:1px solid black;width:95%;margin:5px;display:inline-block;}
.blockset .btitle {background-color:#444;padding:1% 1% 2% 2%;font-weight:bold;font-size:120%;color:white;letter-spacing:3px;}
.blockset .bcontent {margin:5px;}

.AlertPubIns2 {width:728px;color: #000000; font-family: Arial,Helvetica,sans-serif;font-size: 8px;font-weight: bold;margin: 0;padding: 0;text-align: right;margin-top:20px;}
div.addInside {margin-top:15px;margin-bottom:15px;}
.synsetlink {margin-left:10px;font-weight:bold;cursor:pointer;}

div.idefsall {border: 1px dotted black;margin:10px 0px;padding:10px;width:80%;}
div.infldefs {margin-left:10px;margin-bottom:10px;}
.infldefs .def {margin-left:0px;}
.infldefs .entry {color: #515181; font-size: 120%; font-weight: bold;}
.def .lemma {color:darkblue;font-weight:bold;font-size:110%;}
.def .mode {color:darkgreen;}
.def .tense {color:darkred;}

.cwblock { padding:10px; float:left; }
.cwlink { line-height:22px;}


@media (max-width: 799px) {
div.idefsall {margin:5px;padding:5px;width:90%;}
}</style><style>#C_ {margin:0px;}
 @media (max-width: 500px) {
  .hidden-phone {display:none;}
 }</style><script>function getDimensions() {
 var winW = 630, winH = 460;
 if (document.body && document.body.offsetWidth) {
  winW = document.body.offsetWidth;
  winH = document.body.offsetHeight;
 }
 if (document.compatMode=='CSS1Compat' && document.documentElement && document.documentElement.offsetWidth ) {
  winW = document.documentElement.offsetWidth;
  winH = document.documentElement.offsetHeight;
 }
 if (window.innerWidth && window.innerHeight) {
  winW = window.innerWidth;
  winH = window.innerHeight;
 }
 return {'w':winW,'h':winH};
}

function setMatomyAdInside(nConf) {
 if (SENSAGENT_ADDS['dim']['w'] > 800 ) {
  // 1712629
  if (nConf['ad_slot'] == '1422365' ) nConf['position']='above'; 
  if ('position' in nConf) document.write('<SCR'+'IPT SRC="http://ib.adnxs.com/ttj?id='+nConf["ad_slot"]+'&referrer=sensagent.com&position='+nConf['position']+'" TYPE="text/javascript"></SCR'+'IPT>');
  else document.write('<SCR'+'IPT SRC="http://ib.adnxs.com/ttj?id='+nConf["ad_slot"]+'&referrer=sensagent.com" TYPE="text/javascript"></SCR'+'IPT>');
 }
}

function setGoogleAdInside(nConf) {
 google_ad_client = "ca-pub-5638131742820545";
 adWidth = SENSAGENT_ADDS['dim']['w'];
 if (nConf['k'] == 'BAN') {
  if ( adWidth >= 728 ) google_ad_size = ["728", "90"]; /* Leaderboard 728x90 */
  else if ( adWidth >= 468 ) google_ad_size = ["468", "60"]; /* Banner (468 x 60) */
//  else if ( adWidth >= 336 ) google_ad_size = ["336", "280"]; /* Large Rectangle (336 x 280) */
//  else if ( adWidth >= 300 ) google_ad_size = ["300", "250"]; /* Medium Rectangle (300 x 250) */
  else if ( adWidth >= 250 ) google_ad_size = ["250", "250"]; /* Square (250 x 250) */
  else if ( adWidth >= 200 ) google_ad_size = ["200", "200"]; /* Small Square (200 x 200) */
  else if ( adWidth >= 180 ) google_ad_size = ["180", "150"]; /* Small Rectangle (180 x 150) */
  else google_ad_size = ["125", "125"]; /* Button (125 x 125) */
 }
 if (nConf['k'] == 'SQU') {
  if ( adWidth >= 728 ) google_ad_size = ["336", "280"]; /* Leaderboard 728x90 */
  else if ( adWidth >= 468 ) google_ad_size = ["300", "250"]; /* Banner (468 x 60) */
  //else if ( adWidth >= 336 ) google_ad_size = ["336", "280"]; /* Large Rectangle (336 x 280) */
  else if ( adWidth >= 300 ) google_ad_size = ["300", "250"]; /* Medium Rectangle (300 x 250) */
  else if ( adWidth >= 250 ) google_ad_size = ["250", "250"]; /* Square (250 x 250) */
  else if ( adWidth >= 200 ) google_ad_size = ["200", "200"]; /* Small Square (200 x 200) */
  else if ( adWidth >= 180 ) google_ad_size = ["180", "150"]; /* Small Rectangle (180 x 150) */
  else google_ad_size = ["125", "125"]; /* Button (125 x 125) */
 }
 
 if (nConf['k'] == 'MBAN') {
  if ( adWidth < 700 ) google_ad_size = ["320", "100"]; /* Banner (320 x 100) */
  else google_ad_size = ["-1", "-1"]; /* nothing */
 }
 
 if ( google_ad_size[0] != "-1") {
  //"3044526521";
  google_ad_slot = nConf['ad_slot'];
 
  document.write ('<ins class="adsbygoogle" style="display:inline-block;width:'
   + google_ad_size[0] + 'px;height:'
   + google_ad_size[1] + 'px" data-ad-client="'
   + google_ad_client + '" data-ad-slot="'
   + google_ad_slot + '"></ins>'
  );
  (adsbygoogle = window.adsbygoogle || []).push({});
  document.write ('<scr'+'ipt async src="http://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></scr'+'ipt>');
 }
}

 var SENSAGENT_ADDS = {'debug':false,'places':[],'nogoogle':true};
 SENSAGENT_ADDS['dim'] = getDimensions();
 
 SENSAGENT = {}
 SENSAGENT['slid']='en';
 SENSAGENT['tlid']='en';
 function setSourceLanguage2() { $("#TLList").hide(); $("#SLList").toggle();}
 function setTargetLanguage2() { $("#SLList").hide(); $("#TLList").toggle();}
 function search() { 
  _w = $('#SF_wording').val();
  if ( _w.length > 0 ) document.location = '/'+$('#SF_wording').val()+'/'+SENSAGENT['slid']+'-'+SENSAGENT['tlid']+'/'; 
 }
 
$(document).ready(function(){
 $("#SLList span").click(function(){
  $("#SLList").hide();
  $("#SF_sl-wording").html($(this).html());
  $("#SLList span[data-lid='"+SENSAGENT['slid']+"']").removeClass('selectedsl'); 
  SENSAGENT['slid']=$(this).attr('data-lid');
  $(this).addClass('selectedsl'); 
 });
 $("#TLList span").click(function(){
  $("#TLList").hide();
  $("#SF_tl-wording").html($(this).html());
  $("#TLList span[data-lid='"+SENSAGENT['tlid']+"']").removeClass('selectedtl'); 
  SENSAGENT['tlid']=$(this).attr('data-lid');
  $(this).addClass('selectedtl'); 
 });
 $("#SF_swap").click(function(){
  $("#TLList").hide();
  $("#SLList").hide();
  _tampon=SENSAGENT['slid'];
  SENSAGENT['slid']=SENSAGENT['tlid'];
  SENSAGENT['tlid']=_tampon;
  _tampon=$("#SF_sl-wording").html();
  $("#SF_sl-wording").html($("#SF_tl-wording").html());
  $("#SF_tl-wording").html(_tampon);
  _slspan = $("#SLList span[data-lid='"+SENSAGENT['tlid']+"']");
  _tlspan = $("#TLList span[data-lid='"+SENSAGENT['slid']+"']");
  _slspan.removeClass('selectedsl');
  _tlspan.removeClass('selectedtl');
  _slspan = $("#SLList span[data-lid='"+SENSAGENT['slid']+"']");
  _tlspan = $("#TLList span[data-lid='"+SENSAGENT['tlid']+"']");
  _slspan.addClass('selectedsl');
  _tlspan.addClass('selectedtl');
 });
 $("#SLList span[data-lid='"+SENSAGENT['slid']+"']").addClass('selectedsl'); 
 $("#TLList span[data-lid='"+SENSAGENT['tlid']+"']").addClass('selectedtl'); 
// $('#SF_wording').focus();
});</script><script>function popUp(URL) {
 day = new Date();
 id = day.getTime();
 eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=628,left = 62,top = 62');");
} 
function show ( nElement ) { if (nElement) { nElement.style.display="block"; nElement.style.visibility = "visible"; } }
function showById ( nId ) { try { show ( document.getElementById(nId) ); } catch (e) { alert ( "showById() : " + nId ); } }
function hide ( nElement ) { if ( nElement ) { nElement.style.display="none"; nElement.style.visibility = "hidden"; } }
function hideById ( nId ) { try { hide ( document.getElementById(nId) ); } catch (e) { alert ( "hideById() : " + nId ); } }
function getOffsetLeft(nElement) { if (!nElement) return 0; return nElement.offsetLeft + getOffsetLeft(nElement.offsetParent); }
function getOffsetTop(nElement) { if (!nElement) return 0; return nElement.offsetTop + getOffsetTop(nElement.offsetParent); }
function hideOpenedDlg() { if ( bDisplayed ) { hide(document.getElementById(myOpenDlg)); bDisplayed = false; myOpenDlg  = ''; } return false; }
function showDlg ( nId, nX, nY, nMove ) { var d=document.getElementById(nId); if (d) { if (nMove) { d.style.top  = "115px";  d.style.top  = nY+"px"; d.style.left = nX+"px"; }; show(d); bDisplayed = true; myOpenDlg  = nId; }; return false; }</script><link href=http://common.sensagent.eu/_static/rd.css rel=stylesheet><style>#F_ {margin-top:20px;}
@media (max-width: 799px) {
 button.language {width:auto;}
 .addthis_counter {display:none important!;}
} 

@media (max-width: 650px) {
 .blockset {width:90%}
}

@media  (max-width: 600px) {
 a {line-height:150%;}
 body {font-size:14px;}
 #LOGO { font-size: 30px; line-height: 35px;}
 #C_DAT_menu {display:none;}
}

@media (max-width: 800px) {
 #C_DAT_menu {width:100%;}
 .AlertPubIns2 {width:90%;}
 div.languages span {font-size:120%;width:22%;line-height:150%;}
 .l01, .l03, .l06, .l08, .l09, .l11, .l14, .l16, .l17, .l19, .l22, .l24, .l25, .l27, .l30, .l32, .l33, .l35 {background-color:#F5F5DC;} 
 .languages span.selectedsl, .languages span.selectedtl {color:black;font-weight:bold;}
 .l01, .l03, .l05, .l07, .l09, .l11, .l13, .l15, .l17, .l19, .l21, .l23, .l25, .l27, .l29, .l31, .l33, .l35, .l37 {background-color:#F5F5DC;}
 .l02, .l04, .l06, .l08, .l10, .l12, .l14, .l16, .l18, .l20, .l22, .l24, .l26, .l28, .l30, .l32, .l34, .l36 {background-color:#F5F5F5;} 
}

@media (min-width: 401px) and (max-width: 650px) {
 div.languages span {font-size:120%;width:27%;line-height:150%;margin:0px 1%; padding:0px 0px 0px 2%;}
}

@media  (max-width: 600px) {
 .languages {font-size:100%;line-height:120%;padding-top:5px;background-color:#FFF;}
 .languages span {float:left;width:45%;padding-left:5%;border:1px dotted black;margin:2px 1%;text-align:center;padding-left:0%;}
}

@media (min-width: 300px) and (max-width: 400px) {
 div.languages span {font-size:120%;width:33%;line-height:150%;margin-left:1%; margin-right:1%;padding-left:2%;}
 .l01, .l04, .l05, .l08, .l09, .l12, .l13, .l16, .l17, .l20, .l21, .l24, .l25, .l28, .l29, .l32, .l33, .l36, .l37 {background-color:#F5F5DC;}
 .l02, .l03, .l06, .l07, .l10, .l11, .l14, .l15, .l18, .l19, .l22, .l23, .l26, .l27, .l30, .l31, .l34, .l35, .l38 {background-color:#F5F5F5;}
}
@media (max-width: 300px) {
 div.languages span {font-size:120%;width:90%;line-height:150%;margin-left:1%; margin-right:1%;padding-left:5%;}
}

@media (max-width: 400px) {
 #socialnetdiv {display:none;}
}

@media (max-width: 240px) {
}

span.s {display:none}

#bodyContent {font-family:sans-serif;font-size:1.1em;line-height:1.8em;}
/*  */
#bodyContent a {text-decoration:none;color:#345472;}
#bodyContent a:hover {text-decoration:underline;}
.wikiFooter {font-family:sans-serif;font-size:12px;line-height:1.5em;}
.phrases {line-height:1.8em;}</style><link href=http://common.sensagent.eu/_static/css/userdef.css rel=stylesheet><style>.entryLittre .pron {font-size:80%}
 .mw-editsection {display:none;}
 .google_inside {margin:10px 0px 10px 10px;}
 .ebiteminfo {cursor:pointer;}
  #CR_ {float:right;}
  .AlertPubInside {color: #000000; font-family: Arial,Helvetica,sans-serif;font-size: 8px;font-weight: bold;margin: 0;padding: 0;text-align: center;margin-top:20px;}
  .wsep { margin:0px 5px;}
  .se .link {font-size:110%;font-weight:bold;margin-top:5px;}
  .se .extract {margin-left:10px;}
.synsetlink, .csynsetlink {margin-left:10px;font-weight:bold;cursor:pointer;}
.divTranslations h2.entry, .divSynonyms h2.entry {margin-top:10px;}
.curHand {cursor:pointer;}
  
  @media (max-width: 650px) {
   .sensWiki {display:none;}
  }
  

#cookie_mess { background-color: rgba(17, 69, 108, 0.8); bottom: 0; color: #fff; padding: 10px; position: fixed; display: none; width: 100%; z-index: 30; font-family:arial; font-size:1em;}
#cookie_mess p {width:95%; margin-bottom:10px;}
#cookie_mess input { background-color: rgba(17, 69, 108, 0.5); border: 1px solid #ddd; color: #ddd; cursor: pointer; margin: 0 10px; padding: 3px;}
#cookie_mess input:hover { background-color: rgba(17, 69, 108, 0.8);}
#cookie_mess a:hover, #cookie_mess input:hover { border-color: #fff; color: #fff;}</style><script>function dCesar(v,k,l) { _ls = []; for (var i=0; i<v.length; i++) _ls.push(l[(l.indexOf(v[i])-l.indexOf(k[i])+l.length + 1) % l.length]); return _ls.join("");}; 
function dCesar_DITREES(v,k) { return dCesar(v,k,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'); };
function hide_leftsidepub() { $('#lsad').hide(); }

$(document).ready(function(){
 $(".synsetlink").click(function(){
  _didom = '/';
 _didom = 'http://analogical-dictionary.sensagent.com/';

  _diurl = _didom +$(this).attr('data-bid')+'/ML-'+$(this).attr('data-sl')+'-'+$(this).attr('data-tl')+'/';
  document.location.href = _diurl;
 });
 $(".csynsetlink").click(function(){
  _cbid = $(this).attr('data-cbid');
  _ckey = $(this).parent().parent().attr('data-bidk');
  _bid = dCesar_DITREES(_cbid,_ckey);
  document.location = '/'+_bid+'/ML-'+$(this).attr('data-sl')+'-'+$(this).attr('data-tl')+'/';
 });
});

function popUp(URL) {
 day = new Date();
 id = day.getTime();
 eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=628,left = 62,top = 62');");
} 
function searchEbay3(nElt) {
 popUp(nElt.getAttribute('hr')) 
}
function searchEbay2(nElt) {
  var win=window.open(nElt.getAttribute('hr'), '_blank');
  win.focus();  
}</script><div id=contentAll><div id=contentCol><div id=CR_><div id=R_></div><div id=C_><div id=C_TOP><div id=C_TOP_MN><div id=C_SF><div id=C_SF_b2><form action=javascript:search() id=SF_><table class=SF><tbody><tr><td class=SFinput><input value="DATABASE TRANSACTION"id=SF_wording name=w onfocus=this.select()> <br> <button onclick="setSourceLanguage2(); return false;"title="choose source language"class=language type=button><span id=SF_sl-wording> English </span> <span class=SF_arrow> ▼ </span></button> <span id=SF_arrow>  »  </span> <button onclick="setTargetLanguage2(); return false;"title="choose target language"class=language type=button><span id=SF_tl-wording> English </span> <span class=SF_arrow> ▼ </span></button> <button title="swap languages"class=SF_swap id=SF_swap type=button>↔</button> <input id=SF_sl-id name=sl readonly type=hidden value=en> <input id=SF_tl-id name=tl1 readonly type=hidden value=en><td class=SFbutton><button id=SF_button name=Abutton1 title=search><i class=icon-SF> </i> <span class=subtitle> search </span></button></table></form></div><div class=languages id=SLList><span class=l01 data-lid=ar> Arabic </span><span class=l02 data-lid=bg> Bulgarian </span><span class=l03 data-lid=zh> Chinese </span><span class=l04 data-lid=hr> Croatian </span><span class=l05 data-lid=cs> Czech </span><span class=l06 data-lid=da> Danish </span><span class=l07 data-lid=nl> Dutch </span><span class=l08 data-lid=en> English </span><span class=l09 data-lid=et> Estonian </span><span class=l10 data-lid=fi> Finnish </span><span class=l11 data-lid=fr> French </span><span class=l12 data-lid=de> German </span><span class=l13 data-lid=el> Greek </span><span class=l14 data-lid=he> Hebrew </span><span class=l15 data-lid=hi> Hindi </span><span class=l16 data-lid=hu> Hungarian </span><span class=l17 data-lid=is> Icelandic </span><span class=l18 data-lid=id> Indonesian </span><span class=l19 data-lid=it> Italian </span><span class=l20 data-lid=ja> Japanese </span><span class=l21 data-lid=ko> Korean </span><span class=l22 data-lid=lv> Latvian </span><span class=l23 data-lid=lt> Lithuanian </span><span class=l24 data-lid=mg> Malagasy </span><span class=l25 data-lid=no> Norwegian </span><span class=l26 data-lid=fa> Persian </span><span class=l27 data-lid=pl> Polish </span><span class=l28 data-lid=pt> Portuguese </span><span class=l29 data-lid=ro> Romanian </span><span class=l30 data-lid=ru> Russian </span><span class=l31 data-lid=sr> Serbian </span><span class=l32 data-lid=sk> Slovak </span><span class=l33 data-lid=sl> Slovenian </span><span class=l34 data-lid=es> Spanish </span><span class=l35 data-lid=sv> Swedish </span><span class=l36 data-lid=th> Thai </span><span class=l37 data-lid=tr> Turkish </span><span class=l38 data-lid=vi> Vietnamese </span></div><div class=languages id=TLList><span class=l01 data-lid=ar> Arabic </span><span class=l02 data-lid=bg> Bulgarian </span><span class=l03 data-lid=zh> Chinese </span><span class=l04 data-lid=hr> Croatian </span><span class=l05 data-lid=cs> Czech </span><span class=l06 data-lid=da> Danish </span><span class=l07 data-lid=nl> Dutch </span><span class=l08 data-lid=en> English </span><span class=l09 data-lid=et> Estonian </span><span class=l10 data-lid=fi> Finnish </span><span class=l11 data-lid=fr> French </span><span class=l12 data-lid=de> German </span><span class=l13 data-lid=el> Greek </span><span class=l14 data-lid=he> Hebrew </span><span class=l15 data-lid=hi> Hindi </span><span class=l16 data-lid=hu> Hungarian </span><span class=l17 data-lid=is> Icelandic </span><span class=l18 data-lid=id> Indonesian </span><span class=l19 data-lid=it> Italian </span><span class=l20 data-lid=ja> Japanese </span><span class=l21 data-lid=ko> Korean </span><span class=l22 data-lid=lv> Latvian </span><span class=l23 data-lid=lt> Lithuanian </span><span class=l24 data-lid=mg> Malagasy </span><span class=l25 data-lid=no> Norwegian </span><span class=l26 data-lid=fa> Persian </span><span class=l27 data-lid=pl> Polish </span><span class=l28 data-lid=pt> Portuguese </span><span class=l29 data-lid=ro> Romanian </span><span class=l30 data-lid=ru> Russian </span><span class=l31 data-lid=sr> Serbian </span><span class=l32 data-lid=sk> Slovak </span><span class=l33 data-lid=sl> Slovenian </span><span class=l34 data-lid=es> Spanish </span><span class=l35 data-lid=sv> Swedish </span><span class=l36 data-lid=th> Thai </span><span class=l37 data-lid=tr> Turkish </span><span class=l38 data-lid=vi> Vietnamese </span></div><p style=clear:left;></div></div></div><div id=C_DAT><div id=C_DAT_menu><a href="http://www.sensagent.com/en/anagrams-dictionary/search-anagrams.jsp?w=DATABASE TRANSACTION&tl=en&dl=en"class=item>  anagrams  </a><a class=item href=http://crosswords.sensagent.com/>  crosswords  </a><a title="wikipedia DATABASE TRANSACTION"class=item href=#anchorWiki>  wikipedia  </a><a href="http://www.sensagent.com/en/ebay/search-items.html?w=DATABASE TRANSACTION"class=item>  Ebay  </a></div><div style=margin-top:15px;height:40px;overflow:hidden;><div class="addthis_toolbox addthis_default_style"><a style="margin:0px 15px 0px 0px;"class=addthis_button_facebook_like fb:like:href=http://www.facebook.com/pages/Sensagentcom/481170961895640 fb:like:layout=button_count fb:like:locale=en_US fb:like:width=200> </a><a class=addthis_button_google_plusone g:plusone:href=/ g:plusone:size=medium> </a><a class=addthis_button_tweet tw:url=/> </a></div><script src=//s7.addthis.com/js/300/addthis_widget.js#pubid=memodata></script></div><div style=clear:left;height:1px;></div><div class=divInfos><a id=anchorDefinitions style=font-size:1px;line-height:1px;margin:0px;padding:0px;> </a><h2 class=title>definition - DATABASE TRANSACTION</h2><p style="margin:5px 0px 0px 10px"><img src=http://common.sensagent.eu/online-2010/images/fleche.gd.bleu.3.gif> <a href=#anchorWiki> definition </a> of Wikipedia<div id=INSIDE1><p class=AlertPubInside>   Advertizing ▼<div id=INSIDE1><script>setGoogleAdInside({'k':'BAN','ad_slot':'5134909729'});</script></div></div><a id=anchorWiki style=font-size:1px;line-height:1px;margin:0px;padding:0px;> </a><p class=title>Wikipedia<div id=bodyContent><h1 class=firstHeading id=firstHeading><span dir=auto> Database transaction </span></h1>                     <div class=mw-content-ltr dir=ltr id=mw-content-text lang=en><table class="metadata plainlinks ambox ambox-content ambox-Refimprove"><tbody><tr><td class=mbox-image><div style="width: 52px;"><img alt height=39 src=http://bin.sensegates.com/s/Q/u/e/Question_book-new.svg.png width=50></div><td class=mbox-text><span class=mbox-text-span> This article <b> needs additional <a title="Wikipedia:Citing sources"href=http://en.wikipedia.org/wiki/Wikipedia:Citing_sources#Inline_citations> citations </a> for <a href=http://en.wikipedia.org/wiki/Wikipedia:Verifiability title=Wikipedia:Verifiability> verification </a> </b> . <span class=hide-when-compact> Please help <a class="external text"href=http://en.wikipedia.org/w/index.php?title=Database_transaction&action=edit> improve this article </a> by adding citations to <a title="Wikipedia:Identifying reliable sources"href=http://en.wikipedia.org/wiki/Wikipedia:Identifying_reliable_sources> reliable sources </a> . Unsourced material may be <a title="Template:Citation needed"href=http://en.wikipedia.org/wiki/Template:Citation_needed> challenged </a> and <a href=http://en.wikipedia.org/wiki/Wikipedia:Verifiability#Burden_of_evidence title=Wikipedia:Verifiability> removed </a> . </span> <small> <i> (August 2010) </i> </small> </span></table><p>A <b> transaction </b> comprises a unit of work performed within a <a href="/Database management system/en-en/"title="Database management system"> database management system </a> (or similar system) against a database, and treated in a coherent and reliable way independent of other transactions. Transactions in a database environment have two main purposes:<ol><li>To provide reliable units of work that allow correct recovery from failures and keep a database consistent even in cases of system failure, when execution stops (completely or partially) and many operations upon a database remain uncompleted, with unclear status.<li>To provide isolation between programs accessing a database concurrently. If this isolation is not provided the programs outcome are possibly erroneous.</ol><p>A database transaction, by definition, must be <a href="/Atomicity (database systems)/en-en/"title="Atomicity (database systems)"> atomic </a> , <a href="/Consistency (database systems)/en-en/"title="Consistency (database systems)"class=mw-redirect> consistent </a> , <a href="/Isolation (database systems)/en-en/"title="Isolation (database systems)"> isolated </a> and <a href="/Durability (database systems)/en-en/"title="Durability (database systems)"> durable </a> . <sup class=reference id=cite_ref-0> <a href=#cite_note-0> <span> [ </span> 1 <span> ] </span> </a> </sup> Database practitioners often refer to these properties of database transactions using the acronym <a href=/ACID/en-en/ title=ACID> ACID </a> .<p>Transactions provide an "all-or-nothing" proposition, stating that each work-unit performed in a database must either complete in its entirety or have no effect whatsoever. Further, the system must isolate each transaction from other transactions, results must conform to existing constraints in the database, and transactions that complete successfully must get written to durable storage.<table class=toc id=toc><tbody><tr><td><div id=toctitle><h2>Contents</h2></div> <ul><li class="toclevel-1 tocsection-1"><a href=#Purpose> <span class=tocnumber> 1 </span> <span class=toctext> Purpose </span> </a><li class="toclevel-1 tocsection-2"><a href=#Transactional_databases> <span class=tocnumber> 2 </span> <span class=toctext> Transactional databases </span> </a> <ul><li class="toclevel-2 tocsection-3"><a href=#In_SQL> <span class=tocnumber> 2.1 </span> <span class=toctext> In SQL </span> </a></ul><li class="toclevel-1 tocsection-4"><a href=#Distributed_transactions> <span class=tocnumber> 3 </span> <span class=toctext> Distributed transactions </span> </a><li class="toclevel-1 tocsection-5"><a href=#Transactional_filesystems> <span class=tocnumber> 4 </span> <span class=toctext> Transactional filesystems </span> </a><li class="toclevel-1 tocsection-6"><a href=#See_also> <span class=tocnumber> 5 </span> <span class=toctext> See also </span> </a><li class="toclevel-1 tocsection-7"><a href=#References> <span class=tocnumber> 6 </span> <span class=toctext> References </span> </a><li class="toclevel-1 tocsection-8"><a href=#Further_reading> <span class=tocnumber> 7 </span> <span class=toctext> Further reading </span> </a><li class="toclevel-1 tocsection-9"><a href=#External_links> <span class=tocnumber> 8 </span> <span class=toctext> External links </span> </a></ul></table><h2>  <span class=mw-headline id=Purpose> Purpose </span></h2><p><a href=/Database/en-en/ title=Database> Databases </a> and other data stores which treat the <a href="/Data integrity/en-en/"title="Data integrity"> integrity </a> of data as paramount often include the ability to handle transactions to maintain the integrity of data. A single transaction consists of one or more independent units of work, each reading and/or writing information to a database or other data store. When this happens it is often important to ensure that all such processing leaves the database or data store in a consistent state.<p>Examples from <a href="/Double-entry bookkeeping system/en-en/"title="Double-entry bookkeeping system"> double-entry accounting systems </a> often illustrate the concept of transactions. In double-entry accounting every debit requires the recording of an associated credit. If one writes a check for €100 to buy groceries, a transactional double-entry accounting system must record the following two entries to cover the single transaction:<ol><li>Debit €100 to Groceries Expense Account<li>Credit €100 to Checking Account</ol><p>A transactional system would make both entries pass or both entries would fail. By treating the recording of multiple entries as an atomic transactional unit of work the system maintains the integrity of the data recorded. In other words, nobody ends up with a situation in which a debit is recorded but no associated credit is recorded, or vice versa.<h2>  <span class=mw-headline id=Transactional_databases> Transactional databases </span></h2><p>A ' <i> transactional database </i> is a <a class=mw-redirect href=/DBMS/en-en/ title=DBMS> DBMS </a> where write transactions on the database are able to be rolled back if they are not completed properly (e.g. due to power or connectivity loss).<p>Most modern <sup class="plainlinks noprint asof-tag update"style=display:none;> <a class="external text"href=http://en.wikipedia.org/w/index.php?title=Database_transaction&action=edit> [update] </a> </sup> <a href="/Relational database management system/en-en/"title="Relational database management system"> relational database management systems </a> fall into the category of databases that support transactions.<p>In a database system a transaction might consist of one or more data-manipulation statements and queries, each reading and/or writing information in the database. Users of <a href="/Database system/en-en/"title="Database system"> database systems </a> consider <a href="/Data consistency/en-en/"title="Data consistency"> consistency </a> and <a href="/Data integrity/en-en/"title="Data integrity"> integrity </a> of data as highly important. A simple transaction is usually issued to the database system in a language like <a href="/Structured Query Language/en-en/"title="Structured Query Language"class=mw-redirect> SQL </a> wrapped in a transaction, using a pattern similar to the following:<ol><li>Begin the transaction<li>Execute a set of data manipulations and/or queries<li>If no errors occur then commit the transaction and end it<li>If errors occur then rollback the transaction and end it</ol><p>If no errors occurred during the execution of the transaction then the system commits the transaction. A transaction commit operation applies all data manipulations within the scope of the transaction and persists the results to the database. If an error occurs during the transaction, or if the user specifies a <a href="/Rollback (data management)/en-en/"title="Rollback (data management)"> rollback </a> operation, the data manipulations within the transaction are not persisted to the database. In no case can a partial transaction be committed to the database since that would leave the database in an inconsistent state(Article by Vishak P Nair).<p>Internally, multi-user databases store and process transactions, often by using a transaction <a href=/Identifier/en-en/ title=Identifier> ID </a> or XID.<p>There are multiple varying ways for transactions to be implemented other than the simple way documented above. <a href="/Nested transaction/en-en/"title="Nested transaction"> Nested transactions </a> , for example, are transactions which contain statements within them that start new transactions (i.e. sub-transactions). <a title="Multi-level transaction (page does not exist)"class=new href=http://en.wikipedia.org/w/index.php?title=Multi-level_transaction&action=edit&redlink=1> Multi-level transactions </a> are similar but have a few extra properties <sup class=Template-Fact style=white-space:nowrap;> [ <i> <a title="Wikipedia:Citation needed"href=http://en.wikipedia.org/wiki/Wikipedia:Citation_needed> <span title="This claim needs references to reliable sources from November 2011"> citation needed </span> </a> </i> ] </sup> . Another type of transaction is the <a href="/Compensating transaction/en-en/"title="Compensating transaction"> compensating transaction </a> .<h3>  <span class=mw-headline id=In_SQL> In SQL </span></h3><p><a href=/SQL/en-en/ title=SQL> SQL </a> is inherently transactional, and a transaction is automatically started when another ends. Some databases extend SQL and implement a <code>
            START TRANSACTION
           </code> statement, but while seemingly signifying the start of the transaction it merely deactivates <a href=/Autocommit/en-en/ title=Autocommit> autocommit </a> . <sup class=Template-Fact style=white-space:nowrap;> [ <i> <a title="Wikipedia:Citation needed"href=http://en.wikipedia.org/wiki/Wikipedia:Citation_needed> <span title="This claim needs references to reliable sources from April 2012"> citation needed </span> </a> </i> ] </sup><p>The result of any work done after this point will remain invisible to other database-users until the system processes a <code>
            <a href="/Commit (SQL)/en-en/"title="Commit (SQL)"class=mw-redirect> COMMIT </a>
           </code> statement. A <code>
            <a href="/Rollback (data management)/en-en/"title="Rollback (data management)"> ROLLBACK </a>
           </code> statement can also occur, which will undo any work performed since the last transaction. Both <code>
            COMMIT
           </code> and <code>
            ROLLBACK
           </code> will end the transaction, and start anew. If <a href=/Autocommit/en-en/ title=Autocommit> autocommit </a> was disabled using <code>
            START TRANSACTION
           </code> , autocommit will often also be reenabled.<p>Some database systems allow the synonyms <code>
            BEGIN
           </code> , <code>
            BEGIN WORK
           </code> and <code>
            BEGIN TRANSACTION
           </code> , and may have other options available.<h2>  <span class=mw-headline id=Distributed_transactions> Distributed transactions </span></h2><p>Database systems implement <a href="/Distributed transaction/en-en/"title="Distributed transaction"> distributed transactions </a> as transactions against multiple applications or hosts. A distributed transaction enforces the ACID properties over multiple systems or data stores, and might include systems such as databases, file systems, messaging systems, and other applications. In a distributed transaction a coordinating service ensures that all parts of the transaction are applied to all relevant systems. As with database and other transactions, if any part of the transaction fails, the entire transaction is rolled back across all affected systems.<h2>  <span class=mw-headline id=Transactional_filesystems> Transactional filesystems </span></h2><p>The <a href=/Namesys/en-en/ title=Namesys> Namesys </a> <a href=/Reiser4/en-en/ title=Reiser4> Reiser4 </a> filesystem for <a href=/Linux/en-en/ title=Linux> Linux </a> <sup class=reference id=cite_ref-1> <a href=#cite_note-1> <span> [ </span> 2 <span> ] </span> </a> </sup> supports transactions, and as of <a href=/Microsoft/en-en/ title=Microsoft> Microsoft </a> <a href="/Windows Vista/en-en/"title="Windows Vista"> Windows Vista </a> , the Microsoft <a href=/NTFS/en-en/ title=NTFS> NTFS </a> filesystem <sup class=reference id=cite_ref-2> <a href=#cite_note-2> <span> [ </span> 3 <span> ] </span> </a> </sup> supports <a href="/Distributed transactions/en-en/"title="Distributed transactions"class=mw-redirect> distributed transactions </a> across networks.<h2>  <span class=mw-headline id=See_also> See also </span></h2><ul><li><a href="/Concurrency control/en-en/"title="Concurrency control"> Concurrency control </a></ul><h2>  <span class=mw-headline id=References> References </span></h2><div style="list-style-type: decimal;"class=reflist><ol class=references><li id=cite_note-0><span class=mw-cite-backlink> <b> <a href=#cite_ref-0> ^ </a> </b> </span> <span class=reference-text> <a class="external text"href=http://msdn.microsoft.com/en-us/library/aa366402(VS.85).aspx rel=nofollow> A transaction is a group of operations that are atomic, consistent, isolated, and durable ( </a> <a href=/ACID/en-en/ title=ACID> ACID </a> ). </span><li id=cite_note-1><span class=mw-cite-backlink> <b> <a href=#cite_ref-1> ^ </a> </b> </span> <span class=reference-text> <a class="external free"href=http://namesys.com/v4/v4.html#committing rel=nofollow> http://namesys.com/v4/v4.html#committing </a> </span><li id=cite_note-2><span class=mw-cite-backlink> <b> <a href=#cite_ref-2> ^ </a> </b> </span> <span class=reference-text> <a class="external free"href=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/fs/portal.asp rel=nofollow> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/fs/portal.asp </a> </span></ol></div><h2>  <span class=mw-headline id=Further_reading> Further reading </span></h2><ul><li><cite id=Bern2009> <a title="Philip A. Bernstein (page does not exist)"class=new href=http://en.wikipedia.org/w/index.php?title=Philip_A._Bernstein&action=edit&redlink=1> Philip A. Bernstein </a> , Eric Newcomer (2009): <a class="external text"href=http://www.elsevierdirect.com/product.jsp?isbn=9781558606234 rel=nofollow> <i> Principles of Transaction Processing </i> , 2nd Edition </a> , Morgan Kaufmann (Elsevier), <a class="internal mw-magiclink-isbn"href=http://en.wikipedia.org/wiki/Special:BookSources/9781558606234> ISBN 978-1-55860-623-4 </a> </cite><li>Gerhard Weikum, Gottfried Vossen (2001), <i> Transactional information systems: theory, algorithms, and the practice of concurrency control and recovery </i> , Morgan Kaufmann, <a class="internal mw-magiclink-isbn"href=http://en.wikipedia.org/wiki/Special:BookSources/1558605088> ISBN 1-55860-508-8 </a></ul><h2>  <span class=mw-headline id=External_links> External links </span></h2><ul><li><a class=extiw href=http://c2.com/cgi/wiki?TransactionProcessing title=wiki:TransactionProcessing> Wiki:TransactionProcessing </a></ul><table cellspacing=0 class=navbox style=border-spacing:0;;><tbody><tr><td style=padding:2px;><table class="nowraplinks hlist collapsible autocollapse navbox-inner"cellspacing=0 style=border-spacing:0;background:transparent;color:inherit;;><tbody><tr><th class=navbox-title colspan=2 scope=col style=;><div class="noprint plainlinks hlist navbar mini"><ul>     </ul></div> <div style=font-size:110%;><a href="/Database management system/en-en/"title="Database management system"> Database management systems </a></div><tr style=height:2px;><td><tr><td class=navbox-abovebelow colspan=2 style=;><div><ul><li><a href="/Database model/en-en/"title="Database model"> Database models </a><li><a href="/Database normalization/en-en/"title="Database normalization"> Database normalization </a><li><a href="/Database storage structures/en-en/"title="Database storage structures"> Database storage </a><li><a href="/Distributed database management system/en-en/"title="Distributed database management system"> Distributed DBMS </a><li><a href="/Federated database system/en-en/"title="Federated database system"> Federated database system </a><li><a href="/Referential integrity/en-en/"title="Referential integrity"> Referential integrity </a><li><a href="/Relational algebra/en-en/"title="Relational algebra"> Relational algebra </a><li><a href="/Relational calculus/en-en/"title="Relational calculus"> Relational calculus </a><li><a href="/Relational database/en-en/"title="Relational database"> Relational database </a><li><a href="/Relational database management system/en-en/"title="Relational database management system"> Relational DBMS </a><li><a href="/Relational model/en-en/"title="Relational model"> Relational model </a><li><a href="/Object-relational database/en-en/"title="Object-relational database"> Object-relational database </a><li><a href="/Transaction processing/en-en/"title="Transaction processing"> Transaction processing </a></ul></div><tr style=height:2px;><td><tr><th class=navbox-group scope=row style=;;>Concepts<td class="navbox-list navbox-odd"style=text-align:left;border-left-width:2px;border-left-style:solid;width:100%;padding:0px;;;><div style="padding:0em 0.25em"><ul><li><a href=/Database/en-en/ title=Database> Database </a><li><a href=/ACID/en-en/ title=ACID> ACID </a><li><a href="/Create, read, update and delete/en-en/"title="Create, read, update and delete"> CRUD </a><li><a href="/Null (SQL)/en-en/"title="Null (SQL)"> Null </a><li><a href="/Candidate key/en-en/"title="Candidate key"> Candidate key </a><li><a href="/Foreign key/en-en/"title="Foreign key"> Foreign key </a><li><a href="/Primary key/en-en/"title="Primary key"class=mw-redirect> Primary key </a><li><a href=/Superkey/en-en/ title=Superkey> Superkey </a><li><a href="/Surrogate key/en-en/"title="Surrogate key"> Surrogate key </a><li><a href="/Armstrong's axioms/en-en/"title="Armstrong's axioms"> Armstrong's axioms </a><li><a href=/NoSQL/en-en/ title=NoSQL> NoSQL </a></ul></div><tr style=height:2px><td><tr><th class=navbox-group scope=row style=;;>Objects<td class="navbox-list navbox-even"style=text-align:left;border-left-width:2px;border-left-style:solid;width:100%;padding:0px;;;><div style="padding:0em 0.25em"><ul><li><a href="/Relation (database)/en-en/"title="Relation (database)"> Relation </a> <ul><li><a href="/Table (database)/en-en/"title="Table (database)"> table </a><li><a href="/Column (database)/en-en/"title="Column (database)"> column </a><li><a href="/Row (database)/en-en/"title="Row (database)"> row </a></ul><li><a href="/View (database)/en-en/"title="View (database)"> View </a><li><strong class=selflink> Transaction </strong><li><a href="/Transaction log/en-en/"title="Transaction log"> Log </a><li><a href="/Database trigger/en-en/"title="Database trigger"> Trigger </a><li><a href="/Index (database)/en-en/"title="Index (database)"class=mw-redirect> Index </a><li><a href="/Stored procedure/en-en/"title="Stored procedure"> Stored procedure </a><li><a href="/Cursor (databases)/en-en/"title="Cursor (databases)"> Cursor </a><li><a href="/Partition (database)/en-en/"title="Partition (database)"> Partition </a></ul></div><tr style=height:2px><td><tr><th class=navbox-group scope=row style=;;>Components<td class="navbox-list navbox-odd"style=text-align:left;border-left-width:2px;border-left-style:solid;width:100%;padding:0px;;;><div style="padding:0em 0.25em"><ul><li><a href="/Concurrency control/en-en/"title="Concurrency control"> Concurrency control </a><li><a href="/Data dictionary/en-en/"title="Data dictionary"> Data dictionary </a><li><a href="/Java Database Connectivity/en-en/"title="Java Database Connectivity"> JDBC </a><li><a href="/XQuery API for Java/en-en/"title="XQuery API for Java"> XQJ </a><li><a href="/Open Database Connectivity/en-en/"title="Open Database Connectivity"class=mw-redirect> ODBC </a><li><a href="/Query language/en-en/"title="Query language"> Query language </a><li><a href="/Query optimizer/en-en/"title="Query optimizer"> Query optimizer </a><li><a href="/Query plan/en-en/"title="Query plan"> Query plan </a></ul></div><tr style=height:2px><td><tr><th class=navbox-group scope=row style=;;>Functions<td class="navbox-list navbox-even"style=text-align:left;border-left-width:2px;border-left-style:solid;width:100%;padding:0px;;;><div style="padding:0em 0.25em"><ul><li><a href="/Database administration and automation/en-en/"title="Database administration and automation"> Administration and automation </a><li><a href="/Query optimization/en-en/"title="Query optimization"> Query optimization </a><li><a href="/Database replication/en-en/"title="Database replication"class=mw-redirect> Replication </a></ul></div><tr style=height:2px;><td><tr><td class=navbox-abovebelow colspan=2 style=;><div><dl><dt>Database products<dd><a href="/List of object-oriented database management systems/en-en/"title="List of object-oriented database management systems"class=mw-redirect> Object-oriented </a> <dl><dd><a href="/Comparison of object-relational database management systems/en-en/"title="Comparison of object-relational database management systems"> comparison </a></dl><dd><a href="/List of relational database management systems/en-en/"title="List of relational database management systems"> Relational </a> <dl><dd><a href="/Comparison of relational database management systems/en-en/"title="Comparison of relational database management systems"> comparison </a></dl><dd><a href="/Document-oriented database/en-en/"title="Document-oriented database"> Document-oriented </a></dl></div></table></table>    </div>     <div class=printfooter>Retrieved from " <a href=http://en.wikipedia.org/w/index.php?title=Database_transaction&oldid=499223461> http://en.wikipedia.org/w/index.php?title=Database_transaction&oldid=499223461 </a> "</div>     <div class=catlinks id=catlinks><div class=mw-normal-catlinks id=mw-normal-catlinks><a href=http://en.wikipedia.org/wiki/Special:Categories title=Special:Categories> Categories </a> : <ul><li><a title="Category:Database management systems"href=http://en.wikipedia.org/wiki/Category:Database_management_systems> Database management systems </a><li><a title="Category:Data management"href=http://en.wikipedia.org/wiki/Category:Data_management> Data management </a><li><a title="Category:Transaction processing"href=http://en.wikipedia.org/wiki/Category:Transaction_processing> Transaction processing </a></ul></div>  </div>         <div class=wikiFooter lang=en><p class=copyright>This entry is from Wikipedia, the leading user-contributed encyclopedia. It may not have been reviewed by professional editors (see <a href=http://en.wikipedia.org/wiki/Wikipedia:General_disclaimer target=_blank> full disclaimer </a> )<div style="width: 140px;"id=wikiDonate><p style="float: left; margin: 0px; padding: 0px; width: 200px;"><a style="color: black; font-size: 12px;"href=http://wikimediafoundation.org/wiki/Fundraising target=_blank> Donate to Wikimedia </a></p><br></div></div></div><p class=title> <p style=margin-bottom:10px;><img src=http://common-en.sensagent.com/images/alexandria/data/fleche.gd.bleu.3.gif style=width:14px;height:14px;> <a href="http://translation.sensagent.com/translate/DATABASE TRANSACTION/en/multilingual.html"> All translations of DATABASE TRANSACTION </a></div><br></div></div></div><div id=L_><div class=logo><a class=logo href=/ style=color:#1B1B21;text-decoration:none;> sens <span class=sensA> a </span> gent </a><a name=top> </a></div><div class=titled-block><p class=title><span class=fv-sc> sens <span class=sensA> a </span> gent </span> 's content<p class=text><ul style=margin-top:0px;margin-bottom:0px;><li>definitions<li>synonyms<li>antonyms<li>encyclopedia</ul><p></div><div class=add-block id=lsad><p class=AlertPub>   Advertising ▼<div><script>if (SENSAGENT_ADDS['dim']['w'] > 800 ) {
    document.domain='sensagent.com';
     document.write("<iframe src='http://www.sensagent.com/alexandria-advertising/managed/getAddAlexandria.jsp?p=SKY-160x600-NOADSENSE' width=160 height=600 marginheight=0 marginwidth=0 frameborder=0 scrolling=no></iframe>"); 
    
   }</script></div></div><div class=titled-block><a name=partnership> </a><p class=title>Webmaster Solution<p class=section>Alexandria<p class=text><img align=left height=36 hspace=6 src=http://common-en.sensagent.com/common/online-2008/images/columns/dclic_en.bmp width=36> A windows (pop-into) of information (full-content of Sensagent) triggered by double-clicking any word on your webpage. Give contextual explanation and translation from your sites !<p class=text style=text-align:center>Try <a href=http://www.sensagent.com/ebay/search-array.jsp?dl=en&w=i-pod&sid=-1#360043787260 target=_blank> here </a>   or   get the <a href=http://popinto.sensagent.com/alexandria-popinto-2011/v2/webmasters/fr/presentation.jsp> code </a><p class=section>SensagentBox<p class=text>With a <a href=javascript:popUp('/common/online-2008/popup/PopUp-SearchBox.en.html')> SensagentBox </a> , visitors to your site can access reliable information on over 5 million pages provided by Sensagent.com. Choose the design that fits your site.</div><div class=titled-block><a name=business> </a><p class=title>Business solution<p class=section>Improve your site content<p class=text>Add new content to your site from Sensagent by XML.<p class=section>Crawl products or adds<p class=text>Get XML access to reach the best products.<p class=section>Index images and define metadata<p class=text>Get XML access to fix the meaning of your metadata.</p><br><p class=text>Please, <a href=javascript:popUp('/common/online-2008/popup/PopUp-Email.en.html')> email us </a> to describe your idea.</div><div class=titled-block><a class=anchor name=wordgames> </a><p class=title>WordGame<p class=text>The English word games are: <br> ○    <a href=http://www.sensagent.com/en/anagrams-dictionary/search-anagrams.jsp?w=Welcome&tl=en&dl=en> Anagrams </a> <br> ○    <a href=http://crosswords.sensagent.com/crosswords-dictionary/solve-crosswords.jsp?w=wel*m?&tl=en&e=UTF-8&dl=en> Wildcard, crossword </a> <br> ○    <a href=#lettris> Lettris </a> <br> ○    <a href=#boggle> Boggle. </a></div><div class=titled-block><a class=anchor name=lettris> </a><p class=title>Lettris<div class=legended-img><p class=text><a class=aa href=http://www.sensagent.com/en/online-games/lettris/lettris-main.en.html> Lettris </a> is a curious tetris-clone game where all the bricks have the same square shape but different content. Each square carries a letter. To make squares disappear and save space for other squares you have to assemble English words (left, right, up, down) from the falling squares.</div></div><div class=titled-block><a class=anchor name=boggle> </a><p class=title>boggle<div class=legended-img><p class=text><a class=aa href=http://boggle.sensagent.com/boggle/index.jsp?dl=en&pid=&gl=en> <img align=left hspace=6 src=http://common-en.sensagent.com/common/online-2008/images/columns/boggle.jpg style=width:84px;height:82px;> Boggle </a> gives you 3 minutes to find as many words (3 letters or more) as you can in a grid of 16 letters. You can also try the grid of 16 letters. Letters must be adjacent and longer words score better. See if you can get into the grid Hall of Fame !</div></div><div class=titled-block><a name="English dictionary description"class=anchor> </a><p class=title>English dictionary <br> Main references<p class=text>Most English definitions are provided by <a href=http://wordnet.princeton.edu/> WordNet </a> . <br> English thesaurus is mainly derived from The Integral Dictionary (TID). <br> English Encyclopedia is licensed by <a href=http://en.wikipedia.org/wiki/Wikipedia:Copyrights> Wikipedia (GNU). <br> <br> </a></p><a href=http://en.wikipedia.org/wiki/Wikipedia:Copyrights> </a></div><a href=http://en.wikipedia.org/wiki/Wikipedia:Copyrights> </a><div class=titled-block><a href=http://en.wikipedia.org/wiki/Wikipedia:Copyrights> </a><a name="other service"class=anchor> </a><p class=title>Copyrights<p class=text>The wordgames <a href=#wordgames> anagrams, crossword, Lettris and Boggle </a> are provided by Memodata. <br> The web service <a href=http://www.sensagent.com/alexandria-popup/v2/webmasters/en/introduction.jsp> Alexandria </a> <a> is granted from Memodata for the </a> <a href=http://www.sensagent.com/ebay/search-array.jsp?dl=en&w=i-pod&sid=-1#360043787260 target=_blank> Ebay search </a> . <br> The <a href=javascript:popUp('/common/online-2008/popup/PopUp-SearchBox.en.html')> SensagentBox </a> are offered by sensAgent.</div><div class=titled-block><a class=anchor name=translate> </a><p class=title>Translation<p class=text>Change the target language to find translations. <br> Tips: browse the semantic fields (see <a href=#analogical> From ideas to words </a> ) in two languages to learn more. <br></div><div class=titled-block><p class=title> <div class=text style=margin-top:6px;>6953 online visitors</div><p class="section c1">computed in 0.063s</div></div><div style="padding:0px 0px 20px 0px;"id=F_><a name="Information company"> </a><div class=menu><p class=items><a href=javascript:popUp('http://www.sensagent.com/common/online-2008/popup/PopUp-Email.en.html')> Contact Us </a>  |  <a href=javascript:popUp('http://www.sensagent.com/common/online-2008/popup/PopUp-informationcompany.en.html')> Company Information </a>  |  <a href=http://www.sensagent.com/privacy-policy.html lang=en> Privacy policy </a>  |  <a href=/last-modif/dictionary/index.html> Last modifications </a><p class=copyr>Copyright © 2012 sensagent Corporation: Online Encyclopedia, Thesaurus, Dictionary definitions and more. All rights reserved. Ro<div style=text-align:center;font-size:10px;color:#888;><a href=http://dictionary.sensagent.com/synonym/en-en/> synonym </a> - <a href=http://dictionary.sensagent.com/definition/en-en/> definition </a> - <a href=http://dictionary.sensagent.com/dictionary/en-en/> dictionary </a> - <a href=http://dictionary.sensagent.com/definition/en-en/> define </a> - <a href=http://dictionary.sensagent.com/translation/en-en/> translation </a> - <a href=http://dictionary.sensagent.com/translate/en-en/> translate </a> - <a href=http://dictionary.sensagent.com/translator/en-en/> translator </a> - <a href=http://dictionary.sensagent.com/conjugation/en-en/> conjugation </a> - <a href=http://dictionary.sensagent.com/anagram/en-en/> anagram </a></div></div></div></div></div><div class=divwarning id=warning-form><div class=warn-title>I would like to report:</div><div class=input>section : <select disabled name=section><option id=warn-did name=collab-did value=->in the definition above<option name=sectionid value=DEF>in the definition section<option name=sectionid value=SYN>in the synonyms section<option name=sectionid value=TRA>in the translation section</select></div><input value="DATABASE TRANSACTION"name=warn-w type=hidden><input name=warn-sl type=hidden value=en><input name=warn-tl type=hidden value=en><input value="US - 34.133.206.40"name=warn-user type=hidden><div class="input top10"id=warn-ortho><input name=ortho type=checkbox value=1><span class=text> a spelling or a grammatical mistake </span></div><div class=input id=warn-abuse><input name=abuse type=checkbox value=1><span class=text> an offensive content(racist, pornographic, injurious, etc.) </span></div><div class=input id=warn-copyr><input name=copyr type=checkbox value=1><span class=text> a copyright violation </span></div><div class=input id=warn-error><input name=error type=checkbox value=1><span class=text> an error </span></div><div class=input id=warn-missing><input name=missing type=checkbox value=1><span class=text> a missing statement </span></div><div class=input id=warn-other><input name=other type=checkbox value=1><span class=text> other </span></div><div class=warn-title>please precise:</div><textarea dir=ltr id=warn-comment name=comment rows=5 style=width:90%;> </textarea><div class="input top10"><input class=right10 id=warn-send type=button value=SEND><input id=warn-cancel type=button value=CANCEL></div></div><script>if(typeof _SENSAGENT == 'undefined') { _SENSAGENT = {}; }
 _SENSAGENT['search'] = {'sl':'en','tl':'en'};
 _SENSAGENT['display'] = {'dl':'en'};
 $(document).ready(function() {
  $.cookie('sensagent.sufrom',document.location,{'domain':'sensagent.com','path':'/'});
 });</script><script src=http://common.sensagent.eu/_static/js/userdef.js></script><script>if(typeof _SENSAGENT == 'undefined') { _SENSAGENT = {}; }
 _SENSAGENT['search'] = {'sl':'en','tl':'en'};
 _SENSAGENT['display'] = {'dl':'en'};</script><script>function getSelectedLanguages() {
  _lset = {};_lset[_SENSAGENT['search']['sl']]=true;_lset[_SENSAGENT['search']['tl']]=true;
  _llist = [_SENSAGENT['search']['sl']];
  if (_SENSAGENT['search']['tl'] != _SENSAGENT['search']['sl']) _llist.push(_SENSAGENT['search']['tl']);
  
  try {
   l1 = $.cookie('sensagent.hl').split('-');
   for ( var i = 0; i < l1.length; i++ ) { 
    _trimedl = $.trim(l1[i]);
    if (_trimedl.length > 0) { if (typeof(_lset[_trimedl]) == 'undefined' ) { _lset[_trimedl] = true; _llist.push(_trimedl);} } }
  } catch (err) {}
  return _llist; 
 }
 _languagesSelection = getSelectedLanguages().slice(0,5);
 for ( var i=0; i < _languagesSelection.length; i++) {
  $("#SLList span[data-lid='"+_languagesSelection[i]+"']").addClass('highlighted'); 
  $("#TLList span[data-lid='"+_languagesSelection[i]+"']").addClass('highlighted'); 
 }
 $.cookie('sensagent.hl',_languagesSelection.join('-'),{'domain':'sensagent.com','path':'/','expires':365});</script><script>var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));</script><script>try {
var pageTracker = _gat._getTracker("UA-275917-1");
pageTracker._setDomainName(".sensagent.com");
pageTracker._trackPageview();
} catch(err) {}</script><div id=Rtemp><script>function openDlgLogin(nDisplayLanguageId) {
 $.cookie('sensagent.sulfrom','data',{'domain':'.sensagent.com','path':'/'});
 document.location = '/coop/'+getLoginLanguageId(nDisplayLanguageId)+'/login/login.html';
}

function delBlockingCookies() {
 _cookies2del = ['__utma','slhl','tlhl','display','su'];
 for ( var i = 0; i < _cookies2del.length; i++) {
  $.removeCookie(_cookies2del[i],{'domain':'dictionnaire.sensagent.com','path':'/'});
  $.removeCookie(_cookies2del[i],{'domain':'.sensagent.com','path':'/'});
  $.removeCookie(_cookies2del[i],{'path':'/'});
  $.removeCookie(_cookies2del[i]);
 }
}

function myredirect(url) {
 var isOpera, isIE = false;
 if(typeof(window.opera) != 'undefined'){isOpera = true;}
 if(!isOpera && navigator.userAgent.indexOf('Internet Explorer')){isIE = true;}
 if (isIE)
 {
   var referLink = document.createElement('a');
   referLink.href = url;
   document.body.appendChild(referLink);
   referLink.click();
 } else location.href = url;
}

function getLoginLanguageId(nDisplayLanguageId) {
 if (( nDisplayLanguageId == 'fr')  || ( nDisplayLanguageId == 'en')) return nDisplayLanguageId;
 return 'en';}

function logout() { 
 try {
  $.removeCookie('sensagent.su',{'domain':'.sensagent.com','path':'/'});
  window.location.href=window.location.href.split('#')[0];
//  document.location='/reg/en/logout.html'; 
 } catch (err) {}
}
function closeDlgLogin() { /* $('#divlogin').hide(); */ $("#flogin").attr('src',''); return false; }
function openDlgSubscription(nDisplayLanguageId) { closeDlgLogin(); popUp("/reg/"+getLoginLanguageId(nDisplayLanguageId)+"/sensagent/account-new.html"); }

function del_cookie(name) { document.cookie = name + '=; expires=Thu, 01-Jan-70 00:00:01 GMT;';} 
function afterSConnection() {
 closeDlgLogin();
 del_cookie('__utmz');
// window.location.reload(); 
 window.location.href=window.location.href.split('#')[0];
}</script><script>function getWikiTitle(nJQElt) {
 // on récupère le commentaire (nouveaux WIKI)
 _comment = nJQElt.parent().contents().first();
 if ( _comment.get(0).nodeType == 8 ) {
  _commentRegExp = new RegExp('.*/wiki/(.*)$');
  _matching = _commentRegExp.exec(_comment.get(0).nodeValue);
  if (_matching != null ) return [$.trim(_matching[1]),'COMMENT'];
  else return ['','BAD COMMENT FORMAT'];
 }

 // on récupère le texte du titre (anciens WIKI)
 return [nJQElt.contents().filter(function () { return this.nodeType === 3; }).text(),'TITLE']
}

function openDlgUpdateWiki(nDisplayLanguageId,nTitle) { 
// alert(nDisplayLanguageId);
// alert(nTitle[0] + ' - ' + nTitle[1]);
// popUp("/reg/"+getLoginLanguageId(nDisplayLanguageId)+"/actions/update-wiki.html?ref="+document.location+'&title='+nTitle[0]+'&kind='+nTitle[1]); 
 delBlockingCookies();
 popUp("/reg/"+getLoginLanguageId(nDisplayLanguageId)+"/actions/update-wiki-nc.html?ref="+document.location.href.split('#')[0]+'&title='+nTitle[0]+'&kind='+nTitle[1]); 
}

$(document).ready(function(){

 $("h1.firstHeading").append('<button class="wikiUpdate" style="float:right;margin:0px 10px 0px 0px;font-size:70%;color:black;" title="">update</button>');


 $(".wikiUpdate").click(function(){
  _title=getWikiTitle($(this).parent());
  openDlgUpdateWiki('en',_title);
 });
 $(".ebiteminfo").click(function(){$(this).prev().children('a')[0].click();});
});</script><div class=titled-block id=slogin style=margin-top:10px><p class=title>My account<p class=text><a href=javascript:openDlgLogin("en");void(0);> login </a><p class=text><a href=javascript:openDlgSubscription("en");void(0);> registration </a></div><div class=add-block><p class=AlertPub>   Advertising ▼<div><div style=margin-top:10px;margin-bottom:10px><script async src=https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js></script><ins class=adsbygoogle data-ad-client=ca-pub-5638131742820545 data-ad-slot=1319546215 style=display:inline-block;width:300px;height:600px> </ins><script>if (SENSAGENT_ADDS['dim']['w'] > 800 ) {
     (adsbygoogle = window.adsbygoogle || []).push({});
}</script></div></div></div></div><script language=javascript>document.getElementById('R_').innerHTML = document.getElementById('Rtemp').innerHTML
 document.getElementById('Rtemp').innerHTML = ' '</script><script src=http://common.sensagent.eu/online-2010/scripts/alexandria-dictionary.en.js></script><div id=cookie_mess><p>Cookies help us deliver our services. By using our services, you agree to our use of cookies. <input value="Got it"onclick=close_cookie_consent_div() type=submit> <a href=http://www.sensagent.com/privacy-policy.html target=blank> Find out more </a></div><script>function set_cookie_consent(nValue) { $.cookie('SENSAGENT_COOKIE_CONSENT',nValue, {'path':'/','domain':'sensagent.com','expires':3650})}
 function show_cookie_consent_div() { $('#cookie_mess').show();}
 function close_cookie_consent_div() {set_cookie_consent('OK'); $('#cookie_mess').hide();}
 var _cookie_consent = $.cookie('SENSAGENT_COOKIE_CONSENT');
 if (typeof(_cookie_consent) == "undefined") {
  var _user_country='US';
  if (( _user_country == '' ) || ( 'AT-BE-BG-CY-CZ-DE-DK-EE-ES-FI-FR-GR-HR-HU-IE-IT-LT-LV-LU-MT-NL-PO-PT-RO-SE-SI-SK-UK'.indexOf(_user_country) != -1 )) { 
   if ( document.referrer.indexOf('.sensagent.com') != -1 ) set_cookie_consent('NAV');
   else show_cookie_consent_div(); 
  } else { set_cookie_consent('US'); }
 }</script>