Tehing on loogilises j\u00e4rjekorras toimingute jada, mida kasutaja v\u00f5i andmebaasiga t\u00f6\u00f6tav programm teeb.<\/p>\n\n\n\n
Tehing on muudatuste levitamine andmebaasis. N\u00e4iteks kui me loome, muudame v\u00f5i kustutame kirje, siis sooritame tehingu. Tehingute kontrollimine on \u00e4\u00e4rmiselt oluline tagada.<\/p>\n\n\n\n
Tehingu p\u00f5him\u00f5isteid kirjeldab akron\u00fc\u00fcm ACID –<\/p>\n\n\n\n
tagab, et iga tehing salvestatakse ainult tervikuna (t\u00e4ielikult).<\/p>\n\n\n\n
J\u00e4rjepidevus<\/em><\/strong><\/p>\n\n\n\n
J\u00e4rjepidevus t\u00e4hendab, et iga l\u00f5petatud tehing (tehing, mis on j\u00f5udnud tehingu l\u00f5puni – tehingu l\u00f5pp) j\u00e4\u00e4dvustab ainult kehtivaid tulemusi.<\/p>\n\n\n\n
See kontseptsioon tagab, et kui me oleme saanud kinnituse, et tehing on sooritatud, ei tohiks selle tehingu p\u00f5hjustatud muudatusi t\u00fchistada s\u00fcsteemi rikke (nt elektrikatkestuse) t\u00f5ttu.<\/p>\n\n\n\n
SQL<\/p>\n\n\n\n<\/figure>\n\n\n\n
on v\u00f5imatu ROLLBACK ilma tehingut alustamata.<\/p>\n\n\n\n
Tehing on loogilises j\u00e4rjekorras toimingute jada, mida kasutaja v\u00f5i andmebaasiga t\u00f6\u00f6tav programm teeb. Tehing on muudatuste levitamine andmebaasis. N\u00e4iteks kui me loome, muudame v\u00f5i kustutame kirje, siis sooritame tehingu. Tehingute kontrollimine on \u00e4\u00e4rmiselt oluline tagada. Tehingu p\u00f5him\u00f5isteid kirjeldab akron\u00fc\u00fcm ACID – Aatomisus tagab, et iga tehing salvestatakse ainult tervikuna (t\u00e4ielikult). J\u00e4rjepidevus J\u00e4rjepidevus t\u00e4hendab, et iga […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-with-title","meta":{"footnotes":""},"class_list":["post-1683","page","type-page","status-publish","hentry"],"yoast_head":"\n
Transaction - Timur Bashirov Portfolio<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transaction - Timur Bashirov Portfolio\" \/>\n<meta property=\"og:description\" content=\"Tehing on loogilises j\u00e4rjekorras toimingute jada, mida kasutaja v\u00f5i andmebaasiga t\u00f6\u00f6tav programm teeb. Tehing on muudatuste levitamine andmebaasis. N\u00e4iteks kui me loome, muudame v\u00f5i kustutame kirje, siis sooritame tehingu. Tehingute kontrollimine on \u00e4\u00e4rmiselt oluline tagada. Tehingu p\u00f5him\u00f5isteid kirjeldab akron\u00fc\u00fcm ACID – Aatomisus tagab, et iga tehing salvestatakse ainult tervikuna (t\u00e4ielikult). J\u00e4rjepidevus J\u00e4rjepidevus t\u00e4hendab, et iga […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/\" \/>\n<meta property=\"og:site_name\" content=\"Timur Bashirov Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-21T06:44:11+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/tehing\\\/\",\"url\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/tehing\\\/\",\"name\":\"Transaction - Timur Bashirov Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/tehing\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/tehing\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/pilt-19.png\",\"datePublished\":\"2024-09-19T08:36:26+00:00\",\"dateModified\":\"2025-10-21T06:44:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/tehing\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/tehing\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/tehing\\\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/tehing\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transaction\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Timur Bashirov Portfolio\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/timurbasirov23.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Transaction - Timur Bashirov Portfolio","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:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/","og_locale":"en_US","og_type":"article","og_title":"Transaction - Timur Bashirov Portfolio","og_description":"Tehing on loogilises j\u00e4rjekorras toimingute jada, mida kasutaja v\u00f5i andmebaasiga t\u00f6\u00f6tav programm teeb. Tehing on muudatuste levitamine andmebaasis. N\u00e4iteks kui me loome, muudame v\u00f5i kustutame kirje, siis sooritame tehingu. Tehingute kontrollimine on \u00e4\u00e4rmiselt oluline tagada. Tehingu p\u00f5him\u00f5isteid kirjeldab akron\u00fc\u00fcm ACID – Aatomisus tagab, et iga tehing salvestatakse ainult tervikuna (t\u00e4ielikult). J\u00e4rjepidevus J\u00e4rjepidevus t\u00e4hendab, et iga […]","og_url":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/","og_site_name":"Timur Bashirov Portfolio","article_modified_time":"2025-10-21T06:44:11+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/","url":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/","name":"Transaction - Timur Bashirov Portfolio","isPartOf":{"@id":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/#primaryimage"},"image":{"@id":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/#primaryimage"},"thumbnailUrl":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-19.png","datePublished":"2024-09-19T08:36:26+00:00","dateModified":"2025-10-21T06:44:11+00:00","breadcrumb":{"@id":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/tehing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"Transaction"}]},{"@type":"WebSite","@id":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/#website","url":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/","name":"Timur Bashirov Portfolio","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/1683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=1683"}],"version-history":[{"count":1,"href":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/1683\/revisions"}],"predecessor-version":[{"id":1807,"href":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/1683\/revisions\/1807"}],"wp:attachment":[{"href":"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=1683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-19.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-20.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-27.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-28-1024x78.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-29.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-30.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-31.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/timurbasirov23.thkit.ee\/wp\/eng\/wp-content\/uploads\/2024\/09\/pilt-26.png\")
<\/figure>\n\n\n\n