Google tau tshaj tawm cov lus tshaj tawm tshiab cov lus piav qhia, Logica, tsim los rau kev tswj cov ntaub ntawv thiab txhais cov kev pab cuam rau hauv SQL. Cov lus tshiab yog tsom rau cov neeg uas xav siv logic programming syntax thaum sau cov lus nug database. Tam sim no, qhov tshwm sim SQL code tuaj yeem raug tua hauv Google BigQuery cia lossis hauv PostgreSQL thiab SQLite DBMSs, kev txhawb nqa uas tseem muaj kev sim. Nyob rau hauv lub neej yav tom ntej nws yog npaj los nthuav tus naj npawb ntawm kev txhawb nqa SQL dialects. Txoj haujlwm code yog sau hauv Python thiab luam tawm raws li Apache 2.0 daim ntawv tso cai.
Logica txuas ntxiv kev txhim kho ntawm lwm Google-tsim cov ntaub ntawv ua cov lus, Yedalog, thiab muab ib theem ntawm abstraction tsis muaj nyob rau hauv tus qauv SQL. Cov lus nug nyob rau hauv Logica yog programmed nyob rau hauv daim ntawv ntawm ib tug txheej ntawm cov ntsiab lus logic. Txhawb nqa modules, imports, thiab muaj peev xwm siv Logica los ntawm kev sib tham sib Jupyter Notebook plhaub. Piv txwv li, txhawm rau tsim cov ntsiab lus ntawm cov neeg uas nquag hais hauv xov xwm rau 2020, koj tuaj yeem siv Logica program hauv qab no txhawm rau nkag mus rau GDELT database: @OrderBy(Mentions, "mentions desc"); @Limit(Mentions, 10); Mentions(person:, mentions? += 1) distinct :- gdelt-bq.gdeltv2.gkg(persons:, date:), Substr(ToString(date), 0, 4) == “2020”, the_persons == Split (tus neeg, ";"), tus neeg hauv cov neeg; $ logica mentions.l khiav Mentions +——————-+——————-+ | tus neeg | mentions_ suav | ——————-+ —————-+ | Donald Trump | 3077130 | | los angeles | 1078412 | | joe biden | 1054827 | | George floyd | 872919 ;ua | boris johnson | 674786 | | Barack Obama | 438181 | | vladimir Putin | 410587 | | bernie Sanders | 387383 | | andrew cuomo | 345462 | | las vegas | 325487 | ————————————————————-+
Kev sau cov lus nug nyuaj hauv SQL ua rau qhov xav tau los sau cov kab ntau cov kab sib txuas uas tsis pom tseeb kom nkag siab, cuam tshuam nrog kev rov siv dua ntawm cov lus nug, thiab kev saib xyuas nyuaj. Rau cov kev suav rov ua dua qub, SQL tuaj yeem siv cov kev xav thiab kev ua haujlwm, tab sis lawv tsis txhawb nqa kev lag luam thiab tsis muab qhov yooj yim ntawm cov lus qib siab (piv txwv li, koj tsis tuaj yeem dhau txoj haujlwm rau ib qho haujlwm). Logica tso cai rau koj los sau cov kev pab cuam los ntawm me me, nkag siab, thiab rov siv tau cov logical blocks uas tuaj yeem sim, cuam tshuam nrog cov npe tshwj xeeb, thiab muab faib ua cov pob khoom uas tuaj yeem siv ua ib feem ntawm lwm cov haujlwm.
Tau qhov twg los: opennet.ru