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 可以将您的数据分布在应用程序透明的多台机器.卡桑德拉将在机器添加和删除时自动重新分区集群.

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屋！