Homework help > You have recently been promoted to the administrat... > Published by: Professor Henry 3 years ago
By: Professor Henry
Subject: IT/Web
Answered

You have recently been promoted to the administrator for the data warehouse of a nationwide automobile insurance company. You are asked to prepare a checklist for selecting a proper vendor tool to help you with the data warehouse administration. Make a list of the functions in the management and control component of your data warehouse architecture. Use this list to derive the tool-selection ch ...[Show More]

3 years ago


Answer the Question above

Answers (1)


The following are the functions listed in the management and control component of the data warehouse architecture: • Data Quality Checks. • Managing and updating of metadata. • Backup and recovery of data. • Purging data. • Data warehouse storage management. • Information delivery function. • Priority and security management. • Monitoring updates of data from multiple sources. • Distributing and sub-setting data. • Auditing and reporting data warehouse usage and status. • Data replication. According to the information listed above, the best vendor tool will have to able to meet the majority of the most significant management and control components of the data warehouse function (Pasyeka & Pasyeka, 2016). The best vendor tool will, therefore, need to fulfil the above checklist. The list of the appropriate vendors that currently provide proper tools includes Amazon, IBM infosphere, Teradata and Oracle. For an organization with demanding data needs and an increasing amount of data to handle, the proper industry established data warehouse administration applications such as applications such as IBM Infosphere and Oracle. These prove to be the most reliable and operational data warehouse administrator tools that can be employed in an organization of dynamic nature.

By 3 years ago . Marked as helpful (258). Marked as unhelpful (198)


When you can’t seem to find the right answers

Get a step-by-step solution written by a professional tutor