商业智能解决方案从ROLAP到MOLAP的发展英文.ppt

FullSpectrumBISolutionFromROLAPtoMOLAP完整的商業智慧解決方案從ROLAP到MOLAP,StoneLee李志宏Sr.SalesConsultantOracleTaiwanCorporation,Agenda,DataWarehousing&OLAPCurrentStatusOracleOLAP&BISolutionSummary,OLAP,DataMining,RDBMSforDW/DM,Reporting,Ad-HocQuery,Analysis,Portal,TraditionalDW/BIArchitecture,DimensionObjectDimensionHierarchyLevelAttribute,DimensionObject,DimensionObject,DimensionObject,WhatistheROLAP?,資料儲存於關聯資料庫彙總資料可事先作運算,存於OracleMaterializeView熟悉SQLSkill大量資料查詢效率使用者可建立複雜的查詢條件.,WhatistheMOLAP?,資料儲存於多維度資料,Cube彙總資料可事先作運算,存於Cube中分析資料偏重於大量運算及彙總,像KPI需要透過簡易方式將複雜的運算包裝起來,像預測性分析需要分析模型來解決分析運算問題,像What-If分析,TheOldWayInformation&DataFragmentation,Relational,HyperionMSAnalysisServices,CognosPowerplayProClarity,CognosImpromptuBrio,IBMMSSQLServer,OLAP,Agenda,DataWarehousing&OLAPCurrentStatusOracleOLAP&BISolutionSummary,TheOracleWayInformation&DataConsolidation,Relational,TheOracleWayInformation&DataConsolidation,Relational&OLAPDatabasesUnite,TheOracleWayInformation&DataConsolidation,Relational&OLAPToolsUnite,Relational&OLAPDatabasesUnite,OLAPCatalog,Database,OracleOLAP&BISolution,OLAPCatalog,Database,OracleBusinessIntelligenceBeans,CustomBIApplicationsBIBeansintegratedwithJDeveloperprovidesapowerfulenvironmentforrapidlydevelopingpowerfulbusinessintelligenceapplicationsTargetedapplicationsenablecompaniestodelivervaluableinsightstoawiderangeofendusers:executives,analysts,informationconsumers,OracleOLAP&BISolution,VisualDefinitionofBIObjects,Crosstabs,tables支援,VisualDefinitionofBIObjects,支援長條,圓餅,折線,組合,柏拉圖多達14種圖表類型,QueryWizard,AnalyticPower,CustomBIApplication,OLAPEnabledDesktop,OracleBusinessIntelligenceBeans,CustomBIApplications,OLAPExcelAdd-in,OLAPExcelAdd-inQueryOracleOLAPdirectlyfromExcelLeveragesBIBeansQueryBuilderandCalcBuilder,OLAPExcelAdd-in,OLAPExcelAdd-in,DEMONSTRATION,OracleOLAPExcelAdd-In,OLAPEnabledDiscoverer,OracleBusinessIntelligenceBeans,CustomBIApplications,OLAPExcelAdd-in,OracleASDiscoverer,OracleASDiscovererAnintuitivead-hocquery,reporting,analysis,andWeb-publishingtoolEnablesadvancedanalysesonbothoperationalandOLAPdatasources,EasilyCreateReports,GetInformationatAnyLevel,IntegrateIntoDashboards,LinkPortletsToSharedControls,PublishWorksheetsWithBothDataandGraphs,LaunchYourFavoriteReportsFromOnePlace,DEMONSTRATION,OracleDiscovererPlusOLAP,Agenda,DataWarehousing&OLAPCurrentStatusOracleOLAP&BISolutionSummary,Information&DataConsolidation,Relational,Information&DataConsolidation,Relational&OLAPDatabasesUnite,Information&DataConsolidation,Relati