Agenda Azure Cosmos DB Key capabilities Develop an
Agenda • Azure Cosmos DB • Key capabilities • Develop an app with Cosmos DB • Azure Cosmos DB Emulator
What does NOSQL Mean? • Class of database management systems (DBMS) that do not follow all of the rules of a relational DBMS. • Interpreted as "No SQL, " and most translate it as "Not Only SQL. • This type of database is not generally a replacement but, rather, a complementary addition to RDBMS and SQL.
Type of NOSQL DOCUMENT BASEDDOCUMENT DB/Cassandra Column Based - Cassandra NOSQL Key Value Pair –Redis, Azure Storage Graph – Neo 4 j, SAP HANA
Comparison B/W SQL & NO-SQL • Relational • SCALE UP/Horizontally Scalable • Structured or Schema • Atomic Transaction • Difficult for programmer • Eg. CAR Disassembled in and reassembled when required. NOSQL • Non-Relational • Scale OUT/Horizontally Scalable • Semi or unstructured data • EVENTUAL CONSISTENCY • Easy for Programmers • Eg. Park a car in parking
SQL Document. DB Azure Tables Azure Cosmos DB Key-Value Global distribution Column-Family Elastic scale out Documents Guaranteed low latency Graph Tunable Consistency A multi-model, globally-distributed database service Comprehensive SLAs
Capability comparison Capabilities Global distribution Relational databases No Non-relational (No. SQL) databases No Horizontal scale No Yes Latency guarantees No Yes, 99% of reads in <10 ms and writes in <15 ms High availability No Yes, Cosmos DB is always on, has PACELC trade-offs, and provides automatic & manual failover options Data model + API Relational + SQL Multi-model + OSS API SLAs Yes No Multi-model + SQL + OSS API (more coming soon) Yes, comprehensive SLAs for latency, throughput, consistency, availability Azure Cosmos DB Yes, turnkey distribution in 30+ regions, with multihoming APIs Yes, you can independently scale storage and throughput
Develop an app with Cosmos DB DEMO
Azure Cosmos DB Emulator
DEMO
Thank you
- Slides: 15