完整的商業智慧解決方案–從ROLAP到MOLAP.ppt

Agenda Data Warehousing OLAP Current Status Oracle OLAP BI Solution Summary What is the MOLAP ? The Old WayInformation Data Fragmentation Agenda Data Warehousing OLAP Current Status Oracle OLAP BI Solution Summary The Oracle WayInformation Data Consolidation The Oracle WayInformation Data Consolidation The Oracle WayInformation Data Consolidation Oracle OLAP BI Solution Oracle OLAP BI Solution Visual Definition of BI Objects Crosstabs , tables 支援 Visual Definition of BI Objects 支援長條, 圓餅, 折線, 組合, 柏拉圖 …………多達 14 種圖表類型 Query Wizard Analytic Power Custom BI Application OLAP Enabled Desktop OLAP Excel Add-in OLAP Excel Add-in OLAP Enabled Discoverer Easily Create Reports Get Information at Any Level Integrate Into Dashboards Agenda Data Warehousing OLAP Current Status Oracle OLAP BI Solution Summary Information Data Consolidation Information Data Consolidation Information Data Consolidation The Only 2 Products You Need You Portal GRID Discoverer BI Beans OLAP DW GRID OLTP A Q Q U E S T I O N S A N S W E R S Oracle BI Beans is an integrated Extension to JDeveloper, providing a powerful environment to develop analytic applications quickly and easily. The BI Beans accesses the 9i Database through the Java OLAP API which enables access to the power of the 9i Database and to the powerful new SQL analytic functions. Using this approach, custom applications can be targeted at specific user needs. * Full Spectrum BI Solution – From ROLAP to MOLAP 完整的商業智慧解決方案 – 從 ROLAP 到 MOLAP Stone Lee 李志宏 Sr. Sales Consultant Oracle Taiwan Corporation OLAP Data Mining RDBMS for DW/DM Web Site Legacy ERP Reporting Ad-Hoc Query Analysis Portal ETL Engine Traditional DW/BI Architecture PRODUCT prod A prod B prod C prod D prod E SALES Prod Cust Time CUST cust A cust B cust C cust D cust E TIME Year Quarter Month Week Day Dimension Object Dimension Hierarchy Level Attribute Dimension Object Dimension Object Dimension Object Cube What is the ROLAP ? 資料儲存於關聯資料庫 彙總資料