tsarin gudanar da bayanai ne na alaƙa da ACID, wanda ke ƙunshe a cikin ƙaramin ɗakin karatu da aka rubuta a cikin C
Masu haɓaka aikin SQLite sun fara gwada gwajin baya na HCtree wanda ke goyan bayan kulle matakin-jere kuma yana ba da babban matakin daidaitawa a cikin sarrafa tambaya.
Game da sabon backend da suke aiki, an ambaci cewa wannan yana da nufin haɓaka ingantaccen amfani da SQLite a cikin tsarin uwar garken abokin ciniki Dole ne su aiwatar da adadi mai yawa na buƙatun rubuta lokaci guda zuwa bayanan bayanai.
da b-bishiyar tsarin da aka fara amfani da su a cikin SQLite don adana bayanai Ba a tsara su don irin wannan nau'in kaya ba., wanda ke iyakance SQLite zuwa rubutu zuwa rafi ɗaya kawai. A matsayin gwaji, masu haɓakawa sun fara haɓaka madadin mafita wanda ke amfani da tsarin HCtree don ajiya, mafi dacewa da daidaita ayyukan rubutu.
Aikin HC-itace (hctree) ƙoƙari ne na haɓaka sabon bayanan bayanan bayanan da ke inganta akan SQLite na yau da kullun kamar haka:
Ingantattun daidaito: Yin amfani da tsawaita farawa-lokaci guda yana canza wannan don a iya aiwatar da shi a lokaci guda ta amfani da kyakkyawan kullewa a matakin shafi. Wannan yana inganta daidaituwa kaɗan, amma kulle matakin shafi na iya gano rikice-rikice tsakanin ma'amaloli masu zaman kansu, kuma har yanzu ayyukan COMMIT na buƙatar a jera su.
Taimakon maimaitawa: Stock SQLite yana goyan bayan tsawaita zaman, wanda ke ba da damar abubuwan da ke cikin ma'amalar da aka ƙaddamar don zama jeri don watsawa da aikace-aikacen zuwa bayanan bayanai na biyu. Hctree ya haɗa wannan a cikin bayanan bayanan bayanan kuma yana ƙara tallafi don amfani da irin waɗannan ma'amaloli zuwa ma'ajin bayanai na masu bi a cikin saitunan jagora-mabiyi. A wannan yanayin, ana iya amfani da ma'amaloli da aka karɓa daga manyan bayanan bayanai cikin sauri kuma tare da mafi girma fiye da waɗanda aka fara amfani da su zuwa manyan bayanan, saboda babu. tabbatar da ma'amala.
Cire iyakokin girman bayanai: Stock SQLite yana amfani da lambobin shafi 32-bit. Yin amfani da tsohowar girman shafi na 4 KiB, wannan yana kaiwa zuwa matsakaicin girman bayanan bayanai na 2^44 bytes ko 16 TiB.
Don gudanar da ayyuka da yawa a lokaci guda, HCtree rajistan ayyukan yi amfani da tsarin rabuwar ciniki wanda ke amfani da makullin matakin shafi, kama da MVCC (ikon sarrafa nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau'in nau`i),}}amma yana amfani da sarrafa ma`amala bisa maþallin maþallin da maþallin maþallin maimakon saitin shafi.
Ana yin aikin karantawa da rubutawa dangane da hoton bayanan bayanai, wanda canje-canjen zai zama bayyane ga babban bayanan bayanan kawai bayan an gama ciniki.
Abokan ciniki na iya amfani da ayyuka guda uku don buɗe ma'amaloli:
- «GAME«: Ma'amaloli ba sa la'akari da samun damar bayanai na sauran abokan ciniki. Idan an gudanar da ayyukan rubuce-rubuce a cikin ma'amala, za a iya aiwatar da ma'amalar kawai idan babu wasu ayyukan rubutawa ga ma'ajin bayanai yayin lokacin aiwatar da shi.
«FARA DAYA DAYA": Ma'amaloli suna tattara bayanai game da damar sauran abokan ciniki. Idan an aiwatar da ayyukan rubuce-rubuce a cikin ma'amala, ana iya yin ciniki idan an ƙaddamar da wasu ma'amaloli a cikin bayanan tun lokacin da aka ƙirƙiri hoton.
«FARA KENAN«: bayan bude ciniki, toshe ayyukan sauran ma'amaloli har sai an kammala.
HCtree yana goyan bayan kwafin master-bawa, wanda ke ba ka damar canja wurin ma'amaloli zuwa wani rumbun adana bayanai da kuma adana bayanan sirri na sakandare a daidaita tare da bayanan farko.
Har ila yau HCtree yana cire iyakar girman bayanai: maimakon masu gano bayanan shafi na 32-bit, HCtree yana amfani da masu ganowa 48-bit, wanda ke ƙara girman girman ma'auni daga tebibytes 16 zuwa 1 exbibyte (miliyan tebibytes).
Ayyukan SQLite tare da baya na HCtree ana tsammanin ya zama aƙalla mai kyau kamar na baya-bayan nan mai zare guda ɗaya. Abokan ciniki na SQLite tare da tallafin HCtree za su sami damar samun damar bayanai na HC-bishiyar da bayanan SQLite na gado.
Source: https://sqlite.org/