Skip to Main Content
  • Questions
  • SAAS Vs IAAS Vs PAAS for DBCS related query


Question and Answer

Connor McDonald

Thanks for the question, Rajneesh.

Asked: April 03, 2020 - 2:21 pm UTC

Answered by: Connor McDonald - Last updated: April 09, 2020 - 1:11 am UTC

Category: Database Administration - Version: 19 c

Viewed 100+ times

You Asked

Hello TOM,

I need to use DBCS for implementing Reporting Solution on cloud.
Hence need to understand SAAS, IAAS and PAAS platform for cloud.

Can you please help me to understand in simple layman terms with examples of all 3.


and we said...

Lets say you wanted to run an application that manages customers buying stuff on the internet. Here's how that would play out:

IAAS - you basically get a "machine". Its like if you went and bought a server, but the provider looks after the hardware, power etc. After that, it is entirely yours to do with what you want, but also, yours to manage as well. You are in charge of OS, backup, recovery, patching, security, software etc etc etc....So you need to install the OS, install the database, and then build/install your customer application.

PAAS - you get a machine and some level of software on it.. For example, it might just be the OS, or it might be the OS plus the database software and some tools. The provider now looks after the machine plus those software layers in terms of maintenance, patching etc. So you need to build/install your customer application, but the rest is not your concern.

SAAS - the provider provides and controls everything. You use a customer application that already exists (built by someone else).

They are not mutually exclusive. For example, if I might have some IAAS for my specialized applications/environments that are particular to my business. I might also have some PAAS for my app development environments for more conventional applications, and I might use SAAS for stuff that is not my core expertise (eg email, ERP - accounting, payroll etc)

and you rated our response

  (1 rating)


Thanks for your help

April 06, 2020 - 4:46 am UTC

Reviewer: A reader

Thank you, it helps.
Connor McDonald


April 09, 2020 - 1:11 am UTC

glad we could help