TNT2004TNT2004--07120712SQL2000AnalysisServicesSQL2000AnalysisServicesCTOCTO¾¾¾¾¾¾¾¾¾¾AnnuncioAnnuncio¾¾AVPAVP¾¾¾¾BIBIAnalysisServicesAnalysisServices““””BIBIBI?BI?BIBI¾¾¾¾¾¾DataData¾¾InformationInformation¾¾KnowledgeKnowledgeBI?BI?BusinessIntelligenceBusinessIntelligenceGartnerGroupGartnerGroup19961996OLAPOLAP??5-10%15-25%65-80%BIBI¾¾DataWarehouseDataWarehouseDataMartDataMart¾¾OLAPOLAPOLAPOLAP¾¾¾¾DataMiningDataMiningBIBIBIBI¾¾¾¾KPIKPI¾¾¾¾BIBICubeCubeBIBI1212¾¾//DWDW57%57%¾¾WebWeb40%40%¾¾//34%34%¾¾34%34%¾¾61%61%¾¾43%43%¾¾39%39%¾¾35%35%¾¾//32%32%DMReviewTheOLAPSurveyBIBIAnalysisServicesAnalysisServicesOLAPOLAPOracleDeveloperServer/DiscovererOracleDeveloperServer/DiscovererIBMIBMEssbaseEssbaseMicrosoftMicrosoftSAPSAPCACAHyperion/BrioHyperion/BrioBusinessObjects/CrystalReportBusinessObjects/CrystalReportCognosCognosMicroStrategyMicroStrategyMSASMSASTheOLAPSurveyTheOLAPSurveyTT33--MOLAPCubeMOLAPCube1.21.2TBTBDWDW¾¾7777RDWRDWMOLAPMOLAP440440GBGB¾¾5050¾¾=0.02=0.02--0.08sec0.08secOLAPOLAPOnlineAnalyticalOnlineAnalyticalProcessingProcessing--EFEFCoddCodd19941994OLAP=OLAP=OLTPOLTP(real(real--time)time)¾¾¾¾¾¾¾¾¾¾¾¾OLAPOLAP––¾¾““How/what/when/why/whereHow/what/when/why/where””¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾OLTPvs.OLAPOLTPvs.OLAPOLAPOLAPOLTPOLTPOLAPOLAP“…4”RegionWSN$10$1011CubeCubeCubesCubes11334422¾¾FactTableFactTable¾¾(())¾¾…………¾¾DimensionTablesDimensionTables¾¾Employee_DimEmployee_DimEmployeeKeyEmployeeID...EmployeeKeyEmployeeKeyTime_DimTime_DimTimeKeyTheDate...TimeKeyTimeKeyProduct_DimProduct_DimProductKeyProductIDProduceNameProductBrandProductCategory...ProductKeyProductKeyCustomer_DimCustomer_DimCustomerKeyCustomerIDCustomerKeyCustomerKeyShipper_DimShipper_DimShipperKeyShipperID.ShipperKeyShipperKeySales_FactSales_FactTimeKeyEmployeeKeyProductKeyCustomerKeyShipperKeyUnitsPrice...TimeKeyTimeKeyCustomerKeyCustomerKeyShipperKeyShipperKeyProductKeyProductKeyEmployeeKeyEmployeeKeySales_FactSales_FactTimeKeyEmployeeKeyProductKeyCustomerKeyShipperKeyUnitsPrice...Product_Brand_IdProduct_Brand_IdProductBrandProductCategoryIDProduct_Category_IdProduct_Category_IdProductCategoryProductCategoryIDProduct_DimProduct_DimProductKeyProductNameProductSizeProductBrandID¾¾¾¾22CubeCubeCubesCubes11334422ETLETLbuyer_namebuyer_nameBarr,AdamChai,SeanO’Melia,Erin...reg_idreg_id246...total_salestotal_sales17.6052.808.82...buyer_namebuyer_nameBarr,AdamChai,SeanO’Melia,Erin...reg_idreg_id246...total_salestotal_sales17.6052.808.82...buyer_namebuyer_nameBarr,AdamChai,SeanO’Melia,Erin...price_idprice_id.551.10.98...qty_idqty_id32489...buyer_namebuyer_nameBarr,AdamChai,SeanO’Melia,Erin...reg_idreg_idIIIVVI...total_salestotal_sales17.6052.808.82...buyer_namebuyer_nameBarr,AdamChai,SeanO’Melia,Erin...price_idprice_id.551.10.98...qty_idqty_id32489...total_salestotal_sales17.6052.808.82...buyer_firstbuyer_firstAdamSeanErin...buyer_lastbuyer_lastBarrChaiO’Melia...reg_idreg_id246...total_salestotal_sales17.6052.808.82...33CubeCubeCubesCubes11334422CubeCubeMOLAPMOLAPOLAPOLAPROLAPROLAPOLAPOLAPHOLAPHOLAPOLAPOLAP44CubeCubeCubesCubes11442233ReportingServiceReportingServiceSQLSQL¾¾select*fromcustomerwhereage>30select*fromcustomerwhereage>30MDXMDXMDX?MDX?MicrosoftOfficeXPMicrosoftOfficeXPExcelExcelOLEDBforOLEDBforOLAPOLAPOfficeWebOfficeWebReportingServiceReportingServiceBIBI5-10%15-25%65-80%ProClarityProClarityxxxxvs.vs.ProClarityProClarityProClarityProClarityDEMODEMOBIBIAnalysisServicesAnalysisServicesinfo@minesage.cominfo@minesage.comThankyou!Thankyou!