Cloud vs On-Premise
| Feature | Cloud Datawarehouse | On-Premise |
|---|---|---|
Scalability | Instant Up / Down, Scale In / Out | Reconfiguring / purchasing hardware, software, etc. |
Availability | Up to 99.99% | Depends on infrastructure. |
Security | Provided by cloud provider | Depends on the competence of the in-house IT team. |
Performance | Serve multiple geo locations, helps query performance | Scalability challenge |
Cost-effectiveness | No hardware / initial cost. Pay only for usage. *If not managed carefully, it could cost a fortune. | Requires significant initial investment, salary. |
Last updated