DuckDB bụ sistemụ nchekwa data SQL OLAP na-eme
N'oge na-adịbeghị anya a mara ọkwa ntọhapụ nke ụdị DuckDB 0.5.0 ọhụrụ, nke bụ usoro njikwa nchekwa data na-emepe emepe (DBMS) nke Google, Facebook, na Airbnb ji.
DuckDB bụ usoro nchekwa data nyocha dị elu. Emebere ya ka ọ bụrụ ngwa ngwa, ntụkwasị obi, yana dịkwa mfe iji. DuckDB na-enye olumba SQL bara ụba, yana nkwado karịrị SQL bụ isi. DuckDB na-akwado ajụjụ aka ike na akwụghị ụgwọ jikọrọ ọnụ, ọrụ windo, mkpokọta, ụdị mgbagwoju anya (arrays, structs), na ndị ọzọ.
N'ime njirimara ya bụ isi, ihe ndị a pụtara:
- Ntinye dị mfe
- Ejikọtara: enweghị njikwa ihe nkesa
- Otu usoro nchekwa faịlụ
- Nhazi nyocha ngwa ngwa
- Nyefe ngwa ngwa n'etiti R/Python na RDBMS
- Ọ naghị adabere na steeti mpụga ọ bụla. Dịka ọmụmaatụ, faịlụ nhazi dị iche iche, mgbanwe gburugburu ebe obibi.
- Otu usoro nchekwa faịlụ
- interface nwere ike ịmekọrịta. API mmemme SQL na-ada ụda
- Acid zuru oke site na MVCC
Ihe gbasara DuckDB 0.5.0
Otu n'ime ihe ọhụrụ ahụ bụ "esighị na isi", nke na-achọ idozi nsogbu ndị nwere ike ibilite mgbe data a na-ahazi dị ukwuu karịa ebe nchekwa site n'ịtụpụta nsonaazụ etiti..
Ọhụrụ mbipute na-eji ntụnye radix Tree (ART) Adaptive itinye mmachi ma mee ngwa nzacha ajụjụ. Ruo ugbu a, ndenye aha anaghị adịgide adịgide, na-eduga n'okwu ndị dị ka mfu nke ozi ndeksi na ogologo oge ibugharị maka tebụl nwere data.
ART ọ bụ, n'ezie, mbọ iji tinye mkpakọ kwụ ọtọ na kehoraizin iji mepụta usoro ndeksi kọmpat. Ebumnuche bụ usoro data dịka osisi, ebe ọkwa nke ọ bụla nke osisi nwere ozi gbasara akụkụ ụfọdụ nke data. A na-egosipụtakarị ha site na eriri agwa.
Ihe oru ngo a gbakwunyekwara njikarịcha nsonye, nsogbu a na-ahụkarị na ọdụ data nyocha. Hyoun Park, CEO na Chief Analyst na Amalgam Insights, kwuru na DuckDB dị iche na-abịa site na eziokwu na ọ bụ obere ngwa na-arụ ọrụ n'ime koodu dabeere workflows ngwa ngwa iṅomi nnukwu ụlọ ahịa nke data.
"DuckDB nwere ike na-agba ọsọ ajụjụ ozugbo na data na-enweghị nhazi etiti, nke na-eme ka nhazi ahụ dịkwuo mma. Site na echiche teknụzụ naanị, ọ dị ka Actian Vector, nke na-ewerekwa usoro ajụjụ OLAP vectorized, n'agbanyeghị na emebere Actian ka ọ nweta data kama ịrụ ọrụ na usoro ma ọ bụ ibu otu ọrụ. »
DuckDB Labs na-enye ndụmọdụ na nkwado. Onye nchoputa na onye isi ala Hannes Mühleisen, onye na-edekwa koodu ahụ ma na-akwado ọrụ ahụ, kwuru na ọ bụ SQLite, igwe nchekwa data OLTP na-enweghị ihe nkesa, ebe ọ hụrụ ohere maka ụzọ yiri nke ahụ, ma maka nyocha.
A na-ejikwa DuckDB dị ka akụkụ nke nchịkọta ma ọ bụ nchịkọta njikwa. ibu data. Dịka ọmụmaatụ, ọ bụrụ na mmadụ na-ewu ngwa omenala nke na-anakọta data wee chọọ ịmepụta interface SQL, ha ga-ebu ụzọ detuo data ma bugharịa ya na usoro ọzọ, nke nwere ike ịkpata nsogbu mmekọrịta, ọ kọwara.
Ibudata ma nweta
Ọ dị mkpa ikwupụta na ibe ụlọ na-ekwu n'ụzọ doro anya na e kwesịghị iji ya maka "nnukwu ndị ahịa/nrụnye ihe nkesa maka nchekwa data ụlọ ọrụ etiti".
Ihe oru ngo a na-arụ ọrụ na mwepụta nke ụdị 1.0, mgbe nke ahụ gasịrị, ọ gaghịzi ekwe omume ime mgbanwe. Ọrụ nke ndị ọkà mmụta sayensị nke Center for Mathematics and Theoretical Computer Science Centrum Wiskunde & Informatica na Amsterdam, DuckDB na-ejikọta ya na usoro nhazi, ọ dị mma ịmara na ọ dịghị ihe nkesa DBMS iji wụnye, melite ma ọ bụ nọgide na-enwe.
Dịka ọmụmaatụ, ngwugwu DuckDB Python nwere ike ịgba ajụjụ ozugbo na data sitere na ọba akwụkwọ sọftụ Python, na-ebubataghị ma ọ bụ detuo data. Edere DuckDB na C++, bụ n'efu na ebe mepere emepe n'okpuru ikike MIT.
Ị nwere ike ịmụtakwu banyere ya yana ịlele ntuziaka nwụnye, Na njikọ na-esonụ.
Bụrụ onye mbụ ịza ajụjụ