les04资料参考 学习.pptVIP

Business, Logical, Dimensional, and Physical Modeling Objectives After completing this lesson, you should be able to do the following: Discuss data warehouse environment data structures Discuss data warehouse database design phases: Defining the business model Defining the logical model Defining the dimensional model Defining the physical model Lesson Agenda Data warehouse database design phases: Defining the business model Defining the logical model Defining the dimensional model Defining the physical model Data Warehouse Modeling Issues Among the main issues that data warehouse data modelers face are: Different data types Many ways to use warehouse data Many ways to structure the data Multiple modeling techniques Planned replication Large volumes of data Data Warehouse: Design Phases Phase 1: Defining the Business Model Performing strategic analysis Creating the business model Documenting metadata Defining the Business Model:Performing Strategic Analysis Identify crucial business processes. Understand business processes. Prioritize and select the business processes to implement. Defining the Business Model:Creating the Business Model Defining business requirements Determining granularity Documenting metadata Business Requirements Drive the Design Process Primary input Secondary input Using a Business Process Matrix Identifying Business Measures and Dimensions The attribute varies continuously: Sales Quantity sold Units sold Cost The attribute is perceived as constant or discrete: Products Promotions Customers Countries Channels Times Determining Granularity Identifying Business Definitionsand Rules: Example Documenting Metadata Documenting metadata should include: Documenting the design process Documenting the development process Providing a record of changes Recording enhancements over time Business Metadata Elements Name of the measure Business dimensions Dimension attributes Sample data Business definition and rules Metadata Documentation Approac