數(shù)據(jù)庫系統(tǒng)基礎(chǔ)教程

第1章數(shù)據(jù)庫系統(tǒng)概述                  
 1.1數(shù)據(jù)管理的進展1                  
 1.1.1數(shù)據(jù)管理的三個階段1                  
 1.1.2數(shù)據(jù)庫技術(shù)的發(fā)展6                  
 1.2數(shù)據(jù)模型7                  
 1.2.1數(shù)據(jù)模型的組成8                  
 1.2.2層次數(shù)據(jù)模型9                  
 1.2.3網(wǎng)狀數(shù)據(jù)模型12                  
 1.2.4關(guān)系數(shù)據(jù)模型15                  
 1.2.5面向?qū)ο髷?shù)據(jù)模型18                  
 1.3數(shù)據(jù)庫系統(tǒng)20                  
 1.3.1數(shù)據(jù)庫系統(tǒng)的組成20                  
 1.3.2數(shù)據(jù)庫系統(tǒng)的結(jié)構(gòu)21                  
 習(xí)題25                  
                   
 第2章關(guān)系數(shù)據(jù)庫                  
 2.1關(guān)系模型27                  
 2.1.1基本概念27                  
 2.1.2關(guān)系形式化定義28                  
 2.1.3關(guān)系的完整性31                  
 2.2關(guān)系代數(shù)33                  
 2.2.1傳統(tǒng)的集合運算33                  
 2.2.2專門的關(guān)系運算35                  
 2.2.3關(guān)系代數(shù)查詢實例40                  
 2.3關(guān)系演算41                  
 2.3.1元組關(guān)系演算語言ALPHA41                  
 2.3.2域關(guān)系演算語言QBE45                  
 習(xí)題50                  
                   
 第3章關(guān)系數(shù)據(jù)庫標準語言SQL                  
 3.1SQL語言概況52                  
 3.2SQL語言的數(shù)據(jù)定義功能53                  
 3.2.1基本表的定義54                  
 3.2.2基本表的修改與刪除57                  
 3.2.3索引的建立和撤消58                  
 3.3SQL語言數(shù)據(jù)操縱功能59                  
 3.3.1SQL數(shù)據(jù)查詢59                  
 3.3.2SQL數(shù)據(jù)插入74                  
 3.3.3SQL數(shù)據(jù)刪除75                  
 3.3.4SQL數(shù)據(jù)修改76                  
 3.4視圖77                  
 3.4.1視圖的定義和刪除77                  
 3.4.2視圖的查詢78                  
 3.4.3視圖的更新78                  
 3.4.4視圖的優(yōu)點79                  
 3.5SQL語言的數(shù)據(jù)控制功能80                  
 3.5.1權(quán)限與角色80                  
 3.5.2權(quán)限與角色授予和收回81                  
 3.6嵌入式SQL82                  
 3.6.1嵌入式SQL概述83                  
 3.6.2嵌入式SQL數(shù)據(jù)庫訪問過程84                  
 3.6.3不使用游標的嵌入式SQL語句85                  
 3.6.4使用游標的嵌入式SQL語句87                  
 3.6.5動態(tài)SQL語句88                  
 習(xí)題90                  
                   
 第4章關(guān)系數(shù)據(jù)理論                  
 4.1問題的提出91                  
 4.2規(guī)范化94                  
 4.2.1函數(shù)依賴94                  
 4.2.2碼95                  
 4.2.3范式96                  
 4.2.42NF96                  
 4.2.53NF98                  
 4.2.6BCNF98                  
 4.2.7多值依賴99                  
 4.2.84NF102                  
 4.2.9規(guī)范化小結(jié)103                  
 4.3*數(shù)據(jù)依賴的公理系統(tǒng)103                  
 4.4例題及分析107                  
 習(xí)題116                  
                   
 第5章數(shù)據(jù)庫設(shè)計                  
 5.1數(shù)據(jù)庫設(shè)計概述119                  
 5.1.1數(shù)據(jù)庫設(shè)計問題119                  
 5.1.2數(shù)據(jù)庫設(shè)計方法和步驟119                  
 5.2實體聯(lián)系模型121                  
 5.3ER模型向關(guān)系模型的轉(zhuǎn)換126                  
 5.4ER模型設(shè)計實例131                  
 5.4.1概念結(jié)構(gòu)設(shè)計（設(shè)計ER模型）131                  
 5.4.2邏輯結(jié)構(gòu)設(shè)計133                  
 5.4.3數(shù)據(jù)庫的實施136                  
 5.4.4在數(shù)據(jù)庫設(shè)計中應(yīng)注意的問題138                  
 習(xí)題139                   
  第6章數(shù)據(jù)庫管理                  
 6.1引言141                  
 6.2數(shù)據(jù)庫的完整性141                  
 6.2.1數(shù)據(jù)庫完整性分類142                  
 6.2.2完整性約束條件與DBMS的完整性控制143                  
 6.2.3SQL Server 的數(shù)據(jù)完整性144                  
 6.2.4存儲過程148                  
 6.2.5觸發(fā)器149                  
 6.3數(shù)據(jù)庫的安全性155                  
 6.3.1定義視圖155                  
 6.3.2訪問控制156                  
 6.3.3數(shù)據(jù)加密158                  
 6.3.4數(shù)據(jù)庫審計158                  
 6.3.5SQL Server的安全性機制158                  
 習(xí)題172                  
                   
 第7章數(shù)據(jù)庫的恢復(fù)                  
 7.1事務(wù)173                  
 7.1.1事務(wù)的概念173                  
 7.1.2事務(wù)的操作173                  
 7.1.3事務(wù)的狀態(tài)174                  
 7.1.4事務(wù)的性質(zhì)175                  
 7.2SQL的事務(wù)管理176                  
 7.3數(shù)據(jù)庫恢復(fù)及故障177                  
 7.4數(shù)據(jù)庫恢復(fù)的原理178                  
 7.4.1數(shù)據(jù)轉(zhuǎn)儲178                  
 7.4.2登記日志文件179                  
 7.5數(shù)據(jù)庫恢復(fù)技術(shù)179                  
 7.6SQL Server的備份策略與方案182                  
 7.7并發(fā)控制183                  
 7.7.1并發(fā)控制引起的問題183                  
 7.7.2封鎖186                  
 7.7.3封鎖協(xié)議186                  
 7.7.4活鎖與死鎖187                  
 7.7.5并發(fā)調(diào)度的可串行性189                  
 7.7.6協(xié)議190                  
 7.7.7封鎖粒度190                  
 7.7.8插入和刪除操作191                  
 習(xí)題193                  
                   
 第8章關(guān)系系統(tǒng)的查詢優(yōu)化                  
 8.1引言194                  
 8.2代數(shù)優(yōu)化196                  
 8.3物理優(yōu)化200                  
 8.4代價估算優(yōu)化202                  
 8.5SQL Server 的查詢優(yōu)化204                  
 習(xí)題206                  
                   
 第9章數(shù)據(jù)庫訪問技術(shù)                  
 9.1ODBC208                  
 9.1.1ODBC介紹208                  
 9.1.2數(shù)據(jù)源211                  
 9.1.3ODBC API使用基礎(chǔ)217                  
 9.2* JDBC220                  
 9.2.1JDBC介紹220                  
 9.2.2JDBC的結(jié)構(gòu)223                  
 9.2.3JDBC接口概貌224                  
 9.3ADO簡介225                  
 9.3.1OLE DB概述225                  
 9.3.2ADO概述226                  
 習(xí)題231                  
                   
 第10章數(shù)據(jù)庫新技術(shù)與新應(yīng)用                  
 10.1分布式數(shù)據(jù)庫系統(tǒng)233                  
 10.1.1分布式數(shù)據(jù)庫的定義及特點233                  
 10.1.2分布式數(shù)據(jù)庫系統(tǒng)的環(huán)境234                  
 10.1.3分布式數(shù)據(jù)庫系統(tǒng)的體系結(jié)構(gòu)235                  
 10.1.4分布式數(shù)據(jù)庫系統(tǒng)研究現(xiàn)狀及應(yīng)用前景238                  
 10.2主動數(shù)據(jù)庫系統(tǒng)239                  
 10.2.1主動數(shù)據(jù)庫的產(chǎn)生及描述239                  
 10.2.2主動數(shù)據(jù)庫管理系統(tǒng)240                  
 10.2.3主動數(shù)據(jù)庫系統(tǒng)的實現(xiàn)241                   
 10.2.4主動數(shù)據(jù)庫的研究進展242                  
 10.3數(shù)據(jù)挖掘技術(shù)243                  
 10.3.1數(shù)據(jù)挖掘的概念及挑戰(zhàn)243                  
 10.3.2數(shù)據(jù)挖掘的分析方法244                  
 10.3.3數(shù)據(jù)挖掘系統(tǒng)的體系結(jié)構(gòu)及運行過程245                  
 10.3.4數(shù)據(jù)挖掘的應(yīng)用246                  
 習(xí)題247                  
                   
 參考文獻248