Efficient Approach for Compression in Data Warehouse
Data compression has become most requisite and necessary part of data warehousing as it helps in saving disk space and improves query performance as well. Different compression techniques exist at different levels and each type of compression is either best from query processing point of view or compression ratio. This paper focuses on lossless compression for relational databases at attribute level. Efficient compression techniques allow transferring more data on a given bandwidth. The proposed technique in this paper is used at attribute level by compressing three types of attribute (string, integer and date type) and the most interesting feature is that it automatically identifies the type of attribute.