What is the difference between Database vs. Data lake vs. Warehouse?

In this video, we will describe the differences between database, data lake and data warehouse.

If you like this content, please check out the following top-rated courses on Udemy:

AWS SageMaker Practical for Beginners | Build 6 Projects
https://www.udemy.com/course/practica...

AWS Machine Learning Certification Exam | Complete Guide
https://www.udemy.com/course/amazon-w...

Modern Artificial Intelligence with Zero Coding
https://www.udemy.com/course/modern-a...

Python & Machine Learning for Financial Analysis
https://www.udemy.com/course/ml-and-p...

Modern Artificial Intelligence Masterclass: Build 6 Projects
https://www.udemy.com/course/modern-a...

Data Science for Business | 6 Real-world Case Studies
https://www.udemy.com/course/data-sci...

TensorFlow 2.0 Practical
https://www.udemy.com/course/tensorfl...

TensorFlow 2.0 Practical Advanced
https://www.udemy.com/course/tensorfl...

Machine Learning Regression Masterclass in Python
https://www.udemy.com/course/machine-...

Machine Learning Practical Workout | 8 Real-World Projects
https://www.udemy.com/course/deep-lea...

Machine Learning Classification Bootcamp in Python
https://www.udemy.com/course/machine-...

MATLAB/SIMULINK Bible|Go From Zero to Hero!
https://www.udemy.com/course/matlabsi...

Python 3 Programming: Beginner to Pro Masterclass
https://www.udemy.com/course/python-3...

Autonomous Cars: Deep Learning and Computer Vision in Python
https://www.udemy.com/course/autonomo...

Control Systems Made Simple | Beginner's Guide
https://www.udemy.com/course/control-...

Artificial Intelligence in Arabicالذكاء الصناعي مبتدئ لمحترف
https://www.udemy.com/course/artifici...

The Complete MATLAB Computer Programming Bootcamp
https://www.udemy.com/course/the-comp...


Databases are typically structured with a defined schema. Items are organized as a set of tables with columns and rows. Columns include attributes and rows indicate an object or entity.

Database is typically designed to be transactional and they are not designed to perform data analytics.

A data warehouse exists on top of several databases and used for business intelligence. Data warehouse consumes data from all these databases and creates a layer optimized to perform data analytics. Schema is done on import.

A data lake is a centralized repository for structured and unstructured data storage. Data lakes could be used to store raw data as is without any structure (schema). There is no need to perform any ETL or transformation jobs on it. You can store many types of data such images, text, files, videos. You can store machine learning models artifacts, real-time data, and analytics outputs in data lakes. Processing could be done on export so schema is defined on read.


I hope you guys enjoyed my videos. Please subscribe for more videos!
   / @professor-ryanahmed  

Thanks!

#database #datalake #datawarehouse #s3