Google yakaunza mutauro mutsva wedeclarative logic programming, Logica, wakagadzirirwa kushandura data uye kushandura zvirongwa muSQL. Mutauro mutsva wakanangana neavo vanoda kushandisa logic programming syntax kana vachinyora mibvunzo yedatabase. Parizvino, mhedzisiro yeSQL kodhi inogona kuitwa muGoogle BigQuery chengetedzo kana muPostgreSQL neSQLite DBMSs, tsigiro ichiri kuyedza. Mune ramangwana rakarongwa kuwedzera huwandu hwezvinotsigirwa SQL dialects. Iyo kodhi yeprojekiti yakanyorwa muPython uye yakaburitswa pasi peiyo Apache 2.0 rezinesi.
Logica inoenderera mberi nekuvandudzwa kweimwe Google-yakagadziridzwa dhata mutauro, Yedalog, uye inopa nhanho yekubvisa isingawanikwe muyakajairwa SQL. Mibvunzo muLogica yakarongwa muchimiro cheseti yezvirevo zvine musoro. Inotsigira modules, kunze kwenyika, uye kugona kushandisa Logica kubva kune inopindirana Jupyter Notebook shell. Semuenzaniso, kugadzira pfupiso yevanhu vanonyanya kutaurwa munhau dze2020, unogona kushandisa inotevera Logica chirongwa kuwana iyo GDELT dhatabhesi: @OrderBy(Mentions, "mentions desc"); @Limit(Kutaura, 10); Kutaurwa(munhu:, kutaurwa? += 1) kwakasiyana :- gdelt-bq.gdeltv2.gkg(vanhu:, date:), Substr(ToString(date), 0, 4) == “2020”, the_persons == Split (vanhu, ";"), munhu mu_vanhu; $ logica mentions.l run Kutaurwa +——————————————-+ | munhu | mentions_count | +——————+——————-+ | Donald Trump | 3077130 | | los angeles | 1078412 | | joe biden | 1054827 | | george floyd | 872919 | | boris johnson | 674786 | | Barack Obama | 438181 | | vladimir putin | 410587 | | bernie sanders | 387383 | | andrew cuomo | 345462 | | las vegas | 325487 | +——————+——————-+
Kunyora mibvunzo yakaoma muSQL inotungamira kudikanwa kwekunyora zvinorema-mitsetse yakawanda cheni izvo zvisiri pachena kuti zvinzwisise, zvinokanganisa kushandiswazve kwezvikamu zvemubvunzo, uye kuomesa kugadzirisa. Kune akajairwa kudzokorora kuverenga, SQL inogona kushandisa maonero nemabasa, asi haitsigire mashandiro ekunze uye haipe kuchinjika kwemitauro yemhando yepamusoro (semuenzaniso, haugone kupfuudza basa kune rimwe basa). Logica inokutendera kuti ugadzire zvirongwa kubva kune zvidiki, zvinonzwisisika, uye zvinogoneka zvekushandisa zvine musoro zvidhinha zvinogona kuyedzwa, zvine chekuita nemazita chaiwo, uye zvakaiswa mumapakeji anogona kushandiswa sechikamu chemamwe mapurojekiti.
Source: opennet.ru