StarRocks/starrocks

Features

• Real-Time Analytics - Provides a low-latency real-time analytics engine for processing streaming data and updating business dashboards.
• Cloud Data Lake Integrations - Enables direct SQL access to data stored in open table formats within cloud-native data lakes.
• Data Upsert Operations - Ensures real-time data consistency using a primary key upsert model to update records during ingestion.
• Distributed SQL Databases - Implements a distributed SQL database architecture that scales horizontally while maintaining data availability.
• Federated Data Query Engines - Functions as a federated query engine that accesses remote lakehouse storage formats without requiring local data imports.
• Lakehouse Engines - Acts as an analytics engine capable of querying external data lakes and open table formats without local imports.
• Multi-Dimensional Analysis - Performs complex aggregations and ad-hoc queries across large datasets using vectorized processing.
• OLAP Database Engines - Provides a distributed database designed for high-performance multi-dimensional analytics and sub-second SQL queries.
• Cost-Based Optimizers - Implements a cost-based optimizer that determines the most efficient execution plan using table statistics.
• Real-time Data Synchronization - Synchronizes datasets in real-time using primary key upserts and deletes to keep analytics current.
• Vectorized Execution Engines - Utilizes a vectorized execution engine with SIMD instructions to process data in batches for high analytical throughput.
• Lakehouse Querying - Runs high-performance SQL queries directly on open table formats in a data lake without requiring file imports.
• Shared-Nothing Processing Engines - Employs a shared-nothing distributed processing model where each node manages its own local storage and memory.
• Business Intelligence Connectors - Bridges the high-speed engine with business intelligence platforms using standard MySQL protocols and ANSI SQL.
• Materialized Views - Provides automated materialized views that pre-calculate result sets to accelerate query response times.
• Materialized View Selectors - Implements a cost-based optimizer to automatically route queries to the most efficient pre-calculated materialized views.
• Multi-Tenant Resource Isolation - Prevents query interference by allocating specific CPU and memory quotas to individual users or workloads within the cluster.
• MySQL Compatibility - Uses the MySQL protocol to ensure compatibility with standard SQL clients and BI tools.
• Scalable Database Clusters - Provides a scalable database cluster architecture that automatically balances resources during node scaling.
• SQL Database Connectivity - Provides connectivity and compatibility with existing business intelligence tools and database clients via standard MySQL protocols.
• Workload Isolation - Implements multi-tenant resource isolation to manage CPU and memory quotas across concurrent workloads.
• Cluster Scaling Orchestrators - Automatically balances resources and recovers data replicas when adding or removing nodes from the cluster.

Star history