INFORMIX系統(tǒng)管理員指南

第1章  緒論                  
                   
 1.1  數(shù)據(jù)庫(kù)技術(shù)及其發(fā)展                  
 1.2  Informix數(shù)據(jù)庫(kù)產(chǎn)品簡(jiǎn)介                  
 1.2.1  數(shù)據(jù)庫(kù)引擎                  
 1.2.2  分布式數(shù)據(jù)庫(kù)連接產(chǎn)品                  
 1.2.3  Informix開發(fā)工具                  
 1.2.4  對(duì)象關(guān)系型數(shù)據(jù)庫(kù)簡(jiǎn)介                  
 1.3  構(gòu)造客戶/服務(wù)器結(jié)構(gòu)的Informix數(shù)據(jù)庫(kù)系統(tǒng)                  
 1.3.1  客戶/服務(wù)器結(jié)構(gòu)的DBMS的功能劃分                  
 1.3.2  單服務(wù)器和多服務(wù)器結(jié)構(gòu)                  
 1.4  Informix-Online數(shù)據(jù)庫(kù)                  
 1.4.1  數(shù)據(jù)庫(kù)管理系統(tǒng)及數(shù)據(jù)庫(kù)管理員                  
 1.4.2  STORES數(shù)據(jù)庫(kù)及表                  
 1.4.3  Informix-Online動(dòng)態(tài)服務(wù)器的基本術(shù)語(yǔ)                  
 1.4.4  關(guān)于事務(wù)                  
                   
 第2章  Informix-Online Dynamic Server安裝簡(jiǎn)介                  
                   
 2.1  安裝準(zhǔn)備                  
 2.2  安裝步驟                  
 2.3  Informix-Online數(shù)據(jù)庫(kù)服務(wù)器日常管理須知                  
 2.4  Informix-Online 5.x安裝                  
 2.5  Informix-Online 7.x安裝                  
                   
 第3章 創(chuàng)建及管理數(shù)據(jù)庫(kù)和表                  
                   
 3.1  DB-ACCESS中的SQL                  
 3.2  操作數(shù)據(jù)庫(kù)的SQL語(yǔ)句                  
 3.2.1  建立數(shù)據(jù)庫(kù)                  
 3.2.2  關(guān)閉現(xiàn)行數(shù)據(jù)庫(kù)                  
 3.2.3  刪除數(shù)據(jù)庫(kù)                  
 3.2.4  重新命名數(shù)據(jù)庫(kù)                  
 3.3  操作表的SQL語(yǔ)句                  
 3.3.1  創(chuàng)建表                  
 3.3.2  修改表結(jié)構(gòu)                  
 3.4  分段技術(shù)                  
 3.4.1  分段技術(shù)的優(yōu)點(diǎn)                  
 3.4.2  分段技術(shù)的實(shí)現(xiàn)                  
 3.4.3  修改分段策略                  
 3.5  思考與練習(xí)                  
                   
 第4章  索引策略                  
                   
 4.1  索引的內(nèi)部機(jī)制                  
 4.2  索引的種類                  
 4.2.1  單值索引和可重復(fù)索引                  
 4.2.2  復(fù)合索引                  
 4.2.3  聚類索引                  
 4.3  索引的操作方法                  
 4.3.1  創(chuàng)建索引                  
 4.3.2  刪除索引                  
 4.3.3  索引重聚類                  
 4.4  索引規(guī)劃                  
 4.4.1  索引的優(yōu)點(diǎn)                  
 4.4.2  索引的開銷                  
 4.5  有關(guān)索引的指導(dǎo)性原則                  
 4.6  思考與練習(xí)                  
                   
 第5章  視圖                  
                   
 5.1  視圖的定義                  
 5.2  創(chuàng)建視圖                  
 5.2.1  對(duì)基表指定列的訪問                  
 5.2.2  對(duì)基表限定行的訪問                  
 5.2.3  創(chuàng)建一個(gè)含有虛擬字段的視圖                  
 5.2.4  創(chuàng)建連接表的視圖                  
 5.2.5  創(chuàng)建連接表的視圖                  
 5.2.6  基于視圖的視圖                  
 5.3  刪除視圖                  
 5.4  查詢視圖                  
 5.5  更新視圖                  
 5.5.1  對(duì)視圖更新的限制                  
 5.5.2  關(guān)于WITH CHECK OPTION語(yǔ)句                  
 5.6  思考與練習(xí)                  
                   
 第6章  Informix的查詢優(yōu)化器                  
                   
 6.1  查詢優(yōu)化所涉及的概念                  
 6.1.1  概述                  
 6.1.2  連接方法                  
 6.2  查詢優(yōu)化器的工作過程                  
 6.2.1  設(shè)置參數(shù)OPTCOMPIND                  
 6.2.2  查詢路徑                  
 6.2.3  優(yōu)化過程                  
 6.2.4  設(shè)定查詢優(yōu)化的模式                  
 6.2.5  查看優(yōu)化信息                  
 6.3  實(shí)例分析                  
                   
 第7章  統(tǒng)計(jì)更新與數(shù)據(jù)分布                  
                   
 7.1  統(tǒng)計(jì)更新語(yǔ)句                  
 7.2  關(guān)于MEDIUM模式與HIGH模式的統(tǒng)計(jì)更新                  
 7.2.1  數(shù)據(jù)分布                  
 7.2.2  MEDIUM模式和HIGH模式                  
 7.2.3  數(shù)據(jù)分布的產(chǎn)生過程                  
 7.2.4  決定數(shù)據(jù)分布的因素                  
 7.2.5  只產(chǎn)生數(shù)據(jù)分布                  
 7.3  關(guān)于數(shù)據(jù)分布的其他語(yǔ)句                  
 7.3.1  顯示桶的信息                  
 7.3.2  創(chuàng)建數(shù)據(jù)分布時(shí)空間的使用                  
 7.3.3  刪除分布                  
 7.3.4  改變表對(duì)數(shù)據(jù)分布產(chǎn)生的影響                  
 7.4  關(guān)于統(tǒng)計(jì)更新的一些指導(dǎo)性策略                  
 7.4.1  如何為優(yōu)化器產(chǎn)生一個(gè)大小合適且有效的樣本                  
 7.4.2  如何處理有問題的查詢                  
 7.4.3  如何使MEDIUM模式的統(tǒng)計(jì)更新達(dá)到HIGH模式的執(zhí)行效果                  
                   
 第8章  數(shù)據(jù)安全性——用戶存取權(quán)限控制                  
                   
 8.1  概述                  
 8.1.1  數(shù)據(jù)庫(kù)存取                  
 8.1.2  表/字段視圖級(jí)權(quán)限                  
 8.2  授予權(quán)限                  
 8.2.1  授予庫(kù)級(jí)權(quán)限                  
 8.2.2  授予表級(jí)權(quán)限                  
 8.2.3  授予字段級(jí)權(quán)限                  
 8.2.4  授予可執(zhí)行某個(gè)存儲(chǔ)過程的權(quán)限                  
 8.3  回收權(quán)限                  
 8.3.1  回收數(shù)據(jù)庫(kù)級(jí)權(quán)限                  
 8.3.2  回收表級(jí)權(quán)限                  
 8.4  關(guān)于角色                  
 8.4.1  創(chuàng)建角色                  
 8.4.2  劃分用戶角色                  
 8.4.3  授予角色權(quán)限                  
 8.4.4  激活角色                  
 8.5  實(shí)例分析                  
                   
 第9章 數(shù)據(jù)完整性                  
                   
 9.1  概述                  
 9.1.1  完整性約束條件分類                  
 9.1.2  實(shí)現(xiàn)數(shù)據(jù)完整的方式                  
 9.2  約束條件的定義與使用                  
 9.2.1  缺省值                  
 9.2.2  非空約束                  
 9.2.3  約束名                  
 9.2.4  檢查性約束                  
 9.2.5  單值約束                  
 9.2.6  參照約束                  
 9.3  刪除數(shù)據(jù)                  
 9.4  約束檢查機(jī)制                  
 9.4.1  立即執(zhí)行約束檢查                  
 9.4.2  延遲執(zhí)行約束檢查                  
 9.4.3  分開執(zhí)行約束檢查                  
                   
 第10章  并發(fā)控制與數(shù)據(jù)庫(kù)鎖                  
                   
 10.1  數(shù)據(jù)庫(kù)鎖的類型                  
 10.2  并發(fā)控制的類型                  
 10.3  四種隔離級(jí)的特點(diǎn)                  
 10.3.1  設(shè)置隔離級(jí)                  
 10.3.2  四種隔離級(jí)                  
 10.3.3  設(shè)置隔離級(jí)小結(jié)                  
 10.4  更新并發(fā)控制——鎖機(jī)制的種類                  
 10.4.1  庫(kù)級(jí)鎖的特點(diǎn)及使用                  
 10.4.2  表級(jí)鎖的特點(diǎn)及使用                  
 10.4.3  設(shè)置封鎖模式                  
 10.4.4  頁(yè)級(jí)鎖和行級(jí)鎖                  
 10.5  實(shí)例分析                  
                   
 第11章  模式與違例                  
                   
 11.1  數(shù)據(jù)庫(kù)對(duì)象及其模式                  
 11.1.1  數(shù)據(jù)庫(kù)對(duì)象的概念                  
 11.1.2  模式的概念                  
 11.1.3  數(shù)據(jù)庫(kù)對(duì)象及其模式的作用                  
 11.2  與數(shù)據(jù)庫(kù)對(duì)象模式有關(guān)的操作                  
 11.2.1  設(shè)置數(shù)據(jù)庫(kù)對(duì)象有效                  
 11.2.2  設(shè)置數(shù)據(jù)庫(kù)對(duì)象無(wú)效                  
 11.2.3  設(shè)置數(shù)據(jù)庫(kù)對(duì)象為過濾模式                  
 11.3  與數(shù)據(jù)庫(kù)對(duì)象模式及違例有關(guān)的系統(tǒng)表                  
 11.3.1  SYSOBJSTATE系統(tǒng)表                  
 11.3.2  SYSVIOLATIONS系統(tǒng)表                  
 11.4  實(shí)例分析                  
                   
 第12章  備份與恢復(fù)                  
                   
 12.1  Dbexport                  
 12.1.1  Dbexport的主要功能                  
 12.1.2  Dbexport的語(yǔ)法格式                  
 12.1.3  Dbexport應(yīng)用示例                  
 12.2  Dbimport                  
 12.2.1  Dbimport的主要功能                  
 12.2.2  Dbimport的語(yǔ)法格式                  
 12.2.3  使用Dbimport命令的注意事項(xiàng)                  
 12.2.4  Dbimport應(yīng)用示例                  
 12.3  Dbload                  
 12.3.1  Dbload的主要功能                  
 12.3.2  Dbload命令的選項(xiàng)                  
 12.3.3  Dbload應(yīng)用示例                  
 12.4  Onunload/Onload                  
 12.4.1  Onunload和Onload的功能                  
 12.4.2  Onunload的語(yǔ)法格式                  
 12.4.3  Onload的語(yǔ)法格式                  
                   
 附錄 A 系統(tǒng)一覽表                  
                   
 附錄 B dbschema實(shí)用程序