数据仓库及应用-数据仓库课件

单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,*,*,数据仓库,杭诚方 教授,数据仓库杭诚方 教授,What is Data Warehouse,What is Data Warehouse,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?,Data warehouse is a very lar,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,.,What is Data WarehouseA data,What is Data Warehouse,What is Data Warehouse,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 doesnt 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.,Data Warehouse DefinitionsThe,Subject-Oriented,Subject-Oriented,Integrated,Integrated,Integrated,网管系统,财务管理系统,市场分析决策系统,Telcom,DW,System,分析型大客户,CRM,系统信用度管理,客服系统,(Call Center,1000/180/112/170,）系统,其它电信专业网业务系统,“,九七工程”之营业管理生产调度系统,（配线,/,配号,/,开通）,112,故障查修,系统资源管理系统,170/,催缴系统营业系统,本地公司,/IC,卡,/,磁卡管理系统网上营业系统,商务管理层,省级计费结算计费帐务系统中心,业务管理层,网络及网元管理层,电信网网元,Integrated网管系统财务管理系统分析型大客户CRM系,Non-Volatile,Non-Volatile,Time Variant,Time Variant,Accessible,Accessible,Data Warehouse Characteristics,Data warehouse separates functions from operational systems.,Property,Operational,Data Warehouse,Response Time,Sub-second to seconds,Seconds to hours,Data Operation,DML,Primarily read only,Nature of Data,30-60 days,Snapshots over time,Data Organization,Application,Subject,Time,Size,Small to large,Large to very large,Data Sources,Operational,Internal,Operational,Internal,External,Activities,Processes,Analysis,Data Warehouse Characteristics,Data Warehouse Characteristics,Data warehouse serves as a central repository for recording everything about the business for information retrieval.Data is loaded from internal business operational system,and external systems.,Data Warehouse Characteristics,Data Warehouse Characteristics,A data warehouse has a fundamental effect on how the users see the data available about the organization,what to do with it and how to use it for decision making.,Data Warehouse Characteristics,Data Warehouse Characteristics,Data Warehouse Characteristics,Data Warehouse Characteristics,A data warehouse is not a single software or hardware product you purchase to strategic.It is a computing environment where users can find strategic information to make better decisions.It is a user-centric environment,.,Data Warehouse Characteristics,Data Warehouse Characteristics,Data warehouse is a blend of many different technologies needed for supporting the various functions of a data warehouse environment.These different technologies all work together in a data warehouse environment.,Application,Administration,Storage Management,Analysis,Data Management,Data Modeling,Data Acquisition,Data Warehouse,Data Warehouse Characteristics,Enterprise Data Warehouse,Enterprise data warehouses are funded on a corporate basis.Enterprise data warehouse covers the entire business(corporation),incorporating data from all operational systems.Information is extracted from the operational environment,cleansed,and transformed into a central,integrated enterprise-wide data warehouse environment,so that all the departments and other internal organizations of the corporation can benefit from a consistent,integrated source of decision support information,.,Enterprise Data WarehouseEnte,Data Mart,Data marts are often funded on a departmental basis.Data mart is a collection of data tailored to the DSS processing needs of a particular department.It is a subset of a enterprise data warehouse that has been customized to fit the needs of a department.Data marts serve users at a specific level,or for a specific department.,Data MartData marts are often,Data Warehouse versus Data Mart,Property,Data Warehouse,Data Mart,Scope,Enterprise,Department,Subjects,Multiple,Single-subject,Data Source,Many,Few,Size(Typical),TB,TB,Implement Time,Months to years,Months,Data Warehouse versus Data Mar,Data Mart,Data Mart,Data Mart,Control:,A department can completely control the data and processing that occurs inside a data mart.,Cost:,The cost of storage and processing is less,because the data marts machine is smaller than DWs,