Random Articles
Reseach Article
Efficient Approach for Compression in Data Warehouse
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 53 - Number 9 |
| Year of Publication: 2012 |
| Authors: Meenakshi Sharma, Sonia Dora |
10.5120/8446-2233
|
Meenakshi Sharma, Sonia Dora . Efficient Approach for Compression in Data Warehouse. International Journal of Computer Applications. 53, 9 ( September 2012), 1-3. DOI=10.5120/8446-2233
Abstract
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.
References
- J. Ziv and A. Lempel "A universal algorithm for sequential data compression" in IEEE transactions in information theory, vol. 3, no. 3, pp. 337-343(1977)
- Amy Turske McNee "The Evolutionary Data Warehouse--An Object-Oriented Approach" (2008)
- Jonathan Goldstein, Raghu Ramakrishnan ,Uri Shaft "Compressing relations and indexes "in IEEE computer society Washington,USA (1998)
- P. O'Neil and D. Quass. "Improved query performance with variant indexes," Proceedings of the ACM SIGIOD Conference, Tucson, Arizona, May, 1997.
- S. Chaudhuri and U. Dyal, "An overview of Data warehousing and OLAP Technology", ACM SIGMOD record, vol 21, no. 1.
- W. Kim, "Modern Database Systems", ACM Press. New York, New York, 1995
- G. Ray, J. R. Haritsa, and S. Seshadri. Database compression: A performance enhancement tool. In International Conference on Management of Data, pages 0, 1995.
- Jorge Vieira1, Jorge Bernardino2, Henrique Madeira3 "Efficient compression of text attributes of data warehouse dimensions" (2005)
- Akanksha Baid and Swetha Krishnan" Binary Encoded Attribute-Pairing Technique for Database Compression"( 2008)
- Goetz Graefe and Leonard D. Shapiro" Data Compression and Database Performance"(1991)
- Debra A. Lelewer and Daniel S. Hirschberg"Data Compression"(1987)
Index Terms
Keywords