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

1、TP311.65UDC004.92005317DesignandApplicationofHighwayTollSystemDatabasebasedonOracleADissertationSubmittedtoSoutheastUniversityFortheAcademicDegreeofMasterofEngineeringBYZHANGYanSupervisedbyPro.ZHAOJiDepartmentofAutomationControlSoutheastUniversityMarch2005IOracleBarkernullLOBOracleIIThisarticlemainlydiscussesthedatabasedesignbasedonOracleandproblemsofdataprotection.Itbasedonthetheoryofdatabasedesign.First,thearticlepresentbackgroundoftheengineeringproject,meaningofresearch,relatedtheoryofdataba。

2、seandmethodofdatabasedesign.TheBarkermethodadoptedbythearticleisakindofwaterfallmethodandthedatabaseisdesignedbysevenphasesasstrategy,analysis,design,construct,document,transplantandproduct.Thearticleprimarilydissertatesthephasesofanalysisanddesign.ThedatabaseisdesignedwithConceptualInformationModel,LogicalDataModelandPhysicalDataModel.Astrongemphasisislaidonthephysicaldesignofdatabase.Thephysicaldesigniscomposedoftablespacelayout,partition,clusterdesign,indexdesignandview.Inthissectindexdesigni。

3、sdiscussedemphatically.Thearticleexpatiatesthecharacteristic,useconditionofdifferentindexesdetailedlyandeffectofdifferentindexesiscomparedbypracticaldata.Inthisarticle,Ialsodiscussedtheindexscantype,indexrebuildandindexwatch,whicharepartofindexdesign.Inaddition,thearticlediscussedtheOracleTexttechnology,whichisusedinindexdesign.Thearticlediscussestherelatedquestionofdataprotectiononthebasisofaccomplishofdatabasedesign.Thedataprotectionsystemiscomposedofsecuritymanagement,dataarchiving,backupandr。

4、ecovery.Itdiscussesindetailthedatabasesecurity,audit,themethodsofdataarchivingandthemethodsofdatabackup&recovery.Finally,attheendofthearticle,itdiscussesNull,DatetimeandLOBdatatype.Thisthreespecialdatatypeareusedinthedatabasedesign.Keywords:OracleDatabaseDesignIndexDataprotectionIII.....................................................................................................................................................I...................................................................。

5、..............................................................................II..........................................................................................................................................1...................................................................................................................................1............................................................................................................................1........................。

6、....................................1................................................................2................................................................................................2............................................................................................................2............................................................................................................4...................................................................................。

7、.............5......................................................................................6........................................................................................................................6................................................................................................................6....................................................................................................7................................................................。

8、........................................................9.............................................................................................10.............................................................................................................10......................................................................................................................12..................................................................................................................13.。

9、...................................................................................15..........................................................................................................15..........................................................................................................................15..........................................................................................................................15...........................................................。

10、.......................................................16..............................................................................................17..................................................................................18......................................................................................................................18................................................................20..............................................................................。