/plushcap/analysis/fivetran/data-lakes-vs-data-warehouses

Data Lakes vs. Data Warehouses

What's this blog post about?

Successful analytics depends on choosing the right approach to storing enterprise data. Data warehouses, data marts, and data lakes are distinct technologies for storing business data and guiding business decisions. A data warehouse is a relational database designed for analytical queries, while a data mart is an organizational structure within a data warehouse containing summarized rather than raw data. A data lake is an object or file store that can accommodate large volumes of unstructured data such as free-form text, images, videos and other media, as well as structured data. Data warehouses are the most appropriate repository for structured business data used in analytics, while data lakes can store large quantities of media such as documents, images, videos, and audio. Some new technologies combine characteristics of both data warehouses and data lakes, known as data lakehouses.

Company
Fivetran

Date published
Oct. 5, 2021

Author(s)
Charles Wang

Word count
1232

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.