Abathuthukisi bephrojekthi ye-SQLite sebeqalile ukuhlola i-HCtree backend yokuhlola esekela ukukhiya kwezinga lomugqa futhi inikeza izinga eliphezulu lokufana lapho kucutshungulwa imibuzo. I-backend entsha ihloselwe ukuthuthukisa ukusebenza kahle kokusebenzisa i-SQLite ezinhlelweni ze-client-server okufanele zicubungule inani elikhulu lezicelo zokubhala kanyekanye kusizindalwazi.
Izakhiwo ze-b-tree ezisetshenziswa ngokomdabu ku-SQLite ukugcina idatha aziklanyelwe lolu hlobo lomthwalo, olukhawulela i-SQLite ukuthi ibhale umucu owodwa kuphela. Njengokuhlola, abathuthukisi baqala ukwenza esinye isixazululo esisebenzisa izakhiwo ze-HC-tree ukuze zigcinwe, ezifaneleka kakhulu ekusebenzeni kokubhala okuhambisanayo.
Ukuvumela imisebenzi eminingi ukuthi isebenze ngesikhathi esisodwa, irekhodi le-HCtree lisebenzisa indlela yokuhlukanisa umsebenzi esebenzisa ukukhiya izinga lekhasi futhi iyafana ne-MVCC (Multi-Version Concurrency Control) kodwa isebenzisa ukuhlola okwenziwayo okusekelwe kokhiye nobubanzi bokhiye esikhundleni samasethi ekhasi. Imisebenzi yokufunda nokubhala yenziwa ngokuxhumene nesifinyezo sesizindalwazi, izinguquko ezibonakala kusizindalwazi esiyinhloko kuphela ngemva kokuqedwa kokwenziwayo.
Amaklayenti angasebenzisa imisebenzi emithathu evulekile yokuthenga:
- βQALAββimisebenzi ayinaki idatha yokufinyelela yamanye amaklayenti. Uma imisebenzi yokubhala yenziwa ngaphakathi kokuthengiselana, ukuthengiselana kungenziwa kuphela uma ngesikhathi sokwenziwa kwayo ingekho eminye imisebenzi yokubhala kusizindalwazi.
- "QALA NGESONTO" - okwenziwayo kuqoqa ulwazi mayelana nokufinyelela kwamanye amaklayenti. Uma imisebenzi yokubhala yenziwa ngaphakathi kokwenziwe, umsebenzi ungenziwa uma okunye ukuthengiselana kwenziwe kusizindalwazi kusukela kwadalwa isifinyezo.
- βQALA OKUKHETHEKILEβ - ngemva kokuvula umsebenzi, ivimbela ukusebenza kokunye ukuthengiselana kuze kuqedwe.
I-HCtree isekela ukuphindaphinda kwe-master-slave, okukuvumela ukuthi uthuthele okwenziwayo kwenye isizindalwazi futhi ugcine imininingwane egciniwe yesibili ivunyelaniswa nesizindalwazi esiyinhloko. I-HCtree iphinde isuse umkhawulo kusayizi wesizindalwazi - esikhundleni sezihlonzi zekhasi ledatha ye-32-bit, i-HCtree isebenzisa amabhithi angama-48, okwandisa umkhawulo kasayizi wesizindalwazi usuka ku-16 tebibytes uye ku-exbibyte eyi-1 (ama-tebibytes ayisigidi). Kulindeleke ukuthi ukusebenza kwe-SQLite nge-HCtree backend ngeke kube ngaphansi kune-backend yakudala yochungechunge olulodwa. Amaklayenti e-SQLite anosekelo lwe-HCtree azokwazi ukufinyelela kokubili izizindalwazi ezisekelwe esihlahleni se-HC kanye nezingobolwazi ze-SQLite zefa.
Source: opennet.ru