Cassandra是面向列的还是列式数据库 [英] Is Cassandra a column oriented or columnar database

问题描述

列式数据库应将列组存储在一起。但是Cassandra会按行存储数据。
SS表将保存映射到其相应分区键的多行数据。因此，我觉得Cassandra是像MySQL这样的按行数据存储，但是还有宽行之类的其他好处，并且不一定所有行都存在每一列，当然它也存在于内存中。如果我错了，请纠正我。

Columnar database should store group of columns together. But Cassandra stores data row-wise. SS Table will hold multiple rows of data mapped to their corresponding partition key. So I feel like Cassandra is a row wise data store like MySQL but has other benefits like "wide rows" and every columns are not necessarily to be present for all the rows and of course it's in memory . Please correct me if I'm wrong.

推荐答案

如果您转到 GitHub上的Apache Cassandra项目，然后向下滚动到执行摘要，您将得到答案：

If you go to the Apache Cassandra project on GitHub, and scroll down to the "Executive Summary," you will get your answer:

Cassandra是一个分区行存储。行被组织到具有必需主键的表
中。

Cassandra is a partitioned row store. Rows are organized into tables with a required primary key.

分区意味着Cassandra可以跨应用程序透明的
多台计算机分布数据物。 Cassandra将在
集群中添加和删除计算机时自动对
进行分区。

Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster.

行存储意味着与关系数据库一样，Cassandra会组织
行和列的数据。

Row store means that like relational databases, Cassandra organizes data by rows and columns.

所以我觉得Cassandra是行明智的数据存储

"So I feel like Cassandra is a row wise data store"

那是正确的。

这篇关于Cassandra是面向列的还是列式数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！