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

Evaluation of OLTP Table Compression of Oracle 11g database

目的使用量化指标,对比压缩表和非压缩表的查询及更新操作性能进行评测,为大型联机事务处理的数据库应用做技术准备。方法进行实验设计,创建量化平台,分别在压缩与非压缩的数据表上执行特定的数据操纵语句及查询语句,生成结构化查询语言(SQL)数据库执行计划,记录运行时间及结果并进行对比。结果压缩表的空间占用较未压缩表降低1倍多,全表扫描操作的性能提升1倍,而压缩表与未压缩表的数据更新操作和查询操作性能无明显差异。结论联机事务处理的大型应用,可以利用Oracle11g数据库的新特性,采用OLTP表压缩技术,既不影响操作响应时间还可以明显降低磁盘占用空间,从而获得改善数据库性能的好处。

Objective Using quantitative indicators to contrast query of compressed table and non- compressed table, and update their operation performance to make technical preparations for database application of the large scale online transaction processing （OLTP）. Methods Making experimental design and building appropriate platform. Performing specific data manipulation and query statements on the compressed table and non-compressed tables respectively, and generating execution plan of structured query language （SQL） database. Then recording and comparing the running time and results. Results Space occupied by the compressed table is less than half of space occupied by non-compressed table while full table scan operation performance is doubled. However, there is no significant difference between performance of data update and query operations of compressed and non-compressed tables. Conclusion Large scale OLTP applications can take advantage of the new features of Oracle 11 g for table compression technology, which neither affects the operation response time nor significantly reduces the disk space so as to obtain the benefits of improving performance.