Advantages and Disadvantages of Using a Data Warehouse
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 Advantages of Data Warehousing
Data warehouses tend to have a very high query success as they have complete control over the four main areas of data management systems.
- Clean data
- Indexes: multiple types
- Query processing: multiple options
- Security: data and access
- Easy report creation.
- Enhanced access to data and information.
The Disadvantages of Data Warehousing
There are considerable disadvantages involved in moving data from multiple, often highly disparate, data sources to one data warehouse that translate into long implementation time, high cost, lack of flexibility, dated information, and limited capabilities.
- Preparation may be time consuming.
- Compatibility with existing systems.
- Security issues.
- Long initial implementation time and associated high cost
- Limited flexibility of use and types of users
- Difficult to accommodate changes in data types and ranges, data source schema, indexes and queries