Many managers are extremely reluctant to integrate company data. The 'solution that many of them come up with is the ever elusive virtual data warehouse. This is where a single query is sent to several distributed databases. Bill Immon (the 'father of the data warehouse') points out that following this method is not only incredibly wasteful (since it requires a huge amount of system resources) but also ultimately counterproductive (since the data that is delivered will still have to be integrated in order to make sense of it)
Data Warehouse Appliances are changing the way in which companies manage and access their data. The huge variety of products that are available can be slightly bewildering. The purpose of this very helpful study is to analyze some trends in data warehousing and related product development.
This is the second of two-part series exploring effective data warehouse governance. The first article introduced a framework for data warehouse governance and discussed a potential structure for organizing related oversight committees. This second article discusses insights into effective data warehouse governance and keys to success.