DEV Community

Discussion on: What is CrateDB? 🤔 FAQ (1)

Collapse
 
iambudi profile image
I am Budi

Is it suitable to use cratedb as OLAP Database with a lot of aggregation and columns grouping?

Collapse
 
proddata profile image
Georg Traar • Edited

CrateDB isn't a typical OLAP database, as joins (you might need for star-schemas, etc.) are - although not impossible - rather expensive in a distributed manner.
However it performs very well on aggregations and groupings on very large data sets, as everything is distributed ;)