DuckDB ndeye SQL OLAP dhatabhesi manejimendi system mukugadzira
Akazivisa kutanga kwe vhezheni itsva yeDuckDB 0.9.0 ine codename "Undulata" mukukudza dhadha reyero-billed rinobva kuAfrica. Iyo itsva edition inomira pachena nekubatanidza Out-Of-Core hashing, hashi aggregate performance ekuvandudza, kuvandudza mashandiro, nezvimwe.
DuckDB batanidza SQLite zvivakwa senge compactness, kugona kubatana muchimiro cheraibhurari yakasanganiswa, kuchengetedza dhatabhesi mune imwe faira uye iri nyore CLI interface, ine maturusi uye optimizations yekuita mibvunzo yekuongorora inovhara chikamu chakakosha che data rakachengetwa, semuenzaniso, iyo inoita kuunganidzwa kwezvose zviri mukati metafura kana kubatanidza akawanda matafura makuru.
Main new features of DuckDB 0.9.0 “Undulata”
Chimwe chezvinhu zvikuru zvitsva zveiyo vhezheni itsva yeDuckDB 0.9.0 pamwe ndiyo kuvandudzwa kwekuita neOut-Of-Core hashing, kubvira ikozvino pakuwedzera mahombe data seti paunenge uchigadzirisa mibvunzo. Zvinonzi nekushandisa yekutepfenyura execution injini uye buffer maneja, DuckDB inotsigira akawanda mashandiro pamaseti edata anopfuura ndangariro.
Mushanduro iyi, the dhisiki-kurasa rutsigiro rinowedzera kuwedzerwa nekutsigira kunze-kwe-core hash aggregates. Iyo inogadzirisa dambudziko rekupera kwekushanda nekuda kwekushaya ndangariro mumamiriro ezvinhu apo data rinoshandiswa kuwedzera tafura yehashi harina kukwana mu RAM.
Chimwe chitsva chinomira pachena ndechekuti tsigiro yekudzvanya kwetambo nemhando dzenhamba manhamba nguva pfupi data isati yapinda muboka remhando uye aggregation operators izvo zvakaderedza zvakanyanya ndangariro kushandiswa.
Pamusoro peizvi, isu tinogona zvakare kuwana iyo kurodha otomatiki kweakavimbika ekuwedzera uye ichaiswa sarudzo kana yashandiswa mumubvunzo. Zvinotaurwa kuti seti yeautoloading ekuwedzera inogumira kune ekuwedzera epamutemo akagoverwa neDuckDB Labs.
Kutaura pamusoro pekuwedzera, zvakare muDuckDB 0.9.0 "Undulata" a plugin yeAWS iyo inopa kugona kunoshandisa iyo AWS SDK. Kuwedzerwa uku kune "LOAD_AWS_CREDENTIALS" basa rinoshandiswa neAWS kuwana nekugadzirisa zvinyorwa.
Uyewo mune iyi shanduro inowedzerwa tsigiro yekuremedza ekuwedzera kuDuckDB-WASM. Pakutanga, chero yekuwedzera yawaida kushandisa neWASM mutengi yaifanira kubatanidzwa. Neiyi vhezheni, mawedzero anogona kutakurwa zvine simba. Kana yekuwedzera yakatakurwa, iyo WASM package inotorwa uye kushanda kwekuwedzera kunogoneswa.
Yeimwe shanduko izvo zvinoratidzika kubva pane iyi nyowani vhezheni:
- Yakagonesa kucheneswa otomatiki kwemapoka emitsara yese paunenge uchiita DELETE oparesheni. Sarudzo yekudzikisa dhatabhesi faira (kudzikisa saizi yayo) mushure mekudzima data inoitwa zvakare kana akadzimwa mitsara mapoka aive pakupera kwefaira.
- Yakavandudza mashandiro ekuchengetedza ART indexes anoshandiswa kuratidza kusarudzika kana makiyi ekutanga neekunze. Semuenzaniso, zvichienzaniswa neshanduro yapfuura, saizi ye index index yakaderera kubva 278 MB kusvika 78 MB.
- Gadzirisa regression uye gadzirisa eraser mechanism
- Yakagadziriswa segmentation kukanganisa paunenge uchiwedzera rondedzero data
- ART kuyedzwa uye bhenji refactoring
- Kuwedzera ndangariro muganho muyedzo kudzivirira isiri-deterministic IC kutadza
- Yakawedzera plugin yekuyedza kuverenga data kubva kuAzure storage.Kuwedzera uku kunobvumira DuckDB kuverenga data rakachengetwa muAzure, zvakafanana nemaverengero ainoita data yakachengetwa muS3.
- Kugadzirisa Jemalloc, kuwedzera buffer allocator uye kubvisa isina tambo kopi muduramazwi reparquet.
- Mutengi akawedzera rutsigiro rwekuyedza yePySpark API.
- Yakawedzera plugin yekuyedza kuverenga matafura muApache Iceberg fomati.
- Julia anogadziridza ku0.8.1
- Yakawedzera conn.interrupt() kuDuckDB Python API
- Gadzirisa pane zvakachinjwa x/y regression parameters
pakupedzisira kana uri kufarira kuziva zvakawanda nezvazvo, unogona kutarisa ruzivo Mune inotevera chinongedzo.