A multidimensional data model for TPC-DS benchmarking

Authors:
Dan Chen;Xiaojun Ye;Jianmin Wang
Affiliations:
Tsinghua University, Beijing, China;Tsinghua University, Beijing, China;Tsinghua University, Beijing, China
Venue:
Proceedings of the 5th Asia-Pacific Symposium on Internetware
Year:
2013

Citing 8
Cited 0

Requirement-based data cube schema design

Proceedings of the eighth international conference on Information and knowledge management
A survey of logical models for OLAP databases

ACM SIGMOD Record
Constructing OLAP cubes based on queries

Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals

Data Mining and Knowledge Discovery
Conceptual multidimensional models

Multidimensional databases
Hierarchies in a multidimensional model: from conceptual modeling to logical representation

Data & Knowledge Engineering - Special issue: WIDM 2004
Why you should run TPC-DS: a workload analysis

VLDB '07 Proceedings of the 33rd international conference on Very large data bases
BigBench: towards an industry standard benchmark for big data analytics

Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data

Quantified Score

Hi-index	0.00

Visualization

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.