Introduction

• Data is a collection of facts such as numbers, descriptions, and observations used to record information.

  • Structured data - tabular schema

  • Semi-structured data - JSON

  • Unstructured data - documents, images, audio and video, and binary files.

Relational Databases a.k.a. SQL Databases

• designed in the 1970s

• a table-based relation data structure that defines and manipulated data using pre-defined schemas to determine its structure.

• used to store and query structured data.

• follows ACID property which makes it capable of performing different tasks as a single logical operation.

• Examples - MySQL, Microsoft SQL Server, MariaDB, Oracle

• not suitable for frequently changing data

• not flexible due to its rigid pre-determined structure

• difficult to scale as the data increases so the app size increases as well

• are horizontally scalable making them more expensive than non-relational databases

Non-Relational Databases a.k.a. NoSQL Databases

Key-Value databases

• Example - Redis

Document databases

• Examples - MongoDB, Couchbase

Column Family databases

Graph databases

• Example - Neo4j

• can handle the storage of structured and semi-structured data due to its non-tabular form.

• are horizontally scalable making them cheaper than relational databases.

• can make multiple databases with different structures and syntax.

Database.Guide

DB-Engines RankingDB-Engines

Top DBMS Interview Questions and Answers(2023 Updated) - InterviewBitInterviewBit