International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
Volume 180 - Issue 15 |
Published: Jan 2018 |
Authors: Mohammed Benjelloun, Mohamed El Merouani, El Amin A. Abdelouarit |
![]() |
Mohammed Benjelloun, Mohamed El Merouani, El Amin A. Abdelouarit . Impact of using Snowflake Schema and Bitmap Index on Data Warehouse Querying. International Journal of Computer Applications. 180, 15 (Jan 2018), 33-35. DOI=10.5120/ijca2018916286
@article{ 10.5120/ijca2018916286, author = { Mohammed Benjelloun,Mohamed El Merouani,El Amin A. Abdelouarit }, title = { Impact of using Snowflake Schema and Bitmap Index on Data Warehouse Querying }, journal = { International Journal of Computer Applications }, year = { 2018 }, volume = { 180 }, number = { 15 }, pages = { 33-35 }, doi = { 10.5120/ijca2018916286 }, publisher = { Foundation of Computer Science (FCS), NY, USA } }
%0 Journal Article %D 2018 %A Mohammed Benjelloun %A Mohamed El Merouani %A El Amin A. Abdelouarit %T Impact of using Snowflake Schema and Bitmap Index on Data Warehouse Querying%T %J International Journal of Computer Applications %V 180 %N 15 %P 33-35 %R 10.5120/ijca2018916286 %I Foundation of Computer Science (FCS), NY, USA
Designing a data warehouse is the most important task realized by the designer; going to production is considered a remarkable phase to test the data warehouse performance based on it design. 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 query execution time.