RTABench — a Benchmark For Real Time Analytics

RTABench is a benchmark designed to evaluate real-time analytics across various database systems, machine types, and cluster sizes, focusing on metrics such as cold run, hot run, load time, and storage size, with an emphasis on system and machine relative time. A crucial aspect of real-time analytics is the use of incremental materialized views, which significantly enhance query performance on large datasets by allowing for faster retrieval times. However, this capability is not universally supported across all databases, and when available, it may only apply to newly inserted data rather than updates or deletions. The benchmark includes a comparison of query performance when results are incrementally materialized, showing how these views can outperform queries executed on raw data. Despite their importance, results involving incremental materialized views are not included in the overall global performance score due to the limited support among databases for this feature.