J4 ›› 2009, Vol. 47 ›› Issue (05): 1013-1019.

Previous Articles     Next Articles

Retrieving Values from Compressed Data inColumnoriented Databases

HUANG Peng, LI Zhanshan, ZHANG Yonggang, JU Qi   

  1. College of Computer Science and Technology, Jilin University, Changchun 130012, China; |Symbol Computationand Knowledge Engineer of Ministry of Education, Jilin University, Changchun 130012, China
  • Received:2009-02-16 Online:2009-09-26 Published:2009-11-03
  • Contact: LI Zhanshan E-mail:zslizsli@163.com.

Abstract:

Based on the characteristics of data access in column oriented databases, the format of prevalent integer compression schemes is improved, and three integer compression algorithms and corresponding accessing algorithms on compressed data were proposed. Experiments show that retrieving data directly from compressed data without decompression is also very efficient, which thus powerfully supports the future computation on compressed data.

Key words: columnoriented database; data compression; , compressed data accessing; compressed SQL operation

CLC Number: 

  • TP391