【正文】 裸設(shè)備的使用 ............................................................................................... 12 2. 數(shù)據(jù)庫邏輯設(shè)計(jì)原則 ............................................................................................... 13 . 命名規(guī)范 ...................................................................................................... 13 . 表屬性規(guī)范 ........................................................................................ 13 . 索引 ................................................................................................... 14 . 視圖 ................................................................................................... 15 . 實(shí)體化視圖 ........................................................................................ 15 . 存儲(chǔ)過程 ............................................................................................ 15 . 觸發(fā)器 ............................................................................................... 15 . 函數(shù) ................................................................................................... 16 . 數(shù)據(jù)包 ............................................................................................... 16 . 序列 ................................................................................................... 16 . 表空間 ............................................................................................... 16 . 數(shù)據(jù)文件 ............................................................................................ 16 . 普通變量 ............................................................................................ 16 . 游標(biāo)變量 ............................................................................................ 17 . 記錄型變量 ........................................................................................ 17 . 表類型變量 ........................................................................................ 17 . 數(shù)據(jù)庫鏈 ............................................................................................ 17 . 命名 ............................................................................................................. 17 . 語言 ................................................................................................... 17 . 大小寫 ............................................................................................... 18 . 單詞分隔 ............................................................................................ 18 . 保留字 ............................................................................................... 18 . 命名長度 ............................................................................................ 18 . 字段名稱 ............................................................................................ 18 . 數(shù)據(jù)類型 ...................................................................................................... 18 . 字符型 ............................................................................................... 18 . 數(shù)字型 ............................................................................................... 19 . 日期和時(shí)間 ........................................................................................ 19 . 大字段 ............................................................................................... 19 . 唯一鍵 ............................................................................................... 19 . 設(shè)計(jì) ............................................................................................................. 20 . 范式 ................................................................................................... 20 . 表設(shè)計(jì) ............................................................................................... 20 . 索引設(shè)計(jì) ............................................................................................ 23 . 視圖設(shè)計(jì) ............................................................................................ 24 . 包設(shè)計(jì) ............................................................................................... 24 . 安全性設(shè)計(jì) ........................................................................................ 25 . SQL 編寫 ....................................................................................................... 26 . 字符 類型數(shù)據(jù) ..................................................................................... 26 . 復(fù)雜 sql .............................................................................................. 27 . 高效性 ............................................................................................... 27 . 健壯性 ............................................................................................... 28 . 安全性 ............................................................................................... 29 . 完整性 ............................................................................................... 30 3. 備份恢復(fù)設(shè)計(jì)原則 ................................................................................................... 30 . 數(shù)據(jù)庫 exp/imp 備份恢復(fù) .............................................................................. 30 . 數(shù)據(jù)庫級(jí)備份原則 .............................................................................. 30 . 用戶級(jí)備份原則 ................................................................................. 30 . 表級(jí)備份原則 ..................................................................................