DW 개요.PDF

Size: px

Start display at page:

Download "DW 개요.PDF"

영록 국
6 years ago
Views:

1 Data Warehouse Hammersoftkorea BI Group

3 /

4 DW /

6 Automating Informating Source : Kelly, The Data Warehousing : The Route to Mass Customization, 1996.

7 -,, Data

8 .,.., /.

9 ...,.,,,.

10 DW End User Computing Open Computing Client/Server Internet

11 Data Warehouse Data Warehouse DW vs Data Mart Data Mart /

12 Data Warehouse (Right Information, Right Time, Right Place)

13 Data Warehouse (Subject Orientation) (Integration) (Non-Volatility) (Time-Varient)

14 Data Warehouse ( ) (Subject Orientation) Operational Data Warehouse Applications Source : Inmon, Building the Data Warehouse, 2nd Ed

15 Data Warehouse ( ) (Integration) Operational Appl A - m,f Appl B - 1,2 Appl C - x,y Appl D - male,female Appl A - Cm Appl B - inches Appl C - mcfs Appl D - yards Appl A - description A Appl B - description B Appl C - description C Appl A - key char(10) Appl B - key dec fixed(9,2) Appl C - key pic 999,999 Appl D - key char(12) encoding measurement description from multiple sources conflicting keys Data Warehouse m,f Cm description key char(12) Source : Inmon, Building the Data Warehouse, 2nd Ed

16 Data Warehouse ( ) (Non-Volatility) Operational Change Data Warehouse Insert Select Delete Select Load Access Only Source : Inmon, Building the Data Warehouse, 2nd Ed

17 Data Warehouse ( ) (Time-Varient) Operational Data Warehouse Current Value Data Current to 60 ~ 90 Days Update of Records Key Structure may/may not contain an element of time Sophisticated Snapshots of Data 5 ~ 10 years Appending of new snapshots Key Structure contain an element of time Source : Inmon, Building the Data Warehouse, 2nd Ed

18 ?

19 DW vs. Data Mart Warehouse Database Data Marts Data Marts DSS application DW Data Marts DSS application

20 Data Mart implementation (ROI)I data IT data models corporate data model manage/maintain interface No single version of the truth data Single Version of the Truth data data model data transformation data mart options data warehouse

21 DW /

24 DW 1. Business Intelligence - 89% 2.,, - 85% % % 5. DSS systems - 51% * : 100 IT Source : Cutter Consortium, U 1. CRM/eCRM (Web Log, Contents Categorization, CRM Measure) 2. CRM ( ) 3. DB Operational Data

25 DW DW Data Mart DW /

26 DW

27 DW

28 Data Mart DW

29 DW DW /

30 DW DBA Operational System

31 DW Customer Share (Site) Loyalty, /

32 DW Framework DW Architecture DW DW /

33 DW Framework Data Analysis Data Store ETT(ECTL) Data Mining OLAP ROLAP HOLAP MOLAP Query & Report RDBMS MDBMS Extraction, Transformation, Cleansing, Loading M E T A D A T A Data Source Operational Data External Data

34 DW Architecture DATA INFORMATION Data Warehouse DECISION Client Design / Modeling Warehouse Database Metadata Data Marts Populate / Delivery Query & Report OLAP? Warehouse Management Data Mining Data Acquisition Data Store/Aggregation Data Distribution Analysis

35 DW

36 DW

37 DW /

38 DW DW,, (CTI, Web, ERP ), Best Practice /, DW DW, / /

40 ( )

41 /

42 One-Stop Service Master Plan DW

43 DW DW DW Plan DW / / DW DW DB Query & Report/ OLAP/Mining

44 / DW / DW

45 DW / / DW /,, /. Leading Industry Segments Telecommunication Other 20% DW Applications Database Marketing 25% Retail Banking & Insurance Sales 14% Financial 16% Customer Information Service 25% (GartnerGroup, 97 ) (MetaGroup, 95 )

46 DW / OLAP Sales and Marketing Analysis Budgeting Financial Reporting and Consolidation Management Reporting Profitability Analysis Quality Analysis Data Mining Customer Acquisition & Branding Profitability & Risk Assessment Making Customers More Profitable Personalization Inventory/Resource Management?

ecorp-프로젝트제안서작성실무(양식3)

ecorp-프로젝트제안서작성실무(양식3) (BSC: Balanced ScoreCard) ( ) (Value Chain) (Firm Infrastructure) (Support Activities) (Human Resource Management) (Technology Development) (Primary Activities) (Procurement) (Inbound (Outbound (Marketing