PIN: A PARTITIONING & INDEXING OPTIMIZATION METHOD FOR OLAP

Ricardo Jorge Santos, Jorge Bernardino

2007

Abstract

Optimizing the performance of OLAP queries in relational data warehouses (DW) has always been a major research issue. There are various techniques that can be used to achieve its goals, such as data partitioning, indexing, data aggregation, data sampling, redefinition of database (DB) schemas, among others. In this paper we present a simple and easy to implement method which links partitioning and indexing based on the features present in predefined major decision making queries to efficiently optimize a data warehouse’s performance. The evaluation of this method is also presented using the TPC-H benchmark, comparing it with standard partitioning and indexing techniques, demonstrating its efficiency with single and multiple simultaneous user scenarios.

Paper Citation

in Harvard Style

Jorge Santos R. and Bernardino J. (2007). PIN: A PARTITIONING & INDEXING OPTIMIZATION METHOD FOR OLAP . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 170-177. DOI: 10.5220/0002398301700177

in Bibtex Style

@conference{iceis07,
author={Ricardo Jorge Santos and Jorge Bernardino},
title={PIN: A PARTITIONING & INDEXING OPTIMIZATION METHOD FOR OLAP},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={170-177},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002398301700177},
isbn={978-972-8865-88-7},
}

in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - PIN: A PARTITIONING & INDEXING OPTIMIZATION METHOD FOR OLAP
SN - 978-972-8865-88-7
AU - Jorge Santos R.
AU - Bernardino J.
PY - 2007
SP - 170
EP - 177
DO - 10.5220/0002398301700177