Pozadí
Sincethelate1960s,computersusedformanagementhavebecomelargerandlargerandmorewidelyused.Theamountofdatahasincreasedsharply.Atthesametime,multipleapplications,Therequirementsforsharingdatacollectionswithmultiplelanguagescoveringeachotherarebecomingstronger;computerhardwarehaslarge-capacitydisks,thepriceofhardwarehasfallen,andthepriceofsoftwarehasrisen,andthecostofcompilingandmaintainingsystemsoftwareandapplicationprogramshasrelativelyincreased;Intermsofprocessingmethods,onlinereal-timeprocessingrequiresmore,andtheconceptofdistributedprocessinghasbeenformed.Inthiscontext,theuseoffilesystemsasameansofdatamanagementcannolongermeettheneedsofapplications,soinordertosolvetheneedsofmultipleusersandmultipleapplicationstosharedata,databasemanagementtechnologycameintobeing.
Obsah
1.Zřízení databáze
Theestablishmentofthedatabaseincludestwoparts,theestablishmentofthedatamodelandthedataloading.
2.Úprava databáze
Afterthedatabaseisestablishedandrunforaperiodoftime,someunsuitablesituationswilloftenoccur.Atthistime,itneedstobeadjusted.ThedatabaseadjustmentisgenerallydonebytheDBA.
3.Reorganizace databáze
Afteracertainperiodoftimehaspassed,theperformanceofthedatabasewillgraduallydecline.Thereasonforthedeclineismainlyduetocontinuousmodification,deletionandinsertion.Forthesereasons,itisnecessarytorearrangethedatabaseandre-adjustthestoragespace.Thiskindofworkiscalleddatabasereorganization.Atpresent,RDBMSgenerallyprovidecertainmeanstorealizethedatareorganizationfunction.
4.DatabaseSecurityControlandIntegrityControl
Databaseisanimportantresourceofanorganization,anditssecurityisextremelyimportant.ThedatabaseadministratorDBAshouldtakemeasurestoensurethatthedataisprotectedfromillegalmisappropriationanddestroy.Inaddition,inordertoensurethecorrectnessofthedata,sothatthedataenteredinthedatabasecanbekeptcorrect,itisnecessarytohavetheintegritycontrolofthedatabase.
5.Obnova při selhání databáze
Oncethedatainthedatabaseisdamaged,itneedstoberestoredintime.RDBMSgenerallyprovidethisfunction,andtheDBAisresponsibleforperformingthefailurerecoveryfunction.
6.Sledování databáze
DBAneedstoobservethedynamicchangesofthedatabaseatanytime,and:takemeasuresatanytimewhenerrors,failuresorinadaptabilityoccur;atthesametime,theyalsoneedtomonitortheperformancechangesofthedatabase.Makeadjustmentstothedatabasefromtimetotime.
Výhody
1.Dataintegrace
Aunifieddatastructuremethodisadoptedinthedatabasesystemtomakethedatastructured;theglobaldatastructureissharedbymultipleapplications,andeachprogramcallsthedataofthelocalstructure.Formdataintegrationwithlocalstructuralpatterns.
2.Vysoké sdílení dat, nízká redundance
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.