商业智能解决方案从ROLAP到MOLAP的发展英文版(PPT 34).pptx

2Full Spectrum BI Solution From ROLAP to MOLAP完整的商業智慧解決方案完整的商業智慧解決方案 從從 ROLAP 到到 MOLAPStone Lee 李志宏李志宏Sr.Sales ConsultantOracle Taiwan Corporation3AgendaData Warehousing&OLAP Current StatusOracle OLAP&BI SolutionSummary4OLAPData MiningRDBMS forDW/DMWeb SiteLegacyERPReportingAd-Hoc QueryAnalysisPortalETL EngineTraditional DW/BI Architecture5PRODUCTprod Aprod Bprod Cprod Dprod ESALESProdCustTimeCUSTcust Acust Bcust Ccust Dcust ETIMEYearQuarterMonthWeekDayDimension ObjectDimensionHierarchyLevelAttributeDimension ObjectDimension ObjectDimension ObjectCubeWhat is the ROLAP?資料儲存於關聯資料庫資料儲存於關聯資料庫彙總資料可事先作運算彙總資料可事先作運算,存於存於 Oracle Materialize Oracle Materialize ViewView熟悉熟悉 SQL SkillSQL Skill大量資料查詢效率大量資料查詢效率使用者可建立複雜的查使用者可建立複雜的查詢條件詢條件.6What is the MOLAP?CentralEastMonthProductWestJanFilmLensesCamerasSALESSALESDIMENSIONSFebMarKEYS 資料儲存於多維度資料資料儲存於多維度資料,Cube 彙總資料可事先作運算彙總資料可事先作運算,存於存於 Cube 中中 分析資料偏重於大量運算及彙總分析資料偏重於大量運算及彙總,像像 KPI 需要透過簡易方式將複雜的運算包裝起來需要透過簡易方式將複雜的運算包裝起來,像預測性分析像預測性分析 需要分析模型來解決分析運算問題需要分析模型來解決分析運算問題,像像 What-If 分析分析7The Old WayInformation&Data FragmentationRelationalHyperionMS Analysis ServicesCognos PowerplayProClarityCognos ImpromptuBrioIBMMS SQL ServerOLAP8AgendaData Warehousing&OLAP Current StatusOracle OLAP&BI SolutionSummary9The Oracle WayInformation&Data ConsolidationRelationalOLAP10The Oracle WayInformation&Data ConsolidationRelational&OLAPDatabases Unite11The Oracle WayInformation&Data ConsolidationRelational&OLAPTools UniteRelational&OLAPDatabases Unite12OLAP APIOLAP CatalogDatabaseWarehouse BuilderEnterprise ManagerAW ManagerOracle OLAP&BI SolutionAny SQL APPLICATION13OLAP APIOLAP CatalogDatabaseWarehouse BuilderEnterprise ManagerAW ManagerOracle Business Intelligence BeansCustom BI ApplicationsBI Beans integrated with JDeveloper provides a powerful environment for rapidly developing powerful business intelligence applicationsTargeted applications enable companies to deliver valuable insights to a wide range of end users:executives,analysts,information consumersCustom BI ApplicationsOracle OLAP&BI Solution14Visual Definition of BI ObjectsCrosstabs,tables 支援15Visual Definition of BI Objects支援長條,圓餅,折線,組合,柏拉圖 多達 14 種圖表類型16Query Wizard17Analytic Power18Custom BI Application19OLAP Enabled DesktopOLAP APIOLAP CatalogDatabaseWarehouse BuilderEnterprise ManagerAW ManagerOracle Business Intelligence BeansCustom BI ApplicationsOLAP Excel Add-inOLAP Excel Add-inQuery Oracle OLAP directly from ExcelLeverages BI Beans Query Builder and Calc Builder20OLAP Excel Add-in21OLAP Excel Add-in22D E M O N S T R A T I O NOracle OLAP Excel Add-In23OLAP Enabled DiscovererOLAP APIOLAP CatalogDatabaseWarehouse BuilderEnterprise ManagerAW ManagerOracle Business Intelligence BeansCustom BI ApplicationsOLAP Excel Add-inOracleAS DiscovererOracleAS DiscovererAn intuitive ad-hoc query,reporting,analysis,and Web-publishing tool Enables advanced analyses on both operational and OLAP data sources24Easily Create Reports25Get Information at Any Level26Integrate Into DashboardsLink PortletsTo SharedControlsPublishWorksheetsWith BothData andGraphsLaunch YourFavoriteReports FromOne Place27D E M O N S T R A T I O NOracle Discoverer Plus OLAP28AgendaData Warehousing&OLAP Current StatusOracle OLAP&BI SolutionSummary29Information&Data ConsolidationRelationalOLAP30Information&Data ConsolidationRelational&OLAPDatabases Unite31Information&Data ConsolidationRelational&OLAPTools UniteRelational&OLAPDatabases Unite32The Only 2 Products You NeedYouPortalGRIDDiscovererBIBeansOLAPDWGRIDOLTP33AQ&Q U E S T I O N SA N S W E R S