1. Please answer all the follwing infulstructure for data warehousing quetions.
ID: 3745246 • Letter: 1
Question
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 onExplanation / Answer
What is the composition of the operational infrastructure of the data warehouse?
Data warehouse(DW) is a system environment that keeps track of data for business analysis which provides the end users detailed and processed data. In operational infrastructure, it consists of all the method used to analyse and deals with the on how to keep data running for the DW. It consists of the people, the training required to process the system, applications used for the system etc. Basicaly it must ensure all the operational quality to maintain thye efficiency and management of the DW.
Why is the operational infrastructure as important as the physical infrastructure?
The physical infrastructure consists of all the physical details of a warehouse like the hardware components,network used, the OS used etc. which means all the physical things related to the warehouse can be included in the physical infrastructure. The operational infrastructure can be seen as the functional unit of the warehouse. Because it consists of the people, the training required to process the system, applications used for the system etc. Considering both, to functionally process the data warehouse, we need both the operational and physical infrastructure. So we can find both the infrastructures are as important as one another.
List the major components of the physical infrastructure. Write two or three sentences to describe each component.
1.Hardware components - These are the basic hardware components like input/output devices, storage devices,power and cooling infrastructure etc.
2.Network equipments- These are the components used for network usages like routers,cables,modems,firewalls etc.
3. Network softwares- To perform the network operations, the system needs different softwares for each network devices.
4. Operating system- There should be an OS to run any hardware of software for any system, here in the case of a DW all the data extraction, transformation, integration, and staging jobs are done through the hardware using the OS in the memory.
Briefly describe any six criteria you will use for selecting the operating system for your data warehouse.
When selecting an operating system for a computer, the following factors may be considered:
1. The configuration of hardware in our DW. For example memory, stroage capacity etc.
2.User friendliness of the OS
3.The number of users it can support.
4.The hardware and processor quantity it can support.
5. Ability and efficiency to multitask.
6. Amount of reliability and security supported by the OS.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.