{"id":78346,"date":"2020-04-18T19:42:08","date_gmt":"2020-04-18T17:42:08","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-timescaledb-1-7"},"modified":"2020-04-18T19:42:08","modified_gmt":"2020-04-18T17:42:08","slug":"vypusk-subd-timescaledb-1-7","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sl\/blog\/news\/vypusk-subd-timescaledb-1-7","title":{"rendered":"Izid TimescaleDB 1.7","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/releases\/tag\/1.7.0\">Objavljeno<\/a><\/noindex>   izid SDB <noindex><a rel=\"nofollow\" href=\"https:\/\/www.timescale.com\">TimescaleDB 1.7<\/a><\/noindex>, namenjene za shranjevanje in obdelavo podatkov v obliki \u010dasovnih vrst (rezultati vrednosti parametrov v dolo\u010denih \u010dasovnih presledkih, zapis ustvarja \u010das in niz ustreznih vrednosti za ta \u010das). Ta oblika shranjevanja je optimalna za aplikacije, kot so sistemi za spremljanje, trgovinske platforme, sistemi za zbiranje meritev in stanj senzorjev. Ponuja se sredstva za integracijo s projektom <noindex><a rel=\"nofollow\" href=\"https:\/\/grafana.com\/\">Grafana<\/a><\/noindex> in <noindex><a rel=\"nofollow\" href=\"https:\/\/prometheus.io\/\">Prometheus<\/a><\/noindex>. <\/p>\n<p>Projekt TimescaleDB je zasnovan kot raz\u0161iritev za PostgreSQL in <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\">se distribuira<\/a><\/noindex> pod licenco Apache 2.0. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/tree\/master\/tsl\">Del kode<\/a><\/noindex> z raz\u0161irjenimi mo\u017enostmi se ponuja pod lo\u010deno lastni\u0161ko licenco <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/blob\/master\/tsl\/LICENSE-TIMESCALE\">Timescale<\/a><\/noindex> (TSL), ki ne dovoljuje sprememb, prepoveduje uporabo kode v zunanjih izdelkih in ne dovoljuje brezpla\u010dne uporabe v obla\u010dnih podatkovnih bazah (database-as-a-service). <\/p>\n<p>Med spremembami v TimescaleDB 1.7:<\/p>\n<ul>\n<li class=\"l\"> Dodana je podpora za integracijo z SDB <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51604\">PostgreSQL 12<\/a><\/noindex>. Objavljena je zastarela podpora za PostgreSQL 9.6.x in 10.x (v Timescale 2.0 bo ostala podpora samo za PostgreSQL 11+).\n<li class=\"l\"> Spremembe v obna\u0161anju poizvedb z neprekinjenimi agregatnimi funkcijami (agregiranje neprekinjeno prispevajo\u010dih podatkov v realnem \u010dasu). Tak\u0161ne poizvedbe zdaj zdru\u017eujejo materializirane poglede z nedavno prispelem podatkom, ki \u0161e niso materializirani (prej je agregiranje zajemalo samo \u017ee materializirane podatke). Novo obna\u0161anje se uporablja za novo ustvarjene neprekinjene agregacije, za obstoje\u010de poglede pa je treba nastaviti parameter &#171;timescaledb.materialized_only=false&#187; prek &#171;ALTER VIEW&#187;.\n<li class=\"l\"> V Community razli\u010dico so iz komercialne razli\u010dice preneseni nekateri raz\u0161irjeni instrumenti za upravljanje \u017eivljenjskega cikla podatkov, vklju\u010dno s sposobnostmi za preurejanje podatkov in obdelavo politik za izlo\u010danje zastarelih podatkov (omogo\u010dajo hranjenje le aktualnih podatkov ter samodejno odstranjevanje, agregiranje ali arhiviranje zastarelih zapisov).\n<\/ul>\n<p>Naj spomnimo, da SDB TimescaleDB omogo\u010da izvajanje celovitih SQL poizvedb za analizo zbranih podatkov, kar zdru\u017euje udobje dela, zna\u010dilno za relacijske SDB, z raz\u0161irljivostjo in mo\u017enostmi, ki jih ponujajo specializirane NoSQL sisteme. Struktura shranjevanja je optimizirana za zagotavljanje visoke hitrosti dodajanja podatkov. Podprto je paketno dodajanje nizov podatkov, uporaba v pomnilniku shranjenih indeksov, nalaganje zgodovinskih rezin z zamudo in uporaba transakcij.<\/p>\n<p>Klju\u010dna lastnost TimescaleDB je podpora za samodejno partitioniranje (razdelitev) podatkovnega oblaka. Vhodni podatkovni tok se samodejno razporedi po razdeljenih tabelah. Razdelki se ustvarjajo glede na \u010das (v vsakem razdelku so shranjeni podatki za dolo\u010den \u010dasovni interval) ali v navezavi na poljuben klju\u010d (na primer identifikator naprave, lokacijo itd.). Za optimizacijo zmogljivosti se lahko razdeljene tabele razporedijo po razli\u010dnih diskih. <\/p>\n<p>Za poizvedbe sekcionirana baza podatkov izgleda kot ena velika tabela, imenovana hipertabela. Hipertabela predstavlja virtualni pogled na mno\u017eico lo\u010denih tabel, v katerih se kopi\u010dijo prihajajo\u010di podatki. Hipertabela se uporablja ne le za poizvedbe in dodajanje podatkov, temve\u010d tudi za tak\u0161ne operacije, kot so ustvarjanje indeksov in spreminjanje strukture (&#171;ALTER TABLE&#187;), pri \u010demer razvijalcu skriva nizkonivojsku segmentirano strukturo baze podatkov. S hipertabelo lahko uporabite katere koli agregatne funkcije, podpoizvedbe, operacije zdru\u017eevanja (JOIN) s obi\u010dajnimi tabelami in okenske funkcije.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Izvor: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=52759\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB 1.7, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0444\u043e\u0440\u043c\u0435 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0433\u043e \u0440\u044f\u0434\u0430 (\u0441\u0440\u0435\u0437\u044b \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 \u0447\u0435\u0440\u0435\u0437 \u0437\u0430\u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043a\u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438, \u0437\u0430\u043f\u0438\u0441\u044c \u043e\u0431\u0440\u0430\u0437\u0443\u0435\u0442 \u0432\u0440\u0435\u043c\u044f \u0438 \u043d\u0430\u0431\u043e\u0440 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0445 \u044d\u0442\u043e\u043c\u0443 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439). \u041f\u043e\u0434\u043e\u0431\u043d\u0430\u044f \u0444\u043e\u0440\u043c\u0430 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u043e\u043f\u0442\u0438\u043c\u0430\u043b\u044c\u043d\u0430 \u0434\u043b\u044f \u0442\u0430\u043a\u0438\u0445 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u043a\u0430\u043a \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430, \u0442\u043e\u0440\u0433\u043e\u0432\u044b\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b, \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0441\u0431\u043e\u0440\u0430 \u043c\u0435\u0442\u0440\u0438\u043a \u0438 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0439 \u0434\u0430\u0442\u0447\u0438\u043a\u043e\u0432. \u041f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u0434\u043b\u044f \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0438 \u0441 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u043c [&hellip;]<\/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-78346","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sl\/blog\/news\/vypusk-subd-timescaledb-1-7\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sl_SI\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB 1.7 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sl\/blog\/news\/vypusk-subd-timescaledb-1-7\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-04-18T17:42:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-18T17:42:08+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Izdelek SDB TimescaleDB 1.7 | ProHoster","description":"Objavljen je izdelek SDB TimescaleDB.","canonical_url":"https:\/\/prohoster.info\/sl\/blog\/news\/vypusk-subd-timescaledb-1-7","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sl_SI","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\udd47\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB 1.7 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 TimescaleDB.","og:url":"https:\/\/prohoster.info\/sl\/blog\/news\/vypusk-subd-timescaledb-1-7","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":"2020-04-18T17:42:08+00:00","article:modified_time":"2020-04-18T17:42:08+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"78346","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-02-28 16:59:36","updated":"2022-10-01 02:34:05","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/78346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/comments?post=78346"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/78346\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media?parent=78346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/categories?post=78346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/tags?post=78346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}