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

Emany Sidi | Zendy; Mohamed El | Zendy; El Amin | Zendy

AI Assistant Blog Pricing

Home ZAIA Blog

Open Access

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

Author(s) -

Emany Sidi,

Mohamed El,

El Amin

Publication year - 2016

Publication title -

international journal of computer applications

Language(s) - English

Resource type - Journals

ISSN - 0975-8887

DOI - 10.5120/ijca2016908598

Subject(s) - computer science , bitmap , data warehouse , index (typography) , database , warehouse , table (database) , data mining , information retrieval , world wide web , computer graphics (images) , marketing , business

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. 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