loading
Papers Papers/2022 Papers Papers/2022

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

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.

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 3.17.154.171

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. and Bernardino, J. (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; ISSN 2184-4992, SciTePress, 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},
issn={2184-4992},
}

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
IS - 2184-4992
AU - Jorge Santos, R.
AU - Bernardino, J.
PY - 2007
SP - 170
EP - 177
DO - 10.5220/0002398301700177
PB - SciTePress

- Science and Technology Publications, Lda.
RESOURCES

Proceedings

Papers

Authors

Ontology

CONTACTS

Science and Technology Publications, Lda
Avenida de S. Francisco Xavier, Lote 7 Cv. C,
2900-616 Setúbal, Portugal.

Phone: +351 265 520 185 (National fixed network call)
Fax: +351 265 520 186
Email: info@scitepress.org

EXTERNAL LINKS

PRIMORIS

INSTICC

SCITEVENTS

CROSSREF

PROCEEDINGS SUBMITTED FOR INDEXATION BY:

dblp

Ei Compendex

SCOPUS

Semantic Scholar

Google Scholar

Microsoft Academic