A tipping point has been reached, and going forward, you will need only one kind of database to run both the transactional and BI parts of enterprise systems. There will still be different instances due to performance requirements to support diverging transactional and BI workloads, but they will both operate with the same database. Proprietary systems that operate with special purpose technology stacks and databases are out. Open systems – including de facto standard such as IBM DB2, Oracle and Microsoft SQL Server – are in. Open source databases will remain outside the mainstream due to lack of features, functions and experience, but will exert a remorseless flattening influence on the major players in downward pressure on prices.
Just like his other articles on Business Intelligence, in this well conceptualized column, Trends for 2006, Lou Agosta makes a daring thought about the world of Data Warehousing. He throws his views on how companies could derive value from their BI systems by employing open source architecture and low-cost servers. I only wish those corporates who are thinking a zillion times to data warehouse their systems would read this. Build Data Warehouses for cheap and Warehouse the world. For this is what every Data Warehousing guy dreams about.