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

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

Last updated

Was this helpful?