News
 Where
Does Your Database Rank?
What database is the most widely used? A recent
study by the Independent Oracle Users Group (IOUG)
revealed that the most popular database around is –
wait for it – Oracle 9i. Here’s how other databases
ranked.
According to the study, Oracle 9i remains the most
dominant database, with 84 percent of the survey’s
respondents using Oracle 9i. Also hot on the trail
is Oracle 10g, with 49 percent of respondents using
the database. Respondents plan on moving to 10g
within the next year. Meanwhile, Oracle 8i, which
dominated the IOUG survey conducted in 2001 with 93
percent of respondents – is still run at half of the
sites surveyed. Back in 2001, only 14 percent had
adopted Oracle 9i, which was considered the new kid
on the block at that time.
The closest contender to the Oracle lineup is the
Microsoft product set. Seven out of 10 respondents
support SQL Server. Microsoft’s RDBMS product
appears to be gaining ground at Oracle sites as
well. Seventy percent of respondents use SQL Server,
while 50 percent use Microsoft Access.
IBM also caught some attention at Oracle sites, the
survey reveals. More than a quarter of respondents
run DB2, IBM’s relational database management
system, up from 18 percent in the 2001 survey.
MySQL, the open-source database offered under both
under the GNU General Public License (GPL) and
commercial licenses, is in use at about one out of
four Oracle locations. The study notes that
companies will often employ MySQL as a front-end
caching database to support external queries, while
Oracle provides back-end functionality.
Here’s a breakdown on current databases running,
Oracle and non-Oracle:
Oracle 9i 84%
Microsoft SQL Server 70%
Microsoft Access 50%
Oracle 8i 50%
Oracle 10g 49%
IBM DB2 27%
MySQL 25%
Sybase 18%
Oracle 8 10%
IBM Informix 7%
Other 5%
* Source: IOUG Survey
|
|
|
Facebook
Twitter
