Kusintha kwa DBMS , yopangidwa kuti isungidwe ndi kukonza zidziwitso mumndandanda wanthawi (magawo amitundu yazigawo pakanthawi kochepa; mbiriyo imapanga nthawi ndi seti yazikhalidwe zogwirizana ndi nthawi ino). Kusungirako kotereku ndi koyenera kwa mapulogalamu monga kuyang'anira machitidwe, nsanja zamalonda, machitidwe osonkhanitsa ma metrics ndi sensa states. Zida zophatikizana ndi polojekitiyi zimaperekedwa и .
Pulojekiti ya TimescaleDB ikugwiritsidwa ntchito ngati chowonjezera ku PostgreSQL ndi zololedwa pansi pa Apache 2.0. zokhala ndi zida zapamwamba zomwe zikupezeka pansi pa laisensi yaumwini (TSL), yomwe siyilola kusintha, imaletsa kugwiritsa ntchito kachidindo muzinthu zamagulu ena ndipo salola kugwiritsa ntchito kwaulere m'mabuku amtambo (database-as-a-service).
Zina mwa zosintha mu TimescaleDB 1.7:
- Thandizo lowonjezera lophatikizana ndi DBMS . Thandizo la PostgreSQL 9.6.x ndi 10.x latsitsidwa (Timescale 2.0 idzangogwira PostgreSQL 11+).
- Makhalidwe a mafunso okhala ndi ntchito zophatikizika mosalekeza (kuphatikiza kwa data yomwe ikubwera mosalekeza munthawi yeniyeni) asinthidwa. Mafunso oterowo tsopano akuphatikiza mawonedwe aumunthu ndi zomwe zangobwera kumene zomwe sizinapangidwe (kale, kuphatikizika kumangophimba zomwe zidakhalapo kale). Khalidwe latsopanoli likugwiranso ntchito pazophatikiza zomwe zangopangidwa kumene; pazowonera zomwe zilipo, "timescaledb.materialized_only=false" parameter iyenera kukhazikitsidwa kudzera pa "ALTER VIEW".
- Zida zina zotsogola zoyendetsera moyo wa data zasamutsidwira ku mtundu wa Community kuchokera ku mtundu wamalonda, kuphatikiza kuthekera kosonkhanitsira deta ndi kukonza mfundo zothamangitsira zomwe zidatha kale (kukulolani kuti musunge zomwe zilipo komanso kufufuta, kusonkhanitsa kapena kusunga zolemba zakale).
Tikumbukire kuti TimescaleDB DBMS imakupatsani mwayi wogwiritsa ntchito mafunso onse a SQL kuti mufufuze zomwe zasonkhanitsidwa, kuphatikiza kumasuka kwa kugwiritsa ntchito komwe kumayenderana ndi ma DBMS ogwirizana ndi makulitsidwe ndi kuthekera komwe kuli mumayendedwe apadera a NoSQL. Zosungirako zosungirako zimakonzedwa kuti zitsimikizire kuthamanga kwa deta yowonjezera. Imathandizira kuwonjezereka kwa ma seti a data, kugwiritsa ntchito ma index a kukumbukira, kubwezeretsanso magawo akale, komanso kugwiritsa ntchito zochitika.
Chofunikira chachikulu cha TimescaleDB ndikuthandizira kwake kugawikana kwadongosolo la data. Dongosolo la data lolowera limagawidwa pamatebulo onse. Magawo amapangidwa malinga ndi nthawi (gawo lililonse limasunga deta kwa nthawi inayake) kapena pokhudzana ndi kiyi yokhazikika (mwachitsanzo, chozindikiritsa chipangizo, malo, ndi zina). Kuti muwongolere magwiridwe antchito, matebulo ogawa amatha kugawidwa pama disks osiyanasiyana.
Pamafunso, database yogawidwa imawoneka ngati tebulo lalikulu lotchedwa hypertable. Hypertable ndi chithunzithunzi cha matebulo ambiri omwe amasonkhanitsa deta yomwe ikubwera. Hypertable imagwiritsidwa ntchito osati pafunso ndi kuwonjezera deta, komanso ntchito monga kupanga ma index ndikusintha mawonekedwe ("ALTER TABLE"), kubisala magawo otsika a database kuchokera kwa wopanga. Ndi hypertable, mutha kugwiritsa ntchito zophatikizika zilizonse, ma subqueries, kuphatikiza ntchito (JOIN) ndi matebulo okhazikika, ndi ntchito zazenera.
Source: opennet.ru