Choosing the Right Database

Relational Databases

Photo provided by w3resource

Non-Relational

Photo provided by abcloudz

Structured Data vs Unstructured

Photo provided by ProWebScraper
  • Relational databases are normalized. The data is stored in a tabular form, arranged in a table with rows and columns. Whereas, non-relational stores data as files.
  • Primary Keys: The tables of relational databases use primary key identifies. In non-relational, the data is sorted in a hierarchical or navigational form without the use of primary keys.
  • Data Values Relationships: The relationship between data values is stored in the tables in relational databases. Since a non-relational database stores data as files, there is no relationship between the data values.
  • Relational databases use integrity constraints. These ensure integrity and they are defined for atomicity, consistency, isolation, and durability. (ACID)
  • Structured vs. unstructured: Relational databases work great for structured data and the predefined data model doesn’t change much. Non-relational databases are better for unstructured data. These include text, email, photos, videos, and web pages.

Examples

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Extended battles and Recursion

Getting Started with Terrain Tools in Unity Part 3: Details, Wind and Water

Null, Validations and Exceptions

Why Product Owners should challenge technical solutions

TO DO LIST API WITH DJANGO REST FRAMEWORK

26. Juni — 2. Juli 2017

HackTheBox Writeup — Hawk

Unfolding the Art of Code with Origami Studio

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Allison Anzalone

Allison Anzalone

More from Medium

How to Hire an Assistant for the First Time

Zxing-Scanner Zoom In function in video stream

For what reason is BEP20 Trending?

The Texture of Loss in Nier: Replicant ver.1.22474487139…