Kuburitswa kweDBMS , yakagadzirirwa kuchengetedza uye kugadzirisa dhata muchimiro chenguva yakatevedzana (zvimedu zvemitengo yeparameter panguva dzakatarwa; rekodhi inoumba nguva uye seti yehunhu inoenderana nenguva ino). Iyi fomu yekuchengetedza ndiyo yakanakira zvikumbiro zvakaita sekutarisa masisitimu, mapuratifomu ekutengesa, masisitimu ekuunganidza metrics uye sensor nyika. Zvishandiso zvekubatanidza neprojekti zvinopihwa ΠΈ .
Iyo TimescaleDB chirongwa chinoitwa sekuwedzera kuPostgreSQL uye ine rezinesi pasi peApache 2.0. ine maficha epamusoro anowanikwa pasi perezenisi remuridzi rakasiyana (TSL), iyo isingabvumiri kuchinja, inorambidza kushandiswa kwekodhi mune zvechitatu-party zvigadzirwa uye haibvumiri kushandiswa kwemahara mumafu databases (database-as-a-service).
Pakati pekuchinja mu TimescaleDB 1.7:
- Yakawedzerwa rutsigiro rwekubatanidza neDBMS . Tsigiro yePostgreSQL 9.6.x uye 10.x yakaregwa (Timescale 2.0 inongotsigira PostgreSQL 11+).
- Maitiro emibvunzo nekuenderera mberi achimhanya aggregate mabasa akachinjwa (kuunganidzwa kwe data rinoramba richiuya munguva chaiyo). Mibvunzo yakadai ikozvino inosanganisa maonero akaitwa nedata richangosvika risati raitwa (kare, kuunganidzwa kwakangovharwa data iro rakatoitwa). Hunhu hutsva hunoshanda kune zvichangobva kugadzirwa zvinoramba zvichiunganidzwa; pamaonero aripo, "timescaledb.materialized_only=false" parameter inofanira kusetwa kuburikidza ne "ALTER VIEW".
- Mamwe maturusi epamusoro-soro ekuchengetedza data akaendeswa kune iyo Nharaunda vhezheni kubva kushanduro yekutengeserana, kusanganisira kugona kuunganidzazve data uye kugadzirisa echinyakare marekodhi ekudzinga data (zvichikubvumidza iwe kuchengeta data razvino chete uye kudzima otomatiki, kuunganidza kana kuchengetedza marekodhi echinyakare).
Ngatiyeukei kuti TimescaleDB DBMS inokutendera kuti ushandise yakazara-yakazara SQL mibvunzo kuongorora yakaunganidzwa data, kusanganisa kureruka kwekushandisa kunowanikwa mune hukama maDBMS nekuyera uye kugona kuri muhunyanzvi hweNoSQL masisitimu. Iyo yekuchengetedza chimiro yakagadziridzwa kuti ive nechokwadi chekumhanya kwekuwedzera data. Inotsigira batch kuwedzera kwemaseti e data, kushandiswa kwe-mu-memory indexes, kudzoreredza kurodha kwezvimedu zvenhoroondo, uye kushandiswa kwekutengeserana.
Chinhu chakakosha che TimescaleDB kutsigira kwayo otomatiki kupatsanura kweiyo data array. Iyo yekupinza data rwizi inogovaniswa otomatiki pamatafura akapatsanurwa. Zvikamu zvinogadzirwa zvinoenderana nenguva (chikamu chimwe nechimwe chinochengeta data kweimwe nguva yenguva) kana zvine chekuita nekiyi yekupokana (semuenzaniso, ID yemuchina, nzvimbo, nezvimwewo). Kuti uwedzere kuita, matafura akapatsanurwa anogona kugoverwa mumadhisiki akasiyana.
Pamibvunzo, dhatabhesi rakakamurwa rinotaridzika setafura hombe inonzi hypertable. A hypertable inomiririra chaiyo yematafura akawanda ega anounganidza data rinouya. Iyo hypertable haishandiswe kwete kubvunza chete uye kuwedzera data, asiwo kune ma operation akadai sekugadzira indexes uye kushandura chimiro ("ALTER TABLE"), kuvanza yakaderera-chikamu chechikamu cheiyo dhatabhesi kubva kumugadziri. Ne hypertable, unogona kushandisa chero aggregate mabasa, subqueries, kubatanidza mashandiro (JOIN) nematafura akajairwa, uye hwindo mabasa.
Source: opennet.ru