商业智能解决方案从ROLA到MOLA的发展英文版

FullSpectrumBISolution–FromROLAPtoMOLAP完整的商業智慧解決方案–從ROLAP到MOLAPStoneLee李志宏Sr.SalesConsultantOracleTaiwanCorporationAgenda

DataWarehousing&OLAPCurrentStatusOracleOLAP&BISolutionSummaryOLAPDataMiningRDBMSforDW/DMWebSiteLegacyERPReportingAd-HocQueryAnalysisPortalETLEngineTraditionalDW/BIArchitecturePRODUCTprodAprodBprodCprodDprodESALESProdCustTimeCUSTcustAcustBcustCcustDcustETIMEYearQuarterMonthWeekDayDimensionObjectDimensionHierarchyLevelAttributeDimensionObjectDimensionObjectDimensionObjectCubeWhatistheROLAP?資料儲存於關聯資料庫彙總資料可事先作運算,存於OracleMaterializeView熟悉SQLSkill大量資料查詢效率使用者可建立複雜的查詢條件.WhatistheMOLAP?CentralEastMonthProductWestJanFilmLensesCamerasSALESDIMENSIONSFebMarKEYS資料儲存於多維度資料,Cube彙總資料可事先作運算,存於Cube中分析資料偏重於大量運算及彙總,像KPI需要透過簡易方式將複雜的運算包裝起來,像預測性分析需要分析模型來解決分析運算問題,像What-If分析TheOldWay

Information&DataFragmentationRelationalHyperionMSAnalysisServicesCognosPowerplay

ProClarityCognosImpromptuBrioIBMMSSQLServerOLAPAgenda

DataWarehousing&OLAPCurrentStatusOracleOLAP&BISolutionSummaryTheOracleWay

Information&DataConsolidationRelationalOLAPTheOracleWay

Information&DataConsolidationRelational&OLAP

DatabasesUniteTheOracleWayInformation&DataConsolidationRelational&OLAPToolsUniteRelational&OLAPDatabasesUniteOLAPAPIOLAPCatalogDatabaseWarehouseBuilderEnterpriseManagerAWManagerOracleOLAP&BISolutionAnySQLAPPLICATIONOLAPAPIOLAPCatalogDatabaseWarehouseBuilderEnterpriseManagerAWManagerOracleBusinessIntelligenceBeansCustomBIApplicationsBIBeansintegratedwithJDeveloperprovidesapowerfulenvironmentforrapidlydevelopingpowerfulbusinessintelligenceapplicationsTargetedapplicationsenablecompaniestodelivervaluableinsightstoawiderangeofendusers:executives,analysts,informationconsumersCustomBIApplicationsOracleOLAP&BISolutionVisualDefinitionofBIObjectsCrosstabs,tables支援援VisualDefinitionofBIObjects支援援長長條條,圓圓餅餅,折折線線,組組合合,柏柏拉拉圖圖……………………多多達達14種種圖圖表表類類型型QueryWizardAnalyticPowerCustomBIApplicationOLAPEnabledDesktopOLAPAPIOLAPCatalogDatabaseWarehouseBuilderEnterpriseManagerAWManagerOracleBusinessIntelligenceBeansCustomBIApplicationsOLAPExcelAdd-inOLAPExcelAdd-inQueryOracleOLAPdirectlyfromExcelLeveragesBIBeansQueryBuilderandCalcBuilderOLAPExcelAdd-inOLAPExcelAdd-inDEMONSTRATIONOracleOLAPExcelAdd-InOLAPEnabledDiscovererOLAPAPIOLAPCatalogDatabaseWarehouseBuilderEnterpriseManagerAWManagerOracleBusinessIntelligenceBeansCustomBIApplicationsOLAPExcelAdd-inOracleASDiscovererOracleASDiscovererAnintuitivead-hocquery,reporting,analysis,andWeb-publishingtoolEnablesadvancedanalysesonbothoperationalandOLAPdatasourcesEasilyCreateReportsGetInformationatAnyLevelIntegrateIntoDashboardsLinkPortletsToSharedControlsPublishWorksheets

WithBothDataandGraphsLaunchYourFavoriteReportsFromOnePlaceDEMONSTRATIONOracleDiscovererPlusOLAPAgendaDataWarehousing&OLAPCurrentStatusOracleOLAP&BISolutionSummaryInformation&DataConsolidationRelationalOLAPInformation&DataConsolidationRelational&OLAPDatabasesUniteInformation&DataConsolidationRelational&OLAPToolsUniteRelational&OLAPDatabasesUniteTheOnly2ProductsYouNeedYouPortalGRIDDiscovererBIBeansOLAPDWGRIDOLTPAQ&QUESTIONSANSWERS9、静夜四无邻邻，荒居旧业业贫。。12月-2212月-22Thursday,December22,202210、雨中中黄叶叶树，，灯下下白头头人。。。07:33:3207:33:3207:3312/22/20227:33:32AM11、以以我我独独沈沈久久，，愧愧君君相相见见频频。。。。12月月-2207:33:3207:33Dec-2222-Dec-2212、故故人人江江海海别别，，几几度度隔隔山山川川。。。。07:33:3207:33:3207:33Thursday,December22,202213、乍乍见见翻翻疑疑梦梦，，相相悲悲各各问问年年。。。。12月月-2212月月-2207:33:3307:33:33December22,202214、他他乡乡生生白白发发，，旧旧国国见见青青山山。。。。22十十二二月月20227:33:33上上午午07:33:3312月月-2215、比不了了得就不不比，得得不到的的就不要要。。。。十二月227:33上午午12月-2207:33December22,202216、行动出成成果，工作作出财富。。。2022/12/227:33:3307:33:3322December202217、做前，能够够环视四周；；做时，你只只能或者最好好沿着以脚为为起点的射线线向前。。7:33:33上午7:33上上午07:33:3312月-229、没没有有失失败败，，只只有有暂暂时时停停止止成成功功！！。。12月月-2212月月-22Thursday,December22,202210、很多事事情努力力了未必必有结果果，但是是不努力力却什么么改变也也没有。。。07:33:3307:33:3307:3312/22/20227:33:33AM11、成功就就是日复复一日那那一点点点小小努努力的积积累。。。12月-2207:33:3307:33Dec-2222-Dec-2212、世间间成事事，不不求其其绝对对圆满满，留留一份份不足足，可可得无无限完完美。。。07:33:3307:33:3307:33Thursday,December22,202213、不知知香积积寺，，数里里入云云峰。。。12月月-2212月月-2207:33:3307:33:33December22,202214、意志坚坚强的人人能把世世界放在在手中像像泥块一一样任意意揉捏。。22十十二月20227:33:34上午午07:33:3412月-2215、楚塞三三湘接，，荆门九九派通。。。。十二月227:33上午午12月-2207:33December22,202216、少年十十五二十十时，步步行夺得得胡马骑骑。。2022/12/227:33:3407:33:3422December202217、空山新新雨后，，天气晚晚来秋。。。7:33:34上午午7:33上午午07:33:3412月-229、杨柳散和和风，青山山澹吾虑。。。12月-2212月-22Thursday,December22,202210、阅阅读读一一切切好好书书如如同同和和过过去去最最杰杰出出的的人人谈谈话话。。07:33:3407:33:3407:3312/22/20227:33:34AM11、越是没没有本领领的就越越加自命命不凡。。12月-2207:33:3407:33Dec-2222-Dec-2212、越是无无能的人人，越喜喜欢挑剔剔别人的的错儿。。07:33:3407:33:3407:33Thursday,December22,202213、知知人人者者智智，，自自知知者者明明。。胜胜人人者者有有力力，，自自胜胜者者强强。。12月月-221