What are some implications of the growing importance of Business Intelligence for data warehousing technologies?
Today, Business Intelligence/Data Warehousing is moving away from decisional to operational. This essentially means that the questions asked of the warehouse are evolving from “What happened?” to “What is happening?” and “What will happen?” The growing importance of BI is affecting warehousing technologies in more than one way. For instance, data warehouses today have to be well equipped to handle increased query demands (predefined to ad-hoc), higher number of users and ever-increasing data volumes running into terabytes. Not only this but, it has to do all this at considerably reduced latency windows and lower maintenance costs. Data Warehousing technology is evolving to keep up with these requirements with improvements in query processing, scaling across low cost hardware, non-stop DW technology, data compression, fast data loads, support for low-cost hard disks for storage and archiving. What according to you are some of the essentials for a successful BI/DW environment? There are
