Gestione del database

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.

commoda

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.

Related Articles
TOP