Search code examples
sqldatabasedatabase-designolap

SQL/NewSQL suited read only, OLAP Database

I am looking for a sql/newsql database Engine which is suited for fast Response times on a read only Star Schema for ad-hoc olap purposes. Complete dataset is about 4 Billion rows and MySql ist performing very slow on that Task.

I would be very grateful for some recommendations

Solution

  • If it is a read only star schema benchmark, try MariaDB Columnstore. It is very fast with data load and star schema-like queries.