Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

More information on Columnar or 'Column-family' data model in Cosmos DB

The documenation states that the Cosmos DB engine "natively supports multiple data models: key-value, documents, graphs, and columnar ".

However, I can't seem to find any other information relating specifically to the columnar model.

There is also information available on the following APIs:

  • DocumentDB APIs
  • Table APIs
  • Graph APIs

But nothing on Columnar or Column-family, as described in various summaries.

Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/introduction

like image 518
Shane Avatar asked Jul 04 '17 16:07

Shane


People also ask

Is Cosmos DB columnar database?

Azure Cosmos DB analytical store is a fully isolated column store for enabling large-scale analytics against operational data in your Azure Cosmos DB, without any impact to your transactional workloads.

Which Azure Cosmos DB API should you use to work with data in which entities and their relationships to one another are represented in a graph using vertices and edges?

If your data model consists of relationships between entities with associated metadata, you're better off using the graph support in Azure Cosmos DB Gremlin API. If you're currently using Azure Table Storage, the Core (SQL) API would be a better choice.

Which API of Cosmos DB can be used to work with column based data?

The Azure Cosmos DB API for Cassandra stores data in column-oriented schema. Apache Cassandra offers a highly distributed, horizontally scaling approach to storing large volumes of data while offering a flexible approach to a column-oriented schema.


1 Answers

can't seem to find any other information relating specifically to the columnar model

This article will help you understand the concept of column-family:

You can think of a column-family database as holding tabular data with rows and columns, but the columns are divided into groups known as column families. Each column family holds a set of columns that are logically related together and are typically retrieved or manipulated as a unit. Other data that is accessed separately can be stored in separate column families. Within a column family, new columns can be added dynamically, and rows can be sparse (that is, a row doesn't need to have a value for every column).

Besides, as David Makogon said, you can give your feedback (or comment) on that page or contact Cosmos DB team on this email ([email protected]) for more details about column-family data model.

like image 125
Fei Han Avatar answered Jan 02 '23 13:01

Fei Han