{"id":99711,"date":"2021-04-13T16:22:39","date_gmt":"2021-04-13T14:22:39","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/google-opublikoval-yazyk-logicheskogo-programmirovaniya-logica"},"modified":"2021-04-13T16:22:39","modified_gmt":"2021-04-13T14:22:39","slug":"google-opublikoval-yazyk-logicheskogo-programmirovaniya-logica","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sv\/blog\/news\/google-opublikoval-yazyk-logicheskogo-programmirovaniya-logica","title":{"rendered":"Google har publicerat det logiska programmeringsspr\u00e5ket Logica","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Google har introducerat ett nytt deklarativt logiskt programmeringsspr\u00e5k, Logica, som \u00e4r utformat f\u00f6r att manipulera data och \u00f6vers\u00e4tter program till SQL-spr\u00e5ket. Det nya spr\u00e5ket riktar sig till de som vill anv\u00e4nda syntaxen f\u00f6r logisk programmering n\u00e4r de skriver databass\u00f6kningar. F\u00f6r n\u00e4rvarande kan den resulterande SQL-koden k\u00f6ras i Google BigQuery-lagringen eller i databashanteringssystemen PostgreSQL och SQLite, vars st\u00f6d fortfarande \u00e4r i experimentellt stadium. I framtiden planeras det att ut\u00f6ka antalet st\u00f6dda SQL-dialekter. Projektkoden \u00e4r skriven i Python och publicerad under Apache 2.0-licensen. <\/p>\n

Logica forts\u00e4tter att utveckla ett annat dataspr\u00e5k som designades av Google, Yedalog, och erbjuder en abstraktionsniv\u00e5 som inte \u00e4r tillg\u00e4nglig i standard SQL. Fr\u00e5gor i Logica programmeras i form av en upps\u00e4ttning logiska p\u00e5st\u00e5enden. Moduler, importoperationer och m\u00f6jligheten att anv\u00e4nda Logica fr\u00e5n den interaktiva Jupyter Notebook \u00e4r st\u00f6dda. Till exempel, f\u00f6r att sammanst\u00e4lla en lista \u00f6ver personer som oftast n\u00e4mns i nyheterna under 2020, kan f\u00f6ljande Logica-program anv\u00e4ndas f\u00f6r att anropa databasen GDELT: @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(persons, \";\"), person in the_persons; $ logica mentions.l run Mentions +------+-+ | person | 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 | +------+-+ <\/p>\n

Att skriva komplexa SQL-fr\u00e5gor leder till behovet av att skapa otydliga, fler-radiga kedjor, som \u00e4r sv\u00e5ra att f\u00f6rst\u00e5, hindrar \u00e5teranv\u00e4ndning av delar av fr\u00e5gan och f\u00f6rsv\u00e5rar underh\u00e5ll. F\u00f6r typiska, upprepade ber\u00e4kningar i SQL kan vyer och funktioner anv\u00e4ndas, men de st\u00f6djer inte importoperationer och tillhandah\u00e5ller inte den flexibilitet som \u00e4r typisk f\u00f6r h\u00f6g niv\u00e5 spr\u00e5k (till exempel, det \u00e4r om\u00f6jligt att \u00f6verf\u00f6ra en funktion till en annan funktion). Logica m\u00f6jligg\u00f6r komposition av program fr\u00e5n sm\u00e5, tydliga och l\u00e4tta att \u00e5teranv\u00e4nda logiska block som kan testas, kopplas till specifika namn och grupperas i paket tillg\u00e4ngliga f\u00f6r anv\u00e4ndning i andra projekt.
\n
K\u00e4lla: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Google \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u043b\u0430 \u043d\u043e\u0432\u044b\u0439 \u0434\u0435\u043a\u043b\u0430\u0440\u0430\u0442\u0438\u0432\u043d\u044b\u0439 \u044f\u0437\u044b\u043a \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f Logica, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u044b\u0439 \u0434\u043b\u044f \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0438 \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0440\u0443\u044e\u0449\u0438\u0439 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b \u0432 \u044f\u0437\u044b\u043a SQL. \u041d\u043e\u0432\u044b\u0439 \u044f\u0437\u044b\u043a \u043e\u0440\u0438\u0435\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d \u043d\u0430 \u0442\u0435\u0445, \u043a\u0442\u043e \u0445\u043e\u0447\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441 \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043f\u0440\u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a \u0411\u0414. \u0412 \u043d\u0430\u0441\u0442\u043e\u044f\u0449\u0435\u0435 \u0432\u0440\u0435\u043c\u044f \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0439 SQL-\u043a\u043e\u0434 \u043c\u043e\u0436\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c\u0441\u044f \u0432 \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 Google BigQuery \u0438\u043b\u0438 \u0432 \u0421\u0423\u0411\u0414 PostgreSQL \u0438 SQLite, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043f\u043e\u043a\u0430 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-99711","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Google har publicerat det logiska programmeringsspr\u00e5ket Logica | ProHoster","description":"Google har presenterat ett nytt deklarativt logiskt programmeringsspr\u00e5k, Logica, som \u00e4r avsett f\u00f6r datamanipulation och \u00f6vers\u00e4tter program till SQL-spr\u00e5ket.","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/news\/google-opublikoval-yazyk-logicheskogo-programmirovaniya-logica","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sv_SE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47Google \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b \u044f\u0437\u044b\u043a \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f Logica | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Google \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u043b\u0430 \u043d\u043e\u0432\u044b\u0439 \u0434\u0435\u043a\u043b\u0430\u0440\u0430\u0442\u0438\u0432\u043d\u044b\u0439 \u044f\u0437\u044b\u043a \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f Logica, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u044b\u0439 \u0434\u043b\u044f \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0438 \u0442\u0440\u0430\u043d\u0441\u043b\u0438\u0440\u0443\u044e\u0449\u0438\u0439 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b \u0432 \u044f\u0437\u044b\u043a SQL.","og:url":"https:\/\/prohoster.info\/sv\/blog\/news\/google-opublikoval-yazyk-logicheskogo-programmirovaniya-logica","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2021-04-13T14:22:39+00:00","article:modified_time":"2021-04-13T14:22:39+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"99711","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-04-13 14:28:47","updated":"2022-10-11 05:01:14","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/99711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=99711"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/99711\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=99711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=99711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=99711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}