Difference between Data lake and Datawarehouse

Data lake and Data warehouse both are used for storing big data.

Data lake is very big storage repository which is used to store raw unstructured data,machine to machine, logs flowing through in real-time. Purpose of the stored data is not defined in the data lake. They are stored for future analysis of the data.

A data warehouse is a repository for structured, filtered data that has already been processed for a specific purpose. Dataware collect the data from multiple sources and transform the data using ETL process then load it to the Data Warehouse for business purpose.

Mahesh Parahar

Published on 27-Jan-2020 10:46:49

• Related Questions & Answers
• Difference Between Data and Metadata
• Difference Between Data and Information
• Difference between data type and data structure
• Difference Between Data Warehouse and Data Mart
• Difference Between Data Mining and Data Warehousing
• Difference Between Abstraction and Data Hiding
• Difference Between Data Hiding and Encapsulation
• Difference between fundamental data types and derived data types
• Difference between Stack and Queue Data Structures
• Difference between Data warehouse and Operational database
• Difference Between Descriptive and Predictive Data Mining
• Difference between Linear and Non-linear Data Structures
• Difference between Structured, Semi-structured and Unstructured data
• Difference between Data Scientist, Data Engineer, Data Analyst.
• Difference between fundamental data types and derived data types in C++