DuckDB shine tsarin sarrafa bayanai na SQL OLAP a cikin samarwa
Kwanan nan an sanar da sakin sabon sigar DuckDB 0.5.0, wanda shine tsarin gudanarwa na nazari mai tasowa (DBMS) wanda Google, Facebook, da Airbnb ke amfani dashi.
DuckDB babban aiki ne na tsarin bayanai na nazari. An ƙera shi don zama mai sauri, abin dogaro, da sauƙin amfani. DuckDB yana ba da ɗimbin yare na SQL, tare da tallafi fiye da SQL na asali. DuckDB yana goyan bayan sabani da ƙa'idodi masu alaƙa, ayyukan taga, haɗin kai, nau'ikan hadaddun (tsari, tsari), da ƙari.
Daga cikin manyan halayensa, abubuwan da ke biyo baya sun fice:
- Sauƙaƙe shigarwa
- Haɗe-haɗe: babu sarrafa uwar garken
- Tsarin ajiyar fayil guda ɗaya
- Sarrafa nazari mai sauri
- Canja wuri mai sauri tsakanin R/Python da RDBMS
- Ba ya dogara da kowace yanayi na waje. Misali, fayilolin sanyi daban, canjin yanayi.
- Tsarin ajiyar fayil guda ɗaya
- Ƙirƙiri mai haɗawa. API ɗin Shirye-shiryen Fluent SQL
- Cikakken ACID ta hanyar MVCC
Game da DuckDB 0.5.0
Daga cikin sabbin abubuwan akwai "babu tushe", wanda ke da nufin magance matsalolin da ka iya tasowa lokacin da bayanan da ake sarrafa su ya fi girma fiye da ƙwaƙwalwar ajiya ta hanyar ba da shawarar matsakaici..
Sabuwar sigar yana amfani da fihirisar Radix Tree (ART) Adaptive don aiwatar da hani da saurin tacewa. Har ya zuwa yanzu, fihirisa ba su dagewa ba, wanda ke haifar da al'amura kamar asarar bayanan fihirisa da dogon lokacin sake lodawa don takurawar bayanai.
ART shi ne, a zahiri, ƙoƙari ne na amfani da matsawa a tsaye da a kwance don ƙirƙirar ƙaƙƙarfan sifofi. Intents tsarin bayanai ne irin na bishiya, inda kowane matakin bishiyar ya ƙunshi bayanai game da wani ɓangaren saitin bayanan. Yawancin lokaci ana kwatanta su ta hanyar kirtani.
Aikin ya kuma kara inganta odar shiga, matsala gama gari a cikin ma'ajin bayanai. Hyoun Park, Shugaba kuma Babban Manazarci a Amalgam Insights, ya ce bambance-bambancen DuckDB ya fito ne daga gaskiyar cewa ƙaramin aikace-aikacen ne wanda ke aiki a cikin ayyukan aiki na tushen lamba don bincika manyan shagunan bayanai da sauri.
"DuckDB sau da yawa na iya gudanar da tambayoyin kai tsaye akan bayanan ba tare da tsaka-tsakin aiki ba, wanda ke haɓaka aiki. Daga mahangar fasaha zalla, yana da ɗan kama da Actian Vector, wanda kuma yana ɗaukar hanyar tambaya ta OLAP mai ƙima, kodayake Actian an ƙera shi don ɗaukar bayanai maimakon aiki akan tsari ko ɗaukar takamaiman aiki. »
DuckDB Labs yana ba da shawara da tallafi. Wanda ya kafa kuma Shugaba Hannes Mühleisen, wanda shi ma ya rubuta lambar tare da kula da aikin, ya ce ya sami wahayi daga SQLite, injin bayanan OLTP maras sabar, inda ya ga dama don irin wannan hanyar, amma don nazari.
Ana kuma amfani da DuckDB sau da yawa azaman wani ɓangare na nazari ko tarin gudanarwa. manyan bayanai. Misali, idan wani ya gina wata manhaja ta al'ada wacce ke tattara bayanai sannan kuma yana son ƙirƙirar hanyar sadarwa ta SQL, sai da farko ya kwafi bayanan kuma ya matsar da shi zuwa wani tsarin, wanda zai iya haifar da matsalolin daidaitawa, in ji shi.
Zazzage kuma samu
Yana da mahimmanci a ambaci cewa shafin gida ya faɗi a sarari cewa bai kamata a yi amfani da shi ba don "manyan abokin ciniki/sabar uwar garke don ma'ajiyar bayanan kamfani".
Aikin yana aiki akan sakin sigar 1.0, bayan haka ba za a ƙara yin canje-canje ba. Ayyukan ilimin kimiyya na Cibiyar lissafi da ilimin Komputer Cologram coloments, duckdb an haɗa shi a cikin tsari na soja, yana da daraja a lura da cewa babu wani software uwar garken DBMs don kafa, sabuntawa ko ci gaba.
Misali, kunshin DuckDB Python na iya gudanar da tambayoyi kai tsaye kan bayanai daga laburare na software na Python, ba tare da shigo da ko kwafin bayanai ba. An rubuta DuckDB a cikin C++, kyauta ne kuma buɗe tushen ƙarƙashin lasisin MIT.
Kuna iya ƙarin koyo game da shi da kuma tuntuɓar littafin shigarwa, A cikin mahaɗin mai zuwa.