{"id":2521,"date":"2021-05-03T14:18:37","date_gmt":"2021-05-03T17:18:37","guid":{"rendered":"https:\/\/www.sphereit.com.br\/news\/vazamento-de-dados-risco-e-impacto-copy\/"},"modified":"2021-05-04T12:01:16","modified_gmt":"2021-05-04T15:01:16","slug":"diferenca_entre_data_lake_e_data_warehouse","status":"publish","type":"post","link":"https:\/\/www.sphereit.com.br\/en\/news\/diferenca_entre_data_lake_e_data_warehouse\/","title":{"rendered":"The differences between Data Lake and Data Warehouse"},"content":{"rendered":"[et_pb_section fb_built=&#8221;1&#8243; custom_padding_last_edited=&#8221;on|phone&#8221; admin_label=&#8221;Header &#8211; N\u00c3O EDITAR&#8221; _builder_version=&#8221;4.4.8&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#004183&#8243; background_color_gradient_end=&#8221;#001f4c&#8221; background_color_gradient_type=&#8221;radial&#8221; background_image=&#8221;https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2020\/06\/cyber-security-18.png&#8221; parallax=&#8221;on&#8221; custom_padding=&#8221;10vw||64px|||&#8221; custom_padding_tablet=&#8221;&#8221; custom_padding_phone=&#8221;23vw||64px||false|false&#8221; bottom_divider_style=&#8221;slant&#8221; bottom_divider_color=&#8221;#f1fafe&#8221; bottom_divider_height=&#8221;40px&#8221; bottom_divider_flip=&#8221;vertical&#8221; da_disable_devices=&#8221;off|off|off&#8221; locked=&#8221;off&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.4.8&#8243; z_index=&#8221;1&#8243; custom_margin=&#8221;-104px|auto||auto||&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25.1&#8243;][et_pb_post_title author=&#8221;off&#8221; date_format=&#8221;d\/m\/Y&#8221; comments=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.0&#8243; title_font=&#8221;eurostile|700||on|||||&#8221; title_text_align=&#8221;center&#8221; title_text_color=&#8221;#ffffff&#8221; title_font_size=&#8221;37px&#8221; meta_font=&#8221;||||||||&#8221; meta_text_align=&#8221;center&#8221; meta_text_color=&#8221;#ffffff&#8221; meta_font_size=&#8221;18px&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;EDITAR AQUI&#8221; _builder_version=&#8221;4.4.8&#8243; background_color=&#8221;#f1fafe&#8221; z_index=&#8221;10&#8243; custom_padding=&#8221;54px|||||&#8221; bottom_divider_height=&#8221;26vw&#8221; bottom_divider_flip=&#8221;horizontal&#8221; da_disable_devices=&#8221;off|off|off&#8221; locked=&#8221;off&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.4.8&#8243; custom_padding=&#8221;19px|||||&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.4.8&#8243;][et_pb_text _builder_version=&#8221;4.9.0&#8243; text_font=&#8221;eurostile||||||||&#8221; text_font_size=&#8221;16px&#8221; text_orientation=&#8221;justified&#8221; custom_padding=&#8221;||75px|||&#8221;]\n<p><img decoding=\"async\" class=\"wp-image-2530 alignnone size-large\" src=\"https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002-1024x535.jpg\" alt=\"\" width=\"1024\" height=\"535\" srcset=\"https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002-1024x535.jpg 1024w, https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002-980x512.jpg 980w, https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002-480x251.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/p>\n<p><strong>Data Lake e Data Warehouse s\u00e3o tipos de armazenamento de dados \u00fateis para a infraestrutura de organiza\u00e7\u00f5es din\u00e2micas e competitivas. Duas possibilidades com pr\u00f3s e contras a serem avaliados segundo as necessidades das empresas.<\/strong><\/p>\n<p>A expans\u00e3o do mundo do Big Data originou variadas formas de armazenamento, tais como o Data Lake e o Data Warehouse. Com fun\u00e7\u00f5es parecidas e, \u00e0s vezes, confundidas, ambos hospedam dados corporativos para an\u00e1lise e relat\u00f3rios de neg\u00f3cios, por\u00e9m com diferentes sistemas de gera\u00e7\u00e3o e padr\u00f5es de acesso.<\/p>\n<p>Data Lake \u00e9 um dep\u00f3sito de dados \u2013 estruturados, n\u00e3o estruturados e h\u00edbridos \u2013 num s\u00f3 lugar, com qualidade limitada, mas que fornece base para a gera\u00e7\u00e3o de relat\u00f3rios, visualiza\u00e7\u00e3o e an\u00e1lise avan\u00e7ada. Seus dados n\u00e3o se prendem a objetivos predefinidos (<em>schema-on-read<\/em>), o que significa que podem ser armazenados sem limpeza, tratamento ou organiza\u00e7\u00e3o, ou seja, em seu estado bruto. Por armazenar dados a um baixo custo e de modo escal\u00e1vel e por coletar, importar e processar dados de infraestruturas anal\u00edticas j\u00e1 utilizadas, pode passar por upgrades sucessivos, conforme aumentam os dados, sem que haja uma desatualiza\u00e7\u00e3o a curto prazo. N\u00e3o h\u00e1 restri\u00e7\u00f5es para a ferramenta, da\u00ed seu nome, um \u201clago\u201d, que abriga informa\u00e7\u00f5es num \u00fanico local: o Big Data. Suas maiores vantagens s\u00e3o: abrigar qualquer tipo de dado; ter flexibilidade; democratizar o acesso; armazenar grandes quantidades de dados e algoritmos.<\/p>\n<p>Data Warehouse \u00e9 um dep\u00f3sito central de dados integrados e estruturados, de duas ou mais fontes, usado principalmente para relat\u00f3rios e an\u00e1lises e tido como principal componente da intelig\u00eancia de neg\u00f3cios (b<em>usiness intelligence<\/em>). Ele implementa padr\u00f5es anal\u00edticos predefinidos e distribu\u00eddos para um grande n\u00famero de usu\u00e1rios na empresa. Sua caracter\u00edstica \u00e9 possuir um <em>\u201cschema\u201d<\/em>, com dados limpos, tratados e organizados que funciona como um estoque a ser consultado periodicamente, com informa\u00e7\u00f5es bem localizadas e facilmente acessadas, sobre clientes e fornecedores, mas que tendem a ficar desatualizadas a curto prazo. Armazenar volumes de dados num Data Warehouse \u00e9 complexo e custoso pelo fato de, antes da coleta, ser preciso prepar\u00e1-los, transform\u00e1-los e estrutur\u00e1-los. Seus maiores benef\u00edcios s\u00e3o: integrar diferentes fontes em uma vis\u00e3o \u00fanica, armazenar dados higienizados, favorecer insights e permitir an\u00e1lise de hist\u00f3ricos.<\/p>\n<p>De acordo com o Gartner, Inc., uma certa \u201cmoda\u201d em rela\u00e7\u00e3o ao Data Lake est\u00e1 gerando certa confus\u00e3o na \u00e1rea de gest\u00e3o e \u00e9 preciso compreender como ele opera e como se obt\u00e9m valor a partir dele. O fato de os dados estarem no \u201clago\u201d, acess\u00edveis a todos da organiza\u00e7\u00e3o n\u00e3o pressup\u00f5e que todos sejam qualificados para sua manipula\u00e7\u00e3o e an\u00e1lise. \u00c9 preciso um controle empresarial de gest\u00e3o. Muitos veem o Data Lake e o Data Warehouse como op\u00e7\u00f5es intercambi\u00e1veis, mas, na verdade, cada um tem uma finalidade prim\u00e1ria diferente. Quando combinados, suportam cargas de trabalho complexas, diversificadas e distribu\u00eddas. N\u00e3o se trata de saber qual o melhor, mas qual a <strong>melhor op\u00e7\u00e3o para determinada empresa<\/strong><strong>. <\/strong>E a escolha depende de vari\u00e1veis como o porte da empresa, as limita\u00e7\u00f5es e os objetivos dos projetos de Big Data. Apesar das diferen\u00e7as t\u00e9cnicas, conceituais e de finalidade, as ferramentas s\u00e3o complementares e, quando trabalham de modo integrado, geram uma boa rela\u00e7\u00e3o custo-benef\u00edcio e proporcionam \u00e0s organiza\u00e7\u00f5es otimiza\u00e7\u00e3o de processos e de tempo.<\/p>\n<p><a href=\"https:\/\/www.talend.com\/resources\/data-lake-vs-data-warehouse\/\">https:\/\/www.talend.com\/resources\/data-lake-vs-data-warehouse\/<\/a><\/p>\n<p><a href=\"https:\/\/planin.com\/cuidado-com-a-ilusao-do-data-lake-aconselha-o-gartner\/\">https:\/\/planin.com\/cuidado-com-a-ilusao-do-data-lake-aconselha-o-gartner\/<\/a><\/p>\n<p><a href=\"http:\/\/datascienceacademy.com.br\/blog\/como-diferenciar-data-hub-data-lake-e-data-warehouse\/\">http:\/\/datascienceacademy.com.br\/blog\/como-diferenciar-data-hub-data-lake-e-data-warehouse\/<\/a><\/p>\n<p><a href=\"http:\/\/www.gartner.com\/document\/2805917\">http:\/\/www.gartner.com\/document\/2805917<\/a>.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Footer&#8221; _builder_version=&#8221;4.4.8&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#004183&#8243; background_color_gradient_end=&#8221;#001f4c&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top right&#8221; background_color_gradient_start_position=&#8221;42%&#8221; background_image=&#8221;https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2020\/06\/cyber-security-17.png&#8221; z_index=&#8221;10&#8243; min_height=&#8221;545px&#8221; height=&#8221;446px&#8221; overflow-x=&#8221;visible&#8221; overflow-y=&#8221;visible&#8221; custom_margin=&#8221;-2px||-2px||true|false&#8221; custom_padding=&#8221;||0vw||false|false&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_module=&#8221;215&#8243; locked=&#8221;off&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row column_structure=&#8221;2_5,3_5&#8243; make_equal=&#8221;on&#8221; disabled_on=&#8221;on|on|off&#8221; _builder_version=&#8221;4.4.8&#8243; background_color=&#8221;#ffffff&#8221; min_height=&#8221;421px&#8221; custom_margin=&#8221;-137px|auto|-2px|auto|false|false&#8221; custom_padding=&#8221;0px||0px||true&#8221; border_radii=&#8221;on|10px|10px|10px|10px&#8221; box_shadow_style=&#8221;preset1&#8243; box_shadow_vertical=&#8221;40px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_spread=&#8221;-8px&#8221; box_shadow_color=&#8221;rgba(10,45,97,0.48)&#8221; saved_tabs=&#8221;all&#8221; locked=&#8221;off&#8221;][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;3.25.3&#8243; custom_padding=&#8221;60px|40px|60px|40px|true|true&#8221;][et_pb_text _builder_version=&#8221;4.9.0&#8243; text_font=&#8221;||||||||&#8221; header_2_font=&#8221;eurostile|900|||||||&#8221; header_2_font_size=&#8221;56px&#8221; header_2_line_height=&#8221;1.1em&#8221; text_orientation=&#8221;center&#8221; width=&#8221;100%&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;-40px||7px||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; header_2_font_size_tablet=&#8221;38px&#8221; header_2_font_size_phone=&#8221;26px&#8221; header_2_font_size_last_edited=&#8221;on|desktop&#8221; text_text_align=&#8221;center&#8221; locked=&#8221;off&#8221;]\n<h2 style=\"text-align: left;\">Fale com nossa equipe<\/h2>\n[\/et_pb_text][et_pb_blurb title=&#8221;+55 11 4178-8811&#8243; use_icon=&#8221;on&#8221; font_icon=&#8221;%%264%%&#8221; icon_color=&#8221;#006ac1&#8243; icon_placement=&#8221;left&#8221; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;24px&#8221; _builder_version=&#8221;4.4.8&#8243; header_font=&#8221;Overpass|900|||||||&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;Overpass|300|||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;||0px||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;4px|||||&#8221; locked=&#8221;off&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;sphere@sphereit.com.br&#8221; use_icon=&#8221;on&#8221; font_icon=&#8221;%%238%%&#8221; icon_color=&#8221;#006ac1&#8243; icon_placement=&#8221;left&#8221; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;24px&#8221; title_last_edited=&#8221;off|phone&#8221; _builder_version=&#8221;4.4.8&#8243; header_font=&#8221;Overpass|900|||||||&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;Overpass|300|||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;||4px||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;4px|||||&#8221; locked=&#8221;off&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;Endere\u00e7o: Rua Jos\u00e9 Versolato, 111 &#8211; 18\u00ba Andar \u2013 S\u00e3o Bernardo do Campo&#8221; use_icon=&#8221;on&#8221; font_icon=&#8221;%%249%%&#8221; icon_color=&#8221;#006ac1&#8243; icon_placement=&#8221;left&#8221; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;24px&#8221; _builder_version=&#8221;4.4.8&#8243; header_font=&#8221;Overpass|900|||||||&#8221; header_text_align=&#8221;left&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;Overpass|300|||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||-99px|||&#8221; locked=&#8221;off&#8221;][\/et_pb_blurb][et_pb_social_media_follow _builder_version=&#8221;4.4.8&#8243; custom_margin=&#8221;100px||||false|false&#8221;][et_pb_social_media_follow_network social_network=&#8221;linkedin&#8221; url=&#8221;https:\/\/www.linkedin.com\/company\/sphere-it-solutions\/&#8221; icon_color=&#8221;#004183&#8243; _builder_version=&#8221;4.4.8&#8243; background_enable_color=&#8221;off&#8221; border_radii=&#8221;on|22px|22px|22px|22px&#8221; border_width_all=&#8221;2px&#8221; border_color_all=&#8221;#004183&#8243; follow_button=&#8221;off&#8221; url_new_window=&#8221;on&#8221;]linkedin[\/et_pb_social_media_follow_network][et_pb_social_media_follow_network social_network=&#8221;facebook&#8221; url=&#8221;https:\/\/www.facebook.com\/sphereitsolutions&#8221; icon_color=&#8221;#004183&#8243; _builder_version=&#8221;4.4.8&#8243; background_color=&#8221;#3b5998&#8243; background_enable_color=&#8221;off&#8221; border_radii=&#8221;on|22px|22px|22px|22px&#8221; border_width_all=&#8221;2px&#8221; border_color_all=&#8221;#004183&#8243; follow_button=&#8221;off&#8221; url_new_window=&#8221;on&#8221;]facebook[\/et_pb_social_media_follow_network][\/et_pb_social_media_follow][\/et_pb_column][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.4.8&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#004183&#8243; background_color_gradient_end=&#8221; #001c4c&#8221; background_color_gradient_type=&#8221;radial&#8221; background_image=&#8221;https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2020\/06\/cyber-security-010-1.png&#8221; background_size=&#8221;contain&#8221; background_position=&#8221;bottom_left&#8221; transform_translate_linked=&#8221;off&#8221; custom_padding=&#8221;60px|40px|60px|20%|true&#8221; custom_padding_tablet=&#8221;80px|||40px&#8221; custom_padding_phone=&#8221;&#8221; custom_padding_last_edited=&#8221;on|desktop&#8221; background_last_edited=&#8221;on|desktop&#8221; background_image_tablet=&#8221;http:\/\/zaib.sandbox.etdevs.com\/divi\/wp-content\/uploads\/sites\/2\/2019\/06\/cyber-security-11.png&#8221; background_enable_image_tablet=&#8221;on&#8221; background_position_tablet=&#8221;top_left&#8221;][et_pb_image src=&#8221;https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2020\/07\/Logos_Sphere_branco_vertical-1.png&#8221; title_text=&#8221;Logos_Sphere_branco_vertical&#8221; _builder_version=&#8221;4.4.9&#8243; width=&#8221;80%&#8221; width_tablet=&#8221;&#8221; width_phone=&#8221;57%&#8221; width_last_edited=&#8221;on|phone&#8221; filter_saturate=&#8221;127%&#8221; filter_brightness=&#8221;95%&#8221; filter_contrast=&#8221;131%&#8221; module_alignment_tablet=&#8221;&#8221; module_alignment_phone=&#8221;center&#8221; module_alignment_last_edited=&#8221;on|phone&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=&#8221;on&#8221; disabled_on=&#8221;off|off|on&#8221; _builder_version=&#8221;4.4.8&#8243; background_color=&#8221;#ffffff&#8221; min_height=&#8221;526px&#8221; custom_margin=&#8221;-137px|auto|-2px|auto|false|false&#8221; custom_padding=&#8221;0px||0px||true&#8221; border_radii=&#8221;on|10px|10px|10px|10px&#8221; box_shadow_style=&#8221;preset1&#8243; box_shadow_vertical=&#8221;40px&#8221; box_shadow_blur=&#8221;60px&#8221; box_shadow_spread=&#8221;-8px&#8221; box_shadow_color=&#8221;rgba(10,45,97,0.48)&#8221; saved_tabs=&#8221;all&#8221; locked=&#8221;off&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25.3&#8243; custom_padding=&#8221;60px|40px|60px|40px|true|true&#8221;][et_pb_image src=&#8221;https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2020\/06\/LogoV.png&#8221; title_text=&#8221;LogoV&#8221; _builder_version=&#8221;4.4.8&#8243; width_tablet=&#8221;&#8221; width_phone=&#8221;57%&#8221; width_last_edited=&#8221;on|phone&#8221; custom_margin=&#8221;-42px|||||&#8221; filter_saturate=&#8221;127%&#8221; filter_brightness=&#8221;95%&#8221; filter_contrast=&#8221;131%&#8221; module_alignment_tablet=&#8221;&#8221; module_alignment_phone=&#8221;center&#8221; module_alignment_last_edited=&#8221;on|phone&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.4.8&#8243; text_font=&#8221;||||||||&#8221; header_2_font=&#8221;Overpass|900|||||||&#8221; header_2_font_size=&#8221;56px&#8221; header_2_line_height=&#8221;1.1em&#8221; text_orientation=&#8221;center&#8221; width=&#8221;100%&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;-23px||7px||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; header_2_font_size_tablet=&#8221;38px&#8221; header_2_font_size_phone=&#8221;26px&#8221; header_2_font_size_last_edited=&#8221;on|desktop&#8221; text_text_align=&#8221;center&#8221; locked=&#8221;off&#8221;]\n<h2 style=\"text-align: left;\">Fale com nossa equipe<\/h2>\n[\/et_pb_text][et_pb_blurb title=&#8221;+55 11 4178-8811&#8243; use_icon=&#8221;on&#8221; font_icon=&#8221;%%264%%&#8221; icon_color=&#8221;#006ac1&#8243; icon_placement=&#8221;left&#8221; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;24px&#8221; _builder_version=&#8221;4.5.0&#8243; header_font=&#8221;Overpass|900|||||||&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;Overpass|300|||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;||0px||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;4px|||||&#8221; locked=&#8221;off&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;sphere@sphereit.com.br&#8221; use_icon=&#8221;on&#8221; font_icon=&#8221;%%238%%&#8221; icon_color=&#8221;#006ac1&#8243; icon_placement=&#8221;left&#8221; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;24px&#8221; title_last_edited=&#8221;off|phone&#8221; _builder_version=&#8221;4.4.8&#8243; header_font=&#8221;Overpass|900|||||||&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;Overpass|300|||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;||4px||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;4px|||||&#8221; locked=&#8221;off&#8221;][\/et_pb_blurb][et_pb_blurb title=&#8221;Endere\u00e7o: Rua Jos\u00e9 Versolato, 111 &#8211; 18\u00ba Andar \u2013 S\u00e3o Bernardo do Campo&#8221; use_icon=&#8221;on&#8221; font_icon=&#8221;%%249%%&#8221; icon_color=&#8221;#006ac1&#8243; icon_placement=&#8221;left&#8221; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;24px&#8221; _builder_version=&#8221;4.4.8&#8243; header_font=&#8221;Overpass|900|||||||&#8221; header_text_align=&#8221;left&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;Overpass|300|||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;||-99px|||&#8221; locked=&#8221;off&#8221;][\/et_pb_blurb][et_pb_social_media_follow _builder_version=&#8221;4.4.8&#8243; custom_margin=&#8221;100px||||false|false&#8221;][et_pb_social_media_follow_network social_network=&#8221;linkedin&#8221; url=&#8221;https:\/\/www.linkedin.com\/company\/sphere-it-solutions\/&#8221; icon_color=&#8221;#004183&#8243; _builder_version=&#8221;4.4.8&#8243; background_enable_color=&#8221;off&#8221; border_radii=&#8221;on|22px|22px|22px|22px&#8221; border_width_all=&#8221;2px&#8221; border_color_all=&#8221;#004183&#8243; follow_button=&#8221;off&#8221; url_new_window=&#8221;on&#8221;]linkedin[\/et_pb_social_media_follow_network][et_pb_social_media_follow_network social_network=&#8221;facebook&#8221; url=&#8221;https:\/\/www.facebook.com\/sphereitsolutions&#8221; icon_color=&#8221;#004183&#8243; _builder_version=&#8221;4.4.8&#8243; background_color=&#8221;#3b5998&#8243; background_enable_color=&#8221;off&#8221; border_radii=&#8221;on|22px|22px|22px|22px&#8221; border_width_all=&#8221;2px&#8221; border_color_all=&#8221;#004183&#8243; follow_button=&#8221;off&#8221; url_new_window=&#8221;on&#8221;]facebook[\/et_pb_social_media_follow_network][\/et_pb_social_media_follow][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>Data Lake and Data Warehouse are types of data storage useful for the infrastructure of dynamic and competitive organizations. Two possibilities with pros and cons to be evaluated according to the needs of the companies.<\/p>","protected":false},"author":4,"featured_media":2530,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[13],"tags":[],"class_list":["post-2521","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>As diferen\u00e7as entre Data Lake e Data Warehouse - Sphere IT<\/title>\n<meta name=\"description\" content=\"Data Lake e Data Warehouse s\u00e3o tipos de armazenamento de dados \u00fateis para a infraestrutura de organiza\u00e7\u00f5es din\u00e2micas e competitivas. Duas possibilidades com pr\u00f3s e contras a serem avaliados segundo as necessidades das empresas.\" \/>\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.sphereit.com.br\/en\/news\/diferenca_entre_data_lake_e_data_warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"As diferen\u00e7as entre Data Lake e Data Warehouse - Sphere IT\" \/>\n<meta property=\"og:description\" content=\"Data Lake e Data Warehouse s\u00e3o tipos de armazenamento de dados \u00fateis para a infraestrutura de organiza\u00e7\u00f5es din\u00e2micas e competitivas. Duas possibilidades com pr\u00f3s e contras a serem avaliados segundo as necessidades das empresas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sphereit.com.br\/en\/news\/diferenca_entre_data_lake_e_data_warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Sphereit\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-03T17:18:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-04T15:01:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1085\" \/>\n\t<meta property=\"og:image:height\" content=\"567\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Fernando Takashi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fernando Takashi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/\"},\"author\":{\"name\":\"Fernando Takashi\",\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/pt_br\\\/#\\\/schema\\\/person\\\/af3b780c5dd1e269bce8a95376e0e1ea\"},\"headline\":\"As diferen\u00e7as entre Data Lake e Data Warehouse\",\"datePublished\":\"2021-05-03T17:18:37+00:00\",\"dateModified\":\"2021-05-04T15:01:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/\"},\"wordCount\":2263,\"image\":{\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sphereit.com.br\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/post_LINKEDIN_data-lake-002.jpg\",\"articleSection\":[\"News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/\",\"url\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/\",\"name\":\"As diferen\u00e7as entre Data Lake e Data Warehouse - Sphere IT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/pt_br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sphereit.com.br\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/post_LINKEDIN_data-lake-002.jpg\",\"datePublished\":\"2021-05-03T17:18:37+00:00\",\"dateModified\":\"2021-05-04T15:01:16+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/pt_br\\\/#\\\/schema\\\/person\\\/af3b780c5dd1e269bce8a95376e0e1ea\"},\"description\":\"Data Lake e Data Warehouse s\u00e3o tipos de armazenamento de dados \u00fateis para a infraestrutura de organiza\u00e7\u00f5es din\u00e2micas e competitivas. Duas possibilidades com pr\u00f3s e contras a serem avaliados segundo as necessidades das empresas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sphereit.com.br\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/post_LINKEDIN_data-lake-002.jpg\",\"contentUrl\":\"https:\\\/\\\/www.sphereit.com.br\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/post_LINKEDIN_data-lake-002.jpg\",\"width\":1085,\"height\":567},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/news\\\/diferenca_entre_data_lake_e_data_warehouse\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/www.sphereit.com.br\\\/pt_br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"As diferen\u00e7as entre Data Lake e Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/pt_br\\\/#website\",\"url\":\"https:\\\/\\\/www.sphereit.com.br\\\/pt_br\\\/\",\"name\":\"Sphereit\",\"description\":\"Sphere IT Solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sphereit.com.br\\\/pt_br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sphereit.com.br\\\/pt_br\\\/#\\\/schema\\\/person\\\/af3b780c5dd1e269bce8a95376e0e1ea\",\"name\":\"Fernando Takashi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e67927226813e24994f3cd160fd560d5ee9846b835b71ca4bc2fdbf73fcb4778?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e67927226813e24994f3cd160fd560d5ee9846b835b71ca4bc2fdbf73fcb4778?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e67927226813e24994f3cd160fd560d5ee9846b835b71ca4bc2fdbf73fcb4778?s=96&d=mm&r=g\",\"caption\":\"Fernando Takashi\"},\"sameAs\":[\"https:\\\/\\\/www.sphereit.com.br\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"As diferen\u00e7as entre Data Lake e Data Warehouse - Sphere IT","description":"Data Lake and Data Warehouse are types of data storage useful for the infrastructure of dynamic and competitive organizations. Two possibilities with pros and cons to be evaluated according to the needs of the companies.","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.sphereit.com.br\/en\/news\/diferenca_entre_data_lake_e_data_warehouse\/","og_locale":"en_US","og_type":"article","og_title":"As diferen\u00e7as entre Data Lake e Data Warehouse - Sphere IT","og_description":"Data Lake e Data Warehouse s\u00e3o tipos de armazenamento de dados \u00fateis para a infraestrutura de organiza\u00e7\u00f5es din\u00e2micas e competitivas. Duas possibilidades com pr\u00f3s e contras a serem avaliados segundo as necessidades das empresas.","og_url":"https:\/\/www.sphereit.com.br\/en\/news\/diferenca_entre_data_lake_e_data_warehouse\/","og_site_name":"Sphereit","article_published_time":"2021-05-03T17:18:37+00:00","article_modified_time":"2021-05-04T15:01:16+00:00","og_image":[{"width":1085,"height":567,"url":"https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002.jpg","type":"image\/jpeg"}],"author":"Fernando Takashi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Fernando Takashi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/#article","isPartOf":{"@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/"},"author":{"name":"Fernando Takashi","@id":"https:\/\/www.sphereit.com.br\/pt_br\/#\/schema\/person\/af3b780c5dd1e269bce8a95376e0e1ea"},"headline":"As diferen\u00e7as entre Data Lake e Data Warehouse","datePublished":"2021-05-03T17:18:37+00:00","dateModified":"2021-05-04T15:01:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/"},"wordCount":2263,"image":{"@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002.jpg","articleSection":["News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/","url":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/","name":"As diferen\u00e7as entre Data Lake e Data Warehouse - Sphere IT","isPartOf":{"@id":"https:\/\/www.sphereit.com.br\/pt_br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/#primaryimage"},"image":{"@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002.jpg","datePublished":"2021-05-03T17:18:37+00:00","dateModified":"2021-05-04T15:01:16+00:00","author":{"@id":"https:\/\/www.sphereit.com.br\/pt_br\/#\/schema\/person\/af3b780c5dd1e269bce8a95376e0e1ea"},"description":"Data Lake and Data Warehouse are types of data storage useful for the infrastructure of dynamic and competitive organizations. Two possibilities with pros and cons to be evaluated according to the needs of the companies.","breadcrumb":{"@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/#primaryimage","url":"https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002.jpg","contentUrl":"https:\/\/www.sphereit.com.br\/wp-content\/uploads\/2021\/05\/post_LINKEDIN_data-lake-002.jpg","width":1085,"height":567},{"@type":"BreadcrumbList","@id":"https:\/\/www.sphereit.com.br\/news\/diferenca_entre_data_lake_e_data_warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/www.sphereit.com.br\/pt_br\/"},{"@type":"ListItem","position":2,"name":"As diferen\u00e7as entre Data Lake e Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/www.sphereit.com.br\/pt_br\/#website","url":"https:\/\/www.sphereit.com.br\/pt_br\/","name":"Sphereit","description":"Sphere IT Solutions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sphereit.com.br\/pt_br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sphereit.com.br\/pt_br\/#\/schema\/person\/af3b780c5dd1e269bce8a95376e0e1ea","name":"Fernando Takashi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e67927226813e24994f3cd160fd560d5ee9846b835b71ca4bc2fdbf73fcb4778?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e67927226813e24994f3cd160fd560d5ee9846b835b71ca4bc2fdbf73fcb4778?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e67927226813e24994f3cd160fd560d5ee9846b835b71ca4bc2fdbf73fcb4778?s=96&d=mm&r=g","caption":"Fernando Takashi"},"sameAs":["https:\/\/www.sphereit.com.br"]}]}},"_links":{"self":[{"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/posts\/2521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/comments?post=2521"}],"version-history":[{"count":0,"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/posts\/2521\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/media\/2530"}],"wp:attachment":[{"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/media?parent=2521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/categories?post=2521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sphereit.com.br\/en\/wp-json\/wp\/v2\/tags?post=2521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}