ssd9课件 section 15 data warehousing,olap and data mining

《ssd9课件 section 15 data warehousing,olap and data mining》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、DataWarehousing,OLAPandDataMining1PrerequisitesforthissectionReadings:Required:CTESSD75.2Required:ConnollyandBegg,pages1204–1208,sections31.1,34.1,and34.5(inthirdedition,pages1101–1104,sections30.1,32.2.1,and32.2.8;insecondedition,sections25.1,26.1.1,26.2.1,and26.2.

2、8).Elective:ConnollyandBegg,sections33.2–33.5,34.2and34.4(inthirdedition,theremainderofchapter32;insecondedition,theremainderofchapter26).Assessments:Multiple-ChoiceQuiz92SectionobjectivesInthissectionyouwilllearn:1.ThepurposeofOnlineAnalyticalProcessing(OLAP).2.The

3、relationshipbetweenOLAPanddatawarehousing.3.ThekeyfeaturesofOLAPapplications.4.Howtorepresentmulti-dimensionaldata.5.Therelationshipbetweendatamininganddatawarehousing.6.Thepurposeofdatamining(DM)7.Thepropertiesofdatawarehouse.8.Theconceptofadatamartandthemainreason

4、sforimplementingadatamart.3Agenda1.SupportingOLAPandDataMining2.WhatisaDataWarehouse?3.DataWarehouseArchitecture4.MultidimensionalModeling5.Data-Warehouse-EnhancedQueryOperations6.MultidimensionalStorageModel7.IssuesandCategoriesofDataWarehouses4InformationRequireme

5、ntVLDBKnowledgediscoveryValuableknowledgeToomuchdataInformationRequirementWhatisthesumofWhatcausedtheWhataresalesinVancouverincreaseinsalesmyprojectedsalesthisyear?thisyear?nextyear?ClerksandClientsBusinessusersAnalystsTransactionTacticalStrategic6On-lineTransaction

6、Processing(OLTP)Themajortaskofon-lineoperationaldatabasesystemistoperformon-linetransactionandqueryprocessing.Thesesystemsarecalledon-linetransactionprocessing(OLTP)systems.Theycovermostoftheday-to-dayoperationsofanorganization,suchaspurchasing,inventory,manufacturi

7、ng,banking,payroll,registration,andaccounting.7On-lineAnalyticalProcessing(OLAP)Themajortaskistoserveusersorknowledgeworkersintheroleofdataanalysisanddecisionmaking.Suchsystemscanorganizeandpresentdatainvariousformatsinordertoaccommodatethediverseneedsofthedifferent

8、users.8ExampleofOLAPProductTimeSALESLocation9DataMining(DM)Dataminingreferstotheworkofdiscoveringnewanduseful(business)knowledgefromlarger