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 company 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. Data 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).
Highlights
Index is the most suitable technique for fast query processing
Compression technique is basically used to reduce the size of objects [1]. This technique is used in various fields to save the disk space, compression doesn’t reduce the efficiency of object it only reduce the size of objects
Experiments and Results Query Performance with the Bitmap Index Sometime a problem exists in the database that is physical I/O or logical I/O
Summary
Index is the most suitable technique for fast query processing. Here bitmap index is most efficient index in oracle database. The purpose behind compression technique to use data pump and make the index size more efficient. Data pump technique is eligible to reduce all the database objects like table and index. Data pump is used in oracle database to take the logical backup of various objects like tables, index, schema, view [2].
Sign-in/Register to view highlights & summary Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: Turkish Journal of Computer and Mathematics Education (TURCOMAT)
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
