CFP last date
20 December 2024
Call for Paper
January Edition
IJCA solicits high quality original research papers for the upcoming January edition of the journal. The last date of research paper submission is 20 December 2024

Submit your paper
Know more
The week's pick
Responsive image
Improved Shuffled Frog Leaping Algorithm with Self-Adaptive Shuffling for Fuzzy Logic PD+G Controller Optimization in Robotic Manipulators

Duc Hoang Nguyen
Random Articles
Reseach Article

The Impact of Partitioned Fact Tables and Bitmap Index on Data Warehouse Performance

by Emany Sidi, Mohamed El Merouani, El Amin A. Abdelouarit
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 135 - Number 13
Year of Publication: 2016
Authors: Emany Sidi, Mohamed El Merouani, El Amin A. Abdelouarit
10.5120/ijca2016908598

Emany Sidi, Mohamed El Merouani, El Amin A. Abdelouarit . The Impact of Partitioned Fact Tables and Bitmap Index on Data Warehouse Performance. International Journal of Computer Applications. 135, 13 ( February 2016), 39-41. DOI=10.5120/ijca2016908598

@article{ 10.5120/ijca2016908598,
author = { Emany Sidi, Mohamed El Merouani, El Amin A. Abdelouarit },
title = { The Impact of Partitioned Fact Tables and Bitmap Index on Data Warehouse Performance },
journal = { International Journal of Computer Applications },
issue_date = { February 2016 },
volume = { 135 },
number = { 13 },
month = { February },
year = { 2016 },
issn = { 0975-8887 },
pages = { 39-41 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume135/number13/24113-2016908598/ },
doi = { 10.5120/ijca2016908598 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:35:45.594039+05:30
%A Emany Sidi
%A Mohamed El Merouani
%A El Amin A. Abdelouarit
%T The Impact of Partitioned Fact Tables and Bitmap Index on Data Warehouse Performance
%J International Journal of Computer Applications
%@ 0975-8887
%V 135
%N 13
%P 39-41
%D 2016
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The design process is the most considered task of a data warehouse designer, this because of its performance criticality while going to production. Even if technology has developed in term of memory volume and speed, storage… the fact to minimize the execution time and the storage space still being a preoccupation for data warehousing specialists. This papers shows that using bitmap index and partitioned fact tables in data warehouse based on a star schema is more advantageous based on compression.

References
  1. Emany Sidi, Mohamed El Merouani and El Amin A Abdelouarit. Article: Star Schema Advantages on Data Warehouse: Using Bitmap Index and Partitioned Fact Tables. International Journal of Computer Applications 134(13):11-13, January 2016.
  2. E. Abdelouarit, M. El Merouani, A. Medouri, The bitmap index advantages on the data warehouses American Academic & Scholarly Research Journal Vol. 6, No. 4, July 2014
  3. E. Abdelouarit, M. El Merouani, A. Medouri, Data Warehouse Tuning: The Supremacy of Bitmap Index International Journal of Computer Applications (0975 – 8887) Volume 79 – No7, October 2013.
  4. E. Abdelouarit, M. El Merouani, A. Medouri, The impact of indexes on data warehouse performance IJCSI International Journal of Computer Science Issues, Vol. 10, Issue 5, No 2, September 2013.
  5. E. Abdelouarit, M. El Merouani, A. Medouri, OPTIMISATION DES PERFORMANCES DES ENTREPÔTS Rev. Ivoir. Sci. Technol., 20 (2012) 35 - 67 ISSN 1813-3290, http://www.revist.ci
  6. S. Chaudhuri, U. Dayal,An Overview of Data Warehousing and OLAP Technology., ACM SIGMOD RECORD. 1997
  7. E. E-O’Neil and P. P-O’Neil, Bitmap index design choices and their performance impli-cations, Database Engineering and Applications Symposium. IDEAS 2007. 11th International, pp. 72-84.
  8. R. Kimball, L. Reeves, M. Ross, The Data Warehouse Toolkit. John Wiley Sons, NEW YORK, 2nd edition, 2002.
  9. W. Inmon, Building the Data Warehouse., John Wiley Sons, fourth edition, 2005.
  10. C. DELLAQUILA and E. LEFONS and F. TANGORRA, Design and Implementation of a National Data Warehouse. Proceedings of the 5th WSEAS Int. Conf. on Artificial Intelligence, Knowledge Engineering and Data Bases, Madrid, Spain, February 15-17, 2006 pp. 342-347.
  11. R. Kimball and K. Strehlo. Why decision support fails and how to fix it. SIGMOD Record, 24(3) :92–97, September 1995.
Index Terms

Computer Science
Information Sciences

Keywords

Data Warehouse DBMS Indexes Business Intelligence

Powered by PhDFocusTM