Choosing the Right Database

Relational Databases

Photo provided by w3resource

Non-Relational

Photo provided by abcloudz

Structured Data vs Unstructured

Photo provided by ProWebScraper
  • 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

Say a business is building a database to keep track of customers and orders. One table would be composed of the customer’s information. Their name, address, and so forth. There would also be another table for the order. This table would hold attributes such as the product, data, and sales price. This would be a job for a Relational Database Structure.

--

--

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