{"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\/hu\/blog\/news\/google-opublikoval-yazyk-logicheskogo-programmirovaniya-logica","title":{"rendered":"A Google k\u00f6zz\u00e9tette a Logica logikai programoz\u00e1si nyelvet","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

A Google bemutatta az \u00faj Logica deklarat\u00edv logikai programoz\u00e1si nyelvet, amely az adatok manipul\u00e1l\u00e1s\u00e1ra szolg\u00e1l, \u00e9s a programokat SQL nyelvre ford\u00edtja. Az \u00faj nyelv azok sz\u00e1m\u00e1ra k\u00e9sz\u00fclt, akik a logikai programoz\u00e1s szintaxis\u00e1t szeretn\u00e9k haszn\u00e1lni az adatb\u00e1zis lek\u00e9rdez\u00e9sek \u00edr\u00e1sakor. Jelenleg az el\u0151\u00e1ll\u00edtott SQL-k\u00f3d a Google BigQuery t\u00e1rol\u00f3ban, valamint a PostgreSQL \u00e9s SQLite adatb\u00e1zis-kezel\u0151kben futtathat\u00f3, amelyek t\u00e1mogat\u00e1sa egyel\u0151re k\u00eds\u00e9rleti jelleg\u0171. A j\u00f6v\u0151ben tervezz\u00fck a t\u00e1mogatott SQL-dialektusok sz\u00e1m\u00e1nak b\u0151v\u00edt\u00e9s\u00e9t. A projekt k\u00f3dja Python nyelven \u00edr\u00f3dott, \u00e9s Apache 2.0 licenc alatt ker\u00fclt k\u00f6zz\u00e9t\u00e9telre. <\/p>\n

A Logica tov\u00e1bbra is fejleszti a Google \u00e1ltal kidolgozott Yedalog nev\u0171 adatfeldolgoz\u00f3 nyelvet, \u00e9s olyan absztrakci\u00f3s szintet k\u00edn\u00e1l, amely a hagyom\u00e1nyos SQL-ben nem el\u00e9rhet\u0151. A Logica lek\u00e9rdez\u00e9sei logikai \u00e1ll\u00edt\u00e1sok halmazak\u00e9nt programozhat\u00f3k. T\u00e1mogat\u00e1sra ker\u00fclnek a modulok, az import m\u0171veletek, valamint a Logica Jupyter Notebook interakt\u00edv k\u00f6rnyezetb\u0151l val\u00f3 haszn\u00e1lat\u00e1nak lehet\u0151s\u00e9ge. P\u00e9ld\u00e1ul egy 2020-as \u00e9v leggyakrabban eml\u00edtett embereinek \u00f6sszefoglal\u00e1sa \u00e9rdek\u00e9ben az al\u00e1bbi Logica program haszn\u00e1lhat\u00f3 a GDELT adatb\u00e1zis lek\u00e9rdez\u00e9s\u00e9re: @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

Bonyolult SQL lek\u00e9rdez\u00e9sek \u00edr\u00e1sa terjedelmes, sok sorb\u00f3l \u00e1ll\u00f3 l\u00e1ncok megalkot\u00e1s\u00e1t eredm\u00e9nyezi, amelyek nem egy\u00e9rtelm\u0171ek, megnehez\u00edtik az egyes r\u00e9szek \u00fajrahaszn\u00e1lat\u00e1t, \u00e9s bonyol\u00edtj\u00e1k a karbantart\u00e1st. Az SQL-ben gyakori sz\u00e1m\u00edt\u00e1sokhoz n\u00e9zetek \u00e9s funkci\u00f3k haszn\u00e1lhat\u00f3k, de ezek nem t\u00e1mogatj\u00e1k az import\u00e1l\u00e1si m\u0171veleteket, \u00e9s nem k\u00edn\u00e1lnak olyan rugalmass\u00e1got, amely a magas szint\u0171 nyelvekre jellemz\u0151 (p\u00e9ld\u00e1ul nem lehet egy funkci\u00f3t funkci\u00f3ba \u00e1tadni). A Logica lehet\u0151v\u00e9 teszi, hogy a programokat kis, \u00e9rthet\u0151 \u00e9s \u00fajrahaszn\u00e1lhat\u00f3 logikai blokkokb\u00f3l \u00e1ll\u00edtsuk \u00f6ssze, amelyeket tesztelhet\u00fcnk, meghat\u00e1rozott nevekkel l\u00e1thatunk el, \u00e9s csomagokba csoportos\u00edthatunk, hogy m\u00e1s projektek keretein bel\u00fcl is haszn\u00e1lhat\u00f3ak legyenek.
\n
Forr\u00e1s: 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\udd47A Google k\u00f6zz\u00e9tette a Logica logikai programoz\u00e1si nyelvet | ProHoster","description":"A Google bemutatta az \u00faj deklarat\u00edv Logica logikai programoz\u00e1si nyelvet, amely az adatok manipul\u00e1l\u00e1s\u00e1ra szolg\u00e1l, \u00e9s a programokat SQL nyelvre ford\u00edtja.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/google-opublikoval-yazyk-logicheskogo-programmirovaniya-logica","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/99711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=99711"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/99711\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=99711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=99711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=99711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}