基于Oracle的仓库管理数据库系统设计

北京邮电大学世纪学院毕业设计(论文)题目基于Oracle的仓库管理数据库系统设计学号学生姓名专业名称所在系（院）指导教师2012年5月30日I题目基于Oracle的仓库管理数据库系统设计摘要随着现代企业的发展，计算机信息管理系统越来越受到重视。本文简要介绍了SQL语言以及Oracle数据库系统的特点，并详细阐述了仓库管理数据库系统的设计方法。通过PowerDesigner建立概念结构模型，生成SQL脚本，最终建成数据库。主要包括数据库系统需求分析、概念结构设计、逻辑结构设计以及物理结构设计，最终模拟建立数据库。通过本系统的建立，可使企业的仓库管理更加正规化、科学化，以及方便快捷的实现仓库物资的入库、出库和采购等事项的管理功能。因此，本系统的开发有其特有的技术意义和管理意义。关键词PowerDesignerOracle仓库管理IITitleDesignOfStoreManagementDatabaseSystemBasedOnOracleAbstractWiththedevelopmentofmodernindustry,theinformationmanagementsystemofthecomputerispaidmoreandmoreattentionbyenterprise.ThisarticlebrieflydescribesthecharacteristicsoftheSQLlanguageandOracledatabasesystems,andelaboratedonthedesignofthewarehousemanagementdatabasesystem:First,establishtheconceptualstructuremodelandphysicalstructuremodelwithPowerDesigner,thengeneratetheSQLscriptthroughthePDMmodel,finallybuildthedatabasesystem.Includingsystemneedsanalysisofthesystem,conceptualstructuredesign,thelogicalstructuredesignandphysicalstructuredesign,eventuallyestablishasimulationofdatabasesystem.Usingacomputertocontrolinformationofthewarehousewhichhasadvantagesthatartificialmanagementthatcan’tcatchupwith.Itisquicklyinspectional,easytosearch,thecredibilityishigh,anddepositcapacitiesishigh,confidentialitygood,andalsoreducemoremanpowerandmaterialresource.Allofthismanagementscaninfinitelyraisethemanagementefficiencyofgoodsstockandalsoisascientificandregularturn,andbeinlinewithworldofimportantconditionofthestoragemanagement.Therefore,developingastoragemanagementsystemisnecessary.Ithasitsuniquetechnologyandmanagerialimplications.KeywordsPowerDesignerOracleStoremanagementIII目录1.前言................................................................11.1选题背景、意义...................................................11.2国内外发展现状...................................................21.2.1国外发展状况.................................................21.2.2国内发展状况.................................................22．数据库理论基础及应用系统开发工具...................................42.1SQL语言介绍.....................................................42.1.1SQL简介.....................................................42.1.2SQL语句介绍.................................................52.2ORACLE数据库分析.................................................52.2.1Oracle数据库简介............................................52.2.2Oracle数据库结构............................................62.2.3Oracle数据库特点............................................72.2.4Oracle数据仓库概述..........................................83.数据库管理系统总体设计............................................103.1数据库设计概述..................................................103.2系统需求分析....................................................113.2.1需求分析的任务和目标........................................113.2.2需求分析的方法和步骤........................................123.2.3数据字典....................................................123.2.3数据流图....................................................153.3数据库概念模型..................................................163.3.1实体属性图..................................................163.3.2总体E-R图..................................................194.数据库系统逻辑结构设计............................................204.1关系模式的基本范式..............................................204.1.11NF.........................................................20IV4.1.22NF.........................................................214.1.33NF.........................................................214.1.4Boyce-Codd范式.............................................214.2初始关系模型的设计..............................................214.3关系模式的规范化................................................225.数据库系统物理结构设计............................................245.1存储结构的设计..................................................245.1.1基本概念....................................................245.1.2B-树的查找..................................................255.1.3B-树的插入..................................................255.1.4B-树的删除..................................................275.2访问方法设计....................................................305.2.1索引的概念..................................................305.2.2索引的高效原理..............................................305.2.3索引的特性..................................................305.2.4索引的建立..................................................325.3数据存放位置设计................................................325.3.1RAID（磁盘阵列）技术........................................325.3.2RAID的级别.................................................335.3.3RAID级别的选择.............................................355.4系统配置设计....................................................366.数据库实施........................................................376.1建立数据库结构..................................................376.2数据库加载......................................................507．结论..............................................................53致谢.................................................................54参考文献.............................................................55北京邮电大学世纪学院毕业设计（论文）11.前言当今时