UGoogle uye wazisa ulwimi olutsha lwenkqubo yengqiqo, iLogica, eyilelwe ukukhohlisa idatha kunye neenkqubo zokuguqulela kwiSQL. Ulwimi olutsha lujolise kwabo bafuna ukusebenzisa i-logic programming syntax xa bebhala imibuzo yedatabase. Okwangoku, ikhowudi ye-SQL enesiphumo inokuphunyezwa kwi-Google BigQuery yokugcina okanye kwi-PostgreSQL kunye ne-SQLite DBMSs, inkxaso esavavanywayo. Kwixesha elizayo kucetywa ukwandisa inani leentetho ze-SQL ezixhaswayo. Ikhowudi yeprojekthi ibhalwe kwiPython kwaye ipapashwe phantsi kwelayisensi ye-Apache 2.0.
I-Logica iyaqhubeka nokuphuhliswa kolunye ulwimi oluphuhliswe nguGoogle lokucwangcisa idatha, iYedalog, kwaye ibonelela ngenqanaba lokuthatha elingekhoyo kwiSQL esemgangathweni. Imibuzo kwiLogica icwangciswe ngokohlobo lweseti yeengxelo ezinengqiqo. Ixhasa iimodyuli, ukungenisa elizweni, kunye nokukwazi ukusebenzisa iLogica ukusuka kwiqokobhe leJupyter Notebook esebenzayo. Umzekelo, ukuvelisa isishwankathelo sabantu abakhankanywe rhoqo ezindabeni ze-2020, ungasebenzisa le nkqubo yeLogica ilandelayo ukufikelela kwisiseko sedatha ye-GDELT: @OrderBy(Mentions, "mentions desc"); @Limit(Ukhankanya, 10); Ukhankanya(umntu:, ukhankanya? += 1) eyahlukileyo :- gdelt-bq.gdeltv2.gkg(abantu:, umhla:), Substr(ToString(umhla), 0, 4) == “2020”, the_persons == Yahlula (abantu, ";"), umntu e_ebantwini; $ logica mentions.l baleka Ukhankanya +——————————————-+ | umntu | ikhankanya_ukubala | +——————+——————-+ | uDonald trump | 3077130 | | Los angeles | 1078412 | | joe biden | 1054827 | | uGeorge floyd | 872919 | | boris johnson | 674786 | | UBarack Obama | 438181 | | vladimir putin | 410587 | | uBernie sanders | 387383 | | uAndrew cuomo | 345462 | | las vegas | 325487 | +——————+——————-+
Ukubhala imibuzo entsonkothileyo kwi-SQL ikhokelela kwimfuneko yokubhala imixokelelwane enzima yemigca emininzi engacacanga ukuba iqondwe, iphazamise ukusetyenziswa kwakhona kweenxalenye zombuzo, kunye nokugcinwa nzima. Kubalo oluphinda-phindayo oluqhelekileyo, i-SQL inokusebenzisa iimboniselo kunye nemisebenzi, kodwa ayixhasi imisebenzi yokungenisa kwaye ayiboneleli bhetyebhetye lolwimi olukwinqanaba eliphezulu (umzekelo, awukwazi ukudlulisa umsebenzi kumsebenzi). I-Logica ikuvumela ukuba uqulunqe iinkqubo ukusuka kwiibhloko ezincinci, eziqondakalayo, kunye nezisebenzisekayo kwakhona ezinokuvavanywa, ezinxulumene namagama athile, kwaye zihlanganiswe kwiipakethi ezinokusetyenziswa njengenxalenye yezinye iiprojekthi.
umthombo: opennet.ru
