DEV Community

Cover image for DP-900 Part 10
Sakshi
Sakshi

Posted on • Edited on

3

DP-900 Part 10

Hi again!

Azure Tables

Azure table is NoSQL based database, it makes use of key-value data items.
Each item is represented by a row.
It enables to store semi structured data.
All rows must have unique keys and after modification a timestamp column record is created to record data time.
Column in each row may vary
No foreign key, views, relationship exist in this azure table.
It has de-normalized data.
For fast access it splits azure table in partitions.
Partitioning groups related rows, rows with same partition key stored together.
Partitioning groups related rows, rows with same partition key stored together.
Partition are independent of each other
We can add a partition key for fast search.

Fundamentals of CosmosDB

  • It is a NoSQL based database
  • It supports multiple APIs, internal structure is abstracted
  • Use index and partitioning to provide fast read
  • It automatically allocates space in container for partitions 10GB maximum
  • Index are created automatically

  • Used for IoT and telemantics, retail marketing, gaming, web and mobile application

thanks for reading

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay