Background
Sincethelate1960s,computersusedformanagementhavebecomelargerandlargerandmorewidelyused.Theamountofdatahasincreasedsharply.Atthesametime,multipleapplications,Therequirementsforsharingdatacollectionswithmultiplelanguages​​coveringeachotherarebecomingstronger;computerhardwarehaslarge-capacitydisks,thepriceofhardwarehasfallen,andthepriceofsoftwarehasrisen,andthecostofcompilingandmaintainingsystemsoftwareandapplicationprogramshasrelativelyincreased;Intermsofprocessingmethods,onlinereal-timeprocessingrequiresmore,andtheconceptofdistributedprocessinghasbeenformed.Inthiscontext,theuseoffilesystemsasameansofdatamanagementcannolongermeettheneedsofapplications,soinordertosolvetheneedsofmultipleusersandmultipleapplicationstosharedata,databasemanagementtechnologycameintobeing.
Content
1.Theestablishmentofthedatabase
Theestablishmentofthedatabaseincludestwoparts,theestablishmentofthedatamodelandthedataloading.
2.Databaseadjustment
Afterthedatabaseisestablishedandrunforaperiodoftime,someunsuitablesituationswilloftenoccur.Atthistime,itneedstobeadjusted.ThedatabaseadjustmentisgenerallydonebytheDBA.
3.Reorganizationofthedatabase
Afteracertainperiodoftimehaspassed,theperformanceofthedatabasewillgraduallydecline.Thereasonforthedeclineismainlyduetocontinuousmodification,deletionandinsertion.Forthesereasons,itisnecessarytorearrangethedatabaseandre-adjustthestoragespace.Thiskindofworkiscalleddatabasereorganization.Atpresent,RDBMSgenerallyprovidecertainmeanstorealizethedatareorganizationfunction.
4.DatabaseSecurityControlandIntegrityControl
Databaseisanimportantresourceofanorganization,anditssecurityisextremelyimportant.ThedatabaseadministratorDBAshouldtakemeasurestoensurethatthedataisprotectedfromillegalmisappropriationanddestroy.Inaddition,inordertoensurethecorrectnessofthedata,sothatthedataenteredinthedatabasecanbekeptcorrect,itisnecessarytohavetheintegritycontrolofthedatabase.
5.Databasefailurerecovery
Oncethedatainthedatabaseisdamaged,itneedstoberestoredintime.RDBMSgenerallyprovidethisfunction,andtheDBAisresponsibleforperformingthefailurerecoveryfunction.
6.Databasemonitoring
DBAneedstoobservethedynamicchangesofthedatabaseatanytime,and:takemeasuresatanytimewhenerrors,failuresorinadaptabilityoccur;atthesametime,theyalsoneedtomonitortheperformancechangesofthedatabase.Makeadjustmentstothedatabasefromtimetotime.
Advantages
1.Dataintegration
Aunifieddatastructuremethodisadoptedinthedatabasesystemtomakethedatastructured;theglobaldatastructureissharedbymultipleapplications,andeachprogramcallsthedataofthelocalstructure.Formdataintegrationwithlocalstructuralpatterns.
2.Highdatasharing,lowredundancy
Thedatabasesystemviewsanddescribesdatafromanoverallperspective.Thedatafacestheentiresystemandnolongerfacesacertainapplication.Therefore,thedatacanbesharedbymultipleusersandmultipleapplications.shared.Thecombinationofdatabasetechnologyandnetworktechnologyexpandstheapplication.Thedegreeofdatasharinggreatlyreducesdataredundancy,savesstoragespace,andcanavoidincompatibilityandinconsistencybetweendata.
3.Highdataindependence
Dataindependencemeansthattheuser’sapplicationandthedatainthedatabaseareindependentofeachother,thatis,whenthephysicalstructureandlogicalstructureofthedataWhenthereisachange,itdoesnotaffecttheuseofdatabytheapplication.
4.Datamanagementandcontrolcapabilities
Thedatabasesystemmanagesandcontrolsthedatauniformly,ensuringthesecurityandintegrityofthedata.Thedatabasesystemcheckstheidentityofaccessingusersandthelegitimacyoftheiroperations;automaticallycheckstheconsistencyandcompatibilityofthedatatoensurethatthedatameetstheintegrityconstraints;usesconcurrentcontrolmethodstoeffectivelycontrolmulti-userprogramsandoperateonthedataatthesametimetoensuresharingAndconcurrentoperation;therecoveryfunctionguaranteesthatwhenthedatabaseisdamaged,itcanautomaticallyrecovertothecorrectstate.