MySQL 数据库系统设计实现与管理第六版课后习题答案Part 9 Review Questions and Exercises.docVIP

Word可编辑 PAGE PAGE 13 Word可编辑 SOLUTIONS TO REVIEW QUESTIONS AND EXERCISES FOR PART 9 – BUSINESS INTELLIGENCE (CHAPTERS 31 –34) Solutions to Review Questions and Exercises TOC \o 1-3 \h \z Chapter 32 Data Warehousing Concepts 3 Chapter 33 Data Warehousing Design 6 Chapter 34 OLAP 8 Chapter 35 Data Mining 13 Chapter 31 Data Warehousing Concepts Review Questions 31.1 Describe what is meant by the following terms, when describing the characteristics of the data in a data warehouse: (a) subject-oriented; (b) integrated; (c) time-variant; (d) non-volatile. See Section 31.1.2. 31.2 Discuss how Online Transaction Processing (OLTP) systems differ from data warehousing systems. See Section 31.1.4 31.3 Discuss the main benefits and problems associated with data warehousing. For the main benefits of data warehousing see Section 31.1.3 and for the main problems associated with data warehousing see Section 31.1.5. 31.4 Present a diagrammatic representation of the typical architecture and main components of a data warehouse. For a diagram of the typical architecture of a data warehouse see Figure 31.1. 31.5 Describe the characteristics and main functions of the following components of a data warehouse. (a) ETL manager See Section 31.2.3 (b) warehouse manager See Section 31.2.4 (c) query manager See Section 31.2.5 (d) metadata See Section 31.2.9 (e) end-user access tools. See Section 31.2.10 31.6 Describe the processes associated with data extraction, cleansing, and transformation tools. The extraction step targets one or more data sources for the EDW; these sources typically include OLTP databases but can also include sources such as personal databases and spreadsheets, enterprise resource planning (ERP) files, and web usage log files. The data sources are normally internal but can also include external sources, such as the systems used by suppliers and/or customers. The transformation step applies a series of rules or functions to