data all around us.They come through the media, we expect in the workplace, on public transport, even in the kitchen.As every modern man is constantly faced with an enormous amount of information, it has to do with her various actions: collect and store, to select the most necessary, sort, and organize in other ways, delete.To automate the entire process, and have developed databases.By considering the point of view of the database - a system for organizing data.
What is a database
Database is considered to be an ordered array of information.An example of such a sorted database can serve as a library.In her books are usually located in a certain order by title, by author, or depending on the subject.Traditionally, for the convenience of data using a form of the table.The cells are placed its numbers, text, images and other elements.A columns and rows contain some signs by which ordering occurs.It is an important issue for the proper construction of the database is to clarify a set of features that are common to a particular domain.That is, depending on the values of these attributes are separated by instances of each particular entity.
database - a certain database management system.The fact that the data is not enough to get over them must always produce some operations.First of all, the existing information needs to be streamlined to save.And in the future you need as quickly as possible to get exactly the data that the user needs at any given moment in this situation.To do this, the control system must have a certain set of sorting algorithms, as well as the ability to apply a variety of filters.The data is then necessary to add, delete, edit, and so on.For the convenience of operating a variety of information, it is necessary that such a system will also allow users to build a select query in an array, "knew how to" fulfill these requests fast enough and stable.With proper construction of the database is all provides and allows to protect data from unauthorized access and implementing other required functions.
Why RDBMS Mysql
Mysql - a system of relational database management.They call such a relational database in which the information is presented in separate tables that are interconnected and interdependent.On other databases, this has some basic features, namely:
- multithreading, that is at the same time the system can run multiple queries;
- Easily build server;
- reliable protection system consisting of a flexible structure of passwords and rights;
- the ability to use data both fixed and variable length;
- quality storage system based on the flow;
- the ability to accommodate up to 16 keys in the table.
There are also other important differences, such as the fact that in the database there is a utility to repair tables.
Mysql, as the database is easy and logical system that allows you to perform all necessary operations on the data.