基于Oracle的高速公路收费系统数据库设计及应用

TP311.65UDC004.92005317DesignandApplicationofHighwayTollSystemDatabasebasedonOracleADissertationSubmittedtoSoutheastUniversityFortheAcademicDegreeofMasterofEngineeringBYZHANGYanSupervisedbyPro.ZHAOJiDepartmentofAutomationControlSoutheastUniversityMarch2005IOracleBarkernullLOBOracleIIThisarticlemainlydiscussesthedatabasedesignbasedonOracleandproblemsofdataprotection.Itbasedonthetheoryofdatabasedesign.First,thearticlepresentbackgroundoftheengineeringproject,meaningofresearch,relatedtheoryofdatabaseandmethodofdatabasedesign.TheBarkermethodadoptedbythearticleisakindofwaterfallmethodandthedatabaseisdesignedbysevenphasesasstrategy,analysis,design,construct,document,transplantandproduct.Thearticleprimarilydissertatesthephasesofanalysisanddesign.ThedatabaseisdesignedwithConceptualInformationModel,LogicalDataModelandPhysicalDataModel.Astrongemphasisislaidonthephysicaldesignofdatabase.Thephysicaldesigniscomposedoftablespacelayout,partition,clusterdesign,indexdesignandview.Inthissectindexdesignisdiscussedemphatically.Thearticleexpatiatesthecharacteristic,useconditionofdifferentindexesdetailedlyandeffectofdifferentindexesiscomparedbypracticaldata.Inthisarticle,Ialsodiscussedtheindexscantype,indexrebuildandindexwatch,whicharepartofindexdesign.Inaddition,thearticlediscussedtheOracleTexttechnology,whichisusedinindexdesign.Thearticlediscussestherelatedquestionofdataprotectiononthebasisofaccomplishofdatabasedesign.Thedataprotectionsystemiscomposedofsecuritymanagement,dataarchiving,backupandrecovery.Itdiscussesindetailthedatabasesecurity,audit,themethodsofdataarchivingandthemethodsofdatabackup&recovery.Finally,attheendofthearticle,itdiscussesNull,DatetimeandLOBdatatype.Thisthreespecialdatatypeareusedinthedatabasedesign.Keywords:OracleDatabaseDesignIndexDataprotectionIII.....................................................................................................................................................I.................................................................................................................................................II..........................................................................................................................................1...................................................................................................................................1............................................................................................................................1............................................................1................................................................2................................................................................................2............................................................................................................2............................................................................................................4................................................................................................5......................................................................................6........................................................................................................................6................................................................................................................6....................................................................................................7........................................................................................................................9.............................................................................................10.............................................................................................................10......................................................................................................................12..................................................................................................................13....................................................................................15..........................................................................................................15..........................................................................................................................15..........................................................................................................................15..................................................................................................................16..............................................................................................17..................................................................................18......................................................................................................................18................................................................20..............................................................................