Difficulties of Implementing Data Warehouses

Prerequisites – Data Warehousing, Data Warehouse Architecture, Characteristics and Functions of Data warehouse

Here are some of the difficulties of Implementing Data Warehouses:

  1. Implementing a data warehouse is generally a massive effort that must be planned and executed according to established methods.
  2. Construction, administration, and quality control are the significant operational issues which arises with data warehousing.
  3. Some of the important and challenging consideration while implementing data warehouse are: the design, construction and implementation of the warehouse.
  4. The building of an enterprise-wide warehouse in a large organization is a major undertaking.
  5. Manual Data Processing can risk the correctness of the data being entered.
  6. An intensive enterprise is the administration of a data warehouse, which is proportional to the complexity and size of the warehouse.
  7. The complex nature of the administration should be understood by an organization that attempts to administer a data warehouse.
  8. There must be a flexibility to accept and integrate analytics to streamline the business intelligence process.
  9. To handle the evolutions, acquisition component and the warehouse’s schema should be updated.
  10. A significant issue in data warehousing is the quality control of data. The major concerns are: quality and consistency of data.
  11. Consistency remain significant issues for the database administrator.
  12. One of the major challenge that has given differences in naming, domain definitions, identification numbers is Melding data from heterogeneous and disparate sources.
  13. The data warehouse administrator must consider the possible interactions with elements of warehouse, every time when a source database changes.
  14. There should be accuracy of data. The efficiency and working of a warehouse is only a good as the data that support its operation.
  15. Usage projections should be estimated conservatively prior to construction of the data warehouse and should be revised continually to reflect current requirements.
  16. To accommodate addition and attrition of data sources, the warehouse should be designed. This also avoids a major redesign.
  17. Sources and source data will be evolve, and the warehouse must accommodate such changes.
  18. Another continual challenge is fitting of the available source data into the data model of the warehouse. This is because requirements and capabilities of the warehouse will change over time as there will be a continual rapid change in technology.
  19. A far broader skills will be required by administration of data warehouse for traditional database administration.
  20. Managing the data warehouse in large organization, design of the management function and selection of the management team for a database warehouse are some of the major tasks.

Some best practices for implementing a Data Warehouse:

  1. The data warehouse must be built incrementally.
  2. User expectations about he completed projects should be managed.
  3. It is important to be politically aware.
  4. There should be a build in adaptability.
  5. Developing a business/supplier relationship is the best practice.

Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.

Article Tags :
Practice Tags :


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.