DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

Cover image for Azure DP-900 Short Notes: Explore concepts of non-relational data
Newanga  Wickramasinghe
Newanga Wickramasinghe

Posted on • Originally published at blog.newanga.me

Azure DP-900 Short Notes: Explore concepts of non-relational data

πŸ‘‰Learn Module: Explore concepts of non-relational data

characteristics of non-relational data

πŸ‘‰Non relational data has no proper structure in them.

πŸ‘‰No scheme on Data.

πŸ‘‰Store the information for entities in collections or containers and not in relational tables.

πŸ‘‰Two entities in the same collection can have a different set of fields.

πŸ‘‰Data retrieval capabilities of a non-relational database vary based on stored data.

πŸ‘‰Advanced non-relational systems such as Azure Cosmos DB support indexing.

πŸ‘‰Use Cases include IoT and telematics, Retail and marketing, Gaming and Web and mobile applications.


Describe types of non-relational data

πŸ‘‰Two types of non-relational data

  1. Semi-structured Data

    • Data contains fields and two entities of same type can have different fields.
    • There are different formats of semi-structured data.
      1. JSON =Document enclosed in curly brackets.
      2. Avro =Row-based format.
      3. ORC = organizes data into columns rather than rows.
      4. Parquet = columnar data format.
  2. Non-structured Data

    • Do not have fields.
    • Ex: Audio and Video

Describe types of non-relational and NoSQL databases

πŸ‘‰Non-relational database also known as No-SQL database.

πŸ‘‰There are four types of non-relational database.

1.key-value store

  • Each data item in a key-value store has two elements, a key and a value.
  • Key uniquely identifies the item and valued hold the data.
  • value is opaque(DBMS just sees the value as an unstructured block).
  • Ex: Azure Table storage

2.Document database

  • Each document has a unique and fields in the documents are transparent to the DBMS.
  • Store data in JSON format or other formats such as XML, YAML, and BSON
  • Ex: Azure Cosmos DB

3.Column family database

  • Organizes data into rows and columns. Ex: ORC and Parquet files
  • Conceptually similar to relational database but different in implementation.
  • Ex: Apache Cassandra in Azure Cosmos DB supported through the Cassandra API

4.Graph database

  • Store entities with a main focus on the relationship between these entities.
  • stores two types of information. Nodes = Instances of entities and Edges= Relationships between nodes.
  • Nodes and edges can both have properties that provide information about that node or edge.

Top comments (0)

We are hiring! Do you want to be our Senior Platform Engineer? We're hiring for a Senior Platform Engineer and would love for you to apply.

Head here to learn more about who we're looking for.