loading
Papers

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Ricardo Jorge Santos 1 and Jorge Bernardino 2

Affiliations: 1 CISUC – Centre of Informatics and Systems of the University of Coimbra - University of Coimbra, Portugal ; 2 CISUC – Centre of Informatics and Systems of the University of Coimbra - University of Coimbra; ISEC – Superior Engineering Institute of Coimbra – Polytechnic Institute of Coimbra, Portugal

ISBN: 978-972-8865-88-7

Keyword(s): Optimizing, partitioning, indexing, data warehouse.

Related Ontology Subjects/Areas/Topics: Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems

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.

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 100.26.176.182

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

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

@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 3: ICEIS,},
year={2007},
pages={170-177},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002398301700177},
isbn={978-972-8865-88-7},
}

TY - CONF

JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: 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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.