The Intranet Data Warehouse Richard Tanler Ch4 : Online Analytic Processing: From Data To Information 2000. 4. 14 All rights reserved
OLAP OLAP OLAP OLAP OLAP OLAP is a label, rather than a technology 2
OLAP Interface : ( ) ( ) Query : Interface SQL, DB Process : Query DB (result set) Format : Pages, Columns, Rows, Display : PC 3
OLAP : DSS EIS DIS BIS OLAP 1993, E.F.Codd 12 Rules for OLAP ROLAP MOLAP DOLAP HOLAP Data Mining 4
OLAP S/W, DB (query) S/W OLAP Query and Reporting Multidimensional Analysis Statistical Analysis(User-directed) Data Mining(Agent Processing) (C/S or Server ) 2-Tier Architecture 3-Tier Architecture (Cache) Temporary Database Cache Temporary External Cache Persistent External Cache 5
OLAP 1 : Query and Reporting Data Mining(Agent Processing) Multidimensional Analysis Statistical Analysis(User-directed) Data Mining(Agent Processing) 6
Query & Reporting Tools OLAP RDBMS, SQL ( ) Client SQL, ODBC (Status Reporting) : ABC? ( ) (Count) : ABC? (List) : -? 7
Multidimensional Analysis DW??? ( )? Reporting Shell (navigation) (Dimension) 4-5 8
Statistical Analysis (Regression) (Correlation) (Factoring) (Clustering) What If 10%? 9
Data Mining (churn analysis), (fraud detection) Statistical Analysis Neural Networking (Automated Multivariate Analysis) (Agent) 10
OLAP 2 : 2 Tier Architecture 3 Tier Architecture 11
2-Tier Architecture Data Query & Reporting SQL C, C++ Interface Query Process Format Display Interface Query Format Display SQL Result Set SQL Result Set Data Warehouse Data Warehouse Process 12
3-Tier Architecture Interface Display,, Application Partitioning S/W API PC D/L IIOP CGI Performance : H/W S/W Scalability : H/W S/W Flexibility :,, Data Warehouse Data Warehouse Data Warehouse Query Query Server Process Format Server Process Format Interface Display 13
OLAP 3 : (Cache) Cache) Analytical Cache OLAP Cache Query & Reporting 3 Temporary Database Cache Temporary External Cache Persistent External Cache 14
(Cache) Cache) Temporary Database Cache RDB OLAP 2-Tier SQL Tuning Information Advantage, Inc. Decision Suite Temporary External Cache C, C++ DW Data ( ) Marketing Persistent External Cache Hiperion Essbase Oracle Express 15
OLAP Intranet DW Intranet 4 Type 1 : Static HTML Type 2 : Dynamic DW Type 3 : Interactive DW Type 4 : Statistical Analysis & Data mining 16
OLAP Intranet (1) Type 1 : Static Reporting HTML, Web Browser Batch Reporting Paper Digital, Web HTTP Type 2 : Dynamic DW WWW, On-Line, Report Formatting ( ) Query Static 17
OLAP Intranet (2) Type 3 : Interactice DW TCP/IP N/W Web Server OLAP Intranet TCP/IP S/W Type 4 : Statistical Analysis & Data mining, What-If DW 18
240,000 10% Intranet DW Hypertext Search(Textural Documents), spatial model drill down / up / across Pivot Modify Constraints(filtering). 19
OLAP (1) 1. Multidimensional View :,, 2. Pivot/Rotation Columns, Row, Sections breaks 3. Drilling, Skip 4. Cross-Dimensional Calculations, 5. Dynamic Sets (,,, ) (Drill up /Down)., 20
OLAP (2) 6. Filters, drag & drop 7. Decision Groupware Capabilities report,,,, Live Information 8. Collapsible Browsing 9. Flexible Period Definitions,,,, DB 21
OLAP (3) 10. Access to Data Warehouse DW Cache. DB 11. Metadata 12. Sparse Matrix Schema Support (Sparse) 13. Read & Write DW 14. Query Generation SQL 15. Openness DB PC 22
OLAP Trend 1; OLAP Logic Components Query Process Format Web Server Interface Display Trend 2; Presentation Components 23
1 24
2 IIOP(Internet Inter-ORB Protocol Internet Interoperability Protocol). IIOP, TCP/IP. ORB CORBA 2.0, IIOP SmallTalk, C++, Java CGI(Common Gateway Interface),,.,. 25