Tuesday, December 14, 2010

Comparison of Oracle, MySQL and Postgres DBMS


Comparison are given below with include all the basic concept :-
Category Problem Assessment
MySQL Oracle8 Postgres
Elementary features Basic data types B C A
SQL C B B
Declarative constraints C A A
Programming abstractions D A C
Generation of ids C A A
National chars B A B
Transactions Transactions D A A
Locks D A A
Multiuser access C A C
Programming in DB