OBAS: An OLAP Benchmark for Analysis Services

Authors

  • Bruno Edson Martins de Albuquerque Filho Universidade Federal de Pernambuco
  • Thiago Luís Lopes Siqueira Instituto Federal de Educação, Ciência e Tecnologia de São Paulo - Campus São Carlos
  • Valéria Cesário Times Universidade Federal de Pernambuco

DOI:

https://doi.org/10.5753/jidm.2013.1505

Keywords:

Data warehousing, Performance Evaluation, Benchmark, OLAP

Abstract

Some benchmarks have been proposed for helping in the design of data warehouse performance tests, such as TPC-H, which was extended by SSB (Star Schema Benchmark). However, we identified the lack of a benchmark for analysis services (OLAP). In this article, we specify a benchmark for analysis services, called OBAS that extends SSB's multidimensional schema and creates varying-sized data cubes. It enables the evaluation of analysis services through the specification of running configuration parameters, a set of MDX queries and a set of service performance metrics, i.e. response time, rate of execution and service reliability. Using OBAS, we compared two analysis services that adopt XMLA as communication interface: the SQL Server Analysis Services (SSAS) and the Pentaho Mondrian. The results showed that OBAS helped in the comparison of these services with respect to performance and reliability regarding the number of threads.

Downloads

Download data is not yet available.

Downloads

Published

2013-09-25

How to Cite

Albuquerque Filho, B. E. M. de, Siqueira, T. L. L., & Times, V. C. (2013). OBAS: An OLAP Benchmark for Analysis Services. Journal of Information and Data Management, 4(3), 390. https://doi.org/10.5753/jidm.2013.1505

Issue

Section

SBBD Articles