69% of DBAs manage more than one version of the same database and, of those that do, 51% said they manage three or more versions
San Francisco, CA (PRWEB) October 25, 2010
Managing multiple database platforms has become the norm rather than an exception for database administrators (DBAs). A new Database Trends Survey that shows 72% of DBAs manage at least two types of database management systems. Of those surveyed, 20% reported managing one database platform, 33% said they manage two, 25% said three, 8% said four, and 14% said they manage five or more.
Microsoft SQL Server and Oracle were cited as the most common database platforms, with 62% of respondents working with SQL Server and 60% with Oracle. Third on the list was Sybase Adaptive Server Enterprise with 35%, and Microsoft Access earned 19%. Oracle ranked tops as the database platform that respondents work with primarily.
Multiple Databases and Multiple Versions
Exacerbating the multi-platform database situation is that most DBAs are also tasked with managing multiple versions of a database, adding another layer of complexity to their responsibilities and creating more room for error. According to the survey, 69% manage more than one version of the same database and, of those that do, 51% said they manage three or more versions of the same database platform.
“Each database platform and version has its own features and functionality, and keeping them all straight can be a monumental task for DBAs,” said Scott Walz, senior director of product management for Embarcadero. “Multi-platform database management is becoming more commonplace, but that doesn’t mean it’s getting less complicated.”
DBA Challenge No. 1
Although the vast majority of DBAs said they are proficient with more than one database platform, they believe the variables of multi-platform environments will put their skills to the test. When asked to name the single biggest database-related challenge facing them in the next year, the greatest number of respondents said cross-platform database management. Multi-instance databases and tuning tied for second place, followed by database management in third.
The M&A Effect
Mergers and acquisitions may be partly to blame for the increase of heterogeneous database environments and the new batch of problems they bring for DBAs. When asked if their company has gone through a merger or acquisition in the past five years, 43% responded yes. Of those, 18% reported that they had to begin working with new or additional database platforms as a result.
Whether it is through a company acquisition or a newly introduced application, nearly one-third of respondents expect more database platforms to be introduced into their organizations in the next year.
The study, conducted in summer 2010 by Embarcadero Technologies, was designed to uncover the challenges faced by database professionals and trends influencing the industry. The more than 1,200 survey respondents were a mixture of DBAs, developers, architects and analysts. The survey results and additional information are available online at http://www.embarcadero.com/reports/database-trends-survey
About Embarcadero Technologies
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance and accelerate innovation. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world. Embarcadero is online at http://www.embarcadero.com.
Embarcadero, the Embarcadero Technologies logos and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.
# # #