数据压缩相关技术

1. 压缩的技术实现

(1).压缩评估

execute function task("table estimate_compression", "tabname", "dbname", "informix");

(2).压缩

execute function task("table compress repack shrink", "tabname", "dbname", "informix");

(3).解压

execute function task("table uncompress", "tabname", "dbname", "informix");

(4).重组

execute function task("table repack_offline","folk","music","janna");

execute function task("table shrink","folk","music","janna");

(5).压缩某个片

execute function admin("fragment compress","14680071");

execute function task("fragment repack shrink", "14680071");

其中14680071是表的其中一个分区号，你可以通过下面的查询得到表的所有的分区名称、分区号和分区表达式：

select

 a.tabname,b.dbspace,b.partn as partnum,b.exprtext as expression

from systables a,sysfragments

where a.tabid=b.tabid and a.tabname=’tabname’;

(6).在线解压和离线解压

execute function task("table uncompress","rock","music","mario");

execute function task("fragment uncompress_offline," "14680071");