Saturday, January 7, 2017

Understanding MySQL


Understanding MySQL - MySQL is a software or a software SQL database management system or DBMS multithreaded and multi-user. MySQL is actually a derivative of one of the main concepts in the database for the election or selection and data entry that allows the operation of data is done easily and automatically. MySQL was created by Michael "Monty" Widenius in 1979, a Swedish computer programmer who developed a simple database system called UNIREG that uses low-level connection ISAM database engine with indexing.

MySQL is a Relational Database Management System (RDBMS) that is distributed for free under the GPL (General Public License). Where everyone is free to use MySQL, but should not be used as a derivative of a commercial nature. MySQL is actually a derivative of one of the main concepts in the database for a long time, namely SQL (Structured Query Language). SQL is a database operation concept, especially for the election or selection and data entry, which allows the operation of the data is automatically done easily. The reliability of a database system (DBMS) can be known of how the optimizer her in the process of SQL commands, created by the user or application programs. As a database server, MySQL can be said to be superior to the other servers in the database query the data. This proved to the query made by a single user, the speed of MySQL query can be ten times faster than PostgreSQL and five times faster than Interbase.

MySQL has several features, among others:

1. Portability. MySQL can run stable on a variety of operating systems such as Windows, Linux, FreeBSD, Mac OS X Server, Solaris, Amiga, and many more.
2. Open Source.MySQL distributed as open source, licensed under the GPL so it can be used free of charge.
3. 'multiuser'. MySQL can be used by several users at the same time without experiencing any problems or conflicts.
4. 'Performance tuning'. MySQL has an amazing speed in dealing with simple queries, in other words, can process more SQL per unit time.
5. Type column. MySQL has data types is very complex, such as signed / unsigned integer, float, double, char, text, date, timestamp, and others.
6. Command and Function. MySQL has a full service and functionality that support the command Select and Where in the command (query).
7. Security. MySQL has several layers of security such as the level Subnetmask, host name, and user access permissions with a detailed licensing system and encrypted passwords.
8. Scalability and Restrictions. MySQL database capable of handling large scale, with the number of recordings (records) more than 50 million and 60 thousand tables and rows 5 billion. Also limit the index that can fit up to 32 indexes on each table.
9. Connectivity. MySQL can connect with the client using TCP / IP, Unix sockets (UNIX), or Named Pipes (NT).
10. Localization. MySQL can detect the error message on the client by using more than twenty languages. Notwithstanding that, the Indonesian language has not been included in it.
11. Interface. MySQL has an interface (interface) to a variety of applications and programming languages ​​by using the function API (Application Programming Interface).
12. Clients and Equipment. MySQL is equipped with various tools (tools) that can be used for database administration, and on any equipment that is included instructions online.
13. The structure of the table. MySQL has a table structure that is more flexible in dealing with ALTER TABLE, compared to other databases like PostgreSQL or Oracle.

In addition to those listed above privileges, there are also some drawbacks that are owned by MySQL, including:
1. Lack of support connections programming languages ​​such as Visual Basic or we used to know as VB, FoxPro, Delphi and others because of this connection causes the field which should be read in accordance with the connection of the visual programming language.
2. Data that can be handled has not been great and does not support widowing function.