Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Comparison between data warehouse, data lake and data lakehouse

Hi, I'm searching a good and synthetic article that talk about a comparison between data warehouse, data lake and data lakehouse. I haven't found any good articles. Any suggests to me, please? Tha...
data warehouse
warehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi pmscorca ,

     

    Okay, that's more at a glance.

     

    Feature

    Data Warehouse

    Data Lake

    Data Lakehouse

    Data Structure

    Highly structured

    Structured and unstructured

    Combines both

    Use Case

    Business intelligence and reporting

    Big data analytics, machine learning

    BI, reporting, and advanced analytics

    Data Type

    Primarily structured data

    Raw and semi-structured data

    Handles all data types

    Query Performance

    Fast querying

    Slower querying

    Advanced querying capabilities

    Cost

    Generally higher

    More cost-effective for large volumes

    Balances cost efficiency with performance

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

In general, a Lakehouse is a ("virtual") Data Warehouse built on top of a Datalake storage.

 

Warehouse brings structure, schemas and other relational database features, whereas the Datalake storage is flexible (can store unstructured, semi-structured and structured data) and can store large amounts of data, and compute and storage is decoupled so it is highly scalable. The data lake is common for data science and machine learning purposes.

 

The data lakehouse is a warehouse which is using a data lake as data storage.

 

The specific details and definitions will differ between different vendors or products (Microsoft Fabric, Databricks, Google, Amazon, Oracle, etc.)

 

Each of these articles has their own approaches to explaining these concepts:

 

https://www.montecarlodata.com/blog-data-warehouse-vs-data-lake-vs-data-lakehouse-definitions-similarities-and-differences/

 

https://www.forbes.com/sites/bernardmarr/2022/01/18/what-is-a-data-lakehouse-a-super-simple-explanation-for-anyone/

 

https://www.databricks.com/blog/2020/01/30/what-is-a-data-lakehouse.html

 

https://docs.databricks.com/en/lakehouse/index.html#lakehouse-vs-data-lake-vs-data-warehouse

 

https://azure.microsoft.com/en-us/resources/cloud-computing-dictionary/what-is-a-data-lake

 

https://cloud.google.com/discover/what-is-a-data-lakehouse

 

 

P.S.: The Fabric Data Warehouse is actually a lakehouse, however it has different features than the Fabric Lakehouse: https://debruyn.dev/2023/fabric-lakehouse-or-data-warehouse/