Data Warehouse Hammersoftkorea BI Group
/
DW /
1960 1970 1980 1990 2000 Automating Informating Source : Kelly, The Data Warehousing : The Route to Mass Customization, 1996.
-,, Data
.,.., /.
...,.,,,.
DW End User Computing Open Computing Client/Server Internet
Data Warehouse Data Warehouse DW vs Data Mart Data Mart /
Data Warehouse (Right Information, Right Time, Right Place)
Data Warehouse (Subject Orientation) (Integration) (Non-Volatility) (Time-Varient)
Data Warehouse ( ) (Subject Orientation) Operational Data Warehouse Applications Source : Inmon, Building the Data Warehouse, 2nd Ed. 1996.
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. 1996.
Data Warehouse ( ) (Non-Volatility) Operational Change Data Warehouse Insert Select Delete Select Load Access Only Source : Inmon, Building the Data Warehouse, 2nd Ed. 1996.
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. 1996.
?
DW vs. Data Mart Warehouse Database Data Marts Data Marts DSS application DW Data Marts DSS application
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
DW /
1970 1980 1990 2000+
DW 1. Business Intelligence - 89% 2.,, - 85% 3. - 82% 4. - 75% 5. DSS systems - 51% * : 100 IT Source : Cutter Consortium, 1998.10. U 1. CRM/eCRM (Web Log, Contents Categorization, CRM Measure) 2. CRM ( ) 3. DB Operational Data
DW DW Data Mart DW /
DW
DW
Data Mart DW
DW DW /
DW DBA Operational System
DW Customer Share (Site) Loyalty, /
DW Framework DW Architecture DW DW /
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
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
DW
DW
DW /
DW DW,, (CTI, Web, ERP ), Best Practice /, DW DW, / /
( )
/
One-Stop Service Master Plan DW
DW DW DW Plan DW / / DW DW DB Query & Report/ OLAP/Mining
/ DW / DW
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 )
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?