# Comparison On Premise Database vs Cloud DBaaS

| metric | On Premise Database | Cloud DBaaS |
| :-- | :-- | :-- |
| Setup Cost | Can be costly, and time consuming to deploy | Quick deployment |
| Cost Effectiveness | Expensive to setup and deploy on-prem database as a service | Vendor is responsible for setup cost; Company pays for service only |
| Maintenance | High maintenance cost, ie. Hardware, DBAs, support, infrastructure. | No maintenance costs; Pay for what you use |
| Scalability | Limited scalability | Unlimited scalability |
| Speed | Fast, but may can fail due to hardware limitations | Fast, will always be up, no hardware limitations |
| Security | Secure and Controlled | Secure and controlled (based on vendor) |
| Reliability | Reliable and private | More reliable than on-prem but privacy depends on vendor |
------------------------------------------------------------
Comparison between on-premises Traditional Database and Cloud DBaaS (self explanatory)

Summary:

Key Takeaways:

Managed database service better than on-prem because

Physical Infrastructure unlimited

Fewer management requirements and responsibilities 

Automated –creation, backup, monitoring, recovery/repair,scaling security, multitenancy

Security  and isolation 

Cost of hardware eliminated