At first glance, at the subject of my research, I was a bit confused. On the paper was written one word, at least I presumed it was a word. It said “MySQL.” I looked at it a second and third time to make sure that is what it said and sure enough that is exactly how it read. MySQL. I took in a deep slow breath and said quietly, “oh help.” What in the world is MySQL? I have never heard of it, and I’m not sure I want to. I figured that I could simply “google” it and everything would be clear.
Typing MySQL into the google.com search engine I came up with a list of possible hits. Feeling relief, I opened the familiar wikipedia.org to find some interesting information. The developer is Oracle Corporation, the initial release date is May 23, 1995, and it has a cross-platform operating system. The definition reads:
“MySQL is a relational database management system (RDBMS)[1] that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ (My S-Q-L), but often pronounced /maɪˌsiː‘kwɛl/ (My SeQueL).[2] It is named for original developer Michael Widenius‘s daughter My.[3] …”
Okay! No, wait. What is this? “Relational database management system?” I do get nervous when I read the definition and don’t know some of the words. No problem, I’ll just Ctrl+Click the term(s) I don’t know and see what comes up. I do love the fact that the developer, Michael Widenius, named the program after his daughter (My SeQueL), but I also read that SQL also means Structured Query Language.
“A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the relational model. …”
This second definition has two terms that I have not heard of. I am beginning to wonder if this “wiki” thing is made for the average person. I’m not giving up. Ctrl+Click, Ctrl+Click, I will get to the bottom of this.
“A Database Management System (DBMS) is a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists. …”
“The relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969 by E.F. Codd.”
This relational model has a picture… Now we’re talking.
I might be tired or I just might be dense, but this is not sinking in. … sigh … Back to GOOGLE!
Hum… this is interesting. ~click~ Hscripts.com AWAY!
“Database:
A database is a collection of data that is organized so that its contents can be easily accessed, managed and updated. The software used to manage and query a database is known as a Database Management System (DBMS). Then came the concept of Relational Database Management System (RDBMS). Relational database is a database where data are stored in more than one table, each one containing different types of data. The different tables can be linked so that information from the separate files can be used together. This is explained below using an example. …”
Now this is starting to make since. As databases started to grow, the need to extract specific information also grows. The answer was to develop some way of streamlining the process of extracting specific information from these databases. What a great idea!
There are other companies that offer this DBMS service. Some of them are: crunchbase.com, linkedin.com, and allbusiness.com.
There are four certifications available:
- Certified MySQL Associate (CMA)
- Certified MySQL DBA (CMDBA)
- Certified MySQL Developer (CMDEV)
- Certified MySQL Cluster DBA
Since its release in 1995 and about every year after, MySQL has put out a newer better version. MySQL is and has been touted as the best relational database management system. The company was eventually sold in 2008 to Sun Microsystems at a cost of one billion dollars.
MySQL is alive and doing well. I predict that MySQL is here to stay.
Resources:
http://en.wikipedia.org/wiki/MySQL
http://hscripts.com/tutorials/mysql/overview.php
http://www.bestmysqlwebhosting.com/articles2.html
http://certification.about.com/od/certifications/a/mysql_cert.htm