Evaluation of Bitmap Index Compression using Data Pump in Oracle Database

Bitmap index is most commonly used technique for efficient query processing and mostly in the Data warehouse environment. The authors review the existing technologies of Compression and introduce the bitmap index compression through data pump. According to conventional wisdom bitmap index is more efficient for minimum unique value. But through data pump it doesn't require either bitmap index is created on high degree of cardinality or low degree of cardinality. In this paper, they propose data pump utility for release the disk space in database after deletion of records.

Provided by: IOSR Journal of Engineering Topic: Big Data Date Added: May 2014 Format: PDF

Find By Topic