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