發(fā)布時(shí)間：2018-10-30 13:18

【摘要】：隨著互聯(lián)網(wǎng)應(yīng)用和計(jì)算機(jī)信息系統(tǒng)的不斷發(fā)展，數(shù)據(jù)庫(kù)的應(yīng)用范圍越來(lái)越廣泛。伴隨著數(shù)據(jù)庫(kù)規(guī)模不斷地?cái)U(kuò)大，業(yè)務(wù)復(fù)雜程度不斷地增加，數(shù)據(jù)庫(kù)系統(tǒng)的性能問(wèn)題越來(lái)越突出，對(duì)數(shù)據(jù)庫(kù)性能進(jìn)行優(yōu)化也變得十分重要。 本文根據(jù)上海市垃圾物流管理平臺(tái)的運(yùn)行狀況，，結(jié)合MySQL優(yōu)化技術(shù)，對(duì)數(shù)據(jù)庫(kù)性能問(wèn)題進(jìn)行了深入分析，尋找出了造成性能降低的各種原因。根據(jù)分析出的問(wèn)題原因，提出了具體的數(shù)據(jù)庫(kù)優(yōu)化策略。 本文作者的主要研究?jī)?nèi)容和創(chuàng)新點(diǎn)概述如下： 1）分表技術(shù)的應(yīng)用研究。分析了數(shù)據(jù)庫(kù)分表的兩種方案及其適用場(chǎng)景，根據(jù)系統(tǒng)中大數(shù)據(jù)表的特點(diǎn)，采用了水平分表的方案。 2）服務(wù)器配置優(yōu)化的應(yīng)用研究。硬件方面，在分析了不同磁盤(pán)陣列的原理和應(yīng)用場(chǎng)景之后，采用RAID10的磁盤(pán)陣列策略。軟件方面，通過(guò)改善服務(wù)器配置，提高數(shù)據(jù)庫(kù)的并發(fā)性處理能力和緩存命中率。 3）SQL語(yǔ)句及索引優(yōu)化的應(yīng)用研究。在分析了SQL語(yǔ)句和索引優(yōu)化的基本方法后，針對(duì)系統(tǒng)中的慢查詢(xún)語(yǔ)句進(jìn)行了優(yōu)化。 4）Hibernate優(yōu)化的應(yīng)用研究。分析了J2EE系統(tǒng)中主流的持久層框架Hibernate的緩存機(jī)制，并提出了提升Hibernate緩存利用率的方法。 5）數(shù)據(jù)庫(kù)備份恢復(fù)策略的應(yīng)用研究。根據(jù)應(yīng)用系統(tǒng)特性，研究設(shè)計(jì)了基于Linux定時(shí)任務(wù)機(jī)制的自動(dòng)備份策略。 本文的研究工作已經(jīng)完成，提出的數(shù)據(jù)庫(kù)優(yōu)化策略在實(shí)踐中得到了實(shí)際檢驗(yàn)。實(shí)踐結(jié)果表明，本文提出的優(yōu)化策略對(duì)于關(guān)系型數(shù)據(jù)庫(kù)性能優(yōu)化方面具有積極的借鑒意義。
[Abstract]:With the development of Internet and computer information system, the application of database is more and more extensive. With the expansion of database scale and the increase of business complexity, the performance problem of database system becomes more and more serious, so it is very important to optimize database performance. According to the running situation of the garbage logistics management platform in Shanghai and the MySQL optimization technology, this paper makes a deep analysis of the database performance problems, and finds out the various causes of the performance degradation. According to the analysis of the causes of the problems, a specific database optimization strategy is put forward. The main research contents and innovations of this paper are summarized as follows: 1) the applied research of tabular technology. In this paper, two schemes and their applicable scenarios are analyzed. According to the characteristics of large data table in the system, the scheme of horizontal table is adopted. 2) the application research of server configuration optimization. In the aspect of hardware, after analyzing the principle and application scenario of different disk array, RAID10's disk array strategy is adopted. Software, through improving server configuration, improve database concurrency processing ability and cache hit rate. 3) the application research of SQL statement and index optimization. After analyzing the basic methods of SQL and index optimization, the slow query statements in the system are optimized. 4) the application of Hibernate optimization. This paper analyzes the caching mechanism of Hibernate, the mainstream persistence layer framework in J2EE system, and puts forward a method to improve the utilization rate of Hibernate cache. 5) Research on the application of database backup recovery strategy. According to the characteristics of the application system, an automatic backup strategy based on Linux timing task mechanism is designed. The research work in this paper has been completed, and the proposed database optimization strategy has been tested in practice. The practical results show that the proposed optimization strategy has positive reference significance for the performance optimization of relational database.
【學(xué)位授予單位】：東華大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2015
【分類(lèi)號(hào)】：TP311.13

【相似文獻(xiàn)】

相關(guān)期刊論文 前10條

1 吳京慧;數(shù)據(jù)庫(kù)優(yōu)化技術(shù)分析研究[J];計(jì)算機(jī)與現(xiàn)代化;2004年12期

2 徐鑫濤;;淺談數(shù)據(jù)庫(kù)優(yōu)化[J];中國(guó)科技信息;2008年04期

3 周吉文;;醫(yī)院HIS系統(tǒng)數(shù)據(jù)庫(kù)優(yōu)化技術(shù)淺析[J];科技資訊;2008年23期

4 劉斌;湯曉兵;劉震;李盛恩;;基于數(shù)據(jù)庫(kù)優(yōu)化技術(shù)的查詢(xún)應(yīng)用[J];信息技術(shù)與信息化;2008年05期

5 李潔琦;;數(shù)據(jù)庫(kù)優(yōu)化技術(shù)探究[J];文教資料;2006年31期

6 姜樂(lè)樂(lè);單廣榮;王曉;張顯政;;民文數(shù)字圖書(shū)館數(shù)據(jù)庫(kù)優(yōu)化研究[J];甘肅科技縱橫;2009年02期

7 王強(qiáng);;高校綜合人力資源管理系統(tǒng)的數(shù)據(jù)庫(kù)優(yōu)化策略研究[J];電腦知識(shí)與技術(shù);2010年10期

8 劉文峰;;基于求解最優(yōu)路徑的數(shù)據(jù)庫(kù)優(yōu)化研究[J];計(jì)算機(jī)光盤(pán)軟件與應(yīng)用;2012年21期

9 烏嵐;;基于多樣約束模型的遠(yuǎn)程教育數(shù)據(jù)庫(kù)優(yōu)化查詢(xún)算法[J];科技通報(bào);2013年01期

10 吳t熇

本文編號(hào)：2300115