Atoms consist of a small set of primitive types e.g. string, bool, number etc., records are structs and sequences are arrays consisting of atoms, records or sequences. The database engine of Azure Cosmos DB is capable of efficiently translating and projecting the data models onto the ARS based data model.
Azure Cosmos DB supports 5 different APIs and each supports different data models to use document, key/value, wide column and graph based data.
Core or SQL API - Default API in Cosmos DB and provides a view of the data similar to No-SQL data store. Allows you to query hierarchical data using SQL Query language. If you have prior experience with SQL, you can use the familiar SQL commands and clauses.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXqkRltbCwy9fuLbHBW5X6vfeF9el6HiqduPl2zARk91PskHrbYAKSmMcUvSdRmxMVfG5T5M78LDc2M6qzoYjyzVwlNYAfzZScX0_APV6rX5fIY0hAzPTaxfGdO3vQ_4EMkK3ZLg/s1600/mongo-api.png)
Cassendra API - Allows to query data using Cassendra Query Language (CQL). Data will appear to be a partitioned row store. Like MongoDB API, existing clients can connect to Azure Cosmos DB and only the connection string needs to be updated.
Azure Cosmos DB supports familiar CQL commands and clauses.
- CREATE KEYSPACE
- CREATE TABLE
- ALTER TABLE
- USE
- INSERT
- SELECT
- UPDATE
- BATCH (Only unlogged commands are supported)
- DELETE
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZfrBfWhG96GxP924k92oCCsW2QtOt7sZ2GU7hDSh1e5OU96OoOZFaxlOLDPzuK3Zio9s6Whxc-75PnIssbhVNO-E3yXexm4etLfvsJSYCX_DhBeANQd9WYBVG2EpSRbGoq5I1GQ/s1600/cassandra-api.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNMpkmPxICwwKwEL8Zp64LdN5j8JdRX4DT4Z7He3FM3MEojvhxZF1C3AsCrOkospSrg52gr2OsHK9xPThQ7ltstrDrgEzu7dWvIGrD3RoMC0FvaRLZj2hIgLa-Jur-R_3t6qHV3Q/s1600/table-api.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMRR5n6pjE1B7w6y6RxGV2wsyotRH5XKUI0PLK2dNTZILrkicmQELBrkFStWCqUMtbC4s8zL2-0FtsZVfjkvJIhRmX0Pgi06w2OM9OhhomwsbKTteKaeeXEE-f1icZioKIcY0PFA/s1600/graph-api.png)
No comments:
Post a Comment