data-warehouse - 用于数据仓库和空间查询的 NewSQL

Question

哪些 NewSQL 发行版适合处理数据仓库和空间查询？（MemSQL、VoltDB、NuoDB，什么？为什么）

标签： data-warehousespatial-querysinglestorevoltdb

Answer 1

MemSQL can handle data warehousing using disk-based columnstores (https://docs.memsql.com/concepts/v6.7/columnstore/) for fact tables because they can handle very large tables with fast distributed joins (https://www.memsql.com/blog/6-5-performance/) and star joins (https://www.memsql.com/blog/performance-for-memsql-67/). And it can handle geospatial (https://www.memsql.com/content/geospatial/) types and indexing as well.