DBMS is a data management system

The data surrounds us everywhere. They come through the media, expect us in the workplace, in public transport, even in the kitchen. Since every modern person is constantly confronted with a huge amount of information, he has to perform various actions with it: accumulate and store, select the most necessary, sort and order in other ways, delete. To automate the whole process, and databases were developed. From the considered point of view DBMS is a system for data organization.

What is a database

A database is considered to be an ordered array of information. An example of such a sorted database can serve as a library. In it, books are usually arranged in a certain order: by name, by author or by subject. Traditionally, for the convenience of data representation, a table form is used. In the cells of it there are numbers, text, images and other elements. And the columns and rows contain some of the characteristics by which ordering takes place. A very important problem for the correct construction of a database is the identification of sets of features that are common to a particular subject area. It is depending on the meaning of these characteristics that the instances of each particular entity are separated.

What is DBMS

A DBMS is some kind of database management system. The fact is that the data is not easy to get, they need to constantly perform some operations. First of all, the existing orderly information should be kept. And in the future, it is necessary to receive as quickly as possible those data that are required by the user at a given moment in the situation that has arisen. To do this, the management system must have some sort of sorting algorithm, as well as the ability to apply a variety of filters. Then the data must be added, deleted, modified, and so on. For the convenience of operating different information, it is necessary that such a system also give users the opportunity to build a query to select a certain array, "know how" to fulfill these queries fairly quickly and stably. With the proper construction of the DBMS, this provides everything, as well as provides an opportunity to secure data from unauthorized access and implements other required functions.

Why Mysql

Mysql is a relational database management system. Relational is called such a database, in which the information is presented in the form of separate tables, which are interrelated and interdependent. From other DBMS this differs by some basic signs, namely:

- multithreading, that is, several queries can be executed simultaneously in this system;

- Simplicity of building a server;

- a reliable system of protection, including a flexible structure of passwords and rights;

- the ability to use data both fixed and variable length;

- a quality storage system based on flows;

- Possibility of placing up to 16 keys in the table.

There are also other important differences, for example the fact that the DBMS contains a utility for repairing tables.

Mysql, as a DBMS, is a convenient and logical system that allows you to perform all the necessary operations on data.