A database is a bit like a catalogue containing hundreds of thousands of items on various subjects.
A database is a collection of connected data (interrelated data) are stored together in a medium, without mengatap each other do not need a data kerangkapan (controlled redundancy) in a way that is easy to use or display back, it can be used by one or more optimal application program, the data is stored without any reliance on the program will menggunkannya, data is stored in such a way that the addition, retrieval, and modification can be done easily and controlled
MySQL is a relationship database software (Relational Database Management System or RDBMS). MySQL AB refer to the product as popular open source database in the world. Based on the research stated that in the web platform, both for the general category and the open source, MySQL is the most widely used database. MySQL is one of the many database systems, the proper solution is a breakthrough in the application database. Powered by a community of thousands or even millions of internet users who are ready to help.
MySQL is a RDBMS (Relational Database Management System) which is distributed for free under the GPL (General Publish License) where everyone is free to use MySQL. MySQL is actually a derivative of one of the main concepts in the database for a long time, namely SQL (Structure Query Langguage), which is a concept of operation of the database, especially for the selection and the selection of data entry that allows the operation of the data is easily done automatically.
The advantage of using the MySQL database is as follows:
1. Portability
MySQL can run stable on a variety of operating systems including Windows, Linux, Mac OS X Server, HP-UX and many more.
2. Open Source
MySQL is distributed for free (Open Source) under the GPL license.
3. Multi User
MySQL can be used by multiple users at the same time without any problems or conflicts undergo. This allows the MySQL database server.
4. Coloum Types
5. MySQL has a very complex column types such as signed / unsigned, integer, float, double, char, varchar, text, date, BLOB, time, datetime, year, set and enum.
6. Command and fungtions
MySQL has a full service and functionality that support the command and select where in the Query.
7. Security
MySQL has several layers of sub netmask sekuritis as level names, and permits the user access to the detailed licensing system and password.
8. Scalibility and Limits
MySQL database to handle a large scale, with a record number of more than 50 million and 60 thousand billion row table as well.
9. Table Structure
Represents the MySQL table structure that is more flexible in dealing with alter table, as compared to other databases. (Abdul Kadir, 2002, p: 3)