(+91) 7 999 01 02 03

About Databases

Sushmita Mandal
281 Posts

Database: Collection of related information. Databases can be stored in different ways

Eg.:, computer, phone, paper, comment section


Database Management System (DBMS)

A special software program that helps users create and maintain a database.


Two types of databases:

Relational databases (SQL) à Organises data in one or more tables

  • Each table has columns and rows
  • A unique key identifies each row

Non-Relational databases (noSQL/ not just SQL) à Organises data is any format

  • Key-Value stores
  • Documents (JSON, XML, etc.)
  • Graphs


Relational Databases (SQL)

  • Relational Database Management System (RDBMS)
  • Help users create and maintain a relational database

Eg.: mySQL, Oracle, prostgreSQL, MariaDB, etc

  • Structured Query Language (SQL)
  • Standardized language for interacting with RDBMS
  • Used to define tables and structures
  • SQL code used on one RDBMS is not always portable to another without modification

Non-Relational Databases (noSQL/ not just SQL)

  • Non-Relational Database Management Systems (NRDBMS)
  • Help users create and maintain a non-relational database

Eg.: mongoBD, DynamoDB, apache Cassandra, firebase, etc

  • Implementation Specific
  • Any non-relational database falls under this category, so there’s no set language standard
Published By : Sushmita Mandal
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.


Jquery Comments Plugin