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