CFP last date
22 April 2024
Reseach Article

Using Snowflake Schema and Bitmap Index for Big Data Warehouse Volume

by Mohammed Benjelloun, Mohamed El Merouani, El Amin A. Abdelouarit
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 180 - Number 8
Year of Publication: 2017
Authors: Mohammed Benjelloun, Mohamed El Merouani, El Amin A. Abdelouarit
10.5120/ijca2017916049

Mohammed Benjelloun, Mohamed El Merouani, El Amin A. Abdelouarit . Using Snowflake Schema and Bitmap Index for Big Data Warehouse Volume. International Journal of Computer Applications. 180, 8 ( Dec 2017), 30-32. DOI=10.5120/ijca2017916049

@article{ 10.5120/ijca2017916049,
author = { Mohammed Benjelloun, Mohamed El Merouani, El Amin A. Abdelouarit },
title = { Using Snowflake Schema and Bitmap Index for Big Data Warehouse Volume },
journal = { International Journal of Computer Applications },
issue_date = { Dec 2017 },
volume = { 180 },
number = { 8 },
month = { Dec },
year = { 2017 },
issn = { 0975-8887 },
pages = { 30-32 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume180/number8/28822-2017916049/ },
doi = { 10.5120/ijca2017916049 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T01:00:07.374915+05:30
%A Mohammed Benjelloun
%A Mohamed El Merouani
%A El Amin A. Abdelouarit
%T Using Snowflake Schema and Bitmap Index for Big Data Warehouse Volume
%J International Journal of Computer Applications
%@ 0975-8887
%V 180
%N 8
%P 30-32
%D 2017
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Designing a data warehouse is the most important action done by the designer; it is a risk study of its performance as per it’s criticity while going to production. It Is known that hardware has developed in term of memory volume and speed, storage… but to minimize the execution time and the storage space still being the main objective for data warehousing specialists. This paper shows the advantage of using bitmap index and partitioned fact tables in big data warehouses volumes based on a snowflake schema based on compression.

References
  1. 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
  2. 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.
  3. 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.
  4. 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
  5. S. Chaudhuri, U. Dayal,An Overview of Data Warehousing and OLAP Technology., ACM SIGMOD RECORD. 1997
  6. 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.
  7. R. Kimball, L. Reeves, M. Ross, The Data Warehouse Toolkit. John Wiley Sons, NEW YORK, 2nd edition, 2002.
  8. W. Inmon, Building the Data Warehouse., John Wiley Sons, fourth edition, 2005.
  9. 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.
  10. R. Kimball and K. Strehlo. Why decision support fails and how to fix it. SIGMOD Record, 24(3) :92–97, September 1995.
  11. E. Sidi, E. Abdelouarit, M. El Merouani, Star Schema Advantages on Data Warehouse: Using Bitmap Index and Partitioned Fact Tables, International Journal of Computer Applications (973-93-80890-95-3) Volume 134 – No13, January 2016.
  12. E. Sidi, E. Abdelouarit, M. El Merouani, The Impact of Partitioned Fact Tables and Bitmap Index on Data Warehouse Performance, International Journal of Computer Applications (973-93-80891-16-1) Volume 135 – No13, February 2016.
Index Terms

Computer Science
Information Sciences

Keywords

Data Warehouse DBMS Indexes Business Intelligence