【正文】 本 科 生 畢 業(yè) 論 文（設(shè) 計(jì)）中文題目：基于 TPC_C 基準(zhǔn)數(shù)據(jù)庫(kù)系統(tǒng)性能測(cè)試的實(shí)現(xiàn)外文題目：The Implementation of Database System Performance Testing Based on TPC_C Benchmark 基于 TPC_C 基準(zhǔn)數(shù)據(jù)庫(kù)系統(tǒng)性能測(cè)試的實(shí)現(xiàn)摘 要數(shù)據(jù)庫(kù)系統(tǒng)是目前 web 系統(tǒng)普遍使用的系統(tǒng)，當(dāng)前有很多流行的數(shù)據(jù)庫(kù)，比如 DB2,Oracle、SQL 等大型數(shù)據(jù)庫(kù)，數(shù)據(jù)庫(kù)系統(tǒng)的性能決定著系統(tǒng)的總體性能，數(shù)據(jù)庫(kù)的性能如何評(píng)價(jià)，評(píng)價(jià)的指標(biāo)都包含哪些內(nèi)容等問(wèn)題都是對(duì)數(shù)據(jù)庫(kù)進(jìn)行整體評(píng)價(jià)必須做出回答的?；谝陨系膯?wèn)題，本文主要介紹了數(shù)據(jù)庫(kù)性能的評(píng)價(jià)指標(biāo)、測(cè)試方法、內(nèi)容，以 SQL 數(shù)據(jù)庫(kù)為測(cè)試對(duì)象，實(shí)現(xiàn)了基于 TPC_C（TPC BnechmarkTM C）測(cè)試基準(zhǔn)的測(cè)試事務(wù)模型，并采用當(dāng)前流行的數(shù)據(jù)庫(kù)測(cè)試軟件 LoadRunner 通過(guò)腳本的錄入、不同場(chǎng)景設(shè)置等對(duì)該系統(tǒng)進(jìn)行測(cè)試，找出系統(tǒng)的瓶頸并進(jìn)一步提出該進(jìn)方案。關(guān)鍵詞：數(shù)據(jù)庫(kù) SQL Sever LoadRunner 性能測(cè)試The Implementation of Database System Performance Testing Based on TPC_C BenchmarkAbstractDatabase system is a system monly used in web systems, currently there are many popular databases such as DB2, Oracle, SQL Sever etc. The database system39。s 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目 錄摘 要 ........................................................................................................................................................IABSTRACT.............................................................................................................................................II目 錄 .....................................................................................................................................................III1．緒 論 .....................................................................................................1 課題研究背景與意義 .......................................................................................1 國(guó)內(nèi)外數(shù)據(jù)庫(kù)性能測(cè)試的研究狀況 ...............................................................1 本文的主要工作 ...............................................................................................4 本文組織結(jié)構(gòu) ...................................................................................................42．?dāng)?shù)據(jù)庫(kù)性能測(cè)試 ....................................................................................5 數(shù)據(jù)庫(kù)性能測(cè)試方法及內(nèi)容 ...........................................................................5 性能測(cè)試分類 .........................................................................................5 性能測(cè)試指標(biāo) ..........................................................................................6 性能測(cè)試工具 LOADRUNNER 介紹 .................................................................7 LoadRunner 的特點(diǎn) ..................................................................................7 LoadRunner 功能描述 ...........................................................................8 LoadRunner 測(cè)試步驟 ...........................................................................83. 基于 TPC_C 基準(zhǔn)事務(wù)的實(shí)現(xiàn) ............................................................9 TPC_C 基準(zhǔn)總述 ...........................................................................................9 TPC_C 簡(jiǎn)介 ..........................................................................................9 TPC_C 測(cè)試指標(biāo) .................................................................................10 基于 TPC_C 基準(zhǔn)數(shù)據(jù)庫(kù)設(shè)計(jì) .....................................................................12 SQL Server 2022 中表的設(shè)計(jì) ............................................................12 表的結(jié)構(gòu)關(guān)系 .....................................................................................14 TPC_C 基 準(zhǔn) 數(shù)據(jù)錄入 ........................................................................15 基于 TPC_C 基準(zhǔn)事務(wù)模型的實(shí)現(xiàn) .............................................................17 NEW ORDER（新訂單）事務(wù)的實(shí)現(xiàn) ................................................17 PAYMENT（支付）事務(wù)的實(shí)現(xiàn) ........................................................19 DELIVERY（發(fā)貨）事務(wù)的實(shí)現(xiàn) ........................................................21 STOCK LEVEL（庫(kù)存狀況查詢）事務(wù)實(shí)現(xiàn) .....................................22 ORDER STATUS（訂單狀況查詢）事務(wù)的實(shí)現(xiàn) ..............................224. 測(cè)試方案及結(jié)果分析 ..........................................................................24 測(cè)試方案 ..........................................................................................................24 測(cè)試場(chǎng)景設(shè)置 ..................................................................................................29 測(cè)試結(jié)果分析 ..................................................................................................32 系統(tǒng)瓶頸分析 ..................................................................................................385. 全文總結(jié)和展望 ....................................................................................40 全文總結(jié) ..........................................................................................................40 展望 ..................................................................................................................40參考文獻(xiàn) .................................................................................................................................................41致 謝 .......................................................................................................................................................421．緒 論 課題研究背景與意義隨著軟件業(yè)的迅猛發(fā)展，系統(tǒng)開發(fā)的結(jié)構(gòu)層次在不斷地加深，數(shù)據(jù)庫(kù)從以前一個(gè)默默無(wú)聞的后臺(tái)倉(cāng)庫(kù)，逐漸演變?yōu)榻裉斓臄?shù)據(jù)庫(kù)系統(tǒng)，他在很多系統(tǒng)的設(shè)計(jì)中起著舉足輕重的作用，對(duì)于其性能的要求也越來(lái)越高，數(shù)據(jù)庫(kù)測(cè)試開發(fā)也逐漸演變出一些適合其特點(diǎn)的測(cè)試方法和工具 [7]。數(shù)據(jù)庫(kù)的測(cè)試同其他軟件測(cè)試一樣，包含性能測(cè)試和功能測(cè)試兩種。其中功能測(cè)試的目的是驗(yàn)證系統(tǒng)是否實(shí)現(xiàn)了用戶要求的所有功能要求；而性能測(cè)試的目的是驗(yàn)證軟件系統(tǒng)是否能夠達(dá)到用戶提出的性能指標(biāo)發(fā)現(xiàn)軟件系統(tǒng)中存在的性能