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".
Datawarehouseisasubject-oriented,integrated,time-related,unmodifiablecollectionofdata.Thisisthepositioningofthetechnicalcharacteristicsofthedatawarehouse.
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.