Data model

Columnar / OLAP databases

Column-oriented storage and vectorised execution for scanning and aggregating billions of rows quickly. The leading options are Snowflake, ClickHouse and Google BigQuery.

106 active · ordered by fit for this category, then WhichDB Score

SnowflakeColumnar / OLAPmanaged

Fully managed cloud data warehouse with separate storage and compute, now spanning AI and apps.

74.4
ClickHouseColumnar / OLAPopen source

Open-source columnar OLAP database known for very fast aggregations over billions of rows.

69.8
Google BigQueryColumnar / OLAPmanaged

Google's serverless, pay-per-query data warehouse built on Dremel and Colossus.

65.3
DuckDBColumnar / OLAPopen source

In-process columnar SQL database: the SQLite of analytics, running inside your app or notebook.

63.7
Amazon RedshiftColumnar / OLAPmanaged

AWS's MPP columnar data warehouse, available as provisioned RA3 clusters or Serverless.

55.8
MotherDuckColumnar / OLAPmanaged

Serverless cloud data warehouse built on DuckDB, with hybrid local-plus-cloud execution.

37.7
Apache DruidColumnar / OLAPopen source

Real-time analytics database for sub-second slice-and-dice over streaming event data.

35.0
VerticaColumnar / OLAP

Veteran MPP columnar analytics database from the C-Store lineage, now owned by Rocket Software.

33.1
Apache DataFusionColumnar / OLAPopen source

Extensible Rust query engine library on Apache Arrow for building databases and data systems.

31.6
Azure Data ExplorerColumnar / OLAPmanaged

Microsoft's Kusto engine: fast KQL analytics over logs, telemetry and time series at petabyte scale.

31.2
ExasolColumnar / OLAP

In-memory MPP columnar analytics database from Germany, tuned for fast BI with little tuning.

31.0
Apache PinotColumnar / OLAPopen source

Real-time OLAP store from LinkedIn for user-facing analytics at very high query rates.

29.9
MonetDBColumnar / OLAPopen source

Pioneering open-source column-store from CWI, still a lean research-grade analytical SQL database.

24.2
chDBColumnar / OLAPopen source

Embedded, in-process OLAP engine powered by ClickHouse, used mainly from Python.

21.1
Databricks SQLColumnar / OLAPmanaged

Serverless SQL warehouses on the Databricks lakehouse, powered by the Photon C++ engine.

20.8
Apache KuduColumnar / OLAPopen source

Columnar storage engine for fast analytics on fast-changing data, paired with Impala or Spark.

18.6
ParseableColumnar / OLAPopen source

Rust telemetry datalake for logs, metrics and traces on S3, queried with SQL.

18.6
SigNozColumnar / OLAPopen source

OpenTelemetry-native APM and observability platform storing logs, metrics and traces in ClickHouse.

17.0
Apache KylinColumnar / OLAPopen source

OLAP engine that pre-computes cubes and aggregate indexes for sub-second SQL on huge datasets.

16.9
Timeplus ProtonColumnar / OLAPopen source

A single C++ binary for streaming SQL, built on ClickHouse's engine with streams and windows.

16.6
Apache DorisColumnar / OLAPopen source

Real-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access.

15.9
StarRocksColumnar / OLAPopen source

MPP OLAP database with a fast vectorized engine, real-time upserts and native lakehouse queries.

15.6
DatabendColumnar / OLAPopen source

Rust-built cloud data warehouse on object storage, open source with a managed Databend Cloud.

15.4
HEAVY.AI (HeavyDB)Columnar / OLAPopen source

GPU-native columnar SQL database with visual analytics, fully open-sourced by NVIDIA in 2026.

14.3
Apache PaimonColumnar / OLAPopen source

Streaming lakehouse table format with LSM-based upserts and changelogs, born in Apache Flink.

14.2
Grafana TempoColumnar / OLAPopen source

Object-storage-backed distributed tracing backend with TraceQL search and trace-derived metrics.

14.1
TinybirdColumnar / OLAP

Managed ClickHouse platform that turns SQL pipes into low-latency, versioned HTTP APIs.

12.6
SAP IQColumnar / OLAP

Sybase's pioneering columnar warehouse, now SAP IQ and the engine behind HANA Cloud's data lake.

11.9
pg_mooncakeColumnar / OLAPopen source

Postgres extension that mirrors tables into Iceberg columnstores for real-time analytics via DuckDB.

11.2
AxiomColumnar / OLAPmanaged

Managed event and telemetry store with schema-on-read ingest and the piped APL query language.

10.9
Apache FlussColumnar / OLAPopen source

Columnar streaming storage for Flink with primary-key tables and tiering into the lakehouse.

8.4
FireboltColumnar / OLAP

Low-latency analytical database with a Postgres-compliant dialect, as cloud service or self-hosted Core.

7.8
Azure Synapse AnalyticsColumnar / OLAPmanaged

Azure analytics service combining MPP dedicated SQL pools, serverless SQL and Spark.

7.4
Microsoft Fabric Data WarehouseColumnar / OLAPmanaged

T-SQL warehouse in Microsoft Fabric that stores every table as Delta Parquet in OneLake.

6.7
KineticaColumnar / OLAP

GPU- and vector-accelerated database for real-time spatial, time-series and vector analytics.

6.4
InfobrightColumnar / OLAP

Compressed columnar analytics engine on a MySQL front end, now sold by IgniteTech as Infobright AI.

4.4
YellowbrickColumnar / OLAP

PostgreSQL-compatible MPP warehouse that runs on its appliance, any cloud or Kubernetes.

4.1
OcientColumnar / OLAP

Hyperscale data warehouse on NVMe compute-adjacent storage, rebranded as the OcientAIQ platform.

3.8
Actian Analytics Engine (Vector)Columnar / OLAP

Actian's vectorized columnar analytics database, born from CWI's X100; renamed Analytics Engine in 2026.

3.7
ActivePivotColumnar / OLAP

In-memory OLAP aggregation engine for bank risk analytics, renamed Atoti Server by ActiveViam.

3.4
VeloDBColumnar / OLAPmanaged

Commercial cloud and enterprise distribution of Apache Doris from its core maintainers.

2.3
LocustDBColumnar / OLAPopen source

Experimental Rust columnar analytics engine built to scan billions of rows per second on one machine.

2.1
HydrolixColumnar / OLAP

Streaming data lake for log-scale event data, with ClickHouse-based SQL over object storage.

0.2
InMemory.NetColumnar / OLAP

Commercial in-memory columnar SQL engine for .NET that speeds up reporting over hundreds of millions of rows.

0.2
1010dataColumnar / OLAPmanaged

Hosted columnar analytics platform with a spreadsheet-style interface, owned by SymphonyAI since 2023.

0.0
IBM Db2 WarehouseColumnar / OLAP

IBM's MPP analytics edition of Db2 with BLU columnar acceleration, as software or SaaS.

0.0
MariaDBRelationalopen source

Community-led MySQL fork with extra storage engines, built-in Galera and a faster feature cadence.

56.2
InfluxDBTime-Seriesopen source

Purpose-built time-series database, rebuilt in Rust on Arrow, DataFusion and Parquet for version 3.

51.0
Apache Spark SQLRelationalopen source

Spark's SQL and DataFrame engine for large-scale batch, streaming and lakehouse processing.

50.3
TrinoRelationalopen source

Fast distributed SQL query engine for federated analytics across lakes and databases.

49.9
TimescaleDBTime-Series

PostgreSQL extension adding hypertables, columnar compression and continuous aggregates for time series.

47.1
IBM Db2Relational

IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering.

45.5
SAP HANARelational

SAP's in-memory columnar HTAP database, the mandatory engine under S/4HANA.

39.7
Teradata VantageRelational

The original MPP data warehouse, now VantageCloud with open table formats and in-database analytics.

38.5
PrestoRelationalopen source

Distributed SQL query engine from Meta for interactive queries over data lakes and many sources.

37.7
TiDBRelationalopen source

MySQL-compatible distributed SQL with a row store for OLTP and a columnar replica for real-time analytics.

35.9
QuestDBTime-Seriesopen source

Columnar time-series SQL database built for market data and very high ingest rates.

34.1
kdb+Time-Series

Column-store time-series engine with the q language, a fixture of capital-markets tick data.

31.8
Apache HiveRelationalopen source

The original SQL-on-Hadoop warehouse, now mostly valued for its Metastore and Iceberg support.

30.1
Apache ImpalaRelationalopen source

Low-latency MPP SQL engine for Hadoop, Kudu and Iceberg tables, developed largely by Cloudera.

29.0
SingleStoreRelational

Distributed SQL mixing in-memory rowstore and columnstore for real-time analytics, search and vectors.

29.0
LanceDBVectoropen source

Embedded, serverless retrieval database on the Lance columnar format for multimodal AI data.

27.5
YDBRelationalopen source

Open-source distributed SQL from Yandex combining row and column tables, topics and vector search.

27.4
CitusRelationalopen source

Postgres extension that shards tables across nodes for multi-tenant SaaS and real-time analytics.

21.1
GreenplumRelational

PostgreSQL-based MPP data warehouse, closed-sourced by Broadcom in 2024 and sold in Tanzu Data.

20.7
WiredTigerKey-Valueopen source

MongoDB's default storage engine: MVCC B-tree with compression and snapshot isolation.

20.6
OpenObserveSearch Engineopen source

Single-binary Rust observability platform storing logs, metrics and traces as Parquet on object storage.

20.4
Amazon AthenaRelationalmanaged

Serverless AWS query service running Trino-based SQL directly over data in S3.

19.5
OceanBaseRelationalopen source

Alipay-proven distributed SQL with MySQL (and Oracle, in Enterprise) compatibility, HTAP and vector search.

19.4
VictoriaLogsSearch Engineopen source

Log database from the VictoriaMetrics team: schemaless ingestion, LogsQL and low RAM and disk use.

19.4
Manticore SearchSearch Engineopen source

Fast SQL-first search database, forked from Sphinx, with columnar storage and vector KNN.

19.2
Actian IngresRelational

One of the original relational databases, still sold by Actian for long-lived enterprise systems.

16.8
pg_lakeRelationalopen source

Postgres extensions from Snowflake that read and write Iceberg tables and lake files, executed via DuckDB.

15.2
GreptimeDBTime-Seriesopen source

Rust observability database that keeps metrics, logs and traces in one columnar engine on object storage.

15.1
Oracle ExadataRelational

Oracle's engineered system for Oracle Database, with smart storage offload for OLTP and analytics.

15.0
pg_duckdbRelationalopen source

PostgreSQL extension that embeds DuckDB's vectorized engine for fast analytics and data-lake queries.

14.9
SailRelationalopen source

Rust-native, Spark Connect-compatible engine for SQL, DataFrame and streaming jobs without the JVM.

14.5
ArcticDBTime-Series

Serverless DataFrame database from Man Group: Pandas in, versioned columnar data on S3 out.

14.4
DremioRelational

Iceberg-native lakehouse query engine with reflections for acceleration, owned by SAP since 2026.

12.7
Grafana PyroscopeTime-Seriesopen source

Continuous profiling database that stores CPU and memory profiles over time on object storage.

12.7
Deep LakeVectoropen source

Activeloop's tensor-native data engine for AI: vectors, multimodal data and versioning on object storage.

12.2
DolphinDBTime-Series

Distributed time-series database and scripting platform for quant finance and industrial analytics.

11.6
EndecaSearch Engine

Faceted-search and discovery engine (MDEX) that Oracle bought in 2011; now a frozen Oracle Commerce component.

11.0
TileDBArray / Scientificopen source

Embeddable multidimensional array storage engine for dense and sparse data on object storage.

10.5
XTDBRelationalopen source

Bitemporal SQL database on object storage that keeps every version of every row.

8.3
e6dataRelationalmanaged

Lakehouse compute engine that runs SQL on Iceberg, Delta and Hudi in your own cloud account.

7.4
Apache CloudberryRelationalopen source

Open-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel.

6.8
CnosDBTime-Seriesopen source

Rust cloud-native time-series database with SQL on DataFusion and InfluxDB-style ingestion.

6.7
Dameng (DM)Relational

China's leading home-grown RDBMS; DM9 (2026) adds distributed, HTAP and AI features.

6.7
openGaussRelationalopen source

Huawei-originated open-source RDBMS forked from PostgreSQL, with in-memory and column engines.

6.7
quasardbTime-Series

Distributed columnar time-series database, now sold as Quasar, for tick, sensor and industrial data.

6.6
openGeminiTime-Seriesopen source

CNCF sandbox distributed time-series database from Huawei Cloud, compatible with InfluxQL.

6.5
MatrixOneRelationalopen source

MySQL-compatible cloud-native HTAP database on object storage, with vector search and snapshots.

6.1
PolarDB-XRelationalopen source

Alibaba's open-source, MySQL-compatible shared-nothing distributed SQL with Paxos and columnar indexes.

5.0
GenomicsDBArray / Scientificopen source

Sparse-array store for genomic variant data, built on TileDB and shipped inside GATK4.

4.2
eXtremeDBKey-Value

Embedded in-memory and hybrid database for devices, real-time systems and time-series analytics.

4.0
AlloyDB for PostgreSQLRelationalmanaged

Google's Postgres-compatible service with disaggregated storage, a columnar engine and ScaNN vectors.

3.6
Alibaba PolarDBRelationalmanaged

Alibaba Cloud's shared-storage relational service in MySQL-, PostgreSQL- and Oracle-compatible editions.

2.7
FiloDBTime-Seriesopen source

Distributed in-memory time-series database with PromQL, ingesting from Kafka and persisting to Cassandra.

2.2
DatalayersTime-Series

Multi-model database for IoT and observability: time series, full-text, vector and key-value on Parquet.

1.7
KerfTime-Seriesopen source

Columnar tick database and array language from Kona's author, with JSON and SQL syntax; open-sourced in 2022.

1.3
Google Spanner OmniRelational

Downloadable Spanner that runs on your own servers, other clouds or a laptop, with Paxos and auto-sharding.

1.1
MySQL HeatWaveRelationalmanaged

Oracle's managed MySQL with an in-memory columnar engine for analytics, lakehouse, ML and vector search.

0.5
GBaseRelational

Chinese commercial database family: GBase 8a analytics, 8s transactional cluster, 8c distributed.

0.0
Oracle Autonomous DatabaseRelationalmanaged

Self-driving Oracle Database on Exadata: auto-patching, auto-scaling, and Select AI, on OCI and other clouds.

0.0
StarburstRelational

Commercial Trino platform: self-managed Starburst Enterprise and the Starburst Galaxy SaaS.

0.0

license legend · Open source (permissive) · Open source (copyleft) · Source-available · Proprietary