Popular Database Review

basesprocketData Management

Oct 31, 2013 (3 years and 10 months ago)

108 views

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