StarRocks is a distributed SQL OLAP database engine designed for real-time analytics and high-performance multi-dimensional analysis. It functions as a data lakehouse query engine that enables SQL execution across large datasets and external open table formats without requiring local data imports.
The system employs a shared-nothing distributed architecture and utilizes the MySQL protocol to integrate with business intelligence tools. It maintains real-time data consistency through a primary key upsert model and accelerates query response times using vectorized execution and cost-based optimization.
Broad capabilities include the use of automated materialized views to reduce scan volumes and multi-tenant resource isolation to manage CPU and memory quotas across concurrent workloads. The engine also supports automatic resource balancing and data recovery during cluster scaling.