Edgar F Codd had invented it. Later it became exceptionally popular. The relational database management system (RDBMS) is a database management system based on the relational model. Today most databases use it.
MySQL is one of them. Along with PHP, we need to know about MySQL for one reason. MySQL is a central component of the LAMP open-source web application software stack. The LAMP is an acronym for “Linux, Apache, MySQL and Perl/PHP/Python”.
How important MySQL is? Well, it really needs no introduction. Many popular applications, such as WordPress, Drupal or Joomla use it. Many high scale websites including Google, Facebook, Twitter, Flickr and YouTube draw on it.
Since the 1980s it has been a common practice for storage of information in databases used for different types of applications. From financial records to personal data – it’s much easier to implement and administer. RDBMS like MySQL maintain a clearer division between the database model and the application. RDBMS as MySQL received challenges, mainly, from two sectors – one is Object Database Management Systems ODBMS or OODBMS and the second one is XML database management system. However, they were unsuccessful.
As time passes by and the horizontal scaling of the computer clusters become popular, NoSQL is one of the most serious challenges RDBMS faces now.
Relational databases use tabular relations. The NoSQL databases use a data structure that consists of key-value, wide column graph or document. It is not only different from RDMS, but sometimes it is also faster. Sometimes people view it as more flexible.