CrateDB: A Search Engine or a Database? Both! #bbuzz
summary
CrateDB runs a full SQL layer SQL-99 compatible compiled into Lucene queries and routed over Elasticsearch so queries execute across a cluster with a distributed runtime and optimized operators like hashed joins (one join side must fit in RAM). It expects tens of nodes in practice (many customers use ~20), targets real-time monitoring and time-series workloads, supports partitioning, shards and replicas, allows ephemeral storage and snapshots, and deliberately does not provide transactional guarantees.
AI-written summary · about
chapters (7)
- 0:00Start
- 11:30CRATEDB TECH STACK
- 13:44INTRODUCTION TO Lucene
- 14:42INTRODUCTION TO ELASTICSEARCH
- 17:02FROM QUERY TO EXECUTION
- 20:31ARCHITECTURE HIGHLIGHTS
- 23:29ALPLA
related talks
42mMarija Selakovic
23mWhen ms matter: Maximizing query performance in CrateDB
13mUnlocking Your AI Potential With Real-Time Data Unification
41mHow to choose the right database for your application
38mAccelerating Query Performance in CrateDB
47mNo DB: Use a Search Engine!
45mDealing with TBytes of Data in Realtime
36mSearch on the fly: how to lighten your Big Data