Star-Tree Index
Intelligent partial aggregations
Achieve 95% faster queries with the Star-Tree Index. Query fresh data in real time with consistent speed, even at massive scale and concurrency.
Fast insights at petabyte scale with Star-Tree Index
95-99% faster analytics at any scale
Intelligent storage-speed balance
Real results across industries
Results
- reduction in storage costs
- 50%
- faster queries
- 4x
- spans supported in a single request
- 100k
Uses Cases
Observability
01
/02overview
What makes the Star-Tree Index unique
Sub-second query responses
Faster queries
Reduce query latency on massive datasets with millions of records by using intelligent pre-aggregation and optimized data access patterns.
Smart resource optimization
Scan less data
By minimizing the volume of data scanned and aggregated per query, the Star-Tree Index dramatically decreases disk I/O. This reduction not only lowers query latency but also frees up CPU and memory resources, allowing your infrastructure to handle higher workloads efficiently.
Adaptable performance tuning
Flexible configuration
Achieve consistent sub-millisecond response times and meet demanding SLAs by balancing storage space and query speed. Tune the space-time tradeoff with configurable thresholds between pre-aggregation and data scans to maintain high QPS for customer-facing applications.
“The benefits of migrating to StarTree and Pinot center around three areas: query performance, SLAs, and cost. With Pinot, we are now in the subseconds to milliseconds range, the higher query concurrency means we can serve more customers faster, and we’ve been able to reduce our infrastructure costs.”
Joanes Espanol
CTO and Co-Founder
resources for Star-Tree Index
keep exploring
The most powerful real-time analytics platform
Simplified tiered storage
Analyze all your data, new and historical, without slowing down queries or blowing your budget. StarTree automatically stores the data you access most often for super-fast results.
Powerful, flexible indexing
Harness extensive indexing to analyze your data, any way you want. Unlike other techniques which work on a single column, the star-tree index is built on multiple columns, using pre-aggregated results.
Multi-stage query engine
Trust StarTree to handle your multi-stage data processing. Run complex SQL queries without sacrificing blazing fast query performance. And gain the business insights your teams need, in real-time.
Autoscaling minions
Save costs on your cloud infrastructure with auto scaling minions. Ensure tasks are processed efficiently and drop the legwork of repartitioning data post-ingestion and merging smaller segments into larger ones.
