DBMS tso tawm , tsim los khaws cia thiab ua cov ntaub ntawv nyob rau hauv daim ntawv ntawm ib lub sij hawm series (slices ntawm parameter qhov tseem ceeb ntawm lub sij hawm teev; cov ntaub ntawv cov ntaub ntawv lub sij hawm thiab ib tug txheej ntawm cov nqi sib xws rau lub sij hawm no). Daim ntawv khaws cia no yog qhov zoo rau cov ntawv thov xws li kev soj ntsuam cov tshuab, kev lag luam platforms, cov tshuab sau cov ntsuas ntsuas thiab ntsuas lub xeev. Cov cuab yeej rau kev koom ua ke nrog qhov project yog muab ΠΈ .
Lub TimescaleDB qhov project yog siv los ua qhov txuas ntxiv rau PostgreSQL thiab muaj ntawv tso cai nyob rau hauv Apache 2.0. nrog cov yam ntxwv siab heev muaj nyob rau hauv daim ntawv tso cai tshwj xeeb (TSL), uas tsis tso cai hloov pauv, txwv tsis pub siv cov cai hauv cov khoom thib peb thiab tsis tso cai siv dawb hauv huab databases (database-as-a-service).
Ntawm cov kev hloov pauv hauv TimescaleDB 1.7:
- Ntxiv kev txhawb nqa rau kev koom ua ke nrog DBMS . Kev them nyiaj yug rau PostgreSQL 9.6.x thiab 10.x tau deprecated (Timescale 2.0 yuav tsuas txhawb PostgreSQL 11+).
- Tus cwj pwm ntawm cov lus nug nrog kev ua haujlwm tsis tu ncua (kev sib sau ua ke ntawm cov ntaub ntawv nkag mus tsis tu ncua hauv lub sijhawm tiag tiag) tau hloov pauv. Xws li cov lus nug tam sim no muab cov ntsiab lus pom zoo nrog cov ntaub ntawv tuaj txog tshiab uas tseem tsis tau ua tiav (yav dhau los, kev sib sau tsuas yog them cov ntaub ntawv uas twb tau ua tiav lawm). Tus cwj pwm tshiab siv rau cov kev sib sau ua ke tshiab uas tau tsim tas li; rau cov kev xav uas twb muaj lawm, "timescaledb.materialized_only=false" parameter yuav tsum tau teeb tsa ntawm "ALTER VIEW".
- Qee cov ntaub ntawv tshaj lij kev tswj hwm lub neej tau raug xa mus rau Zej Zog version los ntawm kev lag luam luam tawm, suav nrog kev muaj peev xwm rov sau cov ntaub ntawv thiab txheej txheem cov ntaub ntawv tshem tawm tsis siv neeg cov cai (tso cai rau koj khaws cov ntaub ntawv tam sim no nkaus xwb thiab rho tawm, sau lossis khaws cov ntaub ntawv uas tsis siv lawm).
Cia peb nco qab tias TimescaleDB DBMS tso cai rau koj siv tag nrho cov lus nug SQL los txheeb xyuas cov ntaub ntawv khaws tseg, sib txuas qhov yooj yim ntawm kev siv los ntawm kev sib raug zoo DBMSs nrog kev ntsuas thiab muaj peev xwm muaj nyob rau hauv tshwj xeeb NoSQL systems. Cov qauv cia yog optimized los xyuas kom meej kev kub ceev ntawm cov ntaub ntawv ntxiv. Nws txhawb batch sib ntxiv ntawm cov ntaub ntawv teev, kev siv ntawm cov cim xeeb indexes, retroactive loading ntawm keeb kwm slices, thiab kev siv ntawm muas.
Ib qho tseem ceeb ntawm TimescaleDB yog nws cov kev txhawb nqa rau kev muab faib tsis siv neeg ntawm cov ntaub ntawv array. Cov input cov ntaub ntawv kwj yog cia li muab faib nyob rau hauv partitioned rooj. Cov ntu raug tsim nyob ntawm lub sijhawm (txhua ntu khaws cov ntaub ntawv rau lub sijhawm qee lub sijhawm) lossis cuam tshuam nrog tus yuam sij tsis txaus ntseeg (piv txwv li, ntaus ID, qhov chaw, thiab lwm yam). Txhawm rau txhim kho kev ua tau zoo, cov rooj sib faib tuaj yeem muab faib ua ntau hom disks.
Rau cov lus nug, cov ntaub ntawv muab faib zoo li ib lub rooj loj hu ua hypertable. Lub hypertable yog ib tug virtual sawv cev ntawm ntau tus neeg cov ntxhuav uas sau cov ntaub ntawv tuaj. Lub hypertable yog siv tsis tau tsuas yog rau cov lus nug thiab ntxiv cov ntaub ntawv, tab sis kuj rau kev khiav hauj lwm xws li tsim indexes thiab hloov cov qauv ("ALTER TABLE"), zais cov theem qis segmented qauv ntawm cov database los ntawm tus tsim tawm. Nrog lub hypertable, koj tuaj yeem siv tag nrho cov haujlwm sib sau ua ke, subqueries, ua haujlwm sib koom ua ke (JOIN) nrog cov rooj tsis tu ncua, thiab lub qhov rais ua haujlwm.
Tau qhov twg los: opennet.ru