Database Management System Decision Matrix

perchmysteriousData Management

Dec 1, 2012 (4 years and 8 months ago)

366 views


DataCola


pg.
1

Potential DBMS (Database Management System) Selection Matrix




Oracle

MySQL

PostgreSQL

Criteria

Weight

Rating

Weighted
Score

Rating

Weighted
Score

Rating

Weighted
Score

Operating

System

Compatibilities
1

10%

85%

8.5

95%

9.5

90%

9

Fundamental

Features
2

2
5%

100%

25

95%

23
.
7
5

100%

25

Tables and Views
3

5
%

100%

5

90%

4.5

90%

4.5

Indexes
4

5
%

80%

4

60%

3

100%

5

Database
Capabilities
5

10%

90%

9

80%

8

100%

10

Previous
Experience
6

25%

100%

25

80%

20

30%

7.5

Cost
7

20%

20%

4

80%

16

100%

20

Total Score

100%

80.5

84.75

81



1
Refers to compatibilities with the following Operating Systems:

Windows, Mac OS X, Linux, BSD, UNIX, AmigaOS, Symbian, and z/OS.


2
Refers to the following
fundamental RDBMS features:


ACID, Referential Integrity, Transactions, and Unicode.


3
Refers to the
following
tables and views supported by the DBMS
(
besides basic ones
)
:


Temporary Table and Materialized View.


4
Refers to the
following
indexes that are s
upported natively:


R
-
/R+ Tree, Hash, Expression, Partial, Reverse, Bitmap, GiST, and GIN.


5
Refers to the following additional database features:


Union, Intersect, Except, Inner Joins, Outer Joins, Inner Selects, Merge, and Blobs/Clobs.


6
Refers to the P
roject Team’s previous experience in using the DBMS.


7
Refers to the costs associated with the DBMS, including:


Licensing Fees, Software Costs, Support and Maintenance Costs.