Scholarlink

In OLAP (Online Analytical Processing) environments, star schema outperforms 3NF (Third Normal Form). It offers simpler querying and superior performance, along with better tool support, making it analyst-preferred. Currently, the SSB benchmark is the main star schema benchmark but it has limited workload compared to other OLAP benchmarks like TPC-H. This paper introduces StarBench, a novel star schema benchmark that combines the advantages of star schema data model with the comprehensive workload of TPC-H. StarBench utilizes a 4-table denormalized model derived from TPC-H, effectively addressing the data gaps present in SSB. Data loading in StarBench is performed via insert-select operations from TPC-H tables. The workload remains consistent with TPC-H, incorporating SQL modifications to align with the new data model. We evaluated StarBench on PostgreSQL to demonstrate the benchmark’s feasibility.

错误：搜索内容不能为空，请输入英文关键词
错误：关键词超出字数限制，请精简
高级检索

StarBench: A Fresh Approach on Star Schema Benchmarking

  • 会议论文

  • 发表日期：

    2026年

查看全文
  • Hanumath Maduri,
  • Alain Crolotte,
  • Ahmad Ghazal,
  • Yuchao Li

摘要

In OLAP (Online Analytical Processing) environments, star schema outperforms 3NF (Third Normal Form). It offers simpler querying and superior performance, along with better tool support, making it analyst-preferred. Currently, the SSB benchmark is the main star schema benchmark but it has limited workload compared to other OLAP benchmarks like TPC-H. This paper introduces StarBench, a novel star schema benchmark that combines the advantages of star schema data model with the comprehensive workload of TPC-H. StarBench utilizes a 4-table denormalized model derived from TPC-H, effectively addressing the data gaps present in SSB. Data loading in StarBench is performed via insert-select operations from TPC-H tables. The workload remains consistent with TPC-H, incorporating SQL modifications to align with the new data model. We evaluated StarBench on PostgreSQL to demonstrate the benchmark’s feasibility.