Popular Database Review

Popular Database
Review

Timothy Licata

Database Concepts

CSE 346

Comparisons


SQL Server 2000, Oracle 9i, IBM DB2


Market Share


Product Features


Operating Systems & Hardware


Related Software, Tools, or Applications

Oracle 9i


Largest Market Share
–

39.4% (2003)


Supports: Windows, Linux, UNIX


Hardware : 166MHz, 128 MB RAM, 270 MB


Features:




-

PL / SQL dialect is Powerful



-

Fine Tuning



-

Expensive

IBM DB2 v8.1


2
nd

Highest Market Share
–

33.6%


Supports: Windows, Linux, UNIX


Hardware:166MHz, 256 MB RAM, 350 Mb


Features:



-

DB2 SQL dialect



-

Slightly Cheaper than Oracle



-

Fine Tuning



Windows SQL Server 2000


3
rd

Highest Market Share
–

11.1%


Supports: Windows


Hardware: 166MHz, 128 MB RAM, 270 MB


Features:



-

User Friendly



-

Inexpensive



-

Includes OLAP and Data Mining



-

T SQL dialect

Conclusions


Open Source options
-

MySQL


Final remarks