什么是柱状存储DB，与传统的基于行的DB相比，它们有何不同。 [英] What is Columnar storage DBs and what are their difference as compared to traditional Row based DBs.

问题描述

什么是柱状存储DB，与传统的基于行的DB相比有什么区别。





请帮帮我

What is Columnar storage DBs and what are their difference as compared to traditional Row based DBs.


please help me

推荐答案

列存储DB按列顺序存储数据（想象一下普通表但侧向），通常是一系列位图结构。主要的区别是优化存储和查询大量数据（100Gb）的速度。



他们的退回是更新表现。

Column storage DB store data in in column order (think a normal table but sideways), usually in a series of bitmap structures. The main differentiator is optimized storage and speed of querying huge amounts of data (100Gb).

Their draw back is the update performance.

这篇关于什么是柱状存储DB，与传统的基于行的DB相比，它们有何不同。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！