文档介绍：会计学
1
数据仓库及应用数据仓库无锡
Data warehouse is a very large database that stores integrated data of one or more business subject areas
Data warehouse is built to support data analysis for decision making
Integrated customer data warehouse is a necessary step to the success of the business intelligence strategy
Data warehouses are also used for many other purposes such as product manufacturing data warehouses
Data warehouses become the focal point in the enterprise-wide IT infrastructure
What is Data Warehouse?
第1页/共37页
What is Data Warehouse
A data warehouse is simply a single, complete, and consistent store of data obtained from a variety of sources and made available to end users in a way they can understand and use in a business context.
第2页/共37页
What is Data Warehouse
第3页/共37页
Data Warehouse Definitions
The key elements in the definitions:
Subject-Oriented: Presentation as business subjects, not as computer files.
Integrated: A single source of information for and about the business.
Non-Volatile: Stable information that doesn’t change each time an operational process is executed.
Time-Variant: Containing a history of the business, as well as current business information.
Accessible: The primary purpose of a data warehouse is to provide readily accessible information to business people.
第4页/共37页
Subject-Oriented
第5页/共37页
Integrated
第6页/共37页
Integrated
网管系统
财务管理系统
市场分析决策系统
Telcom
DW
System
分析型大客户CRM系统信用度管理
客服系统
(Call Center 1000/180/112/170）系统
其它电信专业网业务系统
“九七工程”之营业管理生产调度系统
（配线/配号/开通）
112故障查修
系统资源管理系统
170/催缴系统营业系统
本地公司/IC卡/磁卡管理系统网上营业系统
商务管理层
省级计费结算计费帐务系统中心
业务管理层
网络及网元管理层
电信网网元
第7页/共37页
Non-Volatile
第8页/共37页
Time Variant
第9页/共37页