Evaluation of Bitmap Index Compression using Data Pump in Oracle Database

Journal Title: IOSR Journals (IOSR Journal of Computer Engineering) - Year 2014, Vol 16, Issue 3

Abstract

 Abstract: Bitmap index is most commonly used technique for efficient query processing and mostly in the Data warehouse environment. We 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, we propose data pump utility for release the disk space in database after deletion of records. Bitmap index point the old location even after deletion of records from table, This utility doesn’t release disk space. We have implemented data pump for compression, to release the space and change the index pointing location. Data pump which is often used for logical backups in oracle database. Finally we review the bitmap index which commonly used for industrial purpose and discuss open issues for future evolution and development.

Authors and Affiliations

Shivam Dwivedi# , Dr. Savita Shiwani#

Keywords

Related Articles

 An encrypted mechanism for securing cloud data from data mining attacks

 Abstract: Cloud Computing is a vast infrastructural and rising pool which provides huge storage of data in one sphere. Organizations nowadays are in the marathon of equipping the whole system in a cloud form. In th...

 A Modified Algorithmic Approach of DSDV Routing Protocol for Wireless Ad Hoc Network

 An ad-hoc network is the cooperative engagement of a collection of Mobile Hosts without the required intervention of any centralized Access Point. A Mobile Ad hoc NETwork called MANET is a kind of wireless ad-h...

 An Intelligent Decision Support System Using Adaptive Network-Based Fuzzy Inference System (ANFIS) For Choosing Suitable Bank Loan Installments

 Abstract : Choosing the best bank to obtain a loan from has become a dilemma for many loan applicants; Thus the need to automate the process throughout establishing an intelligent decision support system (IDSS) to...

 Communist Manifesto Marx’s Published Work (1818-1883):A Critique

 This study titled “Communist Manifesto; Marx’s Published Work (1818-1883): A critique has been carried out to briefly examine the biography of Marx, his philosophical ideas and intellectual role, as the most great...

A Study of Two Different Attacks to IPv6 Network

In the lights of today and future advancing technologies, the demand of IPv6 internet protocol, had becomes crucial for its usages & benefits. This paper investigates the use of information messages to build a visual per...

Download PDF file
  • EP ID EP131757
  • DOI 10.9790/0661-16334348
  • Views 172
  • Downloads 0

How To Cite

Shivam Dwivedi#, Dr. Savita Shiwani# (2014).  Evaluation of Bitmap Index Compression using Data Pump in Oracle Database. IOSR Journals (IOSR Journal of Computer Engineering), 16(3), 43-48. https://europub.co.uk/articles/-A-131757