{"id":1044,"date":"2021-05-25T05:58:50","date_gmt":"2021-05-25T05:58:50","guid":{"rendered":"https:\/\/bcisnotes.com\/fourthsemester\/?p=1044"},"modified":"2021-05-25T06:00:29","modified_gmt":"2021-05-25T06:00:29","slug":"simple-transaction-model","status":"publish","type":"post","link":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/","title":{"rendered":"Simple Transaction Model || Transactions || Database Management System"},"content":{"rendered":"<h1 style=\"text-align: center;\">Simple Transaction Model<\/h1>\n<p>Simple transaction model is a model of transaction how it must be. It has active, partially committed, failed, aborted, and committed states. Transaction is a several operations that can change the content of the database which is handled by a single program. Simple transaction model follows all ACID properties while doing transactions.<\/p>\n<p>Transaction States:<\/p>\n<ul>\n<li><b>Active<\/b><\/li>\n<li><b>Partially committed<\/b><\/li>\n<li><b>Failed<\/b><\/li>\n<li><b>Aborted<\/b><\/li>\n<li><b>Committed<\/b><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1045\" src=\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/Tt7.png\" alt=\"Simple transaction model || Transactions || Database Management System\" width=\"743\" height=\"363\" srcset=\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/Tt7.png 743w, https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/Tt7-300x147.png 300w\" sizes=\"(max-width: 743px) 100vw, 743px\" \/><\/p>\n<p>The above figure describes in this way:<\/p>\n<p>At first, when the transaction is going to operate it is the active state. When the read or write operations occurs, it can be called partially committed states. Finally, after read or write operations, when they use commit operations, they will be committed states meaning the transaction is stored permanently in the database.\u00a0 And when after these both of active states and partially committed states fails, they will fall under the category failed state. Without executing, failed state will rollback which will create the aborted state. Once again, aborted state will be automatically converges into terminated state. Also, after the committed state, the transaction terminates.<\/p>\n<p>In the process of series of operations, read and write operations creates partially committed. That will be stored in local memory or buffer.\u00a0 After, the use of commit statement, data will be moved into permanent storage. This will justify the flow from active to partially committed and\u00a0 to committed state.<\/p>\n<p>On the other hand, in the case of power failure, it will be in failed state. Also, in the partially committed state, in the power failure case, it will be in failed sate. After this, rollback occurs meaning the local memory is cleared. Then aborted occurs meaning the database is unchanged and finally terminated.<\/p>\n<p>&nbsp;<\/p>\n<p>If you liked our content Other Topics of Online Contract, then you may also like <a href=\"https:\/\/bcisnotes.com\/fourthsemester\/normalization-database-management-system-bcisnotes\/\" target=\"_blank\" rel=\"noopener\">Normalization<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Simple Transaction Model Simple transaction model is a model of transaction how it must be. It has active, partially committed, failed, aborted, and committed states. <a class=\"mh-excerpt-more\" href=\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/\" title=\"Simple Transaction Model || Transactions || Database Management System\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":5,"featured_media":1046,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[297,296],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Simple transaction model || Transactions || Database Management System<\/title>\n<meta name=\"description\" content=\"Simple transaction model is a model of transaction how it must be. It has active, partially committed, failed, aborted, and committed states.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simple transaction model || Transactions || Database Management System\" \/>\n<meta property=\"og:description\" content=\"Simple transaction model is a model of transaction how it must be. It has active, partially committed, failed, aborted, and committed states.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/\" \/>\n<meta property=\"og:site_name\" content=\"BCIS Fourth Semester\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-25T05:58:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-25T06:00:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"340\" \/>\n\t<meta property=\"og:image:height\" content=\"230\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Kabir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kabir\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/\"},\"author\":{\"name\":\"Kabir\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/485682c28ff4af4df58e4feb966b2271\"},\"headline\":\"Simple Transaction Model || Transactions || Database Management System\",\"datePublished\":\"2021-05-25T05:58:50+00:00\",\"dateModified\":\"2021-05-25T06:00:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/\"},\"wordCount\":303,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#organization\"},\"image\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg\",\"keywords\":[\"Simple Transaction Model\",\"Transactions\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/\",\"name\":\"Simple transaction model || Transactions || Database Management System\",\"isPartOf\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg\",\"datePublished\":\"2021-05-25T05:58:50+00:00\",\"dateModified\":\"2021-05-25T06:00:29+00:00\",\"description\":\"Simple transaction model is a model of transaction how it must be. It has active, partially committed, failed, aborted, and committed states.\",\"breadcrumb\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#primaryimage\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg\",\"contentUrl\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg\",\"width\":340,\"height\":230,\"caption\":\"Simple Transaction Model\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bcisnotes.com\/fourthsemester\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simple Transaction Model || Transactions || Database Management System\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#website\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/\",\"name\":\"BCIS Fourth Semester\",\"description\":\"Notes of Information and Technology\",\"publisher\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bcisnotes.com\/fourthsemester\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#organization\",\"name\":\"BCIS Fourth Semester\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/02\/cropped-4-1.jpg\",\"contentUrl\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/02\/cropped-4-1.jpg\",\"width\":300,\"height\":100,\"caption\":\"BCIS Fourth Semester\"},\"image\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/485682c28ff4af4df58e4feb966b2271\",\"name\":\"Kabir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eaaf579594c8a7a98ef9f09097a8b1ab?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eaaf579594c8a7a98ef9f09097a8b1ab?s=96&d=mm&r=g\",\"caption\":\"Kabir\"},\"sameAs\":[\"http:\/\/bcisnotes.com\/fourthsemester\"],\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/author\/nuru\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Simple transaction model || Transactions || Database Management System","description":"Simple transaction model is a model of transaction how it must be. It has active, partially committed, failed, aborted, and committed states.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/","og_locale":"en_US","og_type":"article","og_title":"Simple transaction model || Transactions || Database Management System","og_description":"Simple transaction model is a model of transaction how it must be. It has active, partially committed, failed, aborted, and committed states.","og_url":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/","og_site_name":"BCIS Fourth Semester","article_published_time":"2021-05-25T05:58:50+00:00","article_modified_time":"2021-05-25T06:00:29+00:00","og_image":[{"width":340,"height":230,"url":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg","type":"image\/jpeg"}],"author":"Kabir","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kabir","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#article","isPartOf":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/"},"author":{"name":"Kabir","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/485682c28ff4af4df58e4feb966b2271"},"headline":"Simple Transaction Model || Transactions || Database Management System","datePublished":"2021-05-25T05:58:50+00:00","dateModified":"2021-05-25T06:00:29+00:00","mainEntityOfPage":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/"},"wordCount":303,"commentCount":0,"publisher":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/#organization"},"image":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#primaryimage"},"thumbnailUrl":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg","keywords":["Simple Transaction Model","Transactions"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/","url":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/","name":"Simple transaction model || Transactions || Database Management System","isPartOf":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#primaryimage"},"image":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#primaryimage"},"thumbnailUrl":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg","datePublished":"2021-05-25T05:58:50+00:00","dateModified":"2021-05-25T06:00:29+00:00","description":"Simple transaction model is a model of transaction how it must be. It has active, partially committed, failed, aborted, and committed states.","breadcrumb":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#primaryimage","url":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg","contentUrl":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/05\/new-qn-1.jpg","width":340,"height":230,"caption":"Simple Transaction Model"},{"@type":"BreadcrumbList","@id":"https:\/\/bcisnotes.com\/fourthsemester\/simple-transaction-model\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bcisnotes.com\/fourthsemester\/"},{"@type":"ListItem","position":2,"name":"Simple Transaction Model || Transactions || Database Management System"}]},{"@type":"WebSite","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#website","url":"https:\/\/bcisnotes.com\/fourthsemester\/","name":"BCIS Fourth Semester","description":"Notes of Information and Technology","publisher":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bcisnotes.com\/fourthsemester\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#organization","name":"BCIS Fourth Semester","url":"https:\/\/bcisnotes.com\/fourthsemester\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/logo\/image\/","url":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/02\/cropped-4-1.jpg","contentUrl":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/02\/cropped-4-1.jpg","width":300,"height":100,"caption":"BCIS Fourth Semester"},"image":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/485682c28ff4af4df58e4feb966b2271","name":"Kabir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eaaf579594c8a7a98ef9f09097a8b1ab?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eaaf579594c8a7a98ef9f09097a8b1ab?s=96&d=mm&r=g","caption":"Kabir"},"sameAs":["http:\/\/bcisnotes.com\/fourthsemester"],"url":"https:\/\/bcisnotes.com\/fourthsemester\/author\/nuru\/"}]}},"_links":{"self":[{"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/posts\/1044"}],"collection":[{"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/comments?post=1044"}],"version-history":[{"count":3,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/posts\/1044\/revisions"}],"predecessor-version":[{"id":1049,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/posts\/1044\/revisions\/1049"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/media\/1046"}],"wp:attachment":[{"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/media?parent=1044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/categories?post=1044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/tags?post=1044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}