【正文】 FGSJJLKSJGKLJG JLS JGKJ KJ SKJ KJSKLGJKSJLKSJKL KSGK JKLGJSLSK JSGKL JLSGJSLJ GJGKL JLSJ KL JGKL JGKL JKL 北京郵電大學(xué)世紀(jì)學(xué)院 畢業(yè)設(shè)計(jì) (論文 ) 題 目 基于 Oracle的倉(cāng)庫(kù)管理 數(shù)據(jù)庫(kù)系統(tǒng)設(shè)計(jì) 學(xué) 號(hào) 學(xué)生姓名 專業(yè)名稱 所在系（院） 指導(dǎo)教師 2021 年 5 月 30 日 FGSJJLKSJGKLJG JLS JGKJ KJ SKJ KJSKLGJKSJLKSJKL KSGK JKLGJSLSK JSGKL JLSGJSLJ GJGKL JLSJ KL JGKL JGKL JKL 題目 基于 Oracle 的倉(cāng)庫(kù)管理數(shù)據(jù)庫(kù)系統(tǒng)設(shè)計(jì) 摘要 隨著現(xiàn)代企業(yè)的發(fā)展，計(jì)算機(jī)信息管理系統(tǒng)越來(lái)越受到重視。 本文簡(jiǎn)要介紹了SQL 語(yǔ)言以及 Oracle 數(shù)據(jù)庫(kù)系統(tǒng)的特點(diǎn)，并詳細(xì)闡述了倉(cāng)庫(kù)管理數(shù)據(jù)庫(kù)系統(tǒng)的設(shè)計(jì)方法。 通過(guò) Power Designer 建立概念結(jié)構(gòu)模型，生成 SQL 腳本，最終建成數(shù)據(jù)庫(kù)。主要包括數(shù)據(jù)庫(kù)系統(tǒng)需求分析、概念結(jié)構(gòu)設(shè)計(jì)、邏輯結(jié)構(gòu)設(shè)計(jì)以及物理結(jié)構(gòu)設(shè)計(jì)，最終模擬建立數(shù)據(jù)庫(kù)。通過(guò)本系統(tǒng)的建立，可使企業(yè)的倉(cāng)庫(kù)管理更加正規(guī)化、科學(xué)化，以及方便快捷的實(shí)現(xiàn)倉(cāng)庫(kù)物資的入 庫(kù)、出庫(kù)和采購(gòu)等事項(xiàng)的管理功能。 因此，本系統(tǒng)的開發(fā)有其特有的技術(shù)意義和管理意義。 關(guān)鍵詞 Power Designer Oracle 倉(cāng)庫(kù)管理 FGSJJLKSJGKLJG JLS JGKJ KJ SKJ KJSKLGJKSJLKSJKL KSGK JKLGJSLSK JSGKL JLSGJSLJ GJGKL JLSJ KL JGKL JGKL JKL Title Design Of Store Management Database System Based On Oracle Abstract With the development of modern industry, the information management system of the puter is paid more and more attention by enterprise. This article briefly describes the characteristics of the SQL language and Oracle database systems, and elaborated on the design of the warehouse management database system: First, establish the conceptual structure model and physical structure model with Power Designer, then generate the SQL script through the PDM model, finally build the database system. Including system needs analysis of the system, conceptual structure design, the logical structure design and physical structure design, eventually establish a simulation of database system. Using a puter to control information of the warehouse which has advantages that artificial management that can’t catch up with. It is quickly inspectional, easy to search, the credibility is high, and deposit capacities is high, confidentiality good, and also reduce more manpower and material resource. All of this managements can infinitely raise the management efficiency of goods stock and also is a scientific and regular turn, and be in line with world of important condition of the storage management. Therefore, developing a storage management system is necessary. It has its unique technology and managerial implications. Keywords Power Designer Oracle Store management FGSJJLKSJGKLJG JLS JGKJ KJ SKJ KJSKLGJKSJLKSJKL KSGK JKLGJSLSK JSGKL JLSGJSLJ GJGKL JLSJ KL JGKL JGKL JKL 目錄 ................................................................ 1 選題背景、意義 ................................................... 1 國(guó)內(nèi)外發(fā)展現(xiàn)狀 ................................................... 2 國(guó)外發(fā)展?fàn)顩r ................................................. 2 國(guó)內(nèi)發(fā)展?fàn)顩r ................................................. 2 2． 數(shù)據(jù)庫(kù)理論基礎(chǔ)及應(yīng)用系統(tǒng)開發(fā)工具 ................................... 4 SQL 語(yǔ)言介紹 ..................................................... 4 SQL 簡(jiǎn)介 ..................................................... 4 SQL 語(yǔ)句介紹 ................................................. 5 ORACLE數(shù)據(jù)庫(kù)分析 ................................................. 5 Oracle 數(shù)據(jù)庫(kù)簡(jiǎn)介 ............................................ 5 Oracle 數(shù)據(jù)庫(kù)結(jié)構(gòu) ............................................ 6 Oracle 數(shù)據(jù)庫(kù)特點(diǎn) ............................................ 7 Oracle 數(shù)據(jù)倉(cāng)庫(kù)概述 .......................................... 8 3. 數(shù)據(jù)庫(kù)管理系統(tǒng)總體設(shè)計(jì) ............................................ 10 數(shù)據(jù)庫(kù)設(shè)計(jì)概述 .................................................. 10 系統(tǒng)需求分析 .................................................... 11 需求分析的任務(wù)和目標(biāo) ........................................ 11 需求分析的方法和步驟 ........................................ 12 數(shù)據(jù)字典 .................................................... 12 數(shù)據(jù)流圖 .................................................... 15 數(shù)據(jù)庫(kù)概念模型 .................................................. 15 實(shí)體屬性圖 .................................................. 16 總體 ER圖 .................................................. 18 4. 數(shù)據(jù)庫(kù)系統(tǒng)邏輯結(jié)構(gòu)設(shè)計(jì) ............................................ 20 關(guān)系模式的基本范式 .............................................. 20 1NF ......................................................... 20 2NF ......................................................... 21 FGSJJLKSJGKLJG JLS JGKJ KJ SKJ KJSKLGJKSJLKSJKL KSGK JKLGJSLSK JSGKL JLSGJSLJ GJGKL JLSJ KL JGKL JGKL JKL 3NF ......................................................... 21 BoyceCodd 范式 ............................................. 21 初始關(guān)系模型的設(shè)計(jì) .............................................. 21 關(guān)系模式的規(guī)范化 ................................................ 22 5. 數(shù)據(jù)庫(kù)系統(tǒng)物理結(jié)構(gòu)設(shè)計(jì) ............................................ 24 存儲(chǔ)結(jié)構(gòu)的設(shè)計(jì) .................................................. 24 基本概念 .................................................... 24 B樹的查找 .................................................. 25 B樹的插入 .................................................. 25 B樹的刪除 .................................................. 26 訪問(wèn)方法設(shè)計(jì) .................................................... 29 索引的概念 .................................................. 29 索引的高效原理 .............................................. 29 索引的特性 .................................................. 29 索引的建立 .................................................. 31 數(shù)據(jù)存放位置設(shè)計(jì) ................................................ 32 RAID（磁盤陣列）技術(shù) ........................................ 32 RAID 的級(jí)別 ................................................. 32 RAID 級(jí)別的選擇 ............................................. 35 系統(tǒng)配置設(shè)計(jì) .................................................... 35 6. 數(shù)據(jù)庫(kù)實(shí)施 ........................................................