data modeling techniques for data warehousing

《data modeling techniques for data warehousing》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、Chapter1.IntroductionBusinessesofallsizesandindifferentindustries,aswellasgovernmentagencies,arefindingthattheycanrealizesignificantbenefitsbyimplementingadatawarehouse.Itisgenerallyacceptedthatdatawarehousingprovidesanexcellentapproachfortransformingthevastamountso

2、fdatathatexistintheseorganizationsintousefulandreliableinformationforgettinganswerstotheirquestionsandtosupportthedecisionmakingprocess.Adatawarehouseprovidesthebaseforthepowerfuldataanalysistechniquesthatareavailabletodaysuchasdataminingandmultidimensionalanalysis,

3、aswellasthemoretraditionalqueryandreporting.Makinguseofthesetechniquesalongwithdatawarehousingcanresultineasieraccesstotheinformationyouneedformoreinformeddecisionmaking.Thequestionmostaskednowis,HowdoIbuildadatawarehouse?Thisisaquestionthatisnotsoeasytoanswer.Asyou

4、willseeinthisbook,therearemanyapproachestobuildingone.However,attheendofalltheresearch,planning,andarchitecting,youwillcometorealizethatitallstartswithafirmfoundation.Whetheryouarebuildingalargecentralizeddatawarehouse,oneormoresmallerdistributeddatawarehouses(somet

5、imescalleddatamarts),orsomecombinationofthetwo,youwillalwayscometothepointwhereyoumustdecideonhowthedataistobestructured.Thisis,afterall,oneofthemostkeyconceptsindatawarehousingandwhatdifferentiatesitfromthemoretypicaloperationaldatabaseanddecisionsupportapplication

6、building.Thatis,youstructurethedataandbuildapplicationsarounditratherthanstructuringapplicationsandbringingdatatothem.Howwillyoustructurethedatainyourdatawarehouse?Thepurposeofthisbookistohelpyouwiththatdecision.Itallrevolvesarounddatamodeling.Everyonewillhavetodeve

7、lopadatamodel;thedecisionishowmuchefforttoexpendonthetaskandwhattypeofdatamodelshouldbeused.Therearenewdatamodelingtechniquesthathavebecomepopularinrecentyearsandprovideexcellentsupportfordatawarehousing.Thisbookdiscussesthosetechniquesandofferssomeconsiderationsfor

8、theirselectioninadatawarehousingenvironment.Datawarehousemodelingisaprocessthatproducesabstractdatamodelsforoneormoredatabasecomponentsoft