Oracle 11g数据库的OLTP表压缩评测.pdfVIP

。iGITALlZ仨D HOSPiTAL Oraclé 11g数据库的OLTP表压缩评测 Evaluation of OLTP Table Compression of Oracle 11g Database [摘要}目的使用量化指标，对比压缩表和非压缩表的查询及更新操作性能进行评测，为大型联 史洪飞，刘志敏 机事务处理的数据库应用做技术准备。方法进行实验设计，创建量化平台，分别在压缩与非压 解放军总医院计算机室， 缩的数据表上执行特定的数据操纵语句及查询语句，生成结构化查询语言 (SQL) 数据库执行计 北京 1∞853 划，记录运行时间及结果并进行对比。结果压缩表的空间占用较未压缩表降低1倍多，全表扫撼 操作的性能提升1倍，而压缩表与未压缩表的数据更新操作和查询操作性能无明显差异。结论联 机事务处理的大型应用，可以利用Oraclellg数据库的新特性，采用。LTP表压缩技术，既不影响 操作响应时间还可以明显降低磁盘占用空间，从而获得改善数据库性能的好处。 [关键诩]岛配le数据库; SQL; 表压缩技术; HIS Abstract: Objective Using quantitative indicators to contrast query of compressed table and non- ωmpressed table, and upda忧也eir operation performanceωmake technical preparations for database application of the large scale online 仕ansaction processing (OLTP). Methods Making experimental 也sign and buílding appropriate pla:旺。rm. Performing spec谊c data manipulation and qu町statements on the compressed table and non-compressed tables respectively, and generating execution plan of structured qu町language (SQL) datab即. Then record血g andωmp缸ing the running time and results. Results Space occupied by the compressed table is less than half of space occupied by non-compressed table whîle full table scan operation performance is doubled. However, there is no sign姐cant diffi衍enc串 between performance of data update and query operations of compressed and non-compressed tables.