Use case

Databases for Data warehouse

Central store for analytics across the business, usually SQL and columnar. The leading options are Snowflake, ClickHouse and Google BigQuery.

50 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
VerticaColumnar / OLAP

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

33.1
ExasolColumnar / OLAP

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

31.0
MonetDBColumnar / OLAPopen source

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

24.2
Databricks SQLColumnar / OLAPmanaged

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

20.8
Apache KylinColumnar / OLAPopen source

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

16.9
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
SAP IQColumnar / OLAP

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

11.9
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
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
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
Microsoft SQL ServerRelational

Microsoft's flagship RDBMS: T-SQL, columnstore, Always On, and now native vectors and JSON.

71.0
Oracle DatabaseRelational

The enterprise heavyweight: RAC, Data Guard and a converged engine for SQL, JSON, graph and vectors.

56.9
TrinoRelationalopen source

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

49.9
IBM Db2Relational

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

45.5
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
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
GreenplumRelational

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

20.7
Amazon AthenaRelationalmanaged

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

19.5
pg_lakeRelationalopen source

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

15.2
IBM NetezzaRelational

IBM's FPGA-accelerated MPP warehouse, now offered as NPS on-prem, in Cloud Pak and as a service.

15.1
Oracle ExadataRelational

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

15.0
EssbaseArray / Scientific

Oracle's multidimensional OLAP cube server, the long-time engine behind financial planning and reporting.

13.0
DremioRelational

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

12.7
MondrianRelational

Java ROLAP engine that answers MDX queries by generating SQL against your relational warehouse.

12.4
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
TiberoRelational

Korean Oracle-compatible RDBMS with RAC-style Active Cluster, popular for Oracle exits in Asia.

0.8
GBaseRelational

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

0.0
KingbaseESRelational

Chinese PostgreSQL-derived RDBMS with Oracle, MySQL and SQL Server compatibility modes.

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
XtremeData dbXRelational

Parallel, vectorized SQL analytics engine on PostgreSQL roots, once an FPGA appliance, now cloud software.

0.0
Apache Spark SQLRelationalopen source

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

50.3
Dameng (DM)Relational

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

6.7

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