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

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