IBM Corp yesterday took the lid off a new version of its DB2 Data Warehouse Edition system that comes with more integrated real-time analytics and data management capabilities.
The bumped-up functionality in DWE version 9.1 is courtesy of Alphablox and Rational Software,0 two companies that IBM acquired.
Specifically, this includes a new Alphablox-based tool for building custom analytic applications running against the core warehouse. The tools run on IBM’s WebSphere Application Server.
DWE 9.1 also bundles in design and development tools such as Rational Data Architect, as well as other partner products, to help administrators manage the core DB2 database.
DWE also includes DB2 Alphablox, a tool for developing custom applications with embedded analytics that leverages the information warehouse. Alphablox runs on WebSphere Application Server.
Other notable features included in DWE 9.1 are in-database data mining algorithms sourced from IBM’s DB2 Intelligent Miner product and an Eclipse-based design and development studio for profiling data in preparation for analysis and mining.
The studio offers data flow editors to visually depict data mining flows using modeling, scoring techniques which can be automatically translated to SQL and included as part of Alphablox applications or other third-party BI tools.
Officials at Armonk, New York-based IBM says the new release of DWE will allow companies to step up more confidently to the demands of real-time business, by combining essential components for data warehouse administration, data mining, OLAP, in-line analytics and query and reporting.
We’re helping clients quickly build and deploy analytics analytic applications that enable real-time access to data, said Karen Parrish, vice president, IBM business intelligence solutions.
Research firm Gartner pegs business intelligence software as a hot growth sector. It predicts sales of new BI software licenses to exceed $2.5bn this year, representing a CAGR of 6%.