The latest DB2 release has been optimised as a database to replace Oracle for e-business applications, industry experts noted last week
The latest DB2 release has been optimised as a database to replace Oracle for e-business applications, industry experts noted last week.
Analyst group Bloor Research said the latest version of DB2 redresses the lack of e-commerce support of its predecessors. "IBM has come to the table with some enhancements to DB2 that clearly position it as a database well tuned for the e-commerce marketplace."
Steve Way, mid-range controller at the IBM Computer Users Association, said, "DB2 is well ahead of Oracle and Microsoft SQL Server."
Performance data from IBM shows that with a new in-memory relational database technology, the database server can perform 90 million text searches a day for Web applications.
"DB2 has been strengthened and is more flexible, making it easier for businesses to bolt things together," said Way.
He noted that the performance of SQL database queries has improved in version 7: "IBM has put the database closer to the actual computer hardware to improve performance."
Mike Blake, data marketing consultant at IBM, said, "We've done a lot of work with e-business [on DB2]."
Among some of the new features in DB2 version 7 is support for XML (eXtensible Markup Language). "Searching XML documents is now faster," said Blake.
DB2 also offers an XML Extender feature which IBM has said will provide businesses with a means to manage XML documents through the DB2 database. An XML document can also be formulated from existing DB2 tables for data interchange in business-to-business environments.
As for targeting Oracle users, IBM has also built in direct support for the Oracle relational database, allowing businesses to consolidate data in Oracle directly with DB2. Using a facility called Federated Data Access, Blake said, "DB2 can access Oracle databases directly."
DB2 supports Microsoft's object linking and embedding database middleware, which can be used to perform queries on other databases such as Informix, Sybase and SQL Server with DB2.
n IBM is developing Linux links into the AS/400 which will allow applications developed for Linux to run on the AS/400 without modification.