Key Differences between Relational and Non-Relational Databases


  • Relational databases
    • Have tables that store fields in columns, and rows of records that hold data in relational database management systems (RDBMS)
    • Use primary and foreign keys to establish relationships that control how certain data relates to data in other tables
    • Leverage normalization techniques for optimal design
    • Use traditional SQL language to query and handle transactions within the database
    • Expect data to fit within the tables that are designed for the database
    • Are designed around the ACID Principles
  • Non-relational databases
    • do not follow the same structural requirements of a SQL-based database
    • Are much easier to scale and build for web-based applications and do not require the same level of detailed planning and structure that relational databases require
    • Use various programming languages to retrieve and handle transactions within the stored data
    • categorized into four sub-types:
      • document-oriented
        • most prominent
      • key-value stores
      • column-oriented
      • graph stores
    • Can store structured and non-structured data with more flexibility