Oracle應(yīng)用開發(fā)

理論篇...............................................................................................................................1
第1 章 關(guān)系型數(shù)據(jù)庫.........................................................................................................2
1.1 數(shù)據(jù)庫概述.......................................................................................................................4
1.1.1 數(shù)據(jù)庫基本概念..................................................................................................4
1.1.2 數(shù)據(jù)庫發(fā)展史......................................................................................................6
1.1.3 數(shù)據(jù)庫特征..........................................................................................................9
1.1.4 常見數(shù)據(jù)庫..........................................................................................................9
1.2 數(shù)據(jù)模型......................................................................................................................... 11
1.2.1 概念模型............................................................................................................ 11
1.2.2 邏輯數(shù)據(jù)模型....................................................................................................14
1.3 關(guān)系模型理論.................................................................................................................18
1.3.1 關(guān)系....................................................................................................................20
1.3.2 關(guān)系模式............................................................................................................23
1.3.3 關(guān)系的完整性....................................................................................................24
1.3.4 關(guān)系代數(shù)............................................................................................................26
1.4 規(guī)范化理論.....................................................................................................................34
1.4.1 規(guī)范化理論的提出............................................................................................34
1.4.2 函數(shù)依賴............................................................................................................37
1.4.3 函數(shù)依賴定義的碼............................................................................................40
1.4.4 范式及各范式的關(guān)系........................................................................................41
1.4.5 多值依賴............................................................................................................50
1.4.6 規(guī)范化思想........................................................................................................51
1.5 數(shù)據(jù)庫設(shè)計(jì).....................................................................................................................52
1.5.1 數(shù)據(jù)庫設(shè)計(jì)特點(diǎn)................................................................................................53
1.5.2 需求分析............................................................................................................55
1.5.3 數(shù)據(jù)流圖和數(shù)據(jù)字典........................................................................................57
1.6 概念結(jié)構(gòu)設(shè)計(jì).................................................................................................................58
1.6.1 概念結(jié)構(gòu)設(shè)計(jì)定義............................................................................................59
1.6.2 概念結(jié)構(gòu)設(shè)計(jì)的方法和步驟............................................................................60
1.6.3 數(shù)據(jù)抽象............................................................................................................61
1.6.4 E-R 圖的生成.....................................................................................................62
1.7 邏輯結(jié)構(gòu)設(shè)計(jì).................................................................................................................66
1.7.1 初始關(guān)系模式設(shè)計(jì).............................................................................................66
1.7.2 數(shù)據(jù)模型優(yōu)化的方法.........................................................................................68
1.7.3 模式評價(jià)與改進(jìn)................................................................................................68
小結(jié)....................................................................................................................70
練習(xí)..................................................................................................................70
第2 章 Oracle 數(shù)據(jù)庫........................................................................................76
2.1 Oracle 數(shù)據(jù)庫概述..........................................................................................................78
2.1.1 Oracle 數(shù)據(jù)庫簡介.............................................................................................78
2.1.2 Oracle 發(fā)展史.....................................................................................................79
2.1.3 Oracle 數(shù)據(jù)庫的應(yīng)用結(jié)構(gòu).................................................................................81
2.2 Oracle 體系結(jié)構(gòu)..............................................................................................................83
2.3 Oracle 數(shù)據(jù)庫存儲(chǔ)結(jié)構(gòu)..................................................................................................84
2.3.1 物理存儲(chǔ)結(jié)構(gòu)....................................................................................................85
2.3.2 邏輯存儲(chǔ)結(jié)構(gòu)....................................................................................................88
2.4 Oracle 數(shù)據(jù)庫實(shí)例..........................................................................................................90
2.4.1 Oracle 實(shí)例概述.................................................................................................90
2.4.2 SGA ....................................................................................................................92
2.4.3 PGA ....................................................................................................................95
2.4.4 后臺(tái)進(jìn)程............................................................................................................97
小結(jié)..........................................................................................................101
練習(xí).....................................................................................................................102
第3 章 SQL Developer 開發(fā)工具..............................................................................103
3.1 SQL Developer 概述....................................................................................................105
3.1.1 SQL Developer 簡介........................................................................................105
3.1.2 SQL Developer 下載........................................................................................105
3.1.3 創(chuàng)建數(shù)據(jù)庫連接..............................................................................................107
3.2 SQL Developer 基本操作.............................................................................................109
3.2.1 數(shù)據(jù)操作..........................................................................................................110
3.2.2 表的創(chuàng)建、修改..............................................................................................112
3.3 開發(fā)與調(diào)試...................................................................................................................116