Skip to main content
Vibgrate Graph: over 40% fewer tokens, same results
Back to Tags

OLAP

15 items tagged with "olap"

Filter by type:

Tutorials1

Tutorial

How to model an analytics table in ClickHouse

Create a MergeTree table in ClickHouse with the right ordering key and partitioning, then load data and run fast aggregations.

Products1

Product

ClickHouse

Column-oriented database for real-time analytics

Reference Architectures2

Reference Architecture

HTAP OLTP and OLAP Platform

A hybrid transactional and analytical platform that serves OLTP and OLAP on one distributed SQL store with columnar replicas.

Reference Architecture

Columnar OLAP Analytics with ClickHouse

A high-speed columnar OLAP platform on ClickHouse for sub-second aggregation over billions of rows, deployed on Kubernetes.

Stacks4

Stack

ClickHouse Real-Time Analytics Stack

High-performance analytics stack: ClickHouse ingests event streams from Kafka and serves sub-second OLAP queries powering user-facing dashboards.

Stack

ClickHouse + Grafana

A real-time analytics stack using ClickHouse as a fast columnar OLAP database with Grafana for dashboards over high-volume event data.

Stack

Apache Druid + Superset

A real-time OLAP stack using Apache Druid for sub-second slice-and-dice queries and Apache Superset for self-service exploration.

Stack

Apache Pinot Real-Time Analytics

A user-facing analytics stack built on Apache Pinot for ultra-low-latency, high-throughput queries over fresh streaming data.

Comparisons1

Comparison

ClickHouse vs Druid

Columnar OLAP database for fast analytics versus Apache Druid's real-time analytics datastore for time-series and event data.

Benchmarks5

Benchmark

TPC-H

An ad-hoc decision-support benchmark of 22 complex analytical queries over a star-like schema, reporting query throughput and power at fixed scale factors.

Benchmark

TPC-DS

A modern decision-support benchmark with 99 queries over a multi-snowflake retail schema, designed to stress complex analytics, data loading, and concurrency.

Benchmark

ClickBench

An open benchmark for analytical databases using a single wide web-analytics table and 43 queries to compare cold and hot OLAP query latency.

Benchmark

Star Schema Benchmark (SSB)

A simplified TPC-H derivative using a classic star schema and 13 queries in four flights to measure data-warehouse query performance.

Benchmark

OLTP vs OLAP Latency Benchmark

A comparative benchmark category contrasting transactional (OLTP) point-operation latency with analytical (OLAP) scan-and-aggregate latency to evaluate HTAP systems.

FAQs1

FAQ

What is the difference between OLTP and OLAP?

OLTP (Online Transaction Processing) handles many short, concurrent transactions like orders, payments, and updates, optimized for fast writes and row...