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
- EP ID EP131757
- DOI 10.9790/0661-16334348
- Views 174
- Downloads 0
Comparison Of Performance In Image Restoration By Time And Frequency Domain Techniques
Image Processing is a practice of signal processing aimed at which the input is an image, for instance a photograph or video frame. Also the output of image processing might be either an image or some set of characterist...
Improving the Security Layer logic for a Health Care Information System
Abstract: In a previous paper we suggested an information system to store, manage and treat millions of the gathered patient’s information. We were able to propose a reliable application, which is able to fulfill the mos...
A New Approach for Improving Performance of Intrusion Detection System over MANET
A Mobile Ad-hoc Network (MANET) is one of the busy and public networks; Because of this the network suffers from the problems of different kind of attacks. In such attacks some malicious nodes are present that fa...
Building a Diabetes Data Warehouse to Support Decision making in healthcare industry
Abstract : data warehousing did not find its way easily and readily into healthcare and medicine, not like others financial institutions, Healthcare presents unique challenges for the architect of a data warehouse...
Software Engineering Process in Web Application Development
Abstract: The methods used for the development of conventional software engineering models cannot be useddirectly for the development of web based applications. This paper identifies and analyses the variousadaptat...