Database Deployments - A Primary Challenge to Accelerating Application Releases
June 06, 2019

Database deployments continue to be a software delivery bottleneck, a process that has not improved within the past year, according to The 2019 State of Database Deployments in Application Delivery, a report from Datical based on research conducted by Dimensional Research.

Additionally, the growing pressure to deliver application updates faster is greater than ever before. Companies with the fastest application release cycles suffered the biggest impact from slow, manual deployment of database schema changes.

The report is based on a survey of application developers, application release engineers, enterprise architects, and DevOps engineers. Of those, 92% reported it is difficult to accelerate the deployment of database schema changes in an effort to match the pace at which they deploy application code changes. This finding shows there has been no improvement as the same statistic was reported last year.

The process of deploying database schema changes is very complex and demanding. It frequently involves spending hours, if not days, manually reviewing and validating every database change script and schema change within those scripts. In fact, 91% of survey respondents reported they have to re-work database changes multiple times before they are ready for production deployment. This backs up another key finding among survey participants — 80% agree that it takes longer to deploy database code changes than other types of code changes.

Moreover, neglecting the database deployment process has proven to have significant business impacts. Enterprises rely on mission-critical applications and their databases to run the business and drive the customer experience. If database change errors occur and are not resolved quickly, application performance can suffer, service outages can occur, and the risk of data loss increases — all leading to brand reputation damage. The research found that 84% of application stakeholders had serious production issues due to database change errors; 57% of all application changes require a corresponding database schema change; and 88% report taking more than an hour to resolve these schema change issues, up from 81% a year ago.

“The lack of automated testing, change validation, and code deployment around database releases are the biggest threat to an organization’s ability to accelerate application delivery and keep pace with customer demands,” said Robert Reeves, CTO and co-founder of Datical. “As executives search for ways to accelerate application delivery and remove errors, the resolution is simple — automate the database release process. This survey proves the database release process is a significant bottleneck to application delivery. Those that don’t automate this process will see initiatives like agile and DevOps fail.”

The overwhelming majority (92%) of enterprises realize that automating database deployments provides tremendous business value and accelerates overall application release cycles. According to survey respondents, the top benefits of database release automation include the ability for developers to find and fix database schema change errors faster (65%), reduced application downtime because of fewer, bad database schema changes (60%), and removing database deployment process bottlenecks in the application release process (52%).

“This research clearly shows the database deployment process is often considered the most frequent source of bottlenecks and risk to the application release cycle. This indicates a need to deliver error-free application experiences faster without increasing risk,” said Diane Hagglund, Principal Researcher at Dimensional Research. “This research clearly indicates that organizations see the benefits of automating their database deployment process, especially since the data proves that deployments get hard as application release cycles get faster.”

Survey Methodology and Participant Demographics: The State of Database Deployments in Application Delivery survey, commissioned by Datical, was conducted in March 2019 and gathered responses from a total of 307 highly qualified application developers, application release managers, enterprise architects, and DevOps professionals at large enterprises. All had the responsibility for mission-critical applications that connected to enterprise databases, which included a mix of job levels, application responsibilities, databases used, and industry verticals.

Share this

Industry News

March 26, 2020

Redgate’s new SQL Monitor now ensures that DevOps teams can monitor and track deployments at all times.

March 26, 2020

Split Software announced a two-way data integration with Google Analytics that can instantly detect performance issues caused by new features.

March 26, 2020

Cloudreach earned the Kubernetes on Microsoft Azure advanced specialization.

March 25, 2020

Informatica updated its Intelligent Data Platform, powered by Informatica's AI-powered CLAIRE engine, with advanced intelligence and automation capabilities, enabling enterprises to accelerate cloud analytics modernization, drive better customer experiences, and properly govern and manage all their data.

March 25, 2020

Datical released Targeted Rollback capabilities for Liquibase, the rapidly growing open-source tool that helps application developers track, version and deploy database schema changes quickly and safely.

March 25, 2020

HashiCorp raised $175 million in Series E funding, at a company valuation of $5.1 billion.

March 24, 2020

Sysdig launched PromCat.io.

March 24, 2020

Sonatype announced expanded language coverage within Nexus Lifecycle to include Conan (C/C++), Composer (PHP), and RubyGems (Ruby), including the ability to create and contextually enforce policies.

March 24, 2020

Swimlane joined the Chronicle Index Partner program as part of a broader industry effort to help customers improve visibility of and response to cyber threats.

March 23, 2020

Portshift introduced Kubei Open Source container scanning software.

March 23, 2020

Perspecta achieved Amazon Web Services (AWS) DevOps Competency status.

March 23, 2020

Talend announced the availability of Talend Cloud in Microsoft Azure Marketplace, an online store providing applications and services for use on Azure.

March 19, 2020

DevOps Institute, a global member-based association for advancing the human elements of DevOps, announced eight Virtual SKILup Day micro-conferences starting April 30, 2020.

March 19, 2020

Oteemo, an enterprise DevSecOps and Cloud Native Transformation consultancy, launched an enterprise kubernetes and cloud native learning program.

March 19, 2020

Spectro Cloud, an enterprise cloud-native infrastructure company, emerged from stealth and unveiled its first product: Spectro Cloud.