Sakin DBMS , wanda aka ƙera don adanawa da sarrafa bayanai a cikin nau'i na jerin lokaci (yankakken ma'auni a cikin ƙayyadaddun tazara; rikodin yana samar da lokaci da saitin dabi'u masu dacewa da wannan lokacin). Wannan nau'i na ajiya shine mafi kyau ga aikace-aikace kamar tsarin sa ido, dandamali na ciniki, tsarin tattara ma'auni da jihohin firikwensin. Ana ba da kayan aikin haɗin kai tare da aikin и .
Ana aiwatar da aikin TimescaleDB azaman haɓakawa zuwa PostgreSQL da lasisi a ƙarƙashin Apache 2.0. tare da ci-gaba fasali samuwa a ƙarƙashin keɓan lasisin mallakar mallaka (TSL), wanda ba ya ƙyale canje-canje, ya haramta amfani da lambar a cikin samfurori na ɓangare na uku kuma baya bada izinin amfani da kyauta a cikin bayanan girgije (database-as-a-service).
Daga cikin canje-canje a cikin TimecaleDB 1.7:
- Ƙara goyon baya don haɗin kai tare da DBMS . Goyon baya ga PostgreSQL 9.6.x da 10.x an soke su (Timescale 2.0 zai goyi bayan PostgreSQL 11+ kawai).
- An canza halayen tambayoyin tare da ci gaba da gudanar da ayyukan tara (taron bayanan ci gaba da shigowa cikin ainihin lokaci). Irin waɗannan tambayoyin yanzu suna haɗa ra'ayoyi na zahiri tare da sabbin bayanai da suka zo waɗanda ba a yi su ba tukuna (a da, tara bayanan da aka riga aka yi kawai). Sabuwar dabi'ar ta shafi sabbin ci gaba da tarawa; don ra'ayoyin da ake da su, ya kamata a saita siga "timescaledb.materialized_only=arse" ta hanyar "MAGANIN KYAUTA".
- Wasu ci-gaba na kayan aikin sarrafa rayuwar rayuwar bayanai an canza su zuwa sigar Al'umma daga bugu na kasuwanci, gami da ikon sake tattara bayanai da aiwatar da manufofin korar bayanan da ba a daina amfani da su ba (ba ku damar adana bayanan yanzu kawai da sharewa ta atomatik, tara ko adana bayanan da ba a gama ba).
Bari mu tuna cewa TimescaleDB DBMS yana ba ku damar amfani da cikakkun tambayoyin SQL don nazarin bayanan da aka tara, haɗa sauƙin amfani da ke cikin DBMSs masu alaƙa tare da ƙima da iyawar da ke cikin tsarin NoSQL na musamman. An inganta tsarin ajiya don tabbatar da babban saurin ƙara bayanai. Yana goyan bayan ƙara adadin saitin bayanai, amfani da fihirisar ƙwaƙwalwar ajiya, ɗaukar nauyi na yanki na tarihi, da amfani da ma'amaloli.
Babban fasalin TimecaleDB shine goyan bayan sa don rarraba ta atomatik na tsararrun bayanai. Ana rarraba rafin bayanan shigarwa ta atomatik a cikin allunan da aka raba. Ana ƙirƙira sashe dangane da lokaci (kowane sashe yana adana bayanai na ɗan lokaci) ko dangane da maɓalli na sabani (misali, ID na na'ura, wuri, da sauransu). Don inganta aiki, ana iya rarraba allunan da aka raba a cikin fayafai daban-daban.
Don tambayoyi, bayanan da aka raba su yayi kama da babban teburi guda ɗaya da ake kira hypertable. A hypertable wakilci na kama-da-wane na yawancin teburi guda ɗaya waɗanda ke tara bayanai masu shigowa. Ana amfani da hypertable ba kawai don tambayoyi da ƙara bayanai ba, har ma don ayyuka kamar ƙirƙirar firikwensin da canza tsarin ("ALTER TABLE"), ɓoye ƙananan matakan sassa na tsarin bayanai daga mai haɓakawa. Tare da hypertable, za ka iya amfani da kowane tara ayyuka, subqueries, hade ayyuka (JOIN) tare da na yau da kullum tebur ayyuka, da taga ayyuka.
source: budenet.ru