loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Ricardo Jorge Santos and Jorge Bernardino

Affiliation: University of Coimbra, Portugal

Keyword(s): OLAP Query Performance Optimization, Bitmap and Bitwise Operations in OLAP.

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

Abstract: Performance optimization of decision support queries has always been a major issue in data warehousing. A large amount of wide-ranging techniques have been used in research to overcome this problem. Bit-based techniques such as bitmap indexes and bitmap join indexes have been used and are generally accepted as standard common practice for optimizing data warehouses. These techniques are very promising due to their relatively low overhead and fast bitwise operations. In this paper, we propose a new technique which performs optimized row selection for decision support queries, introducing a bit-based attribute into the fact table. This attribute’s value for each row is set according to its relevance for processing each decision support query by using bitwise operations. Simply inserting a new column in the fact table’s structure and using bitwise operations for performing row selection makes it a simple and practical technique, which is easy to implement in any Database Management Syst em. The experimental results, using benchmark TPC-H, demonstrates that it is an efficient optimization method which significantly improves query performance. (More)

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.129.42.198

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:
Santos, R. and Bernardino, J. (2009). A BIT-SELECTOR TECHNIQUE FOR PERFORMANCE OPTIMIZATION OF DECISION-SUPPORT QUERIES. In Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 3: ICEIS; ISBN 978-989-8111-84-5; ISSN 2184-4992, SciTePress, pages 151-157. DOI: 10.5220/0001993001510157

@conference{iceis09,
author={Ricardo Jorge Santos. and Jorge Bernardino.},
title={A BIT-SELECTOR TECHNIQUE FOR PERFORMANCE OPTIMIZATION OF DECISION-SUPPORT QUERIES},
booktitle={Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 3: ICEIS},
year={2009},
pages={151-157},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001993001510157},
isbn={978-989-8111-84-5},
issn={2184-4992},
}

TY - CONF

JO - Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 3: ICEIS
TI - A BIT-SELECTOR TECHNIQUE FOR PERFORMANCE OPTIMIZATION OF DECISION-SUPPORT QUERIES
SN - 978-989-8111-84-5
IS - 2184-4992
AU - Santos, R.
AU - Bernardino, J.
PY - 2009
SP - 151
EP - 157
DO - 10.5220/0001993001510157
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