DBDB.io The Encyclopedia of Database Systems · Est. 2017
Login
Database of Databases

Database Entry

StarRocks

AI-Assisted OLAP

StarRocks is a distributed relational DBMS designed for data warehouse workloads.

Website
https://www.starrocks.io[01]
Source Code
https://github.com/StarRocks/StarRocks[02]
Tech Docs
https://docs.starrocks.io[03]
Twitter
@StarRocksLabs
Developer
Country of Origin
CN
Start Year
2021 [04]
Coding Agents
Project Types
Commercial, Open Source
Written in
C++, Java
Derived From
Doris, Impala, Kudu
Embeds / Uses
Berkeley DB
Compatible With
MySQL
Operating System
Linux
License
Apache v2

Database Entry

StarRocks

AI-Assisted OLAP

StarRocks is a distributed relational DBMS designed for data warehouse workloads.

Compression

Dictionary Encoding Delta Encoding Bitmap Encoding Bit Packing / Mostly Encoding

Concurrency Control

Multi-version Concurrency Control (MVCC)

Data Model

Column Family / Wide-Column Relational

Fault Tolerance

Quorum-based Replication Read Repair Synchronous Replication Asynchronous Replication

Foreign Keys

Supported

StarRocks uses foreign keys for performance enhancements, while users can declare foreign keys, but they are not enforced.

Indexes

BitMap Inverted Index (Full Text)

StarRocks supports a wide range of secondary indexes, including prefix index, bitmap index, bloomfilter index, n-gram index, inverted index, and ANN (Approximate Nearest Neighbor) indexes.

Joins

Nested Loop Join Hash Join Broadcast Join Shuffle Join

StarRocks is MPP and is able to perform in-memory data shuffling.

Parallel Execution

Intra-Operator (Horizontal)

Query Compilation

JIT Compilation

StarRocks uses vectorization without query compilation globally. Its expression uses JIT compilation.

Query Interface

SQL

Storage Architecture

Disk-oriented Hybrid

Storage Format

Iceberg Hudi Custom

StarRocks has its own storage formats and can directly query data stored in Apache Hudi, Apache Iceberg, Delta and Paimon formats.

Storage Model

Decomposition Storage Model (Columnar)

System Architecture

Shared-Nothing Shared-Everything

User-Defined Functions

Python Java

Views

Virtual Views Materialized Views

StarRocks Materialized View supports multi-table queries and can perform query rewrites during query execution.

People Also Viewed
Doris Doris GreatSQL GreatSQL Theseus Theseus StoneDB StoneDB

Citations

8 sources
  1. StarRocks | A High-Performance Analytical Database starrocks.io
  2. GitHub - StarRocks/starrocks: The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional a github.com
  3. StarRocks starrocks.io
  4. Init commit github.com
  5. https://github.com/StarRocks/StarRocks/commit/c88fe8141e67976eda5a23a1f0b7e5501e1b073b github.com
  6. https://github.com/StarRocks/StarRocks/commit/7aa8e116ba0417a8a415a55eaa75340d1ab6e555 github.com
  7. https://github.com/StarRocks/StarRocks/commit/a02142fe3af972e76ad32c2233187e30768d5411 github.com
  8. https://github.com/StarRocks/StarRocks/commit/d70721db3d7bee930765cba17842c894c496773c github.com
Revision #7 Last Updated: