Question

Explain whether or not you feel that data warehouses are essential for a business to succeed. What strategies do organizations put in place if the database were to go down?

Answer 1

Data warehouse is the central repository where entire data of the organization is stored. The direct benefit of data warehouse is simplified access to data. Data Warehouse is a repository of business information, which is considered critical for successful execution of any business process. The strategic information in a data warehouse is the critical data of business, on which effective decision making for business can be based. Data warehouse is the only credible source to obtain strategic information related to any business process. Hence data warehouse is quite critical for the success of the business.

The companies employ to the following strategies if the database were to go down:

• Segmenting and distributing the data across various servers
• Maintaining backup of data
• Installing high-end firewalls and encryptions for data protection