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
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)
What are the various operations that can be performed on different Data Structures?...
By Antony Pius · 2 years ago
Explain various E-business strategy implementation success factors for Small and Medium Organization...
By Khaled Hkh · 3 years ago
Write short notes on the following. i) Internet ...
By Khaled Hkh · 3 years ago
BigBook, Inc. is a large book distributor with domestic and international distribution channels. The company orders from publishers and distributes...
By Hari · 3 years ago
which clouds are on-premise giving it managers complete control over the available resources?...
By Steve · 3 years ago