MYSQL

by Ymku
Introduction

What is database? A database is organized lists of information. Improving computer industry can transform our life in many different ways. We do not have to go outside to go shopping, watch a movie, or even bank work. We can do this entire job at home with computer. All of these works are related to database. The companies have a lot of data for their business. Companies need to organize their data because unorganized data is just useless when data is hard to utilize. Organizing data is a key of the success their business. SQL (Structured Query Language) is a program language for managing RDBMS (relational database management system). The SQL is a way of managing database and I would like to introduce one of widely used SQL which is MYSQL.

What is MySQL

Many of the world’s largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software. MySQL is the world’s most popular open source database software, also ranked as second place in DB engines rank with 214 systems in Feb 2014. MySQL has become the most preferred choice for Web, Web 2.0, SaaS(software as a Service), ISV(independent Software Vendor), Telecom companies and forward-thinking corporate IT Managers because MySQL eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.

History

MySQL comes from Hughes Technologies m-sql. M-SQL was the first low-cost SQL-based database management system Combined with the free Linux operating system. However, m-sql did not provide satisfying speed and flexibility for it to be used widely. In 1995 MySQL version 3.23 was released by TCX Datakonsult (Allan), Monty Program Kb (Monty) and Detron HB (David). Why is the name of SQL a MySQL? MySQL was named after co-founder Monty Widenius’s daughter. In 2008, MySQL AB announced that they had agreed to be merged by Sun Microsystems for approximately $1 billion. In 2009, Sun Microsystems and Oracle announced entered into a definitive agreement under to merge under Oracle. According to DB-Engines Raking Oracle is first ranked for DB-Engines Ranking and MySQL is next to oracle. In 2014 Jan 31 MySQL-5.6.16 released which is new version of the MySQL.

Feature of MySQL

The MySQL is written in C and C++. As a result, MySQL client programs can be written in many languages. A client library written in C is available for clients written in C or C++, or for any language that provides C bindings. In addition, MySQL use privilege and password system. Security of database is very important for the company. The database can lead to the business secret. If competitor companies steal their database, it creates big problem for the company. MySQL includes several client and utility programs. These include both command-line programs such as MySQL dump and MySQL admin, and graphical programs such as MySQL Workbench. MySQL includes several client and utility programs. These include both command-line programs such as MySQL dump and MySQL admin, and graphical programs such as MySQL Workbench. The MySQL can support for large databases. MySQL Server with databases can contain 50milliond records which is more than California population. MySQL is considered a very fast database program. This speed has been backed up by a large number of benchmark tests

Advantage of MySQL

MySQL’s cost is very low because MySQL is an open source system. Anyone can use MySQL for free. That makes a lot of developers use to MySQL to use make database. In addition, one of the biggest factors which make MySQL the most opted form of database is Cross Platform Operability. It has proved itself in getting installed in all the major platforms such as Linux, Windows, Solaris and so on and at the same time performance has not been affected.  Apart from that, the presence of APIs makes its integration with C, C++, Perl, Java and Python etc pretty easy.

In Conclusion

Managing Database cannot guarantee success. However, managing Database is very important for any business. Creating successful company without database it is very hard. There are a lot of databases in Cis field like MS-SQL. However, MySQL is an easy and fast way to control data base.

 

 

Work Cited

(n.d.). Retrieved 2 5, 2014, from MySQL.com: http://www.MySQL.com/

The history of MySQL AB. (2010, 3 8). Retrieved 2 4, 2014, from Dries buytaert: http://buytaert.net/the-history-of-MySQL-ab

DB-Engines Ranking. (2014, 2). Retrieved 2 4, 2014, from DB-Engines: http://db-engines.com/en/ranking

Wilkins, R. (n.d.). MySQL ADVANTAGES. Retrieved 2 5, 2014, from How to MySQL: http://www.howtoMySQL.net/MySQL-advantages.html

6 thoughts on “MYSQL

  • February 21, 2014 at 12:50 pm
    Permalink

    This blog is very clear and can answer many different questions of what MySQL is. It is also related to the lecture and textbook that provide in class. I feel like it covers a chapter in our book. I have a much better understanding the role and usage of MySQL. Good job.

  • February 22, 2014 at 11:15 pm
    Permalink

    Now that we are using mysql i feel that this is helping me understand more fully how to use the database. ALso learning java and C++ is helpful and i can see why they are prerequisites because the code in sql are somewhat similar to java in the sense that both is not sentences like we are used to typing but rather statements

  • March 18, 2014 at 12:39 pm
    Permalink

    Thanks for explaining some of what MySql is and how it works. Its pretty interesting to see how these kinds of technologies has changed the way database management is done. Even though the software is free, companies only need to find skilled, competent SQL managers to effectively use MySQL.

  • March 20, 2014 at 1:39 pm
    Permalink

    I think that MYSQL is great for small businesses that want to have a database to store information but do not want to spend money on too much equipment. I can see why this is the second most popular database in the market since it is open source and the community seems supportive of it.

  • March 20, 2014 at 9:05 pm
    Permalink

    now i got a better idea for how MySql work and what kind of programing language skills is need to become MySql programmer. and Java code is very similar to MySql code. great presentation and blog.

  • March 20, 2014 at 9:30 pm
    Permalink

    MySql is wonderful for a variety of reasons described here. Personally, I enjoy that it is an open platform. If something is missing, or you wish to improve MySql, you are free to do so. This allows any company to tailor their database to fit their needs and ignore any unwanted features. Thanks for the informative blog it helped clear somethings up for me.

Comments are closed.