Channels ▼
RSS

Design

Nearly Two-Thirds of Database Administrators Manage at Least Two Types of Database


Managing multiple database platforms has become the norm rather than an exception for database administrators (DBAs) according to database tools vendor Embarcadero. The company's latest 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.

Exacerbating the multi-platform database situation is the fact 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.”

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 more than 1,200 survey respondents were a mixture of DBAs, developers, architects, and analysts. The survey results and additional information are available online here.


Related Reading


More Insights






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Video