DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Please enter at least three characters to search
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Modernize your data layer. Learn how to design cloud-native database architectures to meet the evolving demands of AI and GenAI workkloads.

Secure your stack and shape the future! Help dev teams across the globe navigate their software supply chain security challenges.

Releasing software shouldn't be stressful or risky. Learn how to leverage progressive delivery techniques to ensure safer deployments.

Avoid machine learning mistakes and boost model performance! Discover key ML patterns, anti-patterns, data strategies, and more.

Related

  • How To Select the Right Vector Database for Your Enterprise GENERATIVE-AI Stack
  • A Step-by-Step Guide: How to Convert Tables to Graph
  • Graph-Oriented Solutions Enhancing Flexibility Over Mutant Requirements
  • Designing Sustainable Hybrid Cloud Architecture: The Crucial Role of Carbon Footprint as a Non-Functional Requirement

Trending

  • The Role of Functional Programming in Modern Software Development
  • Create Your Own AI-Powered Virtual Tutor: An Easy Tutorial
  • Rethinking Recruitment: A Journey Through Hiring Practices
  • Java Virtual Threads and Scaling
  1. DZone
  2. Culture and Methodologies
  3. Agile
  4. To DBaaS or Not to DBaaS?

To DBaaS or Not to DBaaS?

Is DBaaS (Database as a Service) really able to completely replace the DBA? This article can help you shape your opinion.

By 
Dzmitry Ivanou user avatar
Dzmitry Ivanou
·
Aug. 16, 17 · Opinion
Likes (4)
Comment
Save
Tweet
Share
9.1K Views

Join the DZone community and get the full member experience.

Join For Free

According to a new forecast from the International Data Corporation (IDC), total spending on IT infrastructure products (server, enterprise storage, and Ethernet switches) for deployment in cloud environments will increase 15.3% year-over-year in 2017 to $41.7 billion. 

Gartner Inc., a leading research and advisory company, predicts that the public cloud services market will grow 18% in 2017 to $246.8B, while it was $209.2B in 2016. In the cloud world, Infrastructure as a Service (IaaS) is predicted to have highest growth rate from 36.8% in 2017, making a total of $34.6 billion. Cloud application services (Software as a Service, or SaaS) are predicted to grow 20.1% to reach $46.3 billion.

According to an IDC white paper sponsored by Salesforce, the app cloud delivers 520% ROI through the below advantages:

  • 70% accelerated time to market.

  • 80% more apps launched.

  • 75-85% reduction in infrastructure costs.

In IT, cloud computing has now become a major influencer, with a 4.5x higher growth rate than IT spending since 2009. The expected increase in growth rate for cloud computing is six times the rate of IT spending from 2015 to 2020. IDC also states that worldwide spending on public cloud computing will increase from $67B to $162B for the period 2015 to 2020.

Image title

Courtesy: Salesforce.com

DBaaS (Database as a Service) and Cloud

DBaaS is a cloud-based database storage, utilization, administration, and management service that uses a cloud infrastructure for implementation. It is managed by a private or public cloud operator as a metered service. Like any other cloud services, DBaaS is also a provision of database instances in server containers and is provisioned by the user according to their needs and requirements. Accordingly, the user needs to pay for only what they use, including storage and other resources. DBaaS has many advantages compared to in-house database implementation, mainly in terms of deployment, availability, security, latency, reliability, and scalability.

Rapid and user controlled provisioning, automated and centralized management, elastic capacity, etc. are made possible through implementation of DBaaS using the concepts of database containerization and spawning of pluggable tenant databases like that of the Oracle Cloud. 

The Rise of DBaaS

MarketsAndMarkets is forecasting Cloud/DBaaS market to grow from $1.07 billion in 2014 to $14.05 billion by 2019 at a compound annual growth rate (CAGR) of 67.30% during the forecast period of 2014-2019.

ResearchAndMarkets, in their report Global Database as a Service (DBaaS) Market 2016-2020, forecasts the global database as a service (DBaaS) market to grow at a CAGR of 65.49% during the period 2016-2020.

Why DBaaS?

A conventional internal technology infrastructure needs to allocate hardware/software resources, budget, and time for deploying and managing the database system for each project. This is to be duplicated for the development/testing/production environments. The resulting overhead in terms of cost, space, effort, and resources are eliminated in DBaaS due to the service-oriented architecture that allows elasticity, resource pooling, and automation. DBaaS provides production and non-production database instances and their service is never affected by resource/budget limitations.

For the customer, the overhead of typical database administration tasks (DBA) needed with multiple independent database deployments are avoided in the case of DBaaS because of the cloud-based automation provided by the centralized database management application. Accordingly, the responsibilities of the user are limited to only a few functional areas like requirement definition, application implementation, connectivity to the database instances, grabbing the analytic reports for QoS measurements, etc. All other intense and dedicated tasks like configuration, optimization, provisioning, backup, security, monitoring, networking, automation, upgrades, maintenance, etc. are performed by the DBaaS service provider’s automated database management system.

To Use DBaaS...

The following are some of the factors are to be considered to make a decision about consuming a DBaaS service:

  • Are you finding it tedious to create and manage separate databases or database servers for each of your technical entities (development, testing, production, etc.) and for each of your projects?

  • Are database-related costs rising disproportionally to other costs, negatively affecting ROI and profit?

  • Are you finding it difficult to find suitable and compatible hardware/software resources for your database needs?

  • Is your HR department struggling to find the right DBA professionals?

  • Is your data growing, causing you to worry about performance and scalability?

  • Are you looking for enhanced security, backup, and maintenance solutions that don't raise your costs?

If you answered "yes" to the majority of these questions, a DBaaS solution may be the right choice!

Or Not to Use DBaaS?

You shouldn't use DBaaS in the following circumstances.

  • You don’t want separate databases for separate environments or projects, or you can manage the requirements with the in-house allocations.

  • You have exceptional DBA capabilities to manage your internal database ecosystem.

  • You don't expect growth (whether it's data or capabilities) that are unmanageable through your in-house provisions.

  • You have a well-established and linearly growing database system that you can afford.

  • Neither your business nor your data requirements are geo-wide enough to look for a distributed system.

It's notable that many developers and firms are either suspicious or are fearful about using DBaaS in production. Do you think the same way?

What About My DBA?

Database administrator(s) managethe entire administration and management of a company/firm’s database system, often with the help of software. Their responsibilities typically include, but not limited to, the following:

  • Prepare database installation environment in the server; install and configure database(s). Import/export of data, as well as user management.

  • Implement and enforce security at the server level and database level. Adjust or allocate computing and memory requirements as and when needed.

  • Create additional databases including users as needed. Upgrade database in tandem with new releases to accommodate bug fixes and performance enhancements with new releases.

  • Maintain server and database hardware/software compatibility. Enforce high availability and easy provisioning.

  • Continuously monitor database and server performance to identify issues and bottlenecks and take remedial actions promptly; monitor and review database/server logs regularly to identify any misconfiguration or discrepancies. 

  • Set up/automate backup schemes. Perform recovery/restore proactively. Manage complex procedures like replication, virtualization etc. when data requirements rise.

  • Keep watch on changing technologies in database ecosystem to move along with market requirements.

Image title

   DBaaS scheme provided by ClusterEngine.me

With DBaaS, you basically have a DBA. There is no such thing as being out of resources because you are always consuming only a portion of a vast pool. Whether there is a momentary spike in resource usage or a continuous requirement for more resources, it's simply a matter of deciding how much you need to have done. 

There are no costly hardware/software purchases, compatibility checks, or chains of dependencies to be solved. There's no worrying about backup crons, hardware/OS failures, system upgrade downtimes, or firewall rules. All the headaches are safely handed over to the hands that are dedicated to deal with these tasks.

You are provided with a control panel for all kinds of optional tasks in addition to much-needed analytics and statistics. You can examine logs, performance, traffic, and resource usage to make decisions about scaling out or other business/technical decisions. You can select which parts of the DBA role that you want to handle yourself. You simply make decisions and your provider does the rest. And if you are keen to play a more active role in this setup other than the automated and centralized DBA tasks, you can analyze the slow query log provided by the provider and optimize your queries for further speed and optimization.

So what do you think? Is DBaaS really able to completely replace the DBA?

Database Cloud computing Requirement

Opinions expressed by DZone contributors are their own.

Related

  • How To Select the Right Vector Database for Your Enterprise GENERATIVE-AI Stack
  • A Step-by-Step Guide: How to Convert Tables to Graph
  • Graph-Oriented Solutions Enhancing Flexibility Over Mutant Requirements
  • Designing Sustainable Hybrid Cloud Architecture: The Crucial Role of Carbon Footprint as a Non-Functional Requirement

Partner Resources

×

Comments
Oops! Something Went Wrong

The likes didn't load as expected. Please refresh the page and try again.

ABOUT US

  • About DZone
  • Support and feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends:

Likes
There are no likes...yet! 👀
Be the first to like this post!
It looks like you're not logged in.
Sign in to see who liked this post!