{"id":7050,"date":"2025-04-04T10:19:19","date_gmt":"2025-04-04T13:19:19","guid":{"rendered":"https:\/\/geekblogti.wpengine.com\/?p=7050"},"modified":"2025-04-14T10:19:37","modified_gmt":"2025-04-14T13:19:37","slug":"datawarehouse-conceitos-fundamentais-e-arquiteturas","status":"publish","type":"post","link":"https:\/\/www.geekhunter.com/pt/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/","title":{"rendered":"DataWarehouse: Conceitos Fundamentais e Arquiteturas"},"content":{"rendered":"\r\n<p class=\"wp-block-paragraph\">O que \u00e9 um DataWarehouse?<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Como o pr\u00f3prio nome j\u00e1 diz, \u00e9 um armaz\u00e9m de dados digitais.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">E qual a sua utilidade?<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Armazenar grandes volumes deles, criando e organizando relat\u00f3rios por meio de hist\u00f3ricos, que depois podem ser acessados pela empresa.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Com a transforma\u00e7\u00e3o digital e o n\u00famero de pequenas, m\u00e9dias e grandes empresas que n\u00e3o param de surgir, um grande volume de informa\u00e7\u00f5es surge junto.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Um DW (DataWarehouse), \u00e9 uma forma estrat\u00e9gica de armazenar grandes volumes de dados, em um banco de dados relacional, tamb\u00e9m designado como OLTP.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Quem conhece a arquitetura de um banco de dados OLTP sabe da constru\u00e7\u00e3o das tabelas, cursores, <em>procedures<\/em>, e uma gama de itens para gerenciar esses dados.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><em>&gt;&gt;<\/em><strong><em>Leitura Recomendada:<\/em><\/strong><em><br \/><\/em><a href=\"https:\/\/geekblogti.wpengine.com\/sql-nosql-newsql-qual-banco-de-dados-usar\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"SQL, NoSQL, NewSQL (abre numa nova aba)\"><strong><em>SQL, NoSQL, NewSQL<\/em><\/strong><\/a><em>: Qual banco de dados usar?<\/em><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">O diferencial do DataWarehouse<\/h2>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img fetchpriority=\"high\" decoding=\"async\" width=\"960\" height=\"640\" class=\"wp-image-7056\" src=\"https:\/\/geekblogti.wpengine.com\/wp-content\/uploads\/2019\/08\/O-diferencial-do-Data-Warehouse.jpg\" alt=\"tela de computador com codigos de programacao\" srcset=\"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/O-diferencial-do-Data-Warehouse.jpg 960w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/O-diferencial-do-Data-Warehouse-150x100.jpg 150w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/O-diferencial-do-Data-Warehouse-100x67.jpg 100w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/O-diferencial-do-Data-Warehouse-600x400.jpg 600w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/O-diferencial-do-Data-Warehouse-450x300.jpg 450w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/O-diferencial-do-Data-Warehouse-810x540.jpg 810w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O diferencial de um BD e um DW est\u00e1 na forma como s\u00e3o acessados e geram as informa\u00e7\u00f5es necess\u00e1rias. Como este artigo se refere ao segundo, focarei nele para n\u00e3o gerar conflito de informa\u00e7\u00f5es.\u00a0<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Em um DW, os dados podem vir de v\u00e1rias fontes, sistemas (ERP, SAP, etc).<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Esses dados s\u00e3o carregados em arquivos como *.txt, *xls, entre outros, que suportam essa grandeza.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Para carreg\u00e1-los dentro do &#8220;<em>armaz\u00e9m<\/em>&#8220;, ser\u00e1 necess\u00e1rio verific\u00e1-los e valid\u00e1-los. Esse processo \u00e9 definido como <strong>ETL (Extract, Transaction, Load<\/strong>), e nele os dados s\u00e3o padronizados, corrigidos, limpos e carregados dentro do dep\u00f3sito de dados.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Para que um DW seja funcional ele precisar\u00e1 necessariamente contar com uma constru\u00e7\u00e3o de \u00edndices.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">O que s\u00e3o os \u00edndices?<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Os \u00edndices s\u00e3o as chaves dentro de cada tabela para realizar as transa\u00e7\u00f5es dentro da <em>database<\/em>.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Esses \u00edndices separam os dados dispon\u00edveis por assunto, que podem variar entre uma gama diversa de op\u00e7\u00f5es: datas, marcas, algo que defina um grupo de dados integrado.\u00a0<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">A m\u00e1gica de verdade ocorre dentro do armaz\u00e9m, com os \u00edndices, tabelas, scripts de carga, como procedures e cursores, que far\u00e3o toda an\u00e1lise, distribui\u00e7\u00e3o, organiza\u00e7\u00e3o deles.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Com isso, futuramente poder\u00e3o ser acessados de maneira inteligente, gerando informa\u00e7\u00f5es para a tomada de decis\u00e3o dentro de uma corpora\u00e7\u00e3o.\u00a0<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Do lado da corpora\u00e7\u00e3o, existem aplica\u00e7\u00f5es para acessar esses dados.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Nesse artigo n\u00e3o vamos focar nessas aplica\u00e7\u00f5es, talvez esse seja assunto para um pr\u00f3ximo post, aqui pretendemos abordar as maneiras que esses dados s\u00e3o acessados, ou seja, suas arquiteturas.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><em>&gt;<\/em><strong><em>&gt;Leitura Recomendada:<\/em><\/strong><em><br \/>Mini Tutorial de<\/em><strong><a href=\"https:\/\/geekblogti.wpengine.com\/mini-tutorial-de-etl-na-pratica-com-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" ETL na pr\u00e1tica com Power BI (abre numa nova aba)\"><em> ETL na pr\u00e1tica com Power BI<\/em><\/a><\/strong><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><a href=\"http:\/\/bit.ly\/2JPyTWt\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"wp-image-7063\" src=\"https:\/\/geekblogti.wpengine.com\/wp-content\/uploads\/2019\/08\/CTA-Rodap\u00e9-Front-end-e-Back-end-9-1024x134.jpg\" alt=\"\" \/><\/a><\/figure>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">As arquiteturas do DW<\/h2>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"960\" height=\"640\" class=\"wp-image-7057\" src=\"https:\/\/geekblogti.wpengine.com\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW.jpg\" alt=\"imagem de predio com vidros espelhados\" srcset=\"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW.jpg 960w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW-150x100.jpg 150w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW-100x67.jpg 100w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW-600x400.jpg 600w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW-450x300.jpg 450w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW-810x540.jpg 810w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW-300x200.jpg 300w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/As-arquiteturas-do-DW-768x512.jpg 768w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">As arquiteturas do DW podem variar de acordo com as necessidades da empresa que as utilizar\u00e3o.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Arquitetura de Duas camadas<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">A arquitetura de duas camadas utiliza um servidor, juntamente com aplica\u00e7\u00f5es front-end \u2014 que s\u00e3o ferramentas que realizam opera\u00e7\u00f5es sobre os dados consultados e os transformam em informa\u00e7\u00f5es \u00fateis para os usu\u00e1rios.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">J\u00e1 os componentes back-end s\u00e3o ferramentas respons\u00e1veis pela extra\u00e7\u00e3o, limpeza e cargas dos dados, mais conhecidas como<strong> ETL<\/strong> e tamb\u00e9m s\u00e3o utilizadas neste tipo de arquitetura.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"481\" height=\"255\" class=\"wp-image-7059\" src=\"https:\/\/geekblogti.wpengine.com\/wp-content\/uploads\/2019\/08\/duas-camadas-min.jpg\" alt=\"imagem de um dw de duas camadas\" srcset=\"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/duas-camadas-min.jpg 481w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/duas-camadas-min-150x80.jpg 150w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/duas-camadas-min-100x53.jpg 100w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/duas-camadas-min-450x239.jpg 450w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/duas-camadas-min-300x159.jpg 300w\" sizes=\"(max-width: 481px) 100vw, 481px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Arquitetura de Tr\u00eas camadas<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">A arquitetura de tr\u00eas camadas suporta v\u00e1rios usu\u00e1rios e servi\u00e7os, devido a sua flexibilidade.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">As informa\u00e7\u00f5es ficam armazenadas em diversas camadas.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Na primeira camada est\u00e3o as interfaces que trabalham com o usu\u00e1rio, que geralmente s\u00e3o gr\u00e1ficas.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Na segunda camada est\u00e3o os servidores de banco de dados e aplica\u00e7\u00f5es e, por isso, t\u00eam a necessidade de ter um acesso eficiente e veloz aos dados compartilhados.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Na \u00faltima ficam armazenadas as fontes de dados. A arquitetura de tr\u00eas camadas \u00e9 a mais utilizada pelos analistas.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"548\" height=\"320\" class=\"wp-image-7060\" src=\"https:\/\/geekblogti.wpengine.com\/wp-content\/uploads\/2019\/08\/tres-camadas-min.jpg\" alt=\"imagem de um dw de tres camadas\" srcset=\"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/tres-camadas-min.jpg 548w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/tres-camadas-min-150x88.jpg 150w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/tres-camadas-min-100x58.jpg 100w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/tres-camadas-min-450x263.jpg 450w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/tres-camadas-min-300x175.jpg 300w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Segue abaixo uma figura ilustrando a parte gr\u00e1fica de um DW, com seus n\u00edveis e arquiteturas:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"713\" height=\"395\" class=\"wp-image-7061\" src=\"https:\/\/geekblogti.wpengine.com\/wp-content\/uploads\/2019\/08\/image4-min.jpg\" alt=\"\" srcset=\"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/image4-min.jpg 713w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/image4-min-150x83.jpg 150w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/image4-min-100x55.jpg 100w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/image4-min-600x332.jpg 600w, https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/image4-min-450x249.jpg 450w\" sizes=\"(max-width: 713px) 100vw, 713px\" \/><\/figure>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">Em conclus\u00e3o<\/h2>\r\n\r\n\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">De forma geral, um DataWarehouse<strong>\u00a0<\/strong>armazena os dados em grande volume.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O diferencial est\u00e1 na maneira como s\u00e3o gerenciados, para isso \u00e9 necess\u00e1rio um conhecimento das melhores pr\u00e1ticas de desenvolvimento dentro do BD, para otimizar toda consulta, retornando para o usu\u00e1rio final informa\u00e7\u00f5es concisas, que possam ser utilizadas para a tomada de decis\u00e3o.\u00a0<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">E, pra isso, um conhecimento pr\u00e9vio do neg\u00f3cio \u00e9 imprescind\u00edvel.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O acesso, sistemas interligados e conectados, trabalhar\u00e3o mais assertivamente com esses dados, para um melhor trabalho tanto a n\u00edvel organizacional quanto gerencial dentro das empresas.\u00a0<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>O que \u00e9 um DataWarehouse? Como o pr\u00f3prio nome j\u00e1 diz, \u00e9 um armaz\u00e9m de dados digitais. E qual a sua utilidade? Armazenar grandes volumes deles, criando e organizando relat\u00f3rios por meio de hist\u00f3ricos, que depois podem ser acessados pela empresa. Com a transforma\u00e7\u00e3o digital e o n\u00famero de pequenas, m\u00e9dias e grandes empresas que [&hellip;]<\/p>\n","protected":false},"author":167,"featured_media":7055,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-7050","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-desenvolvimiento-de-software"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.3 (Yoast SEO v28.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Aprenda o b\u00e1sico do DataWarehouse<\/title>\n<meta name=\"description\" content=\"Nesse artigo fazemos uma introdu\u00e7\u00e3o ao que \u00e9 DataWarehouse, sua import\u00e2ncia e sua arquitetura. Leia o conte\u00fado!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DataWarehouse: Conceitos Fundamentais e Arquiteturas\" \/>\n<meta property=\"og:description\" content=\"O que \u00e9 um DataWarehouse? Como o pr\u00f3prio nome j\u00e1 diz, \u00e9 um armaz\u00e9m de dados digitais. E qual a sua utilidade? Armazenar grandes volumes deles, criando e\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Geekhunter\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/geekhunterbr\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-04T13:19:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-14T13:19:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"640\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Geekhunter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@geekhunterbr\" \/>\n<meta name=\"twitter:site\" content=\"@geekhunterbr\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Geekhunter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/\"},\"author\":{\"name\":\"Geekhunter\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#\\\/schema\\\/person\\\/9f62b173345139f7bbdaf55312c3d400\"},\"headline\":\"DataWarehouse: Conceitos Fundamentais e Arquiteturas\",\"datePublished\":\"2025-04-04T13:19:19+00:00\",\"dateModified\":\"2025-04-14T13:19:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/\"},\"wordCount\":749,\"publisher\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg\",\"articleSection\":[\"Desenvolvimiento de software\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/\",\"name\":\"Aprenda o b\u00e1sico do DataWarehouse\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg\",\"datePublished\":\"2025-04-04T13:19:19+00:00\",\"dateModified\":\"2025-04-14T13:19:37+00:00\",\"description\":\"Nesse artigo fazemos uma introdu\u00e7\u00e3o ao que \u00e9 DataWarehouse, sua import\u00e2ncia e sua arquitetura. Leia o conte\u00fado!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg\",\"contentUrl\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg\",\"width\":960,\"height\":640,\"caption\":\"imagem de um armazem\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/datawarehouse-conceitos-fundamentais-e-arquiteturas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mundo TI\",\"item\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/category\\\/mundo-ti\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Desenvolvimiento de software\",\"item\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/category\\\/mundo-ti\\\/desenvolvimiento-de-software\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"DataWarehouse: Conceitos Fundamentais e Arquiteturas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/\",\"name\":\"Blog de TI\",\"description\":\"Dicas para o RH e profissionais da \u00e1rea TI\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#organization\",\"name\":\"GeekHunter\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/icon-1.png\",\"contentUrl\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/icon-1.png\",\"width\":300,\"height\":300,\"caption\":\"GeekHunter\"},\"image\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/geekhunterbr\\\/\",\"https:\\\/\\\/x.com\\\/geekhunterbr\",\"https:\\\/\\\/www.instagram.com\\\/geekhunterbr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/geekhunter-brasil\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@GeekHunterOfficial\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#\\\/schema\\\/person\\\/9f62b173345139f7bbdaf55312c3d400\",\"name\":\"Geekhunter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g\",\"caption\":\"Geekhunter\"},\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/author\\\/matias\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Aprenda o b\u00e1sico do DataWarehouse","description":"Nesse artigo fazemos uma introdu\u00e7\u00e3o ao que \u00e9 DataWarehouse, sua import\u00e2ncia e sua arquitetura. Leia o conte\u00fado!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/","og_locale":"pt_BR","og_type":"article","og_title":"DataWarehouse: Conceitos Fundamentais e Arquiteturas","og_description":"O que \u00e9 um DataWarehouse? Como o pr\u00f3prio nome j\u00e1 diz, \u00e9 um armaz\u00e9m de dados digitais. E qual a sua utilidade? Armazenar grandes volumes deles, criando e","og_url":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/","og_site_name":"Blog Geekhunter","article_publisher":"https:\/\/www.facebook.com\/geekhunterbr\/","article_published_time":"2025-04-04T13:19:19+00:00","article_modified_time":"2025-04-14T13:19:37+00:00","og_image":[{"width":960,"height":640,"url":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg","type":"image\/jpeg"}],"author":"Geekhunter","twitter_card":"summary_large_image","twitter_creator":"@geekhunterbr","twitter_site":"@geekhunterbr","twitter_misc":{"Escrito por":"Geekhunter","Est. tempo de leitura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/#article","isPartOf":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/"},"author":{"name":"Geekhunter","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#\/schema\/person\/9f62b173345139f7bbdaf55312c3d400"},"headline":"DataWarehouse: Conceitos Fundamentais e Arquiteturas","datePublished":"2025-04-04T13:19:19+00:00","dateModified":"2025-04-14T13:19:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/"},"wordCount":749,"publisher":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#organization"},"image":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg","articleSection":["Desenvolvimiento de software"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/","url":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/","name":"Aprenda o b\u00e1sico do DataWarehouse","isPartOf":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/#primaryimage"},"image":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg","datePublished":"2025-04-04T13:19:19+00:00","dateModified":"2025-04-14T13:19:37+00:00","description":"Nesse artigo fazemos uma introdu\u00e7\u00e3o ao que \u00e9 DataWarehouse, sua import\u00e2ncia e sua arquitetura. Leia o conte\u00fado!","breadcrumb":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.geekhunter.com/pt/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/#primaryimage","url":"https:\/\/www.geekhunter.com\/pt\/blog\/wp-content\/uploads\/2019\/08\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg","contentUrl":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2019\/08\/DataWarehouse-Conceitos-Fundamentais-e-Arquiteturas.jpg","width":960,"height":640,"caption":"imagem de um armazem"},{"@type":"BreadcrumbList","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/datawarehouse-conceitos-fundamentais-e-arquiteturas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/www.geekhunter.com/pt/blog\/"},{"@type":"ListItem","position":2,"name":"Mundo TI","item":"https:\/\/www.geekhunter.com/pt/blog\/category\/mundo-ti\/"},{"@type":"ListItem","position":3,"name":"Desenvolvimiento de software","item":"https:\/\/www.geekhunter.com/pt/blog\/category\/mundo-ti\/desenvolvimiento-de-software\/"},{"@type":"ListItem","position":4,"name":"DataWarehouse: Conceitos Fundamentais e Arquiteturas"}]},{"@type":"WebSite","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#website","url":"https:\/\/www.geekhunter.com\/pt\/blog\/","name":"Blog de TI","description":"Dicas para o RH e profissionais da \u00e1rea TI","publisher":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.geekhunter.com/pt/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#organization","name":"GeekHunter","url":"https:\/\/www.geekhunter.com\/pt\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.geekhunter.com\/pt\/blog\/wp-content\/uploads\/2024\/10\/icon-1.png","contentUrl":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2024\/10\/icon-1.png","width":300,"height":300,"caption":"GeekHunter"},"image":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/geekhunterbr\/","https:\/\/x.com\/geekhunterbr","https:\/\/www.instagram.com\/geekhunterbr\/","https:\/\/www.linkedin.com\/company\/geekhunter-brasil\/","https:\/\/www.youtube.com\/@GeekHunterOfficial"]},{"@type":"Person","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#\/schema\/person\/9f62b173345139f7bbdaf55312c3d400","name":"Geekhunter","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g","caption":"Geekhunter"},"url":"https:\/\/www.geekhunter.com\/pt\/blog\/author\/matias\/"}]}},"_links":{"self":[{"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/posts\/7050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/users\/167"}],"replies":[{"embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/comments?post=7050"}],"version-history":[{"count":0,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/posts\/7050\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/media\/7055"}],"wp:attachment":[{"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/media?parent=7050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/categories?post=7050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/tags?post=7050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}