2.3 DBMS examples

Scene 1

There are various commercial DBMS platform some of which are outlined below:

MySQL
is widely used due to its ease of integration with the Apache/PHP and its good response tine. MySQL supports only part of the standard SQL-92. This DBMS does not support native transactions, sub queries, triggers and stored procedures. MySQL is a very good choice for usage in conjunction with PHP with simple queries, but it is lacks some features compared to other DBMSs.

Oracle
Oracle is a RDBMS which supports remote access to the database. It is one of the best performing DBMS with powerful tools. Oracle is a RDBMS-oriented environments with heavy constraints (availability, integrity, stability, large volumes of data and high number of users, etc..).

PostgreSQL
PostgreSQL is usable under Linux. PostgreSQL is an excellent choice to manage databases of medium size. Moreover, its free which is a good advantage.

2.3 DBMS examples

Borland Interbase
One of its main strengths is its availability in an open source version. InterBase is a good choice to manage databases for small and medium size.

Microsoft SQL Server
SQL Server is a good choice for databases of medium size.

Access
Developed by Microsoft, Access is suitable for supporting small databases (personal).