IBM has unveiled new business intelligence software, DB2 Data Warehouse Edition V9.1, designed to help clients make decisions about their operations, products, and services in real time by transforming raw business data to business insights. IBM DB2 Data Warehouse Edition (DWE) V9.1 is designed to help organizations remove cost and complexity, and overcome barriers to business growth, by combining components needed for real-time data warehouse administration, data mining, Online Analytical Processing (OLAP), and inline analytics and reporting.
DWE V9.1 features technology from IBM and two of the company's software acquisitions, Rational and Alphablox. The foundation of DWE is the DB2 Universal Database, which is supported by analytics design and development tools including Rational Data Architect and a network of partner offerings. DWE also includes DB2 Alphablox, a tool for developing custom applications with embedded analytics designed to leverage the information warehouse. Alphablox runs on WebSphere Application Server and provides an application framework, a programming model, and development tools for assembling analytic applications. Embedded data mining in DWE uses DB2 Intelligent Miner algorithms to analyze warehouse data 'where it resides' and provides fraud detection, financial forecasts, and insights into customer behavior.
DWE V9.1 also features an Eclipse-based Design Studio, a data discovery function that allows customers to profile data, and sample and view table contents, as well as visualize correlated statistics to understand what parts of the warehouse have potential for mining. The Design Studio offers a data flow editor that enables users to visually design data mining flows using advanced modeling, scoring, and visualization software. Later, SQL can be generated and pasted into an Alphablox page, a third party tool, or any customer application to invoke the mining flow for embedded analytics.