A database management system or DBMS is a software that will allow
us to store information in a database. This information can range from a
company's customer database to a list of people registered on an online
We can mention the following as DBMS: MySQL, PostgreSQL, SQLite,
Oracle Database, Microsoft SQL Server... which are among the best known.
But there is also Firebird or Ingres.
In this article we will make a presentation of these DBMS and also
discuss the NoSQL, a concept that is increasingly present in the data
MySQL, probably one of the best known to date, especially for its
use with PhpMyAdmin. It can be distributed with a free license, which
means that its use can be free. MySQL is very easily used with
WAMP/LAMP/MAMP, which means that many developers use it when it comes to
making applications with PHP. It is good to know that hosts generally
provide PHP and MySQL. A lot of language have made MySQL ,like.NET or
Coupled with PhpMyAdmin, we then have an easy-to-use administration
interface, either with the mouse or with SQL queries within this
PostgreSQL is under a BSD license, which means that it is free to
use. PostgreSQL is a free project that is managed by a community of
developers. Its user interface is PhpPgAdmin. It can be used on Windows,
MacOS and Linux
SQLite has an interesting feature, this DBMS is directly integrated
into the program to which the database is linked. There is no license for
SQLite, anyone can use it without constraints. It is used in Skype, that's
why you can't retrieve messages from one computer to another.
Of course Microsoft has its DBMS, simply called SQL server. It can
only be used on Windows. It is a paid DBMS, the move may dissuade some,
but it offers a plethora of features that may appeal to individual
companies. It has its own procedural language, T-SQL.
Be careful the SQL syntax of SQL server may be different from that
of MySQL. Unlike MySQL, SQL server supports CTE, which are recursive
queries. Without going into details, SQL server is a very powerful tool
but it has a price.
Oracle Database, the DBMS provided by Oracle Corporation. Probably
one of the most popular SBGDs. It works like any other on a key-value
relational model. It is a proprietary system, which like SQL server will
be paid for.
Oracle uses PL SQL as a procedural language unlike T-SQL, it is
probably the biggest difference between the two DBMS, even if they will be
different on other points, this is not the issue of the current article.
Oracle Database just like SQL server offers a lot of tools, an
administration interface, data confidentiality, backup and recovery with
data integrity. Administration tools, Oracle development tools, and
programming tools are thus made available.
Following this presentation of the DBMS, it should be pointed out
that they are so-called relational databases based on a key - > value
model. The concept of NoSQL often comes on the DBMS market in correlation
with Big Data.