More

    Coping with Database Diversity

    he fact of life for most database administrators is that they are usually managing not only multiple types of databases, but multiple versions of those databases.

    A new study of 1,200 IT managers conducted by Embarcadero Technologies finds that while more of them are running Microsoft SQL Server than Oracle databases, the majority spend a lot more of their time working on Oracle databases. That would suggest that while Microsoft SQL Server has successfully proliferated across the enterprise on the back of Windows Server applications, Oracle databases are still the primary production database environment.

    As the numbers and types of databases have proliferated, the number of database administrators has held relatively steady. Scott Walz, senior director of product management for database products at Embarcadero, says the survey shows that this changing dynamic is driving increased interest in automation among the ranks of harried database administrators.

    Despite all the hype surrounding open source databases, one of the more surprising revelations of the survey is the relatively minor presence of MySQL in enterprise environments.

    But as cost pressures continue to mount alongside the volume of data to be managed, Walz said we’re likely to see more diversity in database formats in the enterprise.

    Coping with Database Diversity - slide 1

    Click through for results from a database survey by Embarcadero.

    Coping with Database Diversity - slide 2

    Tough to keep up with the database housekeeping.

    Coping with Database Diversity - slide 3

    Production issues and poor code top the list.

    Coping with Database Diversity - slide 4

    A fair number are.

    Coping with Database Diversity - slide 5

    Microsoft edges out Oracle.

    Coping with Database Diversity - slide 6

    Microsoft continues to hold a slight edge.

    Coping with Database Diversity - slide 7

    Oracle still holds a commanding lead here.

    Coping with Database Diversity - slide 8

    Most work with two or more.

    Coping with Database Diversity - slide 9

    The vast majority are.

    Coping with Database Diversity - slide 10

    Half are running three or more versions.

    Coping with Database Diversity - slide 11

    This is a common challenge.

    Coping with Database Diversity - slide 12

    A little more than half have over three.

    Coping with Database Diversity - slide 13

    Most clearly do not.

    Coping with Database Diversity - slide 14

    Cross-platform leads the pack.

    Latest Articles