Learning Library

← Back to Library

What Is Database as a Service

Key Points

  • DBaaS (Database‑as‑a‑Service) is IBM’s offering that delivers a fully managed database through a cloud “as‑a‑service” model, removing the need for customers to provision and maintain the underlying infrastructure.
  • In a traditional setup you must order a server, install an OS, deploy the database software, and manually configure everything, which is time‑consuming and error‑prone.
  • Ongoing operation of a self‑managed database demands continual patching of hardware, firmware, OS, and database software, strict access‑control management, and separation of duties between administrators—all of which add significant operational overhead.
  • DBaaS also handles essential production tasks such as automated backups, versioning, and rapid recovery, ensuring continuity without the customer having to manage complex restore processes.

Full Transcript

# What Is Database as a Service **Source:** [https://www.youtube.com/watch?v=qfiOVB3yMHQ](https://www.youtube.com/watch?v=qfiOVB3yMHQ) **Duration:** 00:07:41 ## Summary - DBaaS (Database‑as‑a‑Service) is IBM’s offering that delivers a fully managed database through a cloud “as‑a‑service” model, removing the need for customers to provision and maintain the underlying infrastructure. - In a traditional setup you must order a server, install an OS, deploy the database software, and manually configure everything, which is time‑consuming and error‑prone. - Ongoing operation of a self‑managed database demands continual patching of hardware, firmware, OS, and database software, strict access‑control management, and separation of duties between administrators—all of which add significant operational overhead. - DBaaS also handles essential production tasks such as automated backups, versioning, and rapid recovery, ensuring continuity without the customer having to manage complex restore processes. ## Sections - [00:00:00](https://www.youtube.com/watch?v=qfiOVB3yMHQ&t=0s) **Understanding Database as a Service** - Bradley Knapp explains what DBaaS (Database as a Service) is, contrasts it with traditional on‑premise database setup, and highlights the operational complexities it aims to simplify. ## Full Transcript
0:00hi there my name is bradley knapp with 0:01ibm and the question that i want to help 0:03you answer today is what is d-bass 0:08what is this d-bass thing 0:10so d-b-a-n-s 0:15what is it 0:16dbas is an acronym that stands for 0:19database as a service that's our dnrb 0:22here literally stanford database 0:24what is database as a service so if we 0:27think about our cloud model of as a 0:30service products and as a service 0:32offerings and if you've got any 0:34questions about that we've got a bunch 0:35of other videos on the channel that you 0:37can review to learn about that as a 0:39service model 0:40dbas is the ability to deliver a 0:43database in that as a service model 0:46and so if you think about the 0:47traditional way to deploy a database 0:50right is you'd go over here and you'd 0:52order some sort of a server 0:54and on top of that server you'd put 0:57linux 0:58and then on top of that linux you would 1:00install your database software right so 1:04my sequel 1:07and so there's a lot of work involved in 1:09this right you have to go out you order 1:11the server configure the server put your 1:13linux on it whatever it may be 1:15download compile and install your 1:17database software there's a lot that 1:19goes on into this now you can script it 1:21you can make it faster you can make it 1:23easier but there's still a lot to get it 1:26set up but getting it set up isn't the 1:28hard part once it's set up you've got to 1:30keep it running and that's where the 1:32real challenge comes in right because 1:35what do you have to worry about when you 1:36have all of these things 1:39well you've got to worry about your 1:41users 1:42right and so with all of the users who 1:44can log into the server who can log into 1:46the operating system who can log into 1:47the database what kind of access levels 1:50do they need what kind of permissions do 1:51they need you've got to worry about 1:53patching hardware patching firmware 1:55patching software patching for the 1:57operating system software patching for 1:59your database you have to have somebody 2:01who keeps up with all of those patches 2:03protecting against security 2:04vulnerabilities you've got to think 2:06about your access control model 2:08who can get into this why and when do 2:11you have separation of duties between 2:13your database administrators and your 2:15server administrators or can people 2:17cross-pollinate there's a lot of work 2:20that goes into successful operation of a 2:22database server particularly something 2:25that's going to be hosting a production 2:27workload you've got to build it you've 2:29got to secure it and oh hey by the way 2:32you've got to operate it and what does 2:33that mean what do i mean when i say 2:35you've got to operate it well 2:36so you've got these three components 2:38here 2:39that you also have to have backup 2:43what happens if the server goes down 2:46you've got to have backups of it you've 2:47got to have quiest versions of the 2:49database you're going to have backups of 2:50your operating system all of your 2:52configuration 2:54if the server goes down you need to 2:55restore from those backups you need to 2:57bring it back up live again 2:59and there's a lot of work that goes into 3:02all of that 3:03hence 3:04database is a service so what happens 3:08well the whole idea behind database as a 3:10service is 3:11instead of you doing all of this work we 3:15the cloud provider are going to do most 3:17of this for you and so you're going to 3:19come to us and rather than ordering the 3:21server and telling us what operating 3:23system and what version of database 3:24software and all that you want you're 3:26going to say hey bradley i want my sql 3:29database as a service i want an ms and 3:32my sql database that i can just log into 3:35and start using and it's going to have 3:37connections on it you're going to open 3:38some ports up for me so that it can work 3:40for a web server or another application 3:43server 3:44and i just want to interact with it in 3:46an as a service manner i don't want to 3:48worry about backups you take care of 3:50that i don't want to worry about running 3:51it highly available you take care of 3:53that i don't want to worry about it 3:55crashing and me having to restore it you 3:57guys take care of all of that what i 3:58want 3:59is a database 4:03that has connections for user sessions 4:05that has connections for app server 4:07sessions and then it has connections for 4:10admin 4:11admin services 4:13and i don't want to worry about backups 4:15and all of those kinds of things the 4:16cloud provider takes care of all of that 4:19that 4:20is the as a service part and so on the 4:22back end to the cloud provider that you 4:24are buying this database serve this 4:26database as a service product from 4:29they're going to take care of the 4:30hardware the operating system 4:32the patching the user access the 4:35security the backups running it highly 4:37available guaranteeing that it's always 4:39up always available 4:41they are going to take care of all of 4:43those things for you you're just going 4:44to subscribe to this service as a 4:47service right you're going to pay an 4:50amount per month and that amount is 4:52going to be built up of how many rights 4:54do you make the database how big is the 4:56database how much storage space does it 4:58take up 4:59what level of availability do you want 5:01does it have to be available with three 5:03nines or four nines or five nines of 5:05uptime 5:06and then some other little little 5:07add-ons 5:08but it allows you to tailor your spend 5:11to where you are only spending what you 5:14need to run your workload 5:16and so when it's pitched like this of 5:18course everybody comes back and they say 5:20oh man that sounds great why wouldn't 5:22everybody only buy database as a service 5:24why would anybody go out and ever stand 5:26up their own database ever again 5:28this is a good question and let's talk 5:30about that for a minute because the big 5:32difference between database as a service 5:35and running it yourself is that in a 5:37database as a service model 5:40a lot of the administrative control the 5:42very specific tweaking and tuning that 5:45you can do on a database to make it run 5:46faster that gets abstracted away from 5:49you the person who are consuming it 5:52because it's run by the cloud provider 5:54and so if we think about our two models 5:56right 5:57our as a service model 6:00versus our role 6:02your own model 6:04enroll your own which is where you set 6:06up everything yourself 6:08you have a hundred percent 6:09administrative control over everything 6:12you decide what users get access you 6:15decide what your backup strategy is what 6:16your restore strategy is you decide 6:19everything on your own and like in 6:22spider-man with great power comes great 6:24responsibility now in that as a service 6:27model cloud provider is going to make a 6:29bunch of those decisions for you makes 6:30your life easier but you can't get in 6:33and twist all of those dials and knobs 6:35and tune that database so that it runs 6:37at 100 performance all the time specific 6:41to your workload and so you may end up 6:43having to oversize your database as a 6:46service from a performance perspective 6:48as compared if you rolled your own 6:51but that's okay because if you don't 6:53want to go out and hire your own 6:54database administrators and hire your 6:56own server administrators and deal with 6:58the headaches of user access and 7:00security and integration 7:02you don't have to you can consume it in 7:04an as a service model you don't need to 7:06worry about cloud providers going to 7:08take care of that all you worry about 7:10is plugging your endpoints in to where 7:12they need to be 7:13and being sure that the right people 7:15have the credentials and everything else 7:17is going to get taken care of for you so 7:19that you can focus on what you really 7:21want to do which is running that 7:22workload in providing the service out to 7:25your customers your partners and your 7:28consumers thank you so much for your 7:30time today if you have any questions 7:32please drop us a line below if you want 7:34to see more videos like this in the 7:36future please do like and subscribe and 7:38let us know