達夢數(shù)據(jù)庫性能優(yōu)化

定　價：￥98.00

作　者：	曾昭文等
出版社：	電子工業(yè)出版社
叢編項：
標　簽：	暫缺

購買這本書可以去

ISBN：	9787121431135	出版時間：	2022-04-01	包裝：	平塑
開本：	16開	頁數(shù)：	232	字數(shù)：

內(nèi)容簡介

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

作者簡介

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

圖書目錄

第1 章DM8 性能優(yōu)化概述··············································································1
1.1 優(yōu)化的基本概念·················································································1
1.1.1 為什么優(yōu)化···············································································1
1.1.2 誰來優(yōu)化··················································································2
1.1.3 優(yōu)化什么··················································································2
1.1.4 何時優(yōu)化··················································································4
1.1.5 優(yōu)化到什么程度·········································································6
1.2 優(yōu)化的基本思路·················································································7
1.2.1 數(shù)據(jù)庫全面健康檢查···································································7
1.2.2 優(yōu)化階段設(shè)計············································································7
1.2.3 數(shù)據(jù)庫配置···············································································8
1.2.4 添加新的應用程序······································································8
1.2.5 運行過程的優(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ù)庫重演（REPLAY） ··························································.11
1.3.4 檢查數(shù)據(jù)物理一致性································································.12
1.3.5 優(yōu)化數(shù)據(jù)庫布局······································································.12
1.4 數(shù)據(jù)庫優(yōu)化誤區(qū)··············································································.13
第2 章 DM8 體系架構(gòu)·················································································.14
2.1 總體構(gòu)成·······················································································.14
2.1.1 數(shù)據(jù)庫··················································································.15
2.1.2 實例·····················································································.15
2.2 物理存儲結(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 邏輯存儲結(jié)構(gòu)···················································································21
2.3.1 表空間···················································································21
2.3.2 段·························································································24
2.3.3 簇·························································································25
2.3.4 頁·························································································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