IBM gears up for delivery of Information Integrator

IBM next week plans to release its DB2 Information Integrator database software for collating information from multiple sources.

The announcement is one of a barrage of software-related announcements IBM is planning for its Software Symposium for customers on Tuesday in Munich. Formerly called Xperanto, DB2 Information Integrator acts as a dedicated search engine for corporate information, collating data from multiple sources. Rather than having to install a huge, centralised database called a data warehouse to store that disparate information, companies can use DB2 Information Integrator to query several sources and present a consolidated result.

DB2 Information Integrator can work with relational databases, which are used to keep corporate data such as customer records, along with documents or images. Application developers kick off database inquiries with the commonly used Structured Query Language (SQL). IBM plans to make use of the Extensible Mark-up Language (XML) with a querying method based on the XQuery standard when that standard matures sometime next year, according to company executives.

IBM is also preparing a version of DB2 Information Integrator for content management systems. Rather than use SQL to do database searches, the content management edition will be more oriented toward documents, said Jeff Jones, director of strategy for IBM's DB2 data management software.

Several other companies are pursuing similar data aggregation technology, known as enterprise information integration (EII), or federated, databases. BEA Systems last year introduced Liquid Data, an XML-based method for searching databases. Microsoft, too, will introduce similar capabilities in its forthcoming version of the SQL Server database, called Yukon, which is expected to go into customer testing later this year. Nimble Technology and MetaMatrix are two start-ups focused on the information integration.

Information integration technology is beginning to bear fruit, in part for economic reasons, said Stephen O'Grady, an analyst at RedMonk.

"With cost-cutting and economic pressures, companies don't want to buy a whole lot of new databases if they can avoid it," O'Grady said. "If there is a lightweight technology that is cheaper and easier to implement, they are certainly considering it."

O'Grady also noted that greater usage of XML portends well for the future use of XQuery for searching data sources that store documents such as email messages or web content. But at this point, he said, information integration products are best suited for so-called structured data in relational databases, which are used for corporate transaction systems.

DB2 Information Integrator is initially priced at $20,000 for a server licence and $15,000 per data source to which an application connects.

Martin LaMonica writes for CNET News.com.