{"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\/pt\/blog\/news\/vypusk-subd-timescaledb-1-7","title":{"rendered":"Lan\u00e7amento do banco de dados 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\">Publicado<\/a><\/noindex>   lan\u00e7amento do SGBD <noindex><a rel=\"nofollow\" href=\"https:\/\/www.timescale.com\">TimescaleDB 1.7<\/a><\/noindex>, destinado ao armazenamento e processamento de dados na forma de s\u00e9ries temporais (cortes de valores de par\u00e2metros em intervalos de tempo determinados, onde a grava\u00e7\u00e3o forma um tempo e um conjunto de valores correspondentes a esse tempo). Tal forma de armazenamento \u00e9 ideal para aplica\u00e7\u00f5es como sistemas de monitoramento, plataformas de negocia\u00e7\u00e3o, sistemas de coleta de m\u00e9tricas e estados de sensores. S\u00e3o fornecidos meios para a integra\u00e7\u00e3o com o projeto <noindex><a rel=\"nofollow\" href=\"https:\/\/grafana.com\/\">Grafana<\/a><\/noindex> e <noindex><a rel=\"nofollow\" href=\"https:\/\/prometheus.io\/\">Prometheus<\/a><\/noindex>. <\/p>\n<p>O projeto TimescaleDB \u00e9 implementado como uma extens\u00e3o do PostgreSQL e <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\">\u00e9 distribu\u00eddo<\/a><\/noindex> est\u00e3o sob a licen\u00e7a Apache 2.0. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/tree\/master\/tsl\">Parte do c\u00f3digo<\/a><\/noindex> com recursos avan\u00e7ados \u00e9 fornecida sob uma licen\u00e7a propriet\u00e1ria separada <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/timescale\/timescaledb\/blob\/master\/tsl\/LICENSE-TIMESCALE\">Timescale<\/a><\/noindex> (TSL), que n\u00e3o permite modifica\u00e7\u00f5es, pro\u00edbe o uso do c\u00f3digo em produtos de terceiros e n\u00e3o permite o uso gratuito em bancos de dados na nuvem (database-as-a-service). <\/p>\n<p>Entre as mudan\u00e7as no TimescaleDB 1.7:<\/p>\n<ul>\n<li class=\"l\"> Adicionada a suporte \u00e0 integra\u00e7\u00e3o com SGBD <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51604\">PostgreSQL 12<\/a><\/noindex>. O suporte ao PostgreSQL 9.6.x e 10.x foi declarado obsoleto (na vers\u00e3o Timescale 2.0, o suporte ser\u00e1 mantido apenas para PostgreSQL 11+).\n<li class=\"l\"> O comportamento das consultas com fun\u00e7\u00f5es de agrega\u00e7\u00e3o cont\u00ednuas foi alterado (agrega\u00e7\u00e3o de dados que chegam continuamente em tempo real). Agora, essas consultas combinam vis\u00f5es materializadas com dados recentes que ainda n\u00e3o foram materializados (anteriormente, a agrega\u00e7\u00e3o abrangia apenas dados j\u00e1 materializados). Esse novo comportamento \u00e9 aplicado a novas agrega\u00e7\u00f5es cont\u00ednuas; para vis\u00f5es existentes, o par\u00e2metro &#171;timescaledb.materialized_only=false&#187; deve ser definido atrav\u00e9s do comando &#171;ALTER VIEW&#187;.\n<li class=\"l\"> Na vers\u00e3o Community, foram transferidas da edi\u00e7\u00e3o comercial algumas ferramentas avan\u00e7adas de gerenciamento do ciclo de vida dos dados, incluindo recursos para reagrupamento de dados e tratamento de pol\u00edticas de elimina\u00e7\u00e3o de dados obsoletos (permitindo armazenar apenas dados atuais e automaticamente excluir, agregar ou arquivar registros obsoletos).\n<\/ul>\n<p>Lembre-se de que o SGBD TimescaleDB permite aplicar consultas SQL completas para a an\u00e1lise de dados acumulados, combinando a conveni\u00eancia de uso t\u00edpica dos SGBDs relacionais com a escalabilidade e as capacidades inerentes aos sistemas NoSQL especializados. A estrutura de armazenamento \u00e9 otimizada para garantir alta velocidade de inser\u00e7\u00e3o de dados. Suporta a inser\u00e7\u00e3o em lote de conjuntos de dados, o uso de \u00edndices residentes em mem\u00f3ria, a carga de instant\u00e2neas hist\u00f3ricas retroativas e a aplica\u00e7\u00e3o de transa\u00e7\u00f5es.<\/p>\n<p>Uma caracter\u00edstica chave do TimescaleDB \u00e9 o suporte \u00e0 parti\u00e7\u00e3o autom\u00e1tica de arrays de dados. O fluxo de dados de entrada \u00e9 automaticamente distribu\u00eddo entre tabelas particionadas. As parti\u00e7\u00f5es s\u00e3o criadas com base no tempo (cada parti\u00e7\u00e3o armazena dados por um intervalo de tempo espec\u00edfico) ou vinculadas a uma chave arbitr\u00e1ria (como o identificador de um dispositivo, localiza\u00e7\u00e3o, etc.). Para otimiza\u00e7\u00e3o de desempenho, as tabelas particionadas podem ser distribu\u00eddas em diferentes discos. <\/p>\n<p>Para consultas, o banco de dados particionado se apresenta como uma grande tabela \u00fanica, chamada de hipertabela. A hipertabela \u00e9 uma representa\u00e7\u00e3o virtual de v\u00e1rias tabelas individuais, onde os dados recebidos s\u00e3o acumulados. A hipertabela \u00e9 utilizada n\u00e3o apenas para consultas e inser\u00e7\u00e3o de dados, mas tamb\u00e9m para opera\u00e7\u00f5es como cria\u00e7\u00e3o de \u00edndices e altera\u00e7\u00e3o de estrutura (&#171;ALTER TABLE&#187;), ocultando da perspectiva do desenvolvedor a estrutura segmentada de baixo n\u00edvel do banco de dados. Com a hipertabela, \u00e9 poss\u00edvel utilizar qualquer fun\u00e7\u00e3o de agrega\u00e7\u00e3o, subconsultas, opera\u00e7\u00f5es de jun\u00e7\u00e3o (JOIN) com tabelas normais e fun\u00e7\u00f5es de janela.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Fonte: <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.3 - 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\/pt\/blog\/news\/vypusk-subd-timescaledb-1-7\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_PT\" \/>\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\/pt\/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\udd47Lan\u00e7amento do SGBD TimescaleDB 1.7 | ProHoster","description":"A vers\u00e3o do SGBD TimescaleDB foi lan\u00e7ada.","canonical_url":"https:\/\/prohoster.info\/pt\/blog\/news\/vypusk-subd-timescaledb-1-7","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pt_PT","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\/pt\/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\/pt\/wp-json\/wp\/v2\/posts\/78346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/comments?post=78346"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/78346\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=78346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=78346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=78346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}