文档介绍：摘 要
随着软件和网络应用的迅速发展,数据库的应用越来越广泛,发挥的作用也越来越重要,数据库管理系统已经成为企业的核心 IT 系统,大数据量、高并发度也越来越成为企业业务处理系统的首要特征,数据库的处理性能也就成了影响企业应用系统性能的主要瓶颈,这也使得数据库的性能评测尤为重要。
TPC-E 是由事务性能委员会推出的用于测试系统联机事务处理能力的新性能测试基准,它能够比较客观、真实、全面的反映系统的事务处理能力。
基于上述的需求,设计和开发一款基于 TPC-E 基准的性能测试系统 TPCEDriver, 该系统实现了对数据库管理系统的事务处理能力进行评测的功能。该测试系统严格遵循了 TPC-E 基准规范,实现了规范中限定由测试方提供的各功能单元。在功能设计上,该基准测试系统借鉴了目前比较流行的基准实施系统架构的设计思想,并取其所长,对该系统的功能进行设计,使系统更加实用,功能更加完善,测试结果更加真实。在系统实现上,采用了面向对象的程序设计方法,提出并实现了事务模拟消息生成、响应消息接收以及测试状态信息实时监控等处理模型,有效的解决了系统实施中遇到的问题。
实验证明该基准测试系统能够完成数据库性能测试的任务,测试结果能够比较客观真实地反应被测系统的事务处理能力。
关键字:关系数据库,性能测试,基准测试
Abstract
With the rapid development of software work, database application e more and more widely, and play more and more important role, DataBase Manage System have e firm’s core IT system, huge data volume and high concurrency also e the primary features of the enterprise business processing system, database processing performance of enterprise applications will e the main bottleneck in system performance, which makes database performance evaluation is particularly import.
TPC-E is a new performance benchmark that launched by the Transaction Processing Performance Council. TPC-E is used to test the system’s online transaction processing capabilities, it can be more objective, real, plete reflects the system’s transaction processing capabilities.
Based on the above requirements, design and develop a performance evaluation system TPCEDriver based on the TPC-E benchmark, released the function of DBMS transaction processing capacity evaluation. The evaluation system strictly follows the TPC-E benchmark specification, realized the functional units which need supplied by the sponsor. In the functional design, the evaluation system reference current popular architecture, and better improved to make the system more practical and perfect, the test result also more real. In the system implementation, using Object-Oriented programming method, propose and implement transaction simulate message generation model, respon