LES02 Meeting a Business Need 数据仓库英文oracle99版 教学课件.ppt

Schedule: Timing Topic xx minutes Lecture xx minutes Practice xx minutes Total Meeting a Business Need Project Management (Methodology, Maintaining Metadata) DefiningDW Concepts Terminology Planningfor a SuccessfulWarehouse AnalyzingUser QueryNeeds Choosing aComputingArchitecture Modeling the DataWarehouse PlanningWarehouseStorage Overview ETl(Building theWarehouse) Meeting aBusinessNeed SupportingEnd UserAccess Managing the Data Warehouse Lesson Aim Enter lesson aim here. Objectives After completing this lesson, you should be able to do the following: Describe why an online transaction processing (OLTP) system is not suitable for complex analysis Describe how extract processing for decision support querying led to data warehouse solutions employed today Explain why businesses are driven to employ data warehouse technology Identify some of the industries that employ data warehouses Characteristics of OLTP Systems Characteristic OLTP Typical operation Update Level of analytical requirements Low Screens Unchanging Amount of data per transaction Small Data level Detailed Age of data Current Orientation Records Why OLTP Is Not Suitable for Complex Analysis Complex Analysis Historical informationto analyze Data needs to be integrated Database design: Denormalized, star schema OLTP Information to supportday-to-day service Data stored at transactionlevel Database design: Normalized Management Information Systemsand Decision Support Operational reports Decision makers Productionplatforms MIS systems provided business data Reports were developed on request Reports provided little analysis capability Decision support tools gave personal ad hoc access to data Ad hoc access Analyzing Data from Operational Systems Data structures are complex Systems are designed for high performance and throughput Data is not meaningfully represented Data is dispersed OLTP systems may be unsuitable for intensive qu