Relational versus Non-Relational

Relational databases

• Called: RDMBS, SQL databases

• Characteristic

  • Every relational databases has been used to contorl OLTP.

Image result for oltp database meaning
OLTP (Online Transaction Processing) is a data processing category that deals with numerous transactions performed by many users. (feat phoenixNAP)

• support ACID transactions(Atomicity, Consistency, Isolation, and Durability.)

• Pros

  • Relational databases work with structured data.
  • support ACID transactional consistency and "joins"
  • built-in data integrity and a large eco-system
  • Relationships have constraints
  • Strong SQL

• Cons

  • do not scale out horizontally very well, only vertically
  • Data is normalized. meaning lots of joins, which effects speed.
  • problems(semi structured data)

Non-Relational databases

• Called: NoSQL databases , non-relational DBs

• Characteristic

  • All relational databases can be used for OLTP(added the confusion)

• Pros

  • scale out horizontally
  • work with unstructured and semi-structured data
  • support ACID transactional consistency
  • Schema-Free
  • High availability
  • Open source and so free

• Cons

  • Weaker or eventual consistency(BASE) instead of ACID.

  • Denormalized, mass updates

  • Limited support for joins.

  • Limited indexing

  • Not bulid data integrity