What is MySQL and NoSQL

MySQL – A relational database

MySQL is relational database written in C and C++. It is easy to use and open source.Along with PHP, it can be used to create dynamic server-side applications. It supports many operating systems and many programming languages like C, C++, Java, PHP etc.

Features of MySQL
  • Easy to use with basic idea of SQL
  • Secure by encrypting passwords
  • Follows Client-Server architecture
  • Free to use and download
  • Scalable based on hard disk size
  • Supports many Operating systems
  • Supports rollback and crash recovery features
  • Faster, reliable and cheaper
  • Flexible to use
  • Supports triggers and stored procedures
Applications and Organizations using MySQL
  • Joomla
  • WordPress
  • Drupal
  • MODx
  • Google
  • Facebook
  • Youtube
  • Twitter

For complete tutorials on MySQL refer https://www.tutorialspoint.com/mysql/

NoSQL is a class of database management systems (DBMS) that do not follow all of the rules of a relational DBMS and cannot use traditional SQL to query data. One common misconception with NoSQL is that it generally understood as no SQL. But actually it stands for not only SQL and can be better described by non- relational database.

NoSQL databases don’t use tables or columns or the traditional aspects of a relational database and are known for working well with big data and is considered as a flexible database for big data and real-time web apps.

NoSQL based systems generally, are very helpful and are used for very large databases, which can be prone to performance problems due to the limitations of SQL and other relational model of databases.

And it can be taken as an alternative to traditional relational databases in which data is placed in tables and data schema is carefully designed before the database is built. To focus on narrow operational goals, large-scale web organizations such as Amazon, Facebook and Google use NoSQL databases.

Types of NoSQL Database
  • Document Databases[MongoDB,CouchDB]:-Common uses include content management and monitoring web andmobile applications
  • Column Databases[Apache Cassandra]:-Common uses include internet search and other large-scale web applications.
  • Key-Value Stores[Redis,Couchbase Server]:-Common uses include storing clickstream data and application logs.
  • Cache System[Redis,Memcache]
  • Graph Databases[Neo4J]:-Common uses include recommendation engines and geospatial applications.
Advantages of NoSQL over Relational Database:-
  • Handles Big Data
  • Data Models-No predefined schema
  • Data Structure-NoSQL handles unstructured data
  • Cheaper to manage
  • Scaling-Scale out/Horizontal scaling

Join our Forum to discuss more and subscribe our Youtube channel to get updates on webinars.