Режим
Definition:Alsocalledlogicalmode,itisthedescriptionofthelogicalstructureandcharacteristicsofalldatainthedatabase,andisthecommondataviewforallusers.
разбиране:
①Adatabasehasonlyonemode;
②Това е изгледът на базирани на данни данни на логическо ниво;
③Режимът на базата данни е базиран на определен модел на данни;
④Whendefiningthemode,itisnotonlynecessarytodefinethelogicalstructureofthedata(suchaswhichdataitemsconstitutethedatarecord,thename,type,valuerangeofthedataitem,etc.),Anddefinethesecurityandintegrityrequirementsrelatedtothedata,anddefinetherelationshipbetweenthesedata.
Външна схема
Definition:alsoknownasSubschemaorusermode,whichcanbeseenandusedbydatabaseusers(includingapplicationprogrammersandendusers)Thedescriptionofthelogicalstructureandcharacteristicsofthelocaldataisthedataviewofthedatabaseuserandthelogicalrepresentationofthedatarelatedtoacertainapplication.
разбиране:
①Базата данни може да има множество външни режими;
②Външният режим е потребителският изглед;
③Външният режим е мощна мярка за гарантиране на сигурността на данните.
Вътрешна схема
Definition:alsoknownasStorageSchema,itisthedescriptionofthephysicalstructureandstorageofdata,andtherepresentationofdatainthedatabase(Forexample,isthestoragemethodofrecordsstoredsequentially,storedinaB-treestructure,orstoredinahashmethod;howtheindexisorganized;whetherthedataiscompressedandstoredandwhetheritisencrypted;whataretherequirementsforthestoragerecordstructureofthedata).
разбиране:
①Adatabasehasonlyoneinternalschema;
②Atablemayconsistofmultiplefiles,suchasdatafilesandindexfiles.
Itisamethodforthedatabasemanagementsystem(DBMS)toeffectivelyorganizeandmanagethedatainthedatabase
Целта му е:
①Inordertoreducedataredundancy,Realizedatasharing;
②За да се подобри ефективността на достъпа и производителността.
SchemaInterpretation(ConceptualSchema)
ConceptualSchemaisthedescriptionoftheglobaldatalogicalstructureinthedatabasesystem,andisthecommondataviewofallusers(applications).ThisdescriptionisanabstractionThedescriptionof,itdoesnotinvolvespecifichardwareenvironmentandplatform,andhasnothingtodowithspecificsoftwareenvironment.
Theconceptualmodelmainlydescribestheconceptualrecordtypeofdataandthedataandtherelationshipbetweenthem.Italsoincludessomesemanticconstraintsbetweenthedata.ItsdescriptioncanbedefinedbytheDDLlanguageintheDBMS.
Външна схема
Външна схемаisalsocalledSubschemaorUser'sschema.Itistheuser’sdataview,thatis,theuser’sApartoftheseenpatternisderivedfromtheconceptualpattern.Theconceptualpatterngivesaglobaldatadescriptionofthesystemandtheouterpatterngivesalocaldescriptionofeachuser.Aconceptualmodecanhaveseveralexternalmodes,andeachuseronlycaresaboutthemoderelatedtoit.Thiscanshieldalargeamountofirrelevantinformationandisbeneficialtodataprotection,soitisextremelybeneficialtousers.IngeneralDBMS,therearerelatedexternalmodedescriptionlanguages(externalmodeDDL).
Вътрешна схема
Вътрешна схемаisalsocalledPhysicalSchema,whichgivesDatabasephysicalstoragestructureandphysicalaccessmethods,suchasdatastoragefilestructure,index,clusteringandhashaccessmethodsandaccesspaths.Thephysicalityoftheinternalmodeismainlyreflectedintheoperatingsystemandfilelevel.Deepdowntothedevicelevel(suchasdiskanddiskoperations),butinrecentyearstherehasbeenatrendtowardthedevicelevel(suchasrawdisk,diskblocktechnology,etc.),DBMSgenerallyprovidesrelatedinternalmodedescriptionlanguage(internalmodeDDL).
Thedatamodelgivesthedataframestructureofthedatabase,andthedatainthedatabaseistherealentity,butthesedatamustbeorganizedaccordingtothestructuredescribedbytheframework,andthedatabasecomposedoftheconceptualmodelastheframeworkCalledConceptualDatabase,adatabasecomposedofaframeworkwithanexternalmodeliscalledauserdatabase,andadatabasecomposedofaframeworkwithaninternalmodeliscalledaphysicaldatabase.Amongthethreedatabases,onlythephysicaldatabaseisreal.Existinthecomputer'sexternalmemory,theothertwodatabasesdonotreallyexistinthecomputer,butaremappedfromthephysicaldatabasethroughtwomappings.
Thethreelevelsofthemodelreflectthethreedifferentenvironmentsofthemodelandtheirdifferentrequirements.Theinternalmodelisatthelowestlevel.Itreflectstheactualstorageformofthedatainthephysicalstructureofthecomputer,theconceptualmodelInthemiddlelayer,itreflectsthedesigner'sdatagloballogicrequirements,whiletheoutermodeisintheoutermostlayer,whichreflectstheuser'sdatarequirements.
Thethree-levelmodeofthedatabasesystemisanabstractionofthethreelevelsofdata.Itleavesthespecificphysicalrealizationofthedatatothephysicalmode,sothatusersandglobaldesignersdonotneedtocareaboutthespecificrealizationandphysicalbackgroundofthedatabaseAtthesametime,itestablishestheconnectionandconversionbetweenthethree-levelmodelthroughtwo-levelmapping,sothatalthoughtheconceptualmodelandtheexternalmodeldonothaveaphysicalexistence,theycanalsoobtaintheirexistingentitiesthroughthemapping.Atthesametime,thetwo-levelmappingalsoensuresthedatabaseTheindependenceofthedatainthesystem,thatis,changesinthephysicalorganizationofthedataandchangesinthelogicalconceptlevel,doesnotaffectthechangesintheexternalmodeoftheuser.Itonlyneedstoadjustthemappingmodewithoutchangingtheusermode.
Преобразуване от концептуален режим към вътрешен режим
Thismappinggivesthecorrespondencebetweenthegloballogicalstructureofthedataintheconceptualmodeandthephysicalstoragestructureofthedata.ThismappingisgenerallydefinedbyDBMSimplementation.
Преобразуване от външен режим в концептуален режим
Conceptmodeisaglobalmodeandexternalmodeisauser'slocalmode.Aconceptualmodecandefinemultipleexternalmodes,andeachTheexternalmodeisabasicviewoftheconceptualmode.Themappingfromtheexternalmodetotheconceptualmodegivesthecorrespondingrelationshipbetweentheexternalmodeandtheconceptualmode,andthismappingisgenerallyimplementedbyaDBMS.