Treble Phase Compression for better efficiency of Columnar Database using RL-Huffman based LZW Coding

Data compression is now essential for applications such as transmission and storage in data bases. In this paper, we propose a method to reduce data volume stored in Columnar Database with the help of Treble Compression technique which includes combination of three lossless compression techniques. The proposed technique includes Run Length Encoding, Lempel-Ziv Welch and Huffman data compression methods which are lossless in manner. Many factors depend on compression ratio such as storage space in Hard disk, Cache locality, and transmission over media. It is a method and system used in the column oriented database for transferring data from a digital data source to a digital data receiver with refined efficiency. The double compression test based on Run Length and Huffman encoding called as RL-Huffman gives better compression result than a single compression test, we determine the case in which the triple phased Treble compression will provide a better efficiency with the help of compression ratio. The goal is achieved by using combination of three techniques on a raw Column based Database to provide better efficiency than a single compression algorithm. Data compression is now essential for applications such as transmission and storage in data bases. In this paper, we propose a method to reduce data volume stored in Columnar Database with the help of Treble Compression technique which includes combination of three lossless compression techniques. The proposed technique includes Run Length Encoding, Lempel-Ziv Welch and Huffman data compression methods which are lossless in manner. Many factors depend on compression ratio such as storage space in Hard disk, Cache locality, and transmission over media. It is a method and system used in the column oriented database for transferring data from a digital data source to a digital data receiver with refined efficiency. The double compression test based on Run Length and Huffman encoding called as RL-Huffman gives better compression result than a single compression test, we determine the case in which the triple phased Treble compression will provide a better efficiency with the help of compression ratio. The goal is achieved by using combination of three techniques on a raw Column based Database to provide better efficiency than a single compression algorithm. database into a collection of individual columns that are stored separately. By storing each column separately on disk, these column-based systems enable queries to read just the attributes they need, rather than reading entire rows from disk and discard unneeded attributes once they are in memory. A similar benefit is true while transferring data from main memory to CPU registers, improving the overall utilization of the available I/O and memory bandwidth. Overall, taking the column-oriented approach to the extreme allows for numerous innovations in terms of database architectures. (12) In this paper, we discuss optimization of column-stores with compression with higher compression level achieving high compression rate than a single or a double compression with a minimal elapsed time.