ndeye ACID-inoenderana nehukama dhatabhesi manejimendi system, iri mudiki raibhurari yakanyorwa muC
Ivo vanogadzira chirongwa SQLite vatanga kuyedza HCtree backend iyo inotsigira row-level kukiya uye inopa yakakwira mwero weparallelism mukugadzirisa mibvunzo.
Nezvekumashure kutsva kwavari kushanda, kunotaurwa kuti izvi ine chinangwa chekuvandudza kugona kwekushandisa SQLite mumatengi-server masisitimu Vanofanira kugadzirisa nhamba huru yezvikumbiro zvekunyora panguva imwe chete kune database.
ari b-miti zvimiro zvakashandiswa pakutanga muSQLite kuchengetedza data Izvo hazvina kugadzirirwa rudzi urwu rwemutoro., iyo inomisa SQLite kunyora kune imwe chete rwizi. Sechiyedzo, vanogadzira vakatanga kugadzira imwe mhinduro inoshandisa zvimiro zveHCtree yekuchengetedza, yakanyatsokodzera kuenderana kunyora mabasa.
Iyo HC-muti (hctree) purojekiti kuyedza kugadzira dhatabhesi nyowani backend inovandudza pane yakajairwa SQLite sezvinotevera:
Yakavandudzwa concurrency: Kushandisa iyo yekutanga-yakafanana yekuwedzera inoshandura izvi kuti zvigone kuitwa panguva imwe chete uchishandisa tarisiro yekuvhara padanho repeji. Izvi zvinonatsiridza concurrency neimwe nzira, asi peji-level kukiya kunogona kuona makakatanwa pakati pezvine musoro zvekutengesa zvakazvimirira, uye COMMIT mashandiro achiri kuda kuteedzerwa.
Replication rutsigiro: Stock SQLite inotsigira iyo chikamu chekuwedzera, iyo inobvumira zviri mukati mekutengeserana kwakazvipira kuve serialized kuendesa uye kushandiswa kune yechipiri dhatabhesi. Hctree inobatanidza izvi mune dhatabhesi backend uye inowedzera tsigiro yekushandisa kutengeserana kwakadaro kune vateveri dhatabhesi mumagadzirirwo emutungamiri-vateveri. Muchiitiko ichi, kutengeserana kwakagamuchirwa kubva kune inotungamira dhatabhesi kunogona kushandiswa nekukurumidza uye neyakakura concurrency kupfuura iyo yakatanga kushandiswa kune inotungamira dhatabhesi, nekuti kwete. kutengeserana kusimbiswa.
Kubviswa kwezvipimo zvehukuru hwe database: Stock SQLite inoshandisa 32-bit peji nhamba. Uchishandisa saizi yepeji yekusarudzika ye4 KB, izvi zvinotungamira kune yakakura dhatabhesi saizi ye2^44 bytes kana 16 TiB.
Kubata akati wandei maoparesheni panguva imwe chete, HCtree matanda anoshandisa transaction kupatsanura michina iyo inoshandisa makiyi emapeji ekukiya, yakafanana neMVCC (yakawanda vhezheni inotakura control), asi inoshandisa transaction controls yakavakirwa pakiyi renji uye makiyi renji panzvimbo yemapeji seti.
Kuverenga nekunyora mabasa anoitwa maererano nedatabase snapshot, iyo shanduko inozoonekwa kune huru dhatabhesi chete mushure mekunge kutengeserana kwapera.
Vatengi vanogona kushandisa mashandiro matatu kuvhura kutengeserana:
- «TANGIRA«: Transaction haifungi nezve data yekuwana yevamwe vatengi. Kana mabasa ekunyora akaitwa mukati mekutengeserana, kutengeserana kunogona kuitwa chete kana pasina mamwe maitiro ekunyora kune database panguva yekuitwa kwayo.
«TANGA PAKUPENYIRA«: Transactions inounganidza ruzivo nezve kuwana kwevamwe vatengi. Kana zvinyorwa zvekunyora zvikaitwa mukati mekutengeserana, kutengeserana kunogona kuitwa kana kumwe kutengeserana kwakaitwa kudhatabhesi kubva pakagadzirwa mufananidzo.
«TANGA EXCLUSIVE«: mushure mekuvhura kutengeserana, inovhara mashandiro ezvimwe zvekutengesa kusvika zvapera.
HCtree inotsigira tenzi-muranda kudzokorora, izvo zvinokutendera iwe kuendesa kutengeserana kune imwe dhatabhesi uye chengetedza yechipiri dhatabhesi mukuwiriranisa neyekutanga dhatabhesi.
HCtree inobvisawo muganho wehukuru hwedhatabhesi: pachinzvimbo chezviziviso zvepeji yedata 32-bit, HCtree inoshandisa zviziviso zve48-bit, izvo zvinowedzera saizi yepamusoro yedatabase kubva pa16 tebibytes kusvika pa1 exbibyte (mamiriyoni tebibytes).
SQLite kuita neHCtree backend inotarisirwa kunge yakanaka kunge yakasarudzika-yakaiswa tambo yekumashure. Vatengi veSQLite vane HCtree rutsigiro vachakwanisa kuwana ese HC-muti dhatabhesi uye nhaka SQLite dhatabhesi.
mabviro: https://sqlite.org/