I-DuckDB yinkqubo yolawulo lwedatha ye-SQL OLAP ekwenzeni
Mva nje ukukhutshwa kwenguqulelo entsha ye-DuckDB 0.5.0 yabhengezwa, ephuhlisa inkqubo yolawulo lwedatha ye-analytics (DBMS) esetyenziswa yiGoogle, Facebook, kunye ne-Airbnb.
I-DuckDB yinkqubo yesiseko sedatha esebenza kakhulu. Yenzelwe ukuba ikhawuleze, ithembeke, kwaye kube lula ukuyisebenzisa. I-DuckDB ibonelela ngolwimi lwengingqi olutyebileyo lwe-SQL, kunye nenkxaso engaphaya kwesiseko seSQL. I-DuckDB ixhasa ii-subqueries ezidityanisiweyo kunye nendlwane ehambelanayo, imisebenzi yefestile, ukudibanisa, iindidi ezintsonkothileyo (i-arrays, i-structs), kunye nokunye.
Phakathi kweempawu zayo eziphambili, ezi zilandelayo zibalaseleyo:
- Ufakelo olulula
- Idityanisiwe: akukho lawulo lweseva
- Ugcino lwefayile enye
- Ukuqhubekeka kohlalutyo olukhawulezayo
- Ukutshintshwa ngokukhawuleza phakathi kwe-R / Python kunye ne-RDBMS
- Ayixhomekeke kuyo nayiphi na imeko yangaphandle. Umzekelo, iifayile zoqwalaselo ezahlukileyo, ukuguquguquka kwemekobume.
- Ugcino lwefayile enye
- Ujongano oluhlanganisiweyo. Fluent SQL Programmatic API
- Ngokupheleleyo ACID nge MVCC
Malunga neDuckDB 0.5.0
Phakathi kwezinto ezintsha "ngaphandle kwengundoqo", ejolise ekusombululeni iingxaki ezinokuvela xa idatha iqhutyelwa phambili inkulu kunememori ngokuphakamisa iziphumo eziphakathi..
Inguqulelo entsha isebenzisa i-Adaptive Radix Tree (ART) indexes ukufaka izithintelo kunye nokukhawulezisa izihluzi zemibuzo. Ukuza kuthi ga ngoku, izalathisi azizange ziqhubeke, ezikhokelela kwimiba efana nokulahleka kolwazi lwesalathiso kunye namaxesha okulayisha kwakhona amade kwiitafile ezixineneyo zedatha.
ART Ngokwenyani, yinzame yokufaka ucinezelo oluthe nkqo noluthe tye ukwenza izakhiwo zesalathiso esibambeneyo. Iinjongo zizakhiwo zedatha ezinjengomthi, apho umgangatho ngamnye womthi uqulethe ulwazi malunga nenxalenye ethile yedatha. Ngokuqhelekileyo ziboniswa ngeentambo zomlinganiswa.
Iprojekthi yongeze ulungelelwaniso lolungelelwaniso lokujoyina, ingxaki eqhelekileyo kwiinkcukacha zohlalutyo. UHyoun Park, i-CEO kunye noMhlalutyi oyiNtloko kwi-Amalgam Insights, uthe ukwahlukana kwe-DuckDB kuvela kwinto yokuba sisicelo esincinci esisebenza ngaphakathi kwekhowudi-based workflows ukuskena ngokukhawuleza iivenkile ezinkulu zedatha.
"I-DuckDB ihlala iqhuba imibuzo ngokuthe ngqo kwidatha ngaphandle kokulungiswa okuphakathi, okuphucula ukusetyenzwa. Ukusuka kwimbono yetekhnoloji esulungekileyo, iyafana ne-Actian Vector, ekwathatha indlela yombuzo we-OLAP we-columnar vectorized, nangona i-Actian yenzelwe ukulanda idatha kunokuba isebenze kwinkqubo okanye ilayishe umsebenzi othile. »
IiLabhu zeDuckDB zibonelela ngeengcebiso kunye nenkxaso. U-Co-founder kunye ne-CEO uHannes Mühleisen, naye wabhala ikhowudi kunye nokugcina iprojekthi, wathi uphefumlelwe yi-SQLite, injini yedatha ye-OLTP engenaseva, apho wabona ithuba lendlela efanayo, kodwa i-analytics.
I-DuckDB isoloko isetyenziswa njengenxalenye yohlahlelo okanye isitaki solawulo. idatha enkulu. Ngokomzekelo, ukuba umntu wakha isicelo esiqhelekileyo esiqokelela idatha kwaye emva koko ufuna ukudala i-SQL interface, kufuneka baqale bakopishe idatha kwaye bayihambise kwenye inkqubo, enokubangela imiba yokuvumelanisa, wachaza.
Khuphela kwaye ufumane
Kubalulekile ukukhankanya ukuba iphepha lasekhaya lichaza ngokucacileyo ukuba akufanele lisetyenziselwe "ufakelo olukhulu lweklayenti/umncedisi wogcino lwedatha yeshishini eliphakathi".
Iprojekthi isebenza ekukhutshweni kwenguqulo 1.0, emva koko akusayi kuba nako ukwenza utshintsho. Imisebenzi yabafundi beZiko leMathematika kunye neTheoretical Computer Science Centrum Wiskunde & Informatica e-Amsterdam, i-DuckDB ihlanganiswe kwinkqubo yokusingatha, kuyafaneleka ukuba uqaphele ukuba akukho software ye-server ye-DBMS yokufaka, ukuhlaziya okanye ukuyigcina.
Ngokomzekelo, iphakheji ye-DuckDB Python inokuqhuba imibuzo ngokuthe ngqo kwidatha evela kwilayibrari yesofthiwe yePython, ngaphandle kokungenisa okanye ukukopisha idatha. I-DuckDB ibhalwe kwi-C ++, ikhululekile kwaye ivulekile umthombo phantsi kwelayisensi ye-MIT.
Unokufunda ngakumbi malunga nayo kwaye uqhagamshelane nencwadana yokufakela, Kule khonkco ilandelayo.