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

第1章數(shù)據(jù)庫(kù)系統(tǒng)概述                  
 1.1數(shù)據(jù)管理的進(jìn)展1                  
 1.1.1數(shù)據(jù)管理的三個(gè)階段1                  
 1.1.2數(shù)據(jù)庫(kù)技術(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ù)庫(kù)系統(tǒng)20                  
 1.3.1數(shù)據(jù)庫(kù)系統(tǒng)的組成20                  
 1.3.2數(shù)據(jù)庫(kù)系統(tǒng)的結(jié)構(gòu)21                  
 習(xí)題25                  
                   
 第2章關(guān)系數(shù)據(jù)庫(kù)                  
 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)的集合運(yùn)算33                  
 2.2.2專(zhuān)門(mén)的關(guān)系運(yùn)算35                  
 2.2.3關(guān)系代數(shù)查詢(xún)實(shí)例40                  
 2.3關(guān)系演算41                  
 2.3.1元組關(guān)系演算語(yǔ)言ALPHA41                  
 2.3.2域關(guān)系演算語(yǔ)言QBE45                  
 習(xí)題50                  
                   
 第3章關(guān)系數(shù)據(jù)庫(kù)標(biāo)準(zhǔn)語(yǔ)言SQL                  
 3.1SQL語(yǔ)言概況52                  
 3.2SQL語(yǔ)言的數(shù)據(jù)定義功能53                  
 3.2.1基本表的定義54                  
 3.2.2基本表的修改與刪除57                  
 3.2.3索引的建立和撤消58                  
 3.3SQL語(yǔ)言數(shù)據(jù)操縱功能59                  
 3.3.1SQL數(shù)據(jù)查詢(xún)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視圖的查詢(xún)78                  
 3.4.3視圖的更新78                  
 3.4.4視圖的優(yōu)點(diǎn)79                  
 3.5SQL語(yǔ)言的數(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ù)庫(kù)訪(fǎng)問(wèn)過(guò)程84                  
 3.6.3不使用游標(biāo)的嵌入式SQL語(yǔ)句85                  
 3.6.4使用游標(biāo)的嵌入式SQL語(yǔ)句87                  
 3.6.5動(dòng)態(tài)SQL語(yǔ)句88                  
 習(xí)題90                  
                   
 第4章關(guān)系數(shù)據(jù)理論                  
 4.1問(wèn)題的提出91                  
 4.2規(guī)范化94                  
 4.2.1函數(shù)依賴(lài)94                  
 4.2.2碼95                  
 4.2.3范式96                  
 4.2.42NF96                  
 4.2.53NF98                  
 4.2.6BCNF98                  
 4.2.7多值依賴(lài)99                  
 4.2.84NF102                  
 4.2.9規(guī)范化小結(jié)103                  
 4.3*數(shù)據(jù)依賴(lài)的公理系統(tǒng)103                  
 4.4例題及分析107                  
 習(xí)題116                  
                   
 第5章數(shù)據(jù)庫(kù)設(shè)計(jì)                  
 5.1數(shù)據(jù)庫(kù)設(shè)計(jì)概述119                  
 5.1.1數(shù)據(jù)庫(kù)設(shè)計(jì)問(wèn)題119                  
 5.1.2數(shù)據(jù)庫(kù)設(shè)計(jì)方法和步驟119                  
 5.2實(shí)體聯(lián)系模型121                  
 5.3ER模型向關(guān)系模型的轉(zhuǎn)換126                  
 5.4ER模型設(shè)計(jì)實(shí)例131                  
 5.4.1概念結(jié)構(gòu)設(shè)計(jì)（設(shè)計(jì)ER模型）131                  
 5.4.2邏輯結(jié)構(gòu)設(shè)計(jì)133                  
 5.4.3數(shù)據(jù)庫(kù)的實(shí)施136                  
 5.4.4在數(shù)據(jù)庫(kù)設(shè)計(jì)中應(yīng)注意的問(wèn)題138                  
 習(xí)題139                   
  第6章數(shù)據(jù)庫(kù)管理                  
 6.1引言141                  
 6.2數(shù)據(jù)庫(kù)的完整性141                  
 6.2.1數(shù)據(jù)庫(kù)完整性分類(lèi)142                  
 6.2.2完整性約束條件與DBMS的完整性控制143                  
 6.2.3SQL Server 的數(shù)據(jù)完整性144                  
 6.2.4存儲(chǔ)過(guò)程148                  
 6.2.5觸發(fā)器149                  
 6.3數(shù)據(jù)庫(kù)的安全性155                  
 6.3.1定義視圖155                  
 6.3.2訪(fǎng)問(wèn)控制156                  
 6.3.3數(shù)據(jù)加密158                  
 6.3.4數(shù)據(jù)庫(kù)審計(jì)158                  
 6.3.5SQL Server的安全性機(jī)制158                  
 習(xí)題172                  
                   
 第7章數(shù)據(jù)庫(kù)的恢復(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ù)庫(kù)恢復(fù)及故障177                  
 7.4數(shù)據(jù)庫(kù)恢復(fù)的原理178                  
 7.4.1數(shù)據(jù)轉(zhuǎn)儲(chǔ)178                  
 7.4.2登記日志文件179                  
 7.5數(shù)據(jù)庫(kù)恢復(fù)技術(shù)179                  
 7.6SQL Server的備份策略與方案182                  
 7.7并發(fā)控制183                  
 7.7.1并發(fā)控制引起的問(wèn)題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)的查詢(xún)優(yōu)化                  
 8.1引言194                  
 8.2代數(shù)優(yōu)化196                  
 8.3物理優(yōu)化200                  
 8.4代價(jià)估算優(yōu)化202                  
 8.5SQL Server 的查詢(xún)優(yōu)化204                  
 習(xí)題206                  
                   
 第9章數(shù)據(jù)庫(kù)訪(fǎng)問(wèn)技術(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簡(jiǎn)介225                  
 9.3.1OLE DB概述225                  
 9.3.2ADO概述226                  
 習(xí)題231                  
                   
 第10章數(shù)據(jù)庫(kù)新技術(shù)與新應(yīng)用                  
 10.1分布式數(shù)據(jù)庫(kù)系統(tǒng)233                  
 10.1.1分布式數(shù)據(jù)庫(kù)的定義及特點(diǎn)233                  
 10.1.2分布式數(shù)據(jù)庫(kù)系統(tǒng)的環(huán)境234                  
 10.1.3分布式數(shù)據(jù)庫(kù)系統(tǒng)的體系結(jié)構(gòu)235                  
 10.1.4分布式數(shù)據(jù)庫(kù)系統(tǒng)研究現(xiàn)狀及應(yīng)用前景238                  
 10.2主動(dòng)數(shù)據(jù)庫(kù)系統(tǒng)239                  
 10.2.1主動(dòng)數(shù)據(jù)庫(kù)的產(chǎn)生及描述239                  
 10.2.2主動(dòng)數(shù)據(jù)庫(kù)管理系統(tǒng)240                  
 10.2.3主動(dòng)數(shù)據(jù)庫(kù)系統(tǒng)的實(shí)現(xiàn)241                   
 10.2.4主動(dòng)數(shù)據(jù)庫(kù)的研究進(jìn)展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)及運(yùn)行過(guò)程245                  
 10.3.4數(shù)據(jù)挖掘的應(yīng)用246                  
 習(xí)題247                  
                   
 參考文獻(xiàn)248