Data Warehouse |
Data Lake |
Data is relational from transactional systems and operational databases. |
Data is both non-relational and relational from various sources such as IoT devices, mobile apps, websites, and social media. |
Provides fastest query results at high cost of storage. |
Provides faster query results at low storage cost. |
Used by Business analysts. |
Used by Data scientists, Data developers, and Business analysts. |
Helps in Batch reporting, BI and visualizations |
Helps to perform various analytics such as Machine Learning, Predictive analytics, data discovery and profiling |