Call for Paper - November 2019 Edition
IJCA solicits original research papers for the November 2019 Edition. Last date of manuscript submission is October 21, 2019. Read More

Star Schema Advantages on Data Warehouse: Using Bitmap Index and Partitioned Fact Tables

Print
PDF
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Year of Publication: 2016
Authors:
Emany Sidi, Mohamed El Merouani, El Amin A. Abdelouarit
10.5120/ijca2016908108

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. Published by Foundation of Computer Science (FCS), NY, USA. BibTeX

@article{key:article,
	author = {Emany Sidi and Mohamed El Merouani and El Amin A. Abdelouarit},
	title = {Article: Star Schema Advantages on Data Warehouse: Using Bitmap Index and Partitioned Fact Tables},
	journal = {International Journal of Computer Applications},
	year = {2016},
	volume = {134},
	number = {13},
	pages = {11-13},
	month = {January},
	note = {Published by Foundation of Computer Science (FCS), NY, USA}
}

Abstract

The data warehouse designer should consider it effectiveness while the design process, this might be a part of it work by analyzing the update frequency of production databases.

Actually, to decide in a small time interval becomes the most important concern for deciders, this because it’s always depending on data warehouse refresh using the ETLs and the cube generate process based on data warehouse schema type.

To present the KPI’s to the management quickly, we need to minimize the query execution time.

This papers shows that the star schema is more advantageous when using a bitmap index based on ETL query execution time and data access time.

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.

Keywords

Data Warehouse, DBMS, Indexes, Business Intelligence