A Multidimensional Data Model for TPC-DS Benchmarking

Dan Chen,Xiaojun Ye,Jianmin Wang
DOI: https://doi.org/10.1145/2532443.2532479
2013-01-01
Abstract:To evaluate the performance of OLAP engines, adapted benchmarks have been developed in the industry. In this paper, we propose a multidimensional model with cube structure for data analytic system benchmarking based on TPC-DS. A number of analytic operations corresponding with SQL templates are given with MDX forms. Finally, we demonstrate the effectiveness of proposed model on big data stores by experiments of SQL and MDX queries on relational DBMSs and NoSQL databases.
What problem does this paper attempt to address?