October 20, 2009 – More than half of respondents to a recent TDWI survey are planning a data warehouse platform replacement in the next three years, and many of those who aren’t, are looking to make significant updates. The survey data, gleaned from interviews with industry experts, companies and a survey of business intelligence professionals, was released in a TDWI best-practice report, “Next Generation Data Warehouse Platforms,” this month. “The report covers trends for next generation data warehousing, which options are hot and which are fading into the background,” said Philip Russom, senior manager of research and services at TDWI and author of the report.Master data management, real-time data warehousing and advanced analytics are the hottest options in the data warehousing space, according to the report. “Those three items we expect a very high adoption rate from among users,” Russom said.Real-time data warehousing is an area of growth with greater than expected demand, according to Russom. “I knew that real-time data warehousing was a desirable option that had not been adopted by very many organizations, but I didn’t realize there was such a large demand behind it.”Additionally, a section of data warehousing options highlighted in the report that show strong growth but small commitment at this stage, include public clouds, software as a service and open source. Russom describes the category as “bleeding edge stuff” for data warehousing that is pushing the limits of the space. There are 30 or so “hot” data warehousing options discussed in the report, which details adoption rates and highlights real-world examples of use and implementation.Data warehousing is increasingly relevant as businesses are continuously adjusting to boom-and-bust economies, according to the report. Businesses have come to rely on the data warehouse and associated BI infrastructure to understand and react to change appropriately.In order to support changing business requirements, data warehouse platforms need updating, according to the report. And, with more than half of respondents indicating a need for improvement, TDWI highlights the different paths to attaining a next-generation platform, from altering a current data warehouse to replacing it all together.Despite the fact that massively parallel processors (MPP) and database management systems that use open source software, are built for data warehousing or in-memory have higher growth and commitment in the data warehousing space, according to the report, most data warehouses use DBMS built for transactions and symmetric multiprocessors (SMP) – the two options that are fading away the fastest. “Most data warehouses use these components in their platforms,” said Russom. “But they are slated for change or replacement.” “With both technologies, each is being replaced by something else,” said Russom. DBMS built for transactions have been used for years. An extensive list of new DBMS has been released over the last year, however, that organizations are quickly moving toward.“SMP is still the standard hardware as well, but people are pretty aggressively replacing it with MPP,” said Russom. “Imagine these changes happening over a three year period.”For additional information on using data warehousing in as a strategic assets in a tight economy listen to this episode of DM Radio. Or, to hear more about the economics of enterprise data warehousing check out this episode. 

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access