際際滷

際際滷Share a Scribd company logo

Oracle Business Analytics Overview

C
crm2life
1 of 37
Downloaded 18 times
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.1 Oracle Business Analytics 仆舒仍亳亳亠从舒 仗仍舒仂仄舒 仂 Oracle 舒舒仍 仂弍仆仂于舒 Oracle CIS
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.2 仆舒仍亳亳亠从舒 仗仍舒仂仄舒 Oracle 仆亠舒从亳于仆亠 亰舒仗仂 亳 舒仆舒仍亳亰, 亳仆仂仄舒亳仂仆仆亠 仗舒仆亠仍亳, 亟亠舒仍亳亰舒亳 亳 仆舒于亳亞舒亳 Business Intelligence Enterprise Edition OLAP 舒仆舒仍亳亰, 亠仆舒仆仂亠 仄仂亟亠仍亳仂于舒仆亳亠, 亳亠仄 仗仍舒仆亳仂于舒仆亳 Essbase 仍亠亟仂于舒仆亳亠 亟舒仆仆, 舒亠仆亶 仗仂亳从 亳 仆舒于亳亞舒亳 亟仍 从亳仂于舒仆仆 亳 仆亠从亳仂于舒仆仆 亟舒仆仆 Endeca Information Discovery BI Foundation Suite Advanced Analytics 仂亠仆亠 于 Oracle Database 舒亳亳从舒, data mining 亳 磶从 R 仂亞舒仄仄仆仂-舒仗仗舒舒仆亶 从仂仄仗仍亠从 亅从亠仄舒仍仆舒 仗仂亳亰于仂亟亳亠仍仆仂 In-memory 舒仆舒仍亳亳从舒 R 仂仂于亠 舒仆舒仍亳亳亠从亳亠 仗亳仍仂亢亠仆亳BI Applications
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.3 仂仗仂舒亳于仆舒 舒仆舒仍亳亳亠从舒 仗仍舒仂仄舒 Oracle Business Intelligence 从亳于仆亶 弍亳亰仆亠-舒仆舒仍亳亰 亠亞仍舒仄亠仆亳仂于舒仆仆亠 仂仄 仂弍亳仍仆舒 舒仆舒仍亳亳从舒 仂亳亰于仂仍仆亠 亰舒仗仂 亳 仂亠 仍ﾑ亠于亠 仗仂从舒亰舒亠仍亳 亠从亳于仆仂亳 SINGLE ENTERPRISE INFORMATION MODEL 亊 弌 亂 仆亠亞舒亳 c MS Office 仂舒仆于亠仆仆舒 舒仆舒仍亳亳从舒仆仂仄舒亳仂仆仆亠 仗舒仆亠仍亳
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.4 仂仗仂舒亳于仆舒 仄仂亟亠仍 亟舒仆仆
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.5 仆舒仍亳亳亠从亳亶 亠于亠 仂亰仄仂亢仆仂亳 舒亞仄亠仆舒亳亳 亳 亠亟亠舒亳亳 亠亳从舒仍仆舒 - 亳仂仆亳从亳 仂亟亠亢舒 舒亰仆亠 仗仂从舒亰舒亠仍亳 仂亳亰仂仆舒仍仆舒 - 亳仂仆亳从亳 仂亟亠亢舒 舒亰仆亠 仆舒弍仂 亟舒仆仆 亞亠亞亳仂于舒仆亳 - 亳仂仆亳从亳 仂亟亠亢舒 舒亞亠亞舒 舒亰仍亳仆 仂于仆亠亶 仍舒仆 个舒从 source1 source2 仂 2010亞. 仂仍亠 2011亞. source1 source2 仗仂 仄亠舒仄 source1 仗仂 亞仂亟舒仄 source2 仗仂 亟仆礆 source3 舒于亳亞舒亳 从 亳仂仆亳从舒仄 仂亠于仍磳 舒于仂仄舒亳亠从亳, 仗仂 亠亰仍舒舒仄 仂仗亳仄亳亰舒亳亳 亰舒仗仂舒 仗仂仍亰仂于舒亠仍 仂亞亳亠从舒 舒弍仍亳舒 1 仂亞亳亠从舒 舒弍仍亳舒 1 仂亞亳亠从舒 舒弍仍亳舒 1
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.6 仂亰仄仂亢仆仂亳 舒亞仄亠仆舒亳亳 舒 仗亳仄亠亠 舒亞亠亞舒亳亳
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.7 仆亠舒从亳于仆亠 舒仆舒仍亳亳亠从亳亠 仗舒仆亠仍亳 BI Dashboards 仆亠舒从亳于仆亠, 仗亠仂仆舒仍亳亰亳仂于舒仆仆亠 仗亠亟舒于仍亠仆亳 亠舒仍亳亰舒亳 亟仂 仂于仆 舒仆亰舒从亳亶 丿亳仂从亳亠 于仂亰仄仂亢仆仂亳 仆舒于亳亞舒亳亳 仂亠仆仆亠 亠仆舒亳亳 舒仆舒仍亳亰舒
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.8 仂亳亰于仂仍仆亠 亰舒仗仂 亳 仂亠 Analyses 仂仂亶 亳仆亳亳于仆亶 亳仆亠亠亶 仂仄亳仂于舒仆亳 仂亠仂于 drag and drop 仗仂仍亰仂于舒仆亳亠 弍亳亰仆亠- 亠仄亳仆仂仍仂亞亳亳 仗亠亟仄亠仆 仂弍仍舒亠亶 仂亰仄仂亢仆仂 仂仄亳仂于舒仆亳 仂弍于亠仆仆 于亳仍磳仄 仄亠亳从 亳 亞仗仗 舒亰仍亳仆亠 仗仂仂弍 于亳亰舒仍亳亰舒亳亳 亟舒仆仆 仂仂亶 亳仆仄亠仆 ﾐ頴委 于亳亰舒仍亳亰舒亳
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.9 亳亰仆亠-舒仆舒仍亳亰 亳 仗仂舒仆于亠仆仆亠 亟舒仆仆亠 Location Intelligence 仂仍亳仆于仂 舒仆舒仍亳亳亠从亳 亟舒仆仆 于舒亢仆仂 舒仄舒亳于舒 于 仗亳于磶从亠 从 亞亠仂亞舒亳亠从亳仄 仂弍亠从舒仄 仂舒仆于亠仆仆舒 于亳亰舒仍亳亰舒亳 仂弍亠仗亠亳于舒亠 弍仂仍亠亠 亞仍弍仂从仂亠 仗仂仆亳仄舒仆亳亠 亳 舒亳磳 于仂亰仄仂亢仆仂亳 舒仆舒仍亳亰舒
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.10 仆亠舒从亳于仆舒 弍亳亰仆亠-舒仆舒仍亳亳从舒
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.11 仍舒仂仄舒 亟仍 弍仂亶 舒亰舒弍仂从亳 舒仆舒仍亳亳从亳 仆舒 从舒舒 亠 仆亠仂弍仂亟亳仄亠 从仂仄仗仂仆亠仆 亟仍 亞亠仂舒仆舒仍亳亳从亳 亢亠 磦仍ﾑ 舒 BI 仗仍舒仂仄 Oracle DB locator 亳仍亳 spatial 亟仍 舒仆亠仆亳 亞亠仂 亟舒仆仆; Oracle BI Mapviewer 亟仍 仂仂弍舒亢亠仆亳 亞亠仂 亟舒仆仆 于 亳仆亠亠亶亠; 仂仄仗仂仆亠仆 于 Oracle BI, 仗仂亰于仂仍ﾑ亳亠 亳仆亠亞亳仂于舒 舒仆舒仍亳亳亠从亳亠 亳 亞亠仂 亟舒仆仆亠.
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.12 亳亠从舒 从仂仄仗仂仆亠仆仂于 Location Intelligence 仂舒仆于亠仆仆亠 亟舒仆仆亠 (亞舒仆亳 亠亞亳仂仆仂于) 亠舒亟舒仆仆亠 Mapviewer 仆舒仍亳亳亠从亳亠 亟舒仆仆亠 弌仗舒于仂仆亳从 亠亞亳仂仆仂于 (舒 仗亠亟仄. 仂弍仍舒亳 BI) Oracle Database Oracle Weblogic Application Server Oracle BI /analytics Oracle Mapviewer /mapviewer Oracle MapBuilder Java desktop 仂仄仂仆亠仆 仆亠仂弍仂亟亳仄 仂仍从仂 亟仍 仂仗亠亟亠仍亠仆亳 仄亠舒亟舒仆仆
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.13 舒亟舒亳 Location Intelligence 亟仍 亳亠亶仍仂于 弍舒仆从仂于 仗亳仄亳亰舒亳 舒仗仂仍仂亢亠仆亳亶 仂亟亠仍亠仆亳亶 亳 仂仗亠亟亠仍亠仆亳亠 仗亠亠亞亢亠仆仆 亳 仆亠亟仂亞亢亠仆仆 仂亟亠仍亠仆亳亶 亳仍亳 弍舒仆从仂仄舒仂于 磦仍亠仆亳亠 亳仍亳舒仍仂于 从仂仆从亳ﾑ亳 弍舒仆从仂于, 从仂亠仍亳 亰舒亞亢亠仆仆仂 亳 仗亳弍仍仆仂 仂弍于亠仆仆 仂亳仂于 仂仆亳仄舒仆亳亠 仗舒亠仆仂于 仗仂于亠亟亠仆亳 亞仗仗 从仍亳亠仆仂于 于 亰舒于亳亳仄仂亳 仂 亞亠仂亞舒亳亠从仂亞仂 仗仂仍仂亢亠仆亳 仂亳仂于 仍亠亢亳于舒仆亳亠 亳仗仂仍亰仂于舒仆亳 弍舒仆从仂于从亳 亠于亳仂于 亳 仗仂亟从仂于 丐舒亞亠亳仂于舒仆仆亶 仄舒从亠亳仆亞 亳 亳仆仂仄亳仂于舒仆亳亠 仂 亠于亳舒
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.14 仂弍亳仍仆舒 舒仆舒仍亳亳从舒 亠 从仂仆亠仆 Oracle BI 亟仂仗亠仆 仆舒 仄仂弍亳仍仆仂亶 仗仍舒仂仄亠 仗仂亟 iOS 弍亠亰 亟仂仗仂仍仆亳亠仍仆仂亶 舒亰舒弍仂从亳 仂仍仆仂 亳仆亠舒从亳于仆亠 舒仆舒仍亳亳亠从亳亠 仗亳仍仂亢亠仆亳 亠仂舒仆舒仍亳亳从舒, 舒仍亠, 亰舒仗从 弍亳亰仆亠- 仗仂亠仂于 弌仂弍仍ﾐ莞黍出湖 从仂仗仂舒亳于仆 仗仂仍亳亳从 弍亠亰仂仗舒仆仂亳, 于 .. SSL BI Mobile HD
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.15 仂弍亳仍仆舒 舒仆舒仍亳亳从舒 亊 于仂亰仄仂亢仆仂 仂亰亟舒于舒 仄仂弍亳仍仆亠 仗亳仍仂亢亠仆亳 亟仍 仍ﾐ頴笑 仗仍舒仂仄, 仗仂亟亟亠亢亳于舒ﾑ亠亶 html5 仂亠 仂亰亟舒仆亳亠 仄仂弍亳仍仆 舒仆舒仍亳亳亠从亳 仗亳仍仂亢亠仆亳亶 弍亳亰仆亠 仗仂仍亰仂于舒亠仍礆亳(drag and drop, 弍亠亰 仗仂亞舒仄仄亳仂于舒仆亳) 仂亰仄仂亢仆仂 仂亰亟舒仆亳 仂弍于亠仆仆 仗仍舒亞亳仆仂于 BI Mobile App Designer
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.16 仆亠亞舒亳 仂亳仆仄亳 仗仂亟从舒仄亳 SmartView BI Presentation Catalog 于 Smart View 弍亠仗亠亠仆亳亠 弍亠亰仂仗舒仆仂亳, 于从仍ﾑ舒 single sign-on 仂亟亟亠亢从舒 亳仍仂于 舒仆亳 亳 仂亠仂于 Export Dashboards & Dashboard Content 亅从仗仂 仂亠仂于 于 Native Excel 亳 Powerpoint (2003, 2007+) 亅从仗仂 仆舒仍亳亳亠从亳 仗舒仆亠仍亠亶 亳 舒仆亳; 舒仆亳 舒仗仂仍舒亞舒ﾑ 仆舒 仂亟亠仍仆 仍亳舒 Excel 弌仂亰亟舒仆亳亠 仂亠仂于 亳亰 Smart View 弌仂亰亟舒仆亳亠 仂弍于亠仆仆 仂亠仂于 亳亰 Excel 弍仍亳从舒亳 于 Web Catalog
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.17 Oracle Scorecard and Strategy Management 弌仗亠亳舒仍仆亠 BI-仂弍亠从 仍ﾑ亠于亠 仗仂从舒亰舒亠仍亳 (KPI) 舒从/仗仍舒仆, 仗仂仂亞亳, 于亳仍亠仆亳 弌舒亠亞亳亳, 亠仍亳, 仗亠仗亠从亳于 于仂仄舒亳亠从亳亶 仄仂仆亳仂亳仆亞 KPI 舒仍亠 仆舒 仂仆仂于亠 仗仂仂亞仂于 亳亰舒仍亳亰舒亳 舒亠亞亳亶 亳 KPI 弌舒亠亞亳亠从亳亠 从舒 亳 亳亠舒亳亳 亠仍亠亶 亳亳仆仆仂-仍亠亟于亠仆仆亠 于亰舒亳仄仂于磶亳 仆仆仂舒亳亳 亳 从仂亠从亳仂于从亳 仂仆亳仂亳仆亞 亟亠亠仍仆仂亳 从仂仄仗舒仆亳亳 于 舒亳 亟仂亳亢亠仆亳 舒亠亞亳亠从亳 亠仍亠亶
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.18 KPI 弌仗亠亳舒仍仆亠 仂弍亠从 于 Oracle BI EE KPI 仂仆仂于舒仆 仆舒 仗仂从舒亰舒亠仍 仗亠亟仄亠仆仂亶 仂弍仍舒亳 BI 亳 仂舒亢舒亠 仂仂礌亳亠 于仗仂仍仆亠仆亳 仗仍舒仆舒 仂亞亳从舒 KPI 仆舒舒亳于舒亠, 仗亳仄亠: 仍亳 仍舒仆 于仗仂仍仆亠仆 >= 100%, 舒 仍亳 仍舒仆 于仗仂仍仆亠仆 >= 80%, 舒 仆亳仄舒仆亳亠 亳仆舒亠, 舒 亳亳仆仂 亠亶于亳 KPI 仄仂亢仆仂 仆舒亰仆舒舒 舒舒仄, 仗亳仄亠: 亠亠亶亳 仆舒 仂亠 Oracle BI 仆亳亳仂于舒 弍亳亰仆亠-仗仂亠 于 亟亞仂亶 亳亠仄亠 仗舒于亳 于亠亟仂仄仍亠仆亳亠 仗仂 email
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.19 KPI 舒从 仄仂亢仆仂 亳仗仂仍亰仂于舒 亳 仂弍亠从? 仂仄仂 于 于亳亟亠 仂亠仂于 仂仆亳仂亳仆亞 仗亳从舒 KPI 仂仂亠仆亳亠 Scorecards 亠 仗仂 KPI 亞亠仆亠亳ﾑ 舒于仂仄舒亳亠从亳 弌仂亰亟舒仆亳亠 束仄仆損 仗亳从仂于 KPI 弌于仂亟仆舒 亳仆仂仄舒亳 仗仂 KPI - 舒于仂仄舒亳亠从亳 KPI 束仂亳亠仍仆亠 弍仍仂从亳損
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.20 Scorecards 亳仄亠 舒亠亞亳亳 束仂仄仗舒仆亳 丱損 丕仍亳 亳仆. 亠亰仍舒 丕仍亳 仂仆仂亠仆亳 从仍亳亠仆舒仄亳 丕于亠仍亳亳 仗仂亟舒亢亳 丕仄亠仆亳 亰舒舒 于从舒 从仂仍-于仂 仗仂亟舒亢 舒亟仄亳仆. 舒仂亟 . 于亠仄 仂亢亳亟舒仆亳 从仂仍-于仂 仂亟仆亳从仂于 亠仍亳 KPI 舒亠亞亳 丕于亠仍亳亳 - 仂亟仆亳从仂于
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.21 丕仗舒于仍亠仆亳亠 亠从亳于仆仂 弍亳亰仆亠舒 舒 舒亠亞亳亶, 亳亠舒亳亳 亠仍亠亶, 仗亳亳仆仆仂-仍亠亟于亠仆仆亠 于磶亳
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.22 Hyperion Essbase 仆仂亞仂仄亠仆舒 弍舒亰舒 亟舒仆仆
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.23 舒亠仄 亳仗仂仍亰仂于舒 仄仆仂亞仂仄亠仆亠 从弍 OLAP 弍舒亰舒 亟舒仆仆 亅亠从亳于仆仂亠 亢舒仂亠 舒仆亠仆亳亠 舒亞亠亞亳仂于舒仆仆 亟舒仆仆 从仍舒亠亳亰舒亳 in-memory 亠仆仂仍仂亞亳 -- Essbase for Exalytics 亠亰仍舒 仄仂亞 舒仆亳 亳仍亳 于亳仍 束仆舒 仍亠損 亶 亟仂仗 从 舒亞亠亞舒舒仄 仂仆亠 舒仆舒仍亳亳亠从亳亠 亳 于亳仍亳亠仍仆亠 于仂亰仄仂亢仆仂亳 仍ﾐ英亠 于亳亟 仆亠弍舒仍舒仆亳仂于舒仆仆 亳亠舒亳亶 仍ﾐ頴笑 从仂仍亳亠于仂 舒仍亠仆舒亳于仆 亳亠舒亳亶 弍仂仍亠亠 350 于仂亠仆仆 仆从亳亶 仂亰仄仂亢仆仂 仄仂亟亠仍亳仂于舒仆亳, 仗仂亞仆仂亰亳仂于舒仆亳, what-if 舒仆舒仍亳亰舒
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.24 Block Storage Option 仍 仗亳仍仂亢亠仆亳亶, 于磶舒仆仆 亳亠舒亳于仆仄 仗仍舒仆亳仂于舒仆亳亠仄, 舒仗亠亟亠仍亠仆亳礆亳, 仍仂亢仆仄 舒仆舒仍亳亰仂仄 (舒仆舒仍亳亰 仗仂亟舒亢, 舒仆舒仍亳亰 仗亳弍仍仆仂亳) 仗仂仍仆亠仆亳亠 仍仂亢仆 于亳仍亠仆亳亶 亳 亰舒仗亳 亳亰仄亠仆亠仆亳亶 仆舒 仍ﾐ頴笑 仂于亠仆 舒亞亠亞舒亳亳 丕仗舒于仍亠仆亳亠 仗仂磲从仂仄 于亳仍亠仆亳 亳亰仄亠亠仆亳亶 亠亠舒亠 于亠亶 亳仍亳 舒亳 舒仆仆亠 仆舒 仆亳亢仆亠仄 仂于仆亠 亳仍亠仆仆舒 亳仍亳亠仍仆亠 仗仂亠亟
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.25 亞亠亞亳仂于舒仆仆亠 亟舒仆仆亠 舒仆仆亠 仆舒 仆亳亢仆亠仄 仂于仆亠 Aggregate Storage Option 仍 从仗仆仂仄舒舒弍仆, 舒亰亠亢亠仆仆 亟舒仆仆 弍仂仍亳仄 从仂仍亳亠于仂仄 (亟亠从亳) 弍仂仍亳 (仂仆亳 ) 舒亰仄亠仆仂亠亶 于仂仄舒亳亠从舒 仂仗亳仄亳亰舒亳 舒仆亠仆亳, 亢舒亳亠 弌舒仆亟舒仆亶 仆舒弍仂 仗舒于亳仍 舒亞亠亞舒亳亳 仂从舒 亞亳弍从仂 亟仍 仂亠仂于 亳 舒仆舒仍亳亰舒
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.26 亳仄亠 仗仂亳亰于仂亟亳亠仍仆仂亳 仂亠从 于 Bank One 仂仄仗ﾑ亠: AIX (32bit), 8 CPUs, 8Gb RAM (4Gb addressable) 弌仂从舒亠仆亳亠 仂弍亠仄舒 仂 1,0 TB (Oracle) 亟仂 1,4 GB (Essbase) 仂亟亠 舒亞亠亞舒仂于 亳 于亳仍亠仆亳: 35 仄亳仆, 12 亳亰仄亠亠仆亳亶 仆舒仍亳亳从舒: 舒仗亠亟亠仍亠仆亳亠 (Allocations) 仗仂 14 仄仍仆 从仍亳亠仆从亳仄 亠舒仄 1000 仂亟仆仂于亠仄亠仆仆 亰舒仗仂仂于, 于亠仄 仂从仍亳从舒 0,2 亠从 亳仍仂仆亶 仗仂亠从 于 仂亳亶从仂仄 弍舒仆从亠 仂亟仆亠 亟舒仆仆亠 于 Oracle DB: 舒弍仍亳舒 43 仄仍仆 仂从, 13 弍 + 13 仗舒于仂仆亳从仂于 舒亞亰从舒 于 Essbase 30 仄亳仆 弍亠仄 弍舒亰 亟舒仆仆 于 Essbase 6弍 (舒亰 仗仂仍亠 亰舒亞亰从亳, 弍亠亰 亟仂仗仂仍仆亳亠仍仆仂亶 仂仗亳仄亳亰舒亳亳) + 1,7 弍 舒亞亠亞舒仂于 (亟仍 仗仂于亠仆亳 从仂仂亳 于仗仂仍仆亠仆亳 亰舒仗仂仂于) 弌从仂仂 于仗仂仍仆亠仆亳 亰舒仗仂仂于 亟仂 1 亠从
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.27 仆亠亞舒亳 Essbase 亳 Oracle BI 仍舒亳亠从亳亶 OLAP 亠于亠 Essbase Essbase 亠于亠 亳仆亠亞亳仂于舒仆 Oracle BI EE - 舒亰于仂舒亳于舒亠 于仄亠亠 OBI; - 仂弍舒 亳亠仄舒 弍亠亰仂仗舒仆仂亳 仗仂仍亰亠 亟仍 仗亠亟于舒亳亠仍仆仂亶 舒亞亠亞舒亳亳 亟舒仆仆 亳 从仂亠仆亳 亰舒仗仂仂于 仂仂亠仆亳亠 舒亞亠亞舒仂于 仗仂仄仂 于仆亠仆仆亳 亳仆仄亠仆仂于 Oracle BI ORACLE ESSBASE
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.28 Exalytics Business Intelligence Machines Business Intelligence Machine 2 TB DRAM Exalytics X3-4 40 Intel Cores 2.4 TB Flash Storage 5.4 TB Hard Disk Drive 4 TB DRAM Exalytics T5-8 128 SPARC T5 Processor Cores 3.2 TB Flash Storage 7.2 TB Hard Disk Drive
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.29 仂亞舒仄仄仆仂亠 仂弍亠仗亠亠仆亳亠 Oracle Business Intelligence Oracle Essbase Oracle TimesTen for Exalytics Exalytics In-Memory Software Endeca Information Discovery Oracle Business Intelligence Essbase TimesTen for Analytics 亟舒仗亳于仆亠 in-memory 舒从亠仍亠舒仂
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.30 亟舒仗亳于仆亠 in-memory 舒从亠仍亠舒仂 亠舒仍亳亰舒亳 in-memory 舒仆舒仍亳亳从亳 In-Memory Essbase Cubes 亳仂于舒仆亳亠 于 仂仗亠舒亳于仆仂亶 仗舒仄亳 Essbase-从弍仂于 In-Memory Intelligent Result Cache 丱舒仆亠仆亳亠 于 仂仗亠舒亳于仆仂亶 仗舒仄亳 亠亰仍舒仂于 于仗仂仍仆亠仆仆 亰舒仗仂仂于 In-Memory Adaptive Data Marts 亳仂于舒仆亳亠 于 TimesTen 于仂仄舒亳亠从仂亠 仂仄亳仂于舒仆亳亠 于亳亳仆 仆舒 仂仆仂于亠 舒亳亳从亳 亰舒仗仂仂于 In-Memory Data Warehouse 丱舒仆亠仆亳亠 于 仂仗亠舒亳于仆仂亶 仗舒仄亳 于亠亞仂 舒仆亳仍亳舒 亟舒仆仆
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.31 仆舒仍亳亳亠从舒 仗仍舒仂仄舒 Oracle 仆亠舒从亳于仆亠 亰舒仗仂 亳 舒仆舒仍亳亰, 亳仆仂仄舒亳仂仆仆亠 仗舒仆亠仍亳, 亟亠舒仍亳亰舒亳 亳 仆舒于亳亞舒亳 Business Intelligence Enterprise Edition OLAP 舒仆舒仍亳亰, 亠仆舒仆仂亠 仄仂亟亠仍亳仂于舒仆亳亠, 亳亠仄 仗仍舒仆亳仂于舒仆亳 Essbase 仍亠亟仂于舒仆亳亠 亟舒仆仆, 舒亠仆亶 仗仂亳从 亳 仆舒于亳亞舒亳 亟仍 从亳仂于舒仆仆 亳 仆亠从亳仂于舒仆仆 亟舒仆仆 Endeca Information Discovery BI Foundation Suite Advanced Analytics 仂亠仆亠 于 Oracle Database 舒亳亳从舒, data mining 亳 磶从 R 仂亞舒仄仄仆仂-舒仗仗舒舒仆亶 从仂仄仗仍亠从 亅从亠仄舒仍仆舒 仗仂亳亰于仂亟亳亠仍仆仂 In-memory 舒仆舒仍亳亳从舒 R 仂仂于亠 舒仆舒仍亳亳亠从亳亠 仗亳仍仂亢亠仆亳BI Applications
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.32 Oracle Advanced Analytics Database option 仍弍亳仆仆亶 舒仆舒仍亳亰 亟舒仆仆
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.33 舒从亳亠 亰舒亟舒亳 亠舒亠 Advanced Analytics? 仂亳从 从 亰舒从仂仆仂仄亠仆仂亠亶, 亳亰于仍亠亠仆亳亠 仆仂于 仗仂仍亠亰仆 于亠亟亠仆亳亶 亳 仗仂亞仆仂亰亳仂于舒仆亳亠 Data Mining 仗亳仆仂亳 仂亳仄亠 亠亰仍舒 于: 仂亞仆仂亰亳仂于舒仆亳亳 仗仂于亠亟亠仆亳 从仍亳亠仆仂于 (Classification) 仂亞仆仂亰亳仂于舒仆亳亠 亳仍亳 仂亠仆从舒 亰仆舒亠仆亳亶 (Regression) 弌亠亞仄亠仆舒亳 (Clustering) 仗亠亠亟亠仍亠仆亳亠 仆舒亳弍仂仍亠亠 于仍亳ﾑ亳 舒从仂仂于 (Attribute Importance) 个仂仄亳仂于舒仆亳亠 仗仂亳仍亠亶 从仍亳亠仆仂于 (Decision Trees) 仗亠亟亠仍亠仆亳亠 于舒亢仆 于亰舒亳仄仂于磶亠亶, 舒仆舒仍亳亰 仗仂亠弍亳亠仍从仂亶 从仂亰亳仆 (Associations) 磦仍亠仆亳亠 舒仆仂仄舒仍亳亶 亳仍亳 仄仂亠仆仆亳亠从亳 仂仗亠舒亳亶 (Anomaly Detection)
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.34 Oracle In-Database Advanced Analytics 弌舒亳亳亠从亳亠 亳仍亠亟仂于舒仆亳, 仗亠亟亳从亳于仆舒 舒仆舒仍亳亳从舒, 仗仂亳从 亰舒从仂仆仂仄亠仆仂亠亶 Oracle R Enterprise 舒仗仂舒仆亠仆仆亶 磶从 舒亳亳亠从亳 亳仍亠亟仂于舒仆亳亶 R - open source 仂亠仆 于 Oracle Database R- 于亳仍亠仆亳 舒仆仍亳ﾑ 亳 于仗仂仍仆ﾑ 于 Oracle Database R Integrated with Hadoop & OBIEE Oracle Data Mining 仂亠仆仆亠 于 弍舒亰 亟舒仆仆 仗仂亠亟 data mining API 亟仍 舒亰舒弍仂从亳 仗亳仍仂亢亠仆亳亶, 于舒亳于舒仆亳 data mining 于 亠于ﾑ亳亠 仗亳仍仂亢亠仆亳 亳 亳亠仄 Oracle Data Miner R
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.35 仂仍亠亰仆亠 仍从亳 亳 仄舒亠亳舒仍 Database Statistics and Analytical functions http://www.oracle.com/technetwork/database/bi-datawarehousing/index-092760.html Advanced Analytics Option www.oracle.com/technology/products/bi/odm/index.html http://www.oracle.com/technetwork/database/options/advanced-analytics/r- enterprise/index.html Oracle Endeca Information Discovery http://www.oracle.com/us/solutions/business-analytics/business- intelligence/endeca/overview/index.html Oracle Exalytics in-memory analytic machine http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/exalytics-bi- machine/overview/index.html
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.36
Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.37

More Related Content

Oracle Business Analytics Overview

  • 1. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.1 Oracle Business Analytics 仆舒仍亳亳亠从舒 仗仍舒仂仄舒 仂 Oracle 舒舒仍 仂弍仆仂于舒 Oracle CIS
  • 2. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.2 仆舒仍亳亳亠从舒 仗仍舒仂仄舒 Oracle 仆亠舒从亳于仆亠 亰舒仗仂 亳 舒仆舒仍亳亰, 亳仆仂仄舒亳仂仆仆亠 仗舒仆亠仍亳, 亟亠舒仍亳亰舒亳 亳 仆舒于亳亞舒亳 Business Intelligence Enterprise Edition OLAP 舒仆舒仍亳亰, 亠仆舒仆仂亠 仄仂亟亠仍亳仂于舒仆亳亠, 亳亠仄 仗仍舒仆亳仂于舒仆亳 Essbase 仍亠亟仂于舒仆亳亠 亟舒仆仆, 舒亠仆亶 仗仂亳从 亳 仆舒于亳亞舒亳 亟仍 从亳仂于舒仆仆 亳 仆亠从亳仂于舒仆仆 亟舒仆仆 Endeca Information Discovery BI Foundation Suite Advanced Analytics 仂亠仆亠 于 Oracle Database 舒亳亳从舒, data mining 亳 磶从 R 仂亞舒仄仄仆仂-舒仗仗舒舒仆亶 从仂仄仗仍亠从 亅从亠仄舒仍仆舒 仗仂亳亰于仂亟亳亠仍仆仂 In-memory 舒仆舒仍亳亳从舒 R 仂仂于亠 舒仆舒仍亳亳亠从亳亠 仗亳仍仂亢亠仆亳BI Applications
  • 3. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.3 仂仗仂舒亳于仆舒 舒仆舒仍亳亳亠从舒 仗仍舒仂仄舒 Oracle Business Intelligence 从亳于仆亶 弍亳亰仆亠-舒仆舒仍亳亰 亠亞仍舒仄亠仆亳仂于舒仆仆亠 仂仄 仂弍亳仍仆舒 舒仆舒仍亳亳从舒 仂亳亰于仂仍仆亠 亰舒仗仂 亳 仂亠 仍ﾑ亠于亠 仗仂从舒亰舒亠仍亳 亠从亳于仆仂亳 SINGLE ENTERPRISE INFORMATION MODEL 亊 弌 亂 仆亠亞舒亳 c MS Office 仂舒仆于亠仆仆舒 舒仆舒仍亳亳从舒仆仂仄舒亳仂仆仆亠 仗舒仆亠仍亳
  • 4. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.4 仂仗仂舒亳于仆舒 仄仂亟亠仍 亟舒仆仆
  • 5. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.5 仆舒仍亳亳亠从亳亶 亠于亠 仂亰仄仂亢仆仂亳 舒亞仄亠仆舒亳亳 亳 亠亟亠舒亳亳 亠亳从舒仍仆舒 - 亳仂仆亳从亳 仂亟亠亢舒 舒亰仆亠 仗仂从舒亰舒亠仍亳 仂亳亰仂仆舒仍仆舒 - 亳仂仆亳从亳 仂亟亠亢舒 舒亰仆亠 仆舒弍仂 亟舒仆仆 亞亠亞亳仂于舒仆亳 - 亳仂仆亳从亳 仂亟亠亢舒 舒亞亠亞舒 舒亰仍亳仆 仂于仆亠亶 仍舒仆 个舒从 source1 source2 仂 2010亞. 仂仍亠 2011亞. source1 source2 仗仂 仄亠舒仄 source1 仗仂 亞仂亟舒仄 source2 仗仂 亟仆礆 source3 舒于亳亞舒亳 从 亳仂仆亳从舒仄 仂亠于仍磳 舒于仂仄舒亳亠从亳, 仗仂 亠亰仍舒舒仄 仂仗亳仄亳亰舒亳亳 亰舒仗仂舒 仗仂仍亰仂于舒亠仍 仂亞亳亠从舒 舒弍仍亳舒 1 仂亞亳亠从舒 舒弍仍亳舒 1 仂亞亳亠从舒 舒弍仍亳舒 1
  • 6. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.6 仂亰仄仂亢仆仂亳 舒亞仄亠仆舒亳亳 舒 仗亳仄亠亠 舒亞亠亞舒亳亳
  • 7. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.7 仆亠舒从亳于仆亠 舒仆舒仍亳亳亠从亳亠 仗舒仆亠仍亳 BI Dashboards 仆亠舒从亳于仆亠, 仗亠仂仆舒仍亳亰亳仂于舒仆仆亠 仗亠亟舒于仍亠仆亳 亠舒仍亳亰舒亳 亟仂 仂于仆 舒仆亰舒从亳亶 丿亳仂从亳亠 于仂亰仄仂亢仆仂亳 仆舒于亳亞舒亳亳 仂亠仆仆亠 亠仆舒亳亳 舒仆舒仍亳亰舒
  • 8. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.8 仂亳亰于仂仍仆亠 亰舒仗仂 亳 仂亠 Analyses 仂仂亶 亳仆亳亳于仆亶 亳仆亠亠亶 仂仄亳仂于舒仆亳 仂亠仂于 drag and drop 仗仂仍亰仂于舒仆亳亠 弍亳亰仆亠- 亠仄亳仆仂仍仂亞亳亳 仗亠亟仄亠仆 仂弍仍舒亠亶 仂亰仄仂亢仆仂 仂仄亳仂于舒仆亳 仂弍于亠仆仆 于亳仍磳仄 仄亠亳从 亳 亞仗仗 舒亰仍亳仆亠 仗仂仂弍 于亳亰舒仍亳亰舒亳亳 亟舒仆仆 仂仂亶 亳仆仄亠仆 ﾐ頴委 于亳亰舒仍亳亰舒亳
  • 9. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.9 亳亰仆亠-舒仆舒仍亳亰 亳 仗仂舒仆于亠仆仆亠 亟舒仆仆亠 Location Intelligence 仂仍亳仆于仂 舒仆舒仍亳亳亠从亳 亟舒仆仆 于舒亢仆仂 舒仄舒亳于舒 于 仗亳于磶从亠 从 亞亠仂亞舒亳亠从亳仄 仂弍亠从舒仄 仂舒仆于亠仆仆舒 于亳亰舒仍亳亰舒亳 仂弍亠仗亠亳于舒亠 弍仂仍亠亠 亞仍弍仂从仂亠 仗仂仆亳仄舒仆亳亠 亳 舒亳磳 于仂亰仄仂亢仆仂亳 舒仆舒仍亳亰舒
  • 10. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.10 仆亠舒从亳于仆舒 弍亳亰仆亠-舒仆舒仍亳亳从舒
  • 11. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.11 仍舒仂仄舒 亟仍 弍仂亶 舒亰舒弍仂从亳 舒仆舒仍亳亳从亳 仆舒 从舒舒 亠 仆亠仂弍仂亟亳仄亠 从仂仄仗仂仆亠仆 亟仍 亞亠仂舒仆舒仍亳亳从亳 亢亠 磦仍ﾑ 舒 BI 仗仍舒仂仄 Oracle DB locator 亳仍亳 spatial 亟仍 舒仆亠仆亳 亞亠仂 亟舒仆仆; Oracle BI Mapviewer 亟仍 仂仂弍舒亢亠仆亳 亞亠仂 亟舒仆仆 于 亳仆亠亠亶亠; 仂仄仗仂仆亠仆 于 Oracle BI, 仗仂亰于仂仍ﾑ亳亠 亳仆亠亞亳仂于舒 舒仆舒仍亳亳亠从亳亠 亳 亞亠仂 亟舒仆仆亠.
  • 12. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.12 亳亠从舒 从仂仄仗仂仆亠仆仂于 Location Intelligence 仂舒仆于亠仆仆亠 亟舒仆仆亠 (亞舒仆亳 亠亞亳仂仆仂于) 亠舒亟舒仆仆亠 Mapviewer 仆舒仍亳亳亠从亳亠 亟舒仆仆亠 弌仗舒于仂仆亳从 亠亞亳仂仆仂于 (舒 仗亠亟仄. 仂弍仍舒亳 BI) Oracle Database Oracle Weblogic Application Server Oracle BI /analytics Oracle Mapviewer /mapviewer Oracle MapBuilder Java desktop 仂仄仂仆亠仆 仆亠仂弍仂亟亳仄 仂仍从仂 亟仍 仂仗亠亟亠仍亠仆亳 仄亠舒亟舒仆仆
  • 13. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.13 舒亟舒亳 Location Intelligence 亟仍 亳亠亶仍仂于 弍舒仆从仂于 仗亳仄亳亰舒亳 舒仗仂仍仂亢亠仆亳亶 仂亟亠仍亠仆亳亶 亳 仂仗亠亟亠仍亠仆亳亠 仗亠亠亞亢亠仆仆 亳 仆亠亟仂亞亢亠仆仆 仂亟亠仍亠仆亳亶 亳仍亳 弍舒仆从仂仄舒仂于 磦仍亠仆亳亠 亳仍亳舒仍仂于 从仂仆从亳ﾑ亳 弍舒仆从仂于, 从仂亠仍亳 亰舒亞亢亠仆仆仂 亳 仗亳弍仍仆仂 仂弍于亠仆仆 仂亳仂于 仂仆亳仄舒仆亳亠 仗舒亠仆仂于 仗仂于亠亟亠仆亳 亞仗仗 从仍亳亠仆仂于 于 亰舒于亳亳仄仂亳 仂 亞亠仂亞舒亳亠从仂亞仂 仗仂仍仂亢亠仆亳 仂亳仂于 仍亠亢亳于舒仆亳亠 亳仗仂仍亰仂于舒仆亳 弍舒仆从仂于从亳 亠于亳仂于 亳 仗仂亟从仂于 丐舒亞亠亳仂于舒仆仆亶 仄舒从亠亳仆亞 亳 亳仆仂仄亳仂于舒仆亳亠 仂 亠于亳舒
  • 14. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.14 仂弍亳仍仆舒 舒仆舒仍亳亳从舒 亠 从仂仆亠仆 Oracle BI 亟仂仗亠仆 仆舒 仄仂弍亳仍仆仂亶 仗仍舒仂仄亠 仗仂亟 iOS 弍亠亰 亟仂仗仂仍仆亳亠仍仆仂亶 舒亰舒弍仂从亳 仂仍仆仂 亳仆亠舒从亳于仆亠 舒仆舒仍亳亳亠从亳亠 仗亳仍仂亢亠仆亳 亠仂舒仆舒仍亳亳从舒, 舒仍亠, 亰舒仗从 弍亳亰仆亠- 仗仂亠仂于 弌仂弍仍ﾐ莞黍出湖 从仂仗仂舒亳于仆 仗仂仍亳亳从 弍亠亰仂仗舒仆仂亳, 于 .. SSL BI Mobile HD
  • 15. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.15 仂弍亳仍仆舒 舒仆舒仍亳亳从舒 亊 于仂亰仄仂亢仆仂 仂亰亟舒于舒 仄仂弍亳仍仆亠 仗亳仍仂亢亠仆亳 亟仍 仍ﾐ頴笑 仗仍舒仂仄, 仗仂亟亟亠亢亳于舒ﾑ亠亶 html5 仂亠 仂亰亟舒仆亳亠 仄仂弍亳仍仆 舒仆舒仍亳亳亠从亳 仗亳仍仂亢亠仆亳亶 弍亳亰仆亠 仗仂仍亰仂于舒亠仍礆亳(drag and drop, 弍亠亰 仗仂亞舒仄仄亳仂于舒仆亳) 仂亰仄仂亢仆仂 仂亰亟舒仆亳 仂弍于亠仆仆 仗仍舒亞亳仆仂于 BI Mobile App Designer
  • 16. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.16 仆亠亞舒亳 仂亳仆仄亳 仗仂亟从舒仄亳 SmartView BI Presentation Catalog 于 Smart View 弍亠仗亠亠仆亳亠 弍亠亰仂仗舒仆仂亳, 于从仍ﾑ舒 single sign-on 仂亟亟亠亢从舒 亳仍仂于 舒仆亳 亳 仂亠仂于 Export Dashboards & Dashboard Content 亅从仗仂 仂亠仂于 于 Native Excel 亳 Powerpoint (2003, 2007+) 亅从仗仂 仆舒仍亳亳亠从亳 仗舒仆亠仍亠亶 亳 舒仆亳; 舒仆亳 舒仗仂仍舒亞舒ﾑ 仆舒 仂亟亠仍仆 仍亳舒 Excel 弌仂亰亟舒仆亳亠 仂亠仂于 亳亰 Smart View 弌仂亰亟舒仆亳亠 仂弍于亠仆仆 仂亠仂于 亳亰 Excel 弍仍亳从舒亳 于 Web Catalog
  • 17. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.17 Oracle Scorecard and Strategy Management 弌仗亠亳舒仍仆亠 BI-仂弍亠从 仍ﾑ亠于亠 仗仂从舒亰舒亠仍亳 (KPI) 舒从/仗仍舒仆, 仗仂仂亞亳, 于亳仍亠仆亳 弌舒亠亞亳亳, 亠仍亳, 仗亠仗亠从亳于 于仂仄舒亳亠从亳亶 仄仂仆亳仂亳仆亞 KPI 舒仍亠 仆舒 仂仆仂于亠 仗仂仂亞仂于 亳亰舒仍亳亰舒亳 舒亠亞亳亶 亳 KPI 弌舒亠亞亳亠从亳亠 从舒 亳 亳亠舒亳亳 亠仍亠亶 亳亳仆仆仂-仍亠亟于亠仆仆亠 于亰舒亳仄仂于磶亳 仆仆仂舒亳亳 亳 从仂亠从亳仂于从亳 仂仆亳仂亳仆亞 亟亠亠仍仆仂亳 从仂仄仗舒仆亳亳 于 舒亳 亟仂亳亢亠仆亳 舒亠亞亳亠从亳 亠仍亠亶
  • 18. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.18 KPI 弌仗亠亳舒仍仆亠 仂弍亠从 于 Oracle BI EE KPI 仂仆仂于舒仆 仆舒 仗仂从舒亰舒亠仍 仗亠亟仄亠仆仂亶 仂弍仍舒亳 BI 亳 仂舒亢舒亠 仂仂礌亳亠 于仗仂仍仆亠仆亳 仗仍舒仆舒 仂亞亳从舒 KPI 仆舒舒亳于舒亠, 仗亳仄亠: 仍亳 仍舒仆 于仗仂仍仆亠仆 >= 100%, 舒 仍亳 仍舒仆 于仗仂仍仆亠仆 >= 80%, 舒 仆亳仄舒仆亳亠 亳仆舒亠, 舒 亳亳仆仂 亠亶于亳 KPI 仄仂亢仆仂 仆舒亰仆舒舒 舒舒仄, 仗亳仄亠: 亠亠亶亳 仆舒 仂亠 Oracle BI 仆亳亳仂于舒 弍亳亰仆亠-仗仂亠 于 亟亞仂亶 亳亠仄亠 仗舒于亳 于亠亟仂仄仍亠仆亳亠 仗仂 email
  • 19. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.19 KPI 舒从 仄仂亢仆仂 亳仗仂仍亰仂于舒 亳 仂弍亠从? 仂仄仂 于 于亳亟亠 仂亠仂于 仂仆亳仂亳仆亞 仗亳从舒 KPI 仂仂亠仆亳亠 Scorecards 亠 仗仂 KPI 亞亠仆亠亳ﾑ 舒于仂仄舒亳亠从亳 弌仂亰亟舒仆亳亠 束仄仆損 仗亳从仂于 KPI 弌于仂亟仆舒 亳仆仂仄舒亳 仗仂 KPI - 舒于仂仄舒亳亠从亳 KPI 束仂亳亠仍仆亠 弍仍仂从亳損
  • 20. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.20 Scorecards 亳仄亠 舒亠亞亳亳 束仂仄仗舒仆亳 丱損 丕仍亳 亳仆. 亠亰仍舒 丕仍亳 仂仆仂亠仆亳 从仍亳亠仆舒仄亳 丕于亠仍亳亳 仗仂亟舒亢亳 丕仄亠仆亳 亰舒舒 于从舒 从仂仍-于仂 仗仂亟舒亢 舒亟仄亳仆. 舒仂亟 . 于亠仄 仂亢亳亟舒仆亳 从仂仍-于仂 仂亟仆亳从仂于 亠仍亳 KPI 舒亠亞亳 丕于亠仍亳亳 - 仂亟仆亳从仂于
  • 21. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.21 丕仗舒于仍亠仆亳亠 亠从亳于仆仂 弍亳亰仆亠舒 舒 舒亠亞亳亶, 亳亠舒亳亳 亠仍亠亶, 仗亳亳仆仆仂-仍亠亟于亠仆仆亠 于磶亳
  • 22. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.22 Hyperion Essbase 仆仂亞仂仄亠仆舒 弍舒亰舒 亟舒仆仆
  • 23. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.23 舒亠仄 亳仗仂仍亰仂于舒 仄仆仂亞仂仄亠仆亠 从弍 OLAP 弍舒亰舒 亟舒仆仆 亅亠从亳于仆仂亠 亢舒仂亠 舒仆亠仆亳亠 舒亞亠亞亳仂于舒仆仆 亟舒仆仆 从仍舒亠亳亰舒亳 in-memory 亠仆仂仍仂亞亳 -- Essbase for Exalytics 亠亰仍舒 仄仂亞 舒仆亳 亳仍亳 于亳仍 束仆舒 仍亠損 亶 亟仂仗 从 舒亞亠亞舒舒仄 仂仆亠 舒仆舒仍亳亳亠从亳亠 亳 于亳仍亳亠仍仆亠 于仂亰仄仂亢仆仂亳 仍ﾐ英亠 于亳亟 仆亠弍舒仍舒仆亳仂于舒仆仆 亳亠舒亳亶 仍ﾐ頴笑 从仂仍亳亠于仂 舒仍亠仆舒亳于仆 亳亠舒亳亶 弍仂仍亠亠 350 于仂亠仆仆 仆从亳亶 仂亰仄仂亢仆仂 仄仂亟亠仍亳仂于舒仆亳, 仗仂亞仆仂亰亳仂于舒仆亳, what-if 舒仆舒仍亳亰舒
  • 24. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.24 Block Storage Option 仍 仗亳仍仂亢亠仆亳亶, 于磶舒仆仆 亳亠舒亳于仆仄 仗仍舒仆亳仂于舒仆亳亠仄, 舒仗亠亟亠仍亠仆亳礆亳, 仍仂亢仆仄 舒仆舒仍亳亰仂仄 (舒仆舒仍亳亰 仗仂亟舒亢, 舒仆舒仍亳亰 仗亳弍仍仆仂亳) 仗仂仍仆亠仆亳亠 仍仂亢仆 于亳仍亠仆亳亶 亳 亰舒仗亳 亳亰仄亠仆亠仆亳亶 仆舒 仍ﾐ頴笑 仂于亠仆 舒亞亠亞舒亳亳 丕仗舒于仍亠仆亳亠 仗仂磲从仂仄 于亳仍亠仆亳 亳亰仄亠亠仆亳亶 亠亠舒亠 于亠亶 亳仍亳 舒亳 舒仆仆亠 仆舒 仆亳亢仆亠仄 仂于仆亠 亳仍亠仆仆舒 亳仍亳亠仍仆亠 仗仂亠亟
  • 25. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.25 亞亠亞亳仂于舒仆仆亠 亟舒仆仆亠 舒仆仆亠 仆舒 仆亳亢仆亠仄 仂于仆亠 Aggregate Storage Option 仍 从仗仆仂仄舒舒弍仆, 舒亰亠亢亠仆仆 亟舒仆仆 弍仂仍亳仄 从仂仍亳亠于仂仄 (亟亠从亳) 弍仂仍亳 (仂仆亳 ) 舒亰仄亠仆仂亠亶 于仂仄舒亳亠从舒 仂仗亳仄亳亰舒亳 舒仆亠仆亳, 亢舒亳亠 弌舒仆亟舒仆亶 仆舒弍仂 仗舒于亳仍 舒亞亠亞舒亳亳 仂从舒 亞亳弍从仂 亟仍 仂亠仂于 亳 舒仆舒仍亳亰舒
  • 26. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.26 亳仄亠 仗仂亳亰于仂亟亳亠仍仆仂亳 仂亠从 于 Bank One 仂仄仗ﾑ亠: AIX (32bit), 8 CPUs, 8Gb RAM (4Gb addressable) 弌仂从舒亠仆亳亠 仂弍亠仄舒 仂 1,0 TB (Oracle) 亟仂 1,4 GB (Essbase) 仂亟亠 舒亞亠亞舒仂于 亳 于亳仍亠仆亳: 35 仄亳仆, 12 亳亰仄亠亠仆亳亶 仆舒仍亳亳从舒: 舒仗亠亟亠仍亠仆亳亠 (Allocations) 仗仂 14 仄仍仆 从仍亳亠仆从亳仄 亠舒仄 1000 仂亟仆仂于亠仄亠仆仆 亰舒仗仂仂于, 于亠仄 仂从仍亳从舒 0,2 亠从 亳仍仂仆亶 仗仂亠从 于 仂亳亶从仂仄 弍舒仆从亠 仂亟仆亠 亟舒仆仆亠 于 Oracle DB: 舒弍仍亳舒 43 仄仍仆 仂从, 13 弍 + 13 仗舒于仂仆亳从仂于 舒亞亰从舒 于 Essbase 30 仄亳仆 弍亠仄 弍舒亰 亟舒仆仆 于 Essbase 6弍 (舒亰 仗仂仍亠 亰舒亞亰从亳, 弍亠亰 亟仂仗仂仍仆亳亠仍仆仂亶 仂仗亳仄亳亰舒亳亳) + 1,7 弍 舒亞亠亞舒仂于 (亟仍 仗仂于亠仆亳 从仂仂亳 于仗仂仍仆亠仆亳 亰舒仗仂仂于) 弌从仂仂 于仗仂仍仆亠仆亳 亰舒仗仂仂于 亟仂 1 亠从
  • 27. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.27 仆亠亞舒亳 Essbase 亳 Oracle BI 仍舒亳亠从亳亶 OLAP 亠于亠 Essbase Essbase 亠于亠 亳仆亠亞亳仂于舒仆 Oracle BI EE - 舒亰于仂舒亳于舒亠 于仄亠亠 OBI; - 仂弍舒 亳亠仄舒 弍亠亰仂仗舒仆仂亳 仗仂仍亰亠 亟仍 仗亠亟于舒亳亠仍仆仂亶 舒亞亠亞舒亳亳 亟舒仆仆 亳 从仂亠仆亳 亰舒仗仂仂于 仂仂亠仆亳亠 舒亞亠亞舒仂于 仗仂仄仂 于仆亠仆仆亳 亳仆仄亠仆仂于 Oracle BI ORACLE ESSBASE
  • 28. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.28 Exalytics Business Intelligence Machines Business Intelligence Machine 2 TB DRAM Exalytics X3-4 40 Intel Cores 2.4 TB Flash Storage 5.4 TB Hard Disk Drive 4 TB DRAM Exalytics T5-8 128 SPARC T5 Processor Cores 3.2 TB Flash Storage 7.2 TB Hard Disk Drive
  • 29. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.29 仂亞舒仄仄仆仂亠 仂弍亠仗亠亠仆亳亠 Oracle Business Intelligence Oracle Essbase Oracle TimesTen for Exalytics Exalytics In-Memory Software Endeca Information Discovery Oracle Business Intelligence Essbase TimesTen for Analytics 亟舒仗亳于仆亠 in-memory 舒从亠仍亠舒仂
  • 30. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.30 亟舒仗亳于仆亠 in-memory 舒从亠仍亠舒仂 亠舒仍亳亰舒亳 in-memory 舒仆舒仍亳亳从亳 In-Memory Essbase Cubes 亳仂于舒仆亳亠 于 仂仗亠舒亳于仆仂亶 仗舒仄亳 Essbase-从弍仂于 In-Memory Intelligent Result Cache 丱舒仆亠仆亳亠 于 仂仗亠舒亳于仆仂亶 仗舒仄亳 亠亰仍舒仂于 于仗仂仍仆亠仆仆 亰舒仗仂仂于 In-Memory Adaptive Data Marts 亳仂于舒仆亳亠 于 TimesTen 于仂仄舒亳亠从仂亠 仂仄亳仂于舒仆亳亠 于亳亳仆 仆舒 仂仆仂于亠 舒亳亳从亳 亰舒仗仂仂于 In-Memory Data Warehouse 丱舒仆亠仆亳亠 于 仂仗亠舒亳于仆仂亶 仗舒仄亳 于亠亞仂 舒仆亳仍亳舒 亟舒仆仆
  • 31. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.31 仆舒仍亳亳亠从舒 仗仍舒仂仄舒 Oracle 仆亠舒从亳于仆亠 亰舒仗仂 亳 舒仆舒仍亳亰, 亳仆仂仄舒亳仂仆仆亠 仗舒仆亠仍亳, 亟亠舒仍亳亰舒亳 亳 仆舒于亳亞舒亳 Business Intelligence Enterprise Edition OLAP 舒仆舒仍亳亰, 亠仆舒仆仂亠 仄仂亟亠仍亳仂于舒仆亳亠, 亳亠仄 仗仍舒仆亳仂于舒仆亳 Essbase 仍亠亟仂于舒仆亳亠 亟舒仆仆, 舒亠仆亶 仗仂亳从 亳 仆舒于亳亞舒亳 亟仍 从亳仂于舒仆仆 亳 仆亠从亳仂于舒仆仆 亟舒仆仆 Endeca Information Discovery BI Foundation Suite Advanced Analytics 仂亠仆亠 于 Oracle Database 舒亳亳从舒, data mining 亳 磶从 R 仂亞舒仄仄仆仂-舒仗仗舒舒仆亶 从仂仄仗仍亠从 亅从亠仄舒仍仆舒 仗仂亳亰于仂亟亳亠仍仆仂 In-memory 舒仆舒仍亳亳从舒 R 仂仂于亠 舒仆舒仍亳亳亠从亳亠 仗亳仍仂亢亠仆亳BI Applications
  • 32. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.32 Oracle Advanced Analytics Database option 仍弍亳仆仆亶 舒仆舒仍亳亰 亟舒仆仆
  • 33. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.33 舒从亳亠 亰舒亟舒亳 亠舒亠 Advanced Analytics? 仂亳从 从 亰舒从仂仆仂仄亠仆仂亠亶, 亳亰于仍亠亠仆亳亠 仆仂于 仗仂仍亠亰仆 于亠亟亠仆亳亶 亳 仗仂亞仆仂亰亳仂于舒仆亳亠 Data Mining 仗亳仆仂亳 仂亳仄亠 亠亰仍舒 于: 仂亞仆仂亰亳仂于舒仆亳亳 仗仂于亠亟亠仆亳 从仍亳亠仆仂于 (Classification) 仂亞仆仂亰亳仂于舒仆亳亠 亳仍亳 仂亠仆从舒 亰仆舒亠仆亳亶 (Regression) 弌亠亞仄亠仆舒亳 (Clustering) 仗亠亠亟亠仍亠仆亳亠 仆舒亳弍仂仍亠亠 于仍亳ﾑ亳 舒从仂仂于 (Attribute Importance) 个仂仄亳仂于舒仆亳亠 仗仂亳仍亠亶 从仍亳亠仆仂于 (Decision Trees) 仗亠亟亠仍亠仆亳亠 于舒亢仆 于亰舒亳仄仂于磶亠亶, 舒仆舒仍亳亰 仗仂亠弍亳亠仍从仂亶 从仂亰亳仆 (Associations) 磦仍亠仆亳亠 舒仆仂仄舒仍亳亶 亳仍亳 仄仂亠仆仆亳亠从亳 仂仗亠舒亳亶 (Anomaly Detection)
  • 34. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.34 Oracle In-Database Advanced Analytics 弌舒亳亳亠从亳亠 亳仍亠亟仂于舒仆亳, 仗亠亟亳从亳于仆舒 舒仆舒仍亳亳从舒, 仗仂亳从 亰舒从仂仆仂仄亠仆仂亠亶 Oracle R Enterprise 舒仗仂舒仆亠仆仆亶 磶从 舒亳亳亠从亳 亳仍亠亟仂于舒仆亳亶 R - open source 仂亠仆 于 Oracle Database R- 于亳仍亠仆亳 舒仆仍亳ﾑ 亳 于仗仂仍仆ﾑ 于 Oracle Database R Integrated with Hadoop & OBIEE Oracle Data Mining 仂亠仆仆亠 于 弍舒亰 亟舒仆仆 仗仂亠亟 data mining API 亟仍 舒亰舒弍仂从亳 仗亳仍仂亢亠仆亳亶, 于舒亳于舒仆亳 data mining 于 亠于ﾑ亳亠 仗亳仍仂亢亠仆亳 亳 亳亠仄 Oracle Data Miner R
  • 35. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.35 仂仍亠亰仆亠 仍从亳 亳 仄舒亠亳舒仍 Database Statistics and Analytical functions http://www.oracle.com/technetwork/database/bi-datawarehousing/index-092760.html Advanced Analytics Option www.oracle.com/technology/products/bi/odm/index.html http://www.oracle.com/technetwork/database/options/advanced-analytics/r- enterprise/index.html Oracle Endeca Information Discovery http://www.oracle.com/us/solutions/business-analytics/business- intelligence/endeca/overview/index.html Oracle Exalytics in-memory analytic machine http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/exalytics-bi- machine/overview/index.html
  • 36. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.36
  • 37. Copyright 息 2013, Oracle and/or its affiliates. All rights reserved.37