Data Warehouse

1
Data Warehouse Internets Impact on it
By Yao Yurong and He Houcun IEEE-2000
2
Storage Devices
Capacity
Cost
3
Decision Processing Application package
Data Warehouse
Business intelligence tools
Transaction ERP System
4
Export
Import
Source Database
Target Database
Database Conversion Engine
Source Database
5
Import/Export
Source/Target Database
Database synchronization Engine
Source/Target Database
6
Warehouse architecture Selection
Corporate Warehouse
Operational Data System for existing application
Enterprise Scheme Creation
Warehouse population
7
BAPI
OLAP Processor
InfoCube
Metadata repository
Staging Engine
Object Decision Structure
BAPI
Third party products
Production Data extractor
Non_R3 Data
R/3 O T P
8
Specialization
Channel roles
Workbook
Query
InfoCube
Mapping Rule
InfoSource
InfoObject
Extractor
Standardization
9
Local Warehouse
Global Database
Company Database
10
Current Problem

• Aligning ERP with Business process
• Lack of coverage for external business process