Query & OLAP engines
6 articles in this category.
·2 min read
What is a materialized view?
A materialized view stores the precomputed result of a query as a real table, so reads are instant — at the cost of keeping it refreshed as the source changes.
#data
#databases
#performance
#ai-assisted
·2 min read
What is a query engine (Trino, Presto, and friends)?
A query engine plans and executes queries over data it doesn't own — decoupling compute from storage. Trino and Presto run SQL across lakes and many sources at once.
#data
#query
#performance
#ai-assisted
·3 min read
What is Apache Druid?
Apache Druid is a real-time OLAP datastore for sub-second queries on high-volume event data, blending streaming ingestion with columnar storage.
#data
#olap
#realtime
#ai-assisted
·3 min read
What is Apache Pinot?
Apache Pinot is a real-time distributed OLAP datastore built for ultra-low-latency, high-concurrency analytics that powers user-facing dashboards.
#data
#olap
#realtime
#ai-assisted
·3 min read
What is ClickHouse?
ClickHouse is an open-source columnar OLAP database in C++ built for very fast analytical queries over large tables via vectorized execution.
#data
#olap
#databases
#ai-assisted
·3 min read
What is StarRocks?
StarRocks is an open-source MPP analytical database with vectorized execution and a cost-based optimizer, fast at multi-table joins on its own storage and on open lakehouse tables.
#data
#olap
#lakehouse
#ai-assisted