Things to know About MySQL-ISM UNIV

MYSQL is a popular and widely used DBMS system. The name is taken from the girl name My, who is the daughter of the co-founder Michael Wideniusà. SQL stands for “structured query language.” Developed in 1995

MySQL is the most popular open-source database; chances are that you have run across it a time or two in your programmer internet travels. As the battle between open source and propriety software rages on,

it does make you wonder, is it time to ditch MySQL?

Here are some pros and cons of MySQL to consider.

Pros

• MySQL is a Relational Database Management System or RDBMS which means that it stores and presents data in tabular form, organized in rows and columns.
• MySQL is more secure as it consists of a solid data security layer to protect sensitive data from intruders and passwords in MySQL are encrypted.
• MySQL is available for free to download and use from the official site of MySQL.
• MySQL is compatible with most of the operating systems, including Windows, Linux, NetWare, Novell, Solaris and other variations of UNIX.
• MySQL provides the facility to run the clients and the server on the same computer or on different computers, via internet or local network.
• MySQL has a unique storage engine architecture which makes it faster, cheaper and more reliable.
• MySQL gives developers higher productivity by using views, Triggers and Stored procedures
• MySQL is simple and easy to use. You can build and interact with MySQL with only the basic knowledge of MySQL and a few simple SQL statements.

Cons

• MySQL is not very efficient in handling very large databases.
• MySQL doesn’t have as good a developing and debugging tool as compared to paid databases.
• MySQL versions less than 5.0 do not support COMMIT, stored procedure and ROLE.
• MySQL is prone to data corruption as it inefficient in handling transactions.
• MySQL does not support SQL check constraints.

Interesting Facts About MySQL

1. It is a relational database management system (RDBMS).
2. The development of MySQL began in 1994. It was initially released on 23 May 1995; 26 years ago at the time of writing this post.
3. MySQL was initially, created for personal usage from mSQL based on the low-level language ISAM. mSQL or Mini SQL is a lightweight database management system from Hughes Technologies.
4. The name MySQL is derived from “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”.
5. The relational database management system organization’s data in the form of one or more data tables interlinked with some relationship.
6. SQL language is used to create, modify and extract data from the relational database. SQL also controls the users’ access to the database.
7. MySQL is free and open-source software under the terms of the GNU General Public License.
8. Though MySQL is free and open-source, it is also available under a variety of proprietary licenses.
9. Initially, MySQL was owned and sponsored by the Swedish company MySQL AB. In January 2008, Sun Microsystems bought MySQL AB for $1 billion.
10. In 2010, Sun Microsystems was acquired by Oracle Corporation.
11. In 2010, after the Sun acquisition by Oracle, Michael Widenius forked the open-source MySQL project to create MariaDB.