Atomicity (database systems)

In database systems, atomicity (/ˌætəˈmɪsəti/; from Ancient Greek: ἄτομος, romanized: átomos, lit. 'undividable') is one of the ACID (Atomicity, Consistency, Isolation, Durability) transaction properties. An atomic transaction is an indivisible and irreducible series of database operations such that either all occur, or none occur.[1] A guarantee of atomicity prevents partial database updates from occurring, because they can cause greater problems than rejecting the whole series outright. As a consequence, the transaction cannot be observed to be in progress by another database client. At one moment in time, it has not yet happened, and at the next it has already occurred in whole (or nothing happened if the transaction was cancelled in progress).

An example of an atomic transaction is a monetary transfer from bank account A to account B. It consists of two operations, withdrawing the money from account A and saving it to account B. Performing these operations in an atomic transaction ensures that the database remains in a consistent state, that is, money is neither lost nor created if either of those two operations fails.[2]

The same term is also used in the definition of First normal form in database systems, where it instead refers to the concept that the values for fields may not consist of multiple smaller values to be decomposed, such as a string into which multiple names, numbers, dates, or other types may be packed.

Orthogonality

Atomicity does not behave completely orthogonally with regard to the other ACID properties of transactions. For example, isolation relies on atomicity to roll back the enclosing transaction in the event of an isolation violation such as a deadlock; consistency also relies on atomicity to roll back the enclosing transaction in the event of a consistency violation by an illegal transaction.

As a result of this, a failure to detect a violation and roll back the enclosing transaction may cause an isolation or consistency failure.

Implementation

Typically, systems implement Atomicity by providing some mechanism to indicate which transactions have started and which finished; or by keeping a copy of the data before any changes occurred (read-copy-update). Several filesystems have developed methods for avoiding the need to keep multiple copies of data, using journaling (see journaling file system). Databases usually implement this using some form of logging/journaling to track changes. The system synchronizes the logs (often the metadata) as necessary after changes have successfully taken place. Afterwards, crash recovery ignores incomplete entries. Although implementations vary depending on factors such as concurrency issues, the principle of atomicity – i.e. complete success or complete failure – remain.

Ultimately, any application-level implementation relies on operating-system functionality. At the file-system level, POSIX-compliant systems provide system calls such as open(2) and flock(2) that allow applications to atomically open or lock a file. At the process level, POSIX Threads provide adequate synchronization primitives.

The hardware level requires atomic operations such as Test-and-set, Fetch-and-add, Compare-and-swap, or Load-Link/Store-Conditional, together with memory barriers. Portable operating systems cannot simply block interrupts to implement synchronization, since hardware that lacks concurrent execution such as hyper-threading or multi-processing is now extremely rare.[citation needed]

See also

References

  1. ^ "atomic operation". Webopedia. 25 November 2003. Retrieved 2011-03-23. An operation during which a processor can simultaneously read a location and write it in the same bus operation. This prevents any other processor or I/O device from writing or reading memory until the operation is complete.
  2. ^ Amsterdam, Jonathan. "Atomic File Transactions, Part 1". O'Reilly. Archived from the original on 2016-03-03. Retrieved 2016-02-28.

Read other articles:

Nawab of Sardhana

The Nawab of Sardhana is an honorary Muslim title bestowed upon the descendants of the Afghan noble chieftain (nawab) and statesman Jan-Fishan Khan, for services to the British Raj – both in the failed British Afghan campaigns, as well as during the 1857 Rebellion in India. The hereditary title was once accompanied by a large jagir at Sardhana, made up largely of ancestral lands which once belonging to the Begum Samru. While these lands have mostly now been dispensed of, the descendants of ...

 

Daniel Freund

German politician Daniel FreundMEPMember of the European ParliamentIncumbentAssumed office 2 July 2019Parliamentary groupThe Greens/European Free Alliance Personal detailsBorn (1984-10-14) 14 October 1984 (age 39)Aachen, GermanyPolitical partyAlliance 90/The GreensOther politicalaffiliationsEuropean Green PartyChildren1 son, 2 daughtersAlma materLeipzig UniversityParis Institute of Political StudiesGeorge Washington UniversityWebsitewww.danielfreund.eu Daniel Freund (born 14 October ...

 

Velòdrom d'Horta

This article includes a list of references, related reading, or external links, but its sources remain unclear because it lacks inline citations. Please help improve this article by introducing more precise citations. (September 2020) (Learn how and when to remove this template message) Velòdrom d'HortaThe banking of the Velòdrom d'HortaLocationBarcelona, Catalonia, SpainCoordinates41°26′17″N 2°08′56″E / 41.43813°N 2.148861°E / 41.43813; 2.148861Capacity3...

Technoparade

Parade of vehicles playing electronic dance music This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Technoparade – news · newspapers · books · scholar · JSTOR (September 2016) (Learn how and when to remove this template message) TechnoparadeA DJ mixing music and multiple dancers at the Paris Techno Parade. The...

 

Pengantin Pantai Biru (film 2010)

Untuk kegunaan lain, lihat Pengantin Pantai Biru. Pengantin Pantai BiruSutradaraNayato Fio NualaProduserFirman BintangDitulis olehEry SofidPemeranCatherine WilsonKeith FooUli AulianiCynthiara AlonaDebby AyuFendi TrihartantoRosnita PutriRico VeraldYoga HoebnerjTorro MargensPenata musikEka FirdausSinematograferNayato Fio Nuala Freddy A. LinggaPenyuntingTiara PusparaniDistributorKanta Indah FilmBic Production Multivision PlusTanggal rilis23 September 2010NegaraIndonesia Pengantin Pantai Bi...

 

Kapal selam kelas Cakra

KRI Cakra (401) Tentang kelas Nama:Cakra classPembangun:Howaldtswerke-Deutsche WerftOperator: Angkatan Laut IndonesiaDidahului oleh:Kapal selam kelas WhiskeyDigantikan oleh:Kapal selam kelas ScorpèneDibangun:1977–1981Bertugas:1981–sekarangSelesai:2Aktif:1Hilang:1 Ciri-ciri umum Jenis Kapal selam serbuBerat benaman 1,285 ton di permukaan[1] 1,390 ton menyelamPanjang 595 m (1.952 ft 1 in)Lebar 62 m (203 ft 5 in)Sarat air 54 m (177 ft 2&...

Франц (герцог Саксен-Кобург-Заальфельдский)

Франц Саксен-Кобург-Заальфельдскийнем. Franz von Sachsen-Coburg-Saalfeld герцог Саксен-Кобург-Заальфельдский 8 сентября 1800 — 9 декабря 1806 Предшественник Эрнст Фридрих Саксен-Кобург-Заальфельдский Преемник Эрнст I Саксен-Кобург-Заальфельдский Рождение 15 июля 1750(1750-07-15)Кобург, Сакс...

 

新罕布什尔州

坐标：43°11′38″N 71°34′21″W / 43.1938516°N 71.5723953°W / 43.1938516; -71.5723953 此條目需要补充更多来源。 (2017年5月21日)请协助補充多方面可靠来源以改善这篇条目，无法查证的内容可能會因為异议提出而被移除。致使用者：请搜索一下条目的标题（来源搜索：新罕布什尔州 — 网页、新闻、书籍、学术、图像），以检查网络上是否存在该主题的更多可靠来源...

 

Zirah rantai dan lempeng

Untuk zirah yang terbuat sepenuhnya dari lempeng, lihat Zirah lempeng. Zirah rantai splint beralih ke halaman ini. Untuk zirah yang terbuat dari potongan logam panjang, lihat Zirah splint. Zirah rantai dan lempeng Russia (behterets), Museum Hermanni linn, Narva, Estonia. bahasa Polandia: Bechter diagramm Berbagai jenis cara menggabungkan pelat ke rantai Zirah rantai dan lempeng (mail and plate armour, plated mail, plated chainmail, splinted mail/chainmail) adalah jenis dari zirah rantai d...

中华人民共和国国家元首列表

  提示：此条目页的主题不是中華人民共和國最高領導人。 中华人民共和国 中华人民共和国政府与政治系列条目 执政党 中国共产党 党章、党旗党徽 主要负责人、领导核心 领导集体、民主集中制 意识形态、组织 以习近平同志为核心的党中央 两个维护、两个确立 全国代表大会 （二十大） 中央委员会 （二十届） 总书记：习近平 中央政治局 常务委员会 中央书记处 �...

 

美国众议院

此條目需要补充更多来源。 (2021年7月4日)请协助補充多方面可靠来源以改善这篇条目，无法查证的内容可能會因為异议提出而被移除。致使用者：请搜索一下条目的标题（来源搜索：美国众议院 — 网页、新闻、书籍、学术、图像），以检查网络上是否存在该主题的更多可靠来源（判定指引）。 美國眾議院 United States House of Representatives第118届美国国会众议院徽章 众议院旗...

 

Zain al-Din al-'Iraqi

13th-century Kurdish Islamic scholar Zain al-Din al-'IraqiTitleShaykh al-Islām[1]Zain al-DinAl-ḤāfiẓPersonalBorn1325Died1403 (aged 78)ReligionIslamRegionEgyptDenominationSunniJurisprudenceShafi'iCreedAsh'ari[2]Main interest(s)Hadith, Usul Hadith, FiqhMuslim leader Influenced by Al-Shafi'iAbu Hasan al-Ash'ariAl-GhazaliIbn al-SalahAl-NawawiTaqi al-Din al-SubkiJamal al-Din al-Isnawi Influenced Wali al-Din al-'IraqiNur al-Din al-HaythamiIbn Hajar al-AsqalaniBadr al-Din ...

1960 Labour Party deputy leadership election

Election after the death of Aneurin Bevan 1960 Labour Party deputy leadership election ← 1959 3–10 November 1960 (1960-11-03 – 1960-11-10) 1961 →   Candidate George Brown Frederick Lee James Callaghan First ballot 118 (48.0%) 73 (29.7%) 55 (22.4%) Second ballot 146 (63.8%) 83 (36.2%) Eliminated Deputy Leader before election Aneurin Bevan Elected Deputy Leader George Brown The 1960 Labour Party deputy leadership election took place i...

 

Newmarket, New Zealand

Suburb in Auckland, New ZealandNewmarketSuburbBroadway, the main street of Newmarket.Coordinates: 36°52′12″S 174°46′39″E / 36.869862°S 174.777578°E / -36.869862; 174.777578CountryNew ZealandCityAucklandLocal authorityAuckland CouncilElectoral wardŌrākei wardLocal boardWaitematā Local BoardEstablished1840sArea[1] • Land85 ha (210 acres)Population (June 2023)[2] • Total2,680Train stationsNewmarket rai...

 

Reptile Gardens

This article's tone or style may not reflect the encyclopedic tone used on Wikipedia. See Wikipedia's guide to writing better articles for suggestions. (May 2014) (Learn how and when to remove this message) Zoo in South Dakota, United States Reptile GardensSky Dome43°59′25″N 103°16′18″W / 43.9903599°N 103.2716882°W / 43.9903599; -103.2716882Date openedJune 3, 1937LocationRapid City, South Dakota, United StatesWebsitewww.reptilegardens.com Reptile Gardens is...

Miguel Mateos

Miguel MateosInformación personalNombre de nacimiento Miguel Ángel Mateos SorrentinoApodo El Jefe del Rock en Español[1]​[2]​[3]​[4]​[5]​Nacimiento 26 de enero de 1954 (70 años) Buenos Aires, ArgentinaNacionalidad ArgentinaInformación profesionalOcupación Cantautor, productor y músicoAños activo Desde 1969Géneros Pop contestatario, pop rock, new wave, post-punk, post-disco, synth pop, heartland rock y americanaInstrumentos Voz, guitarra, teclados, p...

 

Christ the King College, Isle of Wight

School in Isle of Wight, UK Christ the King CollegeChrist the King College lower campusAddressWellington RoadNewport, Isle of Wight, PO30 5QTEnglandCoordinates50°41′39″N 1°18′38″W / 50.6941°N 1.3105°W / 50.6941; -1.3105InformationTypeVoluntary aided schoolMottoVia Veritas VitaReligious affiliation(s)Church of England/Roman CatholicEstablished2008Local authorityIsle of WightDepartment for Education URN135552 TablesOfstedReportsChair of GovernorsE BurdenStaff...

 

Jaime Alguersuari

Jaime AlguersuariJaime Alguersuari di Grand Prix Kanada 2010.LahirJaime Víctor Alguersuari Escudero23 Maret 1990 (umur 34)Barcelona, SpanyolPekerjaanPembalap (pensiun)DJ, broadcasterTahun aktif2005–2015 (pembalap)2009–sekarang (DJ)Tinggi5 ft 11 in (1,80 m)Karier Kejuaraan Dunia Formula SatuKebangsaan SpanyolTahun aktif2009–2011TimToro RossoJumlah lomba46 (46 start)Juara Dunia0Menang0Podium0Total poin31Posisi pole0Lap tercepat0Lomba pertamaGrand Prix Hungaria 2...

.gw

Internet country code top-level domain for Guinea-Bissau This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: .gw – news · newspapers · books · scholar · JSTOR (February 2024) (Learn how and when to remove this message) .gwIntroduced4 February 1997TLD typeCountry code top-level domainStatusActiveRegistryAssociaç...

 

Malafretaz

Cet article est une ébauche concernant la Bresse et une commune de l’Ain. Vous pouvez partager vos connaissances en l’améliorant (comment ?) selon les recommandations des projets correspondants. Malafretaz Église Saint-Marc. Logo Administration Pays France Région Auvergne-Rhône-Alpes Département Ain Arrondissement Bourg-en-Bresse Intercommunalité Communauté d'agglomération du Bassin de Bourg-en-Bresse Maire Mandat Gary Leroux 2020-2026 Code postal 01340 Code commune 01229 D...