Google BigQuery pioneered the serverless cloud warehouse, billing scanned bytes so petabyte analysis needs no capacity planning, with partitioning, clustering, and BI Engine governing both bills and responsiveness.
TAG COLLECTION
columnar collection
Explore providers, articles, and companies related to columnar for practical research and comparison.
Providers
Amazon Redshift is AWS's columnar MPP cloud warehouse where RA3 separates storage from compute, Spectrum queries the S3 lake directly, and Glue, QuickSight, and SageMaker complete the AWS analytics stack.
DuckDB is the in-process embedded analytical database dubbed analytical SQLite, running vectorised SQL over Parquet and DataFrames without a server as an efficient tool for exploration and ETL staging.
Apache Druid is the columnar OLAP store built for real-time analytics, where streaming ingestion with rollup delivers sub-second responses for high-concurrency dashboards over high-cardinality event data.
QuestDB is a time-series database built for high ingestion throughput, where columnar storage and time partitioning with SAMPLE BY and LATEST ON fit market data, IoT, and metric workloads.
Greenplum is the open source MPP warehouse built on PostgreSQL, where the GPORCA optimiser with columnar and external tables supports terabyte parallel analytics at near-zero learning cost for PostgreSQL teams.