1. Please answer all the follwing infulstructure for data warehousing quetions. Please also share all of your answers.

Chapter 8:

What is the composition of the operational infrastructure of the data warehouse?

Why is the operational infrastructure as important as the physical infrastructure?

List the major components of the physical infrastructure. Write two or three sentences to describe each component.

Briefly describe any six criteria you will use for selecting the operating system for your data warehouse.

What are the platform options for the staging area? Compare the options and mention the advantages and disadvantages.

What are the four common methods for data movement within the data warehouse?

Explain any two of these methods.

What are data warehouse appliances? List their benefits.

What are the four parallel server hardware options? List the features, benefits, and limitations of any one of these options.

How have RDBMS vendors enhanced their products for data warehousing? Describe briefly in one or two paragraphs.

What is intraquery parallelization by the DBMS? What are the three methods?

List any six types of software tools used in the data warehouse. Pick any three types from your list and describe the features and the purposes.

2. In your company, all the source systems reside on a single UNIX-based platform, except one legacy system on a mainframe computer. Analyze the platform options for your data warehouse. Would you consider the single-platform option? If so, why? If not, why not?

3. You are the manager for the data warehouse project of a nationwide car rental company. Your data warehouse is expected to start out in the 500 GB range. Examine the options for server hardware and write a justification for choosing one.

4. As the administrator of the proposed data warehouse for a hotel chain with a leading presence in 10 eastern states, write a proposal describing the criteria you will use to select the RDBMS for your data warehouse. Make your assumptions clear.

5. You are the senior analyst responsible for the tools in the data warehouse of a large local bank with branches in only one state. Make a list of the types of tools you will provide for use in your data warehouse. Include tools for developers and users. Describe the features you will be looking for in each tool type.

1. Match the columns 1. operational infrastructure 2. preemptive multitasking 3. shared disk 4. MPP 5. SMP 6. A. shared-nothing architecture B. provides high concurrency C. single memory address space D. operating system feature E. vertical parallelism F. people, procedures, training G. easy administration H. choice data warehouse platform I. optimize for data transformation J. data movement option interquery parallelizati 7. intraquery parallelization 8. NUMA 9. UNIX-based system 10. data staging area on