Plan du site  
pixel
pixel

Articles - Étudiants SUPINFO

Database Management Systems

Par Anis BENZIANE Publié le 06/10/2019 à 18:53:20 Noter cet article:
(0 votes)
Avis favorable du comité de lecture

Introduction

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 sales site.

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 world.

Free DBMS

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 Python accessible.

Coupled with PhpMyAdmin, we then have an easy-to-use administration interface, either with the mouse or with SQL queries within this interface.

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.

Proprietary DBMSs

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.

A propos de SUPINFO | Contacts & adresses | Enseigner à SUPINFO | Presse | Conditions d'utilisation & Copyright | Respect de la vie privée | Investir
Logo de la société Cisco, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société IBM, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Sun-Oracle, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Apple, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Sybase, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Novell, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Intel, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Accenture, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société SAP, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Prometric, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Toeic, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo du IT Academy Program par Microsoft, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management

SUPINFO International University
Ecole d'Informatique - IT School
École Supérieure d'Informatique de Paris, leader en France
La Grande Ecole de l'informatique, du numérique et du management
Fondée en 1965, reconnue par l'État. Titre Bac+5 certifié au niveau I.
SUPINFO International University is globally operated by EDUCINVEST Belgium - Avenue Louise, 534 - 1050 Brussels