Home Tekniikka Tietovarastotekniikka

Tietovarastotekniikka



Basicinformation

WiththeriseandrapiddevelopmentoftheInternetinthelate1990s,wehaveenteredanewera,withalargeamountofinformationanddatacomingoncoming,usingscientificmethodstogoItismoreurgentthanevertoorganizedatatoaccuratelyanalyzeandaccuratelyjudgeallaspectsofbusinessinformationfromdifferentperspectives,andtheeffectivenessoftheimplementationofcommercialbehaviorsisalsomoreconcernedthanever.

Theinformationsystembuiltusingthesetechnologiesiscalledadatawarehousesystem.Withthecontinuousdeepeningoftheapplicationofdatawarehousetechnology,datawarehousetechnologyhasbeendevelopedbyleapsandboundsinrecentyears.Typicaldatawarehousesystems,suchas:businessanalysissystems,decisionsupportsystems,etc.Withthegoodresultsbroughtaboutbythedatawarehousesystem,unitsinallwalksoflifehavebeenabletoacceptnewaspectssuchas"integratingdata,findingknowledgefromdata,usingdataknowledge,andspeakingwithdata",whicharerelatedtoimprovingproductionactivities.Theconceptofimprovingproductionefficiencyanddevelopingproductivityinallaspects.

Datawarehousetechnologyisatooltoachieve"scientificjudgmentandeffectivebehavior"basedonrigorouslogicalthinkinginmathematicsandstatistics.Datawarehousetechnologyisalsoaneffectivemeanstoachieve"dataintegrationandknowledgemanagement".

Tietovarasto on aihekohtainen, integroitu, aikasidonnainen, muokkaamaton tiedonkeruu. Tämä on tietovaraston teknisten ominaisuuksien sijainti.

Founder

DatawarehouseconceptfounderWHInmondefinedadatawarehouseinthebook"BuildingaDataWarehouse"as:adatawarehouseissubject-oriented,integrated,andrelativelyAstable,time-changing(differenttime)datacollectionisusedtosupportthedecision-makingprocessinoperationandmanagement,andthedatainthedatawarehouseissubject-oriented,correspondingtotheapplication-orientedtraditionaldatabase.Thethemeisastandardforcategorizingdataatahigherlevel,andeachthemecorrespondstoamacroanalysisfield:theintegrationfeatureofthedatawarehousemeansthatbeforethedataentersthedatawarehouse,itmustgothroughdataprocessingandintegration.ThisistheestablishmentofdataThekeystepofthewarehouseistofirstunifythecontradictionsintheoriginaldata,andtotransformtheoriginaldatastructurefromapplication-orientedtotopic-oriented;thestabilityofthedatawarehousemeansthatthedatawarehousereflectshistoricaldata,notThedatageneratedbydailytransactionprocessingisprocessedandintegratedintothedatawarehousewithlittleornomodification;thedatawarehouseisacollectionofdataatdifferenttimes,whichrequiresthedatastoragetimelimitinthedatawarehousetomeettheneedsofdecision-makinganalysis,Andthedatainthedatawarehousemustbemarkedwiththehistoricalperiodofthedata.

Features

Themostfundamentalfeatureofadatawarehouseistostoredataphysically,andthesedataarenotup-to-dateandproprietary,butderivedfromotherdatabases.Theestablishmentofadatawarehouseisnotintendedtoreplacethedatabase.Itmustbeestablishedonthebasisofamorecomprehensiveandcompleteinformationapplicationtosupporthigh-leveldecisionanalysis.Thetransactionprocessingdatabaseisresponsiblefordailyoperationintheenterpriseinformationenvironment.Task.Datawarehouseisanewapplicationofdatabasetechnology,anddatawarehousestillusesrelationaldatabasemanagementsystemtomanagethedatainit.

Basicfeatures

Subject-oriented

Correspondingtotheapplication-orienteddataorganizationcharacteristicsoftraditionaldatabases,thedatainthedatawarehouseissubject-orientedorganization.Thesubject-orienteddataorganizationmethodisacompleteandconsistentdescriptionofthedataoftheanalysisobjectatahigherlevel,whichcancompletelyanduniformlydescribethedataandtherelationshipbetweenthedatainvolvedineachanalysisobject.

Integratedfeatures

Thedatainthedatawarehouseisextractedfromtheoriginalscattereddatabase,becausethesourcedatacorrespondingtoeachthemeofthedatawarehouseisintheoriginalscatteredTheremaybeduplicationorinconsistenciesinthedatabase,andtheintegrateddatacannotbedirectlyobtainedfromtheoriginaldatabase.Therefore,datamustbeunifiedandintegratedtoformintegrateddatabeforeenteringthedatawarehouse.

Constantlychangingovertime

Thenon-updateabilityofdatainthedatawarehouseisforapplications,thatis,usersdonotperformdataupdateoperationswhenperforminganalysisandprocessing;butnotInotherwords,duringtheentiredatagenerationcyclefromdataintegrationintothedatabasetothefinaldeletion,thedatainalldatawarehouseswillneverchange,butwillchangeovertime.

Non-volatility

Thenon-volatilityofdatainadatawarehouseisanotherimportantfeatureofadatawarehouse.Thedataintheoperationalenvironmentisusuallyaccessedandprocessedonerecordatatime,andthedataintheoperationalenvironmentcanbeupdated.However,thedatainthedatawarehouseisusuallyloadedandaccessedonce,andthedatainthedatawarehouseisnotupdatedinageneralsense.

This article is from the network, does not represent the position of this station. Please indicate the origin of reprint
TOP