Non-Relational Databases


Non-relational database is a database system that stores data without the use of relational database models.

  • aka NoSQL
  • addresses the need for web-based databases to handle large amounts of traffic and data
    • easier to scale
  • data is typically large and unstructured, and likely changes often
  • often use different programming languages to retrieve data from a non-relational database

4 Categories of NoSQL Databases

  • Document-oriented databases
    • store data in XML documents or JSON
    • flexible
      • allow developers to reshape the data to meet the format needed for the application
  • Key-value stores
    • store each value with a key value
    • similar to a table with just two columns: a field (key) and value
  • Column-oriented database
    • store data in columns rather than rows
    • can make for easier analysis in some cases
      • e.g., when counting the total number of orders
  • Graph stores
    • store individual elements as nodes
    • more complex and focuses on the relationships between data elements
    • connections are first-class elements of the database and stored directly
    • often run side by side with a relational database