Looking for the high-level differences/comparison among
- Database
- Data Mart (Top-down approach)
- Data Warehouse
- Data Lake
Please use relative comparison when specifics are not available.
Database vs DataMart vs Data Warehouse vs Data Lake
Viewed 945
1 Answers
Included below is a high-level comparison between the various data tiers mentioned. Please feel free to drop a comment if any of these need corrections.
| Database | Data Mart (Top-down) | Data Warehouse | Data Lake | |
|---|---|---|---|---|
| Source | Single | Single | Multiple | Multiple |
| Structure | Structured | Structured | Structured | Raw |
| Purpose | Determined | Determined | Determined | Undertermined |
| Storage | Centralized | Decentralized | Centralized | Centralized |
| Data Format | Detailed | Summarized | Detailed | All |
| Flexibility | Low | Medium | Medium | High |
| Primary Use | Transactional | Reporting | Analytics & Reporting | Analytics |
| Cost | Low | Medium | Medium | High |
| Data Volume | Low | Low | Medium | High |
| Development | Top-down | Bottom-up | Top-down | All |
| Design Time | Medium | Medium | High | Low |
| Volatility | Medium | Low | None | None |
| Data Operations | CRUD | CR | CRU | CR |
| Subject Area | Single | Single | Multiple | Multiple |
| Design Schema | Relational | Multi-dimensional | Relational | No Schema |
Related