Turkish Journal of Computer and Mathematics Education
Journal license

Journal

Turkish Journal of Computer and Mathematics Education


Volume
& Issue

Volume 12, Issue 2


Published
on

April 5, 2021


Pages

1513-1520


DOI

Article

An Improved Framework for Bitmap Indexes and their Use in Data Warehouse Optimization


Authors

J. Preethaa Affiliation:
Department of Computer Science and Engineering, Muthayammal Engineering College(Autonomous), Rasipuram, Tamilnadu
, S. Lavanya Affiliation:
Department of Computer Science and Engineering, Muthayammal Engineering College(Autonomous), Rasipuram, Tamilnadu
, T. Kowsalya Affiliation:
Department of Electronics and Communication Engineering, Muthayammal Engineering College(Autonomous), Rasipuram, Tamilnadu
, C. Selvi Affiliation:
Department of Electronics and Communication Engineering, Muthayammal Engineering College(Autonomous), Rasipuram, Tamilnadu
and M. Ganthimathie Affiliation:
Department of Computer Science and Engineering, Muthayammal Engineering College(Autonomous), Rasipuram, Tamilnadu


Abstract

Compression technique is basically used to compress the size of table or reduce the storage area. Oracle already gives this feature for the table compression as well as for the index compression. when index is created on particular column of a table then it contain some space, which require some storage or disk space by this technique we can save our disk space because in industry the compan y have to purchase the disk space according to the size of the their data and pay according to their disk space. To utilize this disk space for useful records data rather than wasting it. In this paper used the data pump utility for the compression of Bitmap index and table. Da ta pump utility performed for the logical backups in database.in this paper implemented data pump for compression, to release the space and change the index pointing location. It will not release the space even after deletion of records. This is of special interest for the case to compress the bitmap index and table space along with the'S (Data Manipulation Language).


Keywords

Bitmap Index, Compression, Data Pump, DML, Query Performance


Citation

Preethaa, J., Lavanya, S., Kowsalya, T., Selvi, C., & Ganthimathie, M. (2021). An improved framework for bitmap indexes and their use in data warehouse optimization. Turkish Journal of Computer and Mathematics Education, 12(2), 1513–1520.

Published by: Engineering Journals

Engineering Journals Logo