What is Data?
In order to understand SQL database, you need to first understand what is data?
In simple words data can be anything, for example, your name, age, height, weight, etc are data related to you.
An image, file, pdf, etc can also fall under data category.
What is Database?
The database is nothing but a collection of data. The database also supports storage and manipulation of data. Database make your data management easy.
Let’s understand with some example:
An online telephone directory would definitely use a database to store data pertaining to people, phone numbers, other contact details, etc.
Your electricity service provider is obviously using a database to manage billing, client related issues, to handle fault data, etc.
Let’s dive deeper:
What is Database Management System (DBMS)?
DBMS is a collection of applications which enables its users to access the database, create database, update, reporting, and representation of data. It also controls the access to the database. Database Management Systems are not a new concept and as such had been first implemented in the 1960s.
What is SQL?
SQL stands for Structured Query Language. It is a standard language for dealing with Relational database.SQL programming can be effectively used to insert, search, update, delete database records. That doesn’t mean SQL cannot do things beyond that.
In fact, it can do a lot of things including, but not limited to, be optimizing and maintenance of databases.
What is NoSQL?
NoSQL is an upcoming category of Database Management Systems. Its main characteristic is its non-adherence to Relational Database Concepts. NoSQL means “Not only SQL”. The concept of NoSQL databases grew with internet giants such as Google, Facebook, Amazon etc who deal with gigantic volumes of data.
When you use the relational database for massive volumes of data, the system starts getting slow in terms of response time.
To overcome this, we could of course “scale up” our systems by upgrading our existing hardware.
The alternative to the above problem would be to distribute our database load on multiple hosts as the load increases.
This is known as “scaling out”.
Did you find the article useful? Do let us know your thoughts on this article in the comment box below.