123,123,123

內(nèi)容簡(jiǎn)介

　　本書以達(dá)夢(mèng)數(shù)據(jù)庫(kù)DM8 為藍(lán)本，圍繞DM8 性能為什么優(yōu)化、誰(shuí)來優(yōu)化、優(yōu)化什么、何時(shí)優(yōu)化、優(yōu)化到什么程度等問題進(jìn)行詳細(xì)介紹，從DM8 體系架構(gòu)入手，分析了DM8 的運(yùn)行機(jī)制，從DM8 的實(shí)例優(yōu)化、I/O 優(yōu)化、SQL 語(yǔ)句優(yōu)化3 個(gè)方面詳細(xì)地介紹了影響DM8 性能的核心問題。全書共6 章，內(nèi)容包括DM8 性能優(yōu)化概述、DM8體系架構(gòu)、DM8 調(diào)優(yōu)診斷工具、DM8 實(shí)例優(yōu)化、DM8 I/O 優(yōu)化和DM8 SQL 語(yǔ)句優(yōu)化等。同時(shí)，本書還將DM8 參數(shù)配置文件相關(guān)參數(shù)、DM8 系統(tǒng)數(shù)據(jù)字典和DM8 常用動(dòng)態(tài)性能視圖作為附錄，便于廣大讀者查閱。本書內(nèi)容實(shí)用、示例豐富、語(yǔ)言通俗、格式規(guī)范，可以作為計(jì)算機(jī)、數(shù)據(jù)庫(kù)等專業(yè)的教材，也可以作為工程技術(shù)人員的參考用書。

作者簡(jiǎn)介

　　曾昭文，教授，主要從事數(shù)據(jù)工程和知識(shí)管理相關(guān)研究，主持軍隊(duì)重大科研項(xiàng)目10余項(xiàng)，先后獲軍隊(duì)科技進(jìn)步二等獎(jiǎng)1項(xiàng)、三等獎(jiǎng)多項(xiàng)，獲軍隊(duì)教學(xué)成果二等獎(jiǎng)1項(xiàng)，出版專著4部。

圖書目錄

第1 章DM8 性能優(yōu)化概述··············································································1
1.1 優(yōu)化的基本概念·················································································1
1.1.1 為什么優(yōu)化···············································································1
1.1.2 誰(shuí)來優(yōu)化··················································································2
1.1.3 優(yōu)化什么··················································································2
1.1.4 何時(shí)優(yōu)化··················································································4
1.1.5 優(yōu)化到什么程度·········································································6
1.2 優(yōu)化的基本思路·················································································7
1.2.1 數(shù)據(jù)庫(kù)全面健康檢查···································································7
1.2.2 優(yōu)化階段設(shè)計(jì)············································································7
1.2.3 數(shù)據(jù)庫(kù)配置···············································································8
1.2.4 添加新的應(yīng)用程序······································································8
1.2.5 運(yùn)行過程的優(yōu)化·········································································8
1.2.6 生產(chǎn)環(huán)境中優(yōu)化的特殊問題··························································9
1.3 優(yōu)化的基本步驟··············································································.10
1.3.1 問題分析···············································································.10
1.3.2 監(jiān)控系統(tǒng)性能·········································································.11
1.3.3 數(shù)據(jù)庫(kù)重演（REPLAY） ··························································.11
1.3.4 檢查數(shù)據(jù)物理一致性································································.12
1.3.5 優(yōu)化數(shù)據(jù)庫(kù)布局······································································.12
1.4 數(shù)據(jù)庫(kù)優(yōu)化誤區(qū)··············································································.13
第2 章 DM8 體系架構(gòu)·················································································.14
2.1 總體構(gòu)成·······················································································.14
2.1.1 數(shù)據(jù)庫(kù)··················································································.15
2.1.2 實(shí)例·····················································································.15
2.2 物理存儲(chǔ)結(jié)構(gòu)·················································································.15
2.2.1 配置文件···············································································.16
2.2.2 控制文件···············································································.16
2.2.3 數(shù)據(jù)文件···············································································.17
2.2.4 日志文件················································································18
2.2.5 備份文件················································································21
2.2.6 數(shù)據(jù)重演文件··········································································21
2.3 邏輯存儲(chǔ)結(jié)構(gòu)···················································································21
2.3.1 表空間···················································································21
2.3.2 段·························································································24
2.3.3 簇·························································································25
2.3.4 頁(yè)·························································································26
2.3.5 記錄······················································································27
2.4 DM8 內(nèi)存結(jié)構(gòu)··················································································27
2.4.1 內(nèi)存池···················································································27
2.4.2 緩沖區(qū)···················································································28
2.4.3 排序區(qū)···················································································30
2.4.4 哈希區(qū)···················································································31
2.5 DM8 線程結(jié)構(gòu)··················································································31
2.5.1 監(jiān)聽線程·······················2