基于TPC_C基准数据库系统性能测试的实现--计算机系毕业论文推荐.docVIP

本 科 生 毕 业 论 文（设 计） 中文题目：基于TPC_C基准数据库系统性能测试的实现 外文题目：The Implementation of Database System Performance Testing Based on TPC_C Benchmark 基于TPC_C基准数据库系统性能测试的实现 摘 要 数据库系统是目前web系统普遍使用的系统，当前有很多流行的数据库，比如DB2,Oracle、SQL等大型数据库，数据库系统的性能决定着系统的总体性能，数据库的性能如何评价，评价的指标都包含哪些内容等问题都是对数据库进行整体评价必须做出回答的。 基于以上的问题，本文主要介绍了数据库性能的评价指标、测试方法、内容，以SQL数据库为测试对象，实现了基于TPC_C（TPC BnechmarkTM C）测试基准的测试事务模型，并采用当前流行的数据库测试软件LoadRunner通过脚本的录入、不同场景设置等对该系统进行测试，找出系统的瓶颈并进一步提出该进方案。 关键词：数据库SQL Sever LoadRunner 性能测试 The Implementation of Database System Performance Testing Based on TPC_C Benchmark Abstract Database system is a system commonly used in web systems, currently there are many popular databases such as DB2, Oracle, SQL Sever etc. The database systems performance determines the overall system performance. How to make an overall evaluation of the performance of the database? What evaluation indicators should be included? All these issues about the overall evaluation of the database must be made to answer. Accounting for the above issues, this paper describes the performance evaluation of database, test methods. Content to SQL database as the test object, this paper achieves the TPC_C (TPC BnechmarkTM C) benchmark tests based on transaction model and uses the popular database test software LoadRunner to make test on the system by script entry and different scene settings to identify system bottlenecks and further into the scheme of the improvement. Key Words: Database SQL Sever LoadRunner Performance Testing  目 录 TOC \o 1-3 \h \z \u HYPERLINK \l _Toc263888841 摘 要 PAGEREF _Toc263888841 \h I HYPERLINK \l _Toc263888842 Abstract PAGEREF _Toc263888842 \h II HYPERLINK \l _Toc263888843 目 录 PAGEREF _Toc263888843 \h III HYPERLINK \l _Toc263888844 1．绪 论 PAGEREF _Toc263888844 \h 1 HYPERLINK \l _Toc263888845 1.1 课题研究背景与意义 PAGEREF _Toc263888845 \h 1 HYPERLINK \l _Toc263888846 1.2 国内外数据库性能测试的研究状况 PAGEREF _Toc263888846 \h 1 HYPERLINK \l _Toc263888847 1.3 本文的主要工作 PAGEREF _Toc263888847 \h 4