Welcome!

Open Source Cloud Authors: Liz McMillan, Yeshim Deniz, Elizabeth White, Pat Romanski, Zakia Bouachraoui

Related Topics: SYS-CON MEDIA, Java IoT, Microservices Expo, Open Source Cloud, Agile Computing

SYS-CON MEDIA: News Item

SMG Research Reveals DBA Tools Not Effective for Managing Database Change

Database Schema Changes Rank High Among Contributing Factors

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. 42 percent of change requests require in-depth database schema knowledge.
  • Lack of skills in-house - On average, it takes 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 7 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 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."

 

More Stories By Pete Pickerill

Pete Pickerill is Vice President of Products and Co-founder of Datical. Pete is a software industry veteran who has built his career in Austin’s technology sector. Prior to co-founding Datical, he was employee number one at Phurnace Software and helped lead the company to a high profile acquisition by BMC Software, Inc. Pete has spent the majority of his career in successful startups and the companies that acquired them including Loop One (acquired by NeoPost Solutions), WholeSecurity (acquired by Symantec, Inc.) and Phurnace Software.

IoT & Smart Cities Stories
Tapping into blockchain revolution early enough translates into a substantial business competitiveness advantage. Codete comprehensively develops custom, blockchain-based business solutions, founded on the most advanced cryptographic innovations, and striking a balance point between complexity of the technologies used in quickly-changing stack building, business impact, and cost-effectiveness. Codete researches and provides business consultancy in the field of single most thrilling innovative te...
Darktrace is the world's leading AI company for cyber security. Created by mathematicians from the University of Cambridge, Darktrace's Enterprise Immune System is the first non-consumer application of machine learning to work at scale, across all network types, from physical, virtualized, and cloud, through to IoT and industrial control systems. Installed as a self-configuring cyber defense platform, Darktrace continuously learns what is ‘normal' for all devices and users, updating its understa...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
CloudEXPO has been the M&A capital for Cloud companies for more than a decade with memorable acquisition news stories which came out of CloudEXPO expo floor. DevOpsSUMMIT New York faculty member Greg Bledsoe shared his views on IBM's Red Hat acquisition live from NASDAQ floor. Acquisition news was announced during CloudEXPO New York which took place November 12-13, 2019 in New York City.
OpsRamp is an enterprise IT operation platform provided by US-based OpsRamp, Inc. It provides SaaS services through support for increasingly complex cloud and hybrid computing environments from system operation to service management. The OpsRamp platform is a SaaS-based, multi-tenant solution that enables enterprise IT organizations and cloud service providers like JBS the flexibility and control they need to manage and monitor today's hybrid, multi-cloud infrastructure, applications, and wor...
The Master of Science in Artificial Intelligence (MSAI) provides a comprehensive framework of theory and practice in the emerging field of AI. The program delivers the foundational knowledge needed to explore both key contextual areas and complex technical applications of AI systems. Curriculum incorporates elements of data science, robotics, and machine learning-enabling you to pursue a holistic and interdisciplinary course of study while preparing for a position in AI research, operations, ...
Codete accelerates their clients growth through technological expertise and experience. Codite team works with organizations to meet the challenges that digitalization presents. Their clients include digital start-ups as well as established enterprises in the IT industry. To stay competitive in a highly innovative IT industry, strong R&D departments and bold spin-off initiatives is a must. Codete Data Science and Software Architects teams help corporate clients to stay up to date with the mod...
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha...
With the introduction of IoT and Smart Living in every aspect of our lives, one question has become relevant: What are the security implications? To answer this, first we have to look and explore the security models of the technologies that IoT is founded upon. In his session at @ThingsExpo, Nevi Kaja, a Research Engineer at Ford Motor Company, discussed some of the security challenges of the IoT infrastructure and related how these aspects impact Smart Living. The material was delivered interac...
Intel is an American multinational corporation and technology company headquartered in Santa Clara, California, in the Silicon Valley. It is the world's second largest and second highest valued semiconductor chip maker based on revenue after being overtaken by Samsung, and is the inventor of the x86 series of microprocessors, the processors found in most personal computers (PCs). Intel supplies processors for computer system manufacturers such as Apple, Lenovo, HP, and Dell. Intel also manufactu...