軟件公司關(guān)系型數(shù)據(jù)庫設(shè)計(jì)規(guī)范(已修改)
2025-07-29 18:15 本頁面
【正文】 中國最大的管理資源中心 第 1 頁 共 15 頁 關(guān)系型數(shù)據(jù)庫設(shè)計(jì)規(guī)范 (V ) 中國最大的管理資源中心 第 2 頁 共 15 頁 目錄 文檔類別使用對(duì)象 4 1. 概述 5 簡介 ................................................................................................................... 5 術(shù)語定義 ............................................................................................................ 5 參考資料 ............................................................................................................ 5 版本更新記錄 ..................................................................................................... 5 2．?dāng)?shù)據(jù)庫設(shè)計(jì)的目標(biāo) 6 3. 數(shù)據(jù)庫的特征 6 完整性約束 .......................................................................................................... 6 null 約束 ................................................................................................ 7 缺省值 ....................................................................................................... 7 unique 約束 .......................................................................................... 7 primary key 約束 ................................................................................... 7 參照完整性約束 ................................................................................... 7 check 約束 ............................................................................................ 8 存儲(chǔ)過程 ..................................................................................................... 8 觸發(fā)器 ........................................................................................................ 8 事務(wù)處理 ..................................................................................................... 9 事務(wù)與一致性 ....................................................................................... 9 事務(wù)和恢復(fù) ........................................................................................ 10 并發(fā)處理 ................................................................................................... 10 死鎖 ................................................................................................... 10 讀一致性 ............................................................................................ 10 序號(hào)生成器 ............................................................................................... 11 視圖 .......................................................................................................... 11 安全性 ............................................................................................... 11 邏輯數(shù)據(jù)獨(dú)立性 ................................................................................. 12 4. 調(diào)整數(shù)據(jù)庫設(shè)計(jì)以提高系統(tǒng)性能 12 建立有用的性能標(biāo)準(zhǔn) ................................................................................. 12 數(shù)據(jù)庫的規(guī)范化 ........................................................................................
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1