The recent popularity of data warehousing technology as a management technique advocated by various data warehousing associations and business groups would seem to imply the overall positive aspects of using the process as a business model. However, not every system is applicable to every business setting. Business owners should fully research the advantages and disadvantages of data warehousing before attempting to implement the strategy.
A D V E R T I S E M E N T
The major disadvantages of data warehousing is the time commitment required and the need to create a cohesive, compatible system of data collection, storage, and retrieval.
Preparation may be time consuming :One of the most common data warehousing issues pertains to the need to regularly extract, clean, and load data into the system. Even though this process is fully automated, it still consumes time as does regular maintenance.
Compatibility with existing systems : The use of data warehousing technology may require a company to modify the database system already in place. This could really be the foremost concern of businesses when adapting the model given the cost of the computer systems and software needed.
Security issues :Data warehousing technology, as good as it is to implement, may contain security flaws. If the database contains sensitive information, its use may be restricted to a limited group of people and precautions will be required to insure that access is not compromised. Limited data access situations can also effect the overall utilization of the data stragetgy.