Using Snowflake Schema and Bitmap Index for Big Data Warehouse Volume | Zendy

Mohammed Benjelloun | Zendy; Mohamed El | Zendy; El Amin | Zendy

AI Assistant Blog Pricing

Home ZAIA Blog

Open Access

Using Snowflake Schema and Bitmap Index for Big Data Warehouse Volume

Author(s) -

Mohammed Benjelloun,

Mohamed El,

El Amin

Publication year - 2017

Publication title -

international journal of computer applications

Language(s) - English

Resource type - Journals

ISSN - 0975-8887

DOI - 10.5120/ijca2017916049

Subject(s) - computer science , data warehouse , bitmap , schema (genetic algorithms) , volume (thermodynamics) , star schema , database , index (typography) , data mining , information retrieval , computer graphics (images) , world wide web , database design , database schema , physics , quantum mechanics

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. General Terms Business Intelligence, Data Warehouse.

The content you want is available to Zendy users.

Already have an account? Click here to sign in.

Having issues? You can contact us here

Accelerating Research