Open Source Cloud Authors: Liz McMillan, Zakia Bouachraoui, William Schmarzo, Elizabeth White, Yeshim Deniz

News Feed Item

SMG Research Reveals DBA Tools Not Effective for Managing Database Change

New research from Simon Management Group reveals that despite the high percentage of companies who use DBA tools, a majority of companies still struggle with database change and configuration management issues that impede the first-time success rate of business-critical application deployments.

Commissioned by Datical, Inc., the study examines the views of application development and deployment professionals in large organizations with $100 million or greater in IT department spending. The companies surveyed have similar characteristics including a large number of applications in use, frequent database application change requests per week, adoption of agile development methodologies, and greater variation in the skills of their SQL programmers.

Findings from the analysis of nearly 100 verified responses point to a number of key issues:

  • Multiple databases, platforms – On average, companies use three different types of databases with MS SQL Server and Oracle being the most common.
  • High number of applications and changes – Companies support an average of 183 applications and IT receives requests for database application changes about four times per day. Forty-two percent of change requests require in-depth database schema knowledge.
  • Lack of skills in-house – On average, companies have 70 developers to support these applications, and only 39 percent of those organizations believe their in-house SQL programming expertise is adequate enough to manually update the schema.
  • Dependencies and change velocity – Across the board, the pain caused by database application changes is highest for managing the velocity of changes and application dependencies.
  • Application failures – Companies average a seven percent application failure rate, or 12 business critical failures per year.

However, the pain levels and types of change depend upon the use of agile development methodologies. Among 45 percent of companies using agile for development and test:

  • The pain among high agile users is greatest for velocity of changes, application dependency management and deployments that require manual intervention; whereas
  • The pain for low agile users is highest for managing dependencies, missing necessary steps in documentation and scripts, and deployments that require manual intervention.

Two-thirds of the organizations surveyed report that using DBA tools do not mitigate these issues when updating the database schema.

“Large organizations still rely on manual scripting to implement a high volume of database changes – opening themselves up to risks and errors when deploying the very applications that drive revenue for their business,” said Daniel Nelson, Datical CEO and co-founder. “By taking steps to eliminate manual scripting, automate and forecast the impact of change in production, these companies can reduce their risk, accelerate releases, speed time to market and cut cost.”

Download the infographic for a quick summary of the SMG research results.

About Simon Management Group

Simon Management Group is a management consulting firm dedicated to helping technology-based companies achieve their growth objectives. Based on primary research and compelling analysis, our work helps management teams make well-informed decisions that significantly improve business performance.

About Datical

Datical enhances, extends and fully supports proven open source projects for use in enterprise environments. Datical's flagship product, Datical DB, automates the deployment of database schema updates for large organizations that struggle with the constant state of application change across complex environments. Based upon the Liquibase open source project, Datical DB manages the database schema lifecycle for people who develop, deploy and maintain applications. Datical is led by the same experienced team that founded Phurnace Software, acquired by BMC Software. The company is privately held with headquarters in Austin, Texas and has strong venture backing from Austin Ventures, Mohr Davidow and Mercury Fund. For more information, visit www.datical.com or call 949-DATICAL.

More Stories By Business Wire

Copyright © 2009 Business Wire. All rights reserved. Republication or redistribution of Business Wire content is expressly prohibited without the prior written consent of Business Wire. Business Wire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.

IoT & Smart Cities Stories
Dion Hinchcliffe is an internationally recognized digital expert, bestselling book author, frequent keynote speaker, analyst, futurist, and transformation expert based in Washington, DC. He is currently Chief Strategy Officer at the industry-leading digital strategy and online community solutions firm, 7Summits.
Digital Transformation is much more than a buzzword. The radical shift to digital mechanisms for almost every process is evident across all industries and verticals. This is often especially true in financial services, where the legacy environment is many times unable to keep up with the rapidly shifting demands of the consumer. The constant pressure to provide complete, omnichannel delivery of customer-facing solutions to meet both regulatory and customer demands is putting enormous pressure on...
IoT is rapidly becoming mainstream as more and more investments are made into the platforms and technology. As this movement continues to expand and gain momentum it creates a massive wall of noise that can be difficult to sift through. Unfortunately, this inevitably makes IoT less approachable for people to get started with and can hamper efforts to integrate this key technology into your own portfolio. There are so many connected products already in place today with many hundreds more on the h...
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of containers. It was one of the first and best-known examples of projects that make containers truly useful for production use. However, more recently, the container ecosystem has truly exploded. A service mesh like Istio addr...
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
Charles Araujo is an industry analyst, internationally recognized authority on the Digital Enterprise and author of The Quantum Age of IT: Why Everything You Know About IT is About to Change. As Principal Analyst with Intellyx, he writes, speaks and advises organizations on how to navigate through this time of disruption. He is also the founder of The Institute for Digital Transformation and a sought after keynote speaker. He has been a regular contributor to both InformationWeek and CIO Insight...
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...
To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitoring and Cost Management … But How? Overwhelmingly, even as enterprises have adopted cloud computing and are expanding to multi-cloud computing, IT leaders remain concerned about how to monitor, manage and control costs across hybrid and multi-cloud deployments. It’s clear that traditional IT monitoring and management approaches, designed after all for on-premises data centers, are falling short in ...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D...
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence. Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more busine...