IBM to ease DB2 admin

Signalling an attempt to link its database and grid computing plans, IBM has revealed that the next release of its DB2 database will ease administration hassles and contain better XML document support.

DBAs (database administrators) can expect the new version to make their lives easier with an automated query optimization utility, said Jeff Jones, senior program manager of data management solutions at IBM's labs in San Jose, Calif.

DBAs can already run a utility that gathers statistics on the data geography and optimizes subsequent query requests, but the next release will perform these functions in real time.

"In essence the database will maintain an understanding of how the data is laid out so that queries are automatically optimized for performance," Jones said.

According to Jones, the new features reflect IBM's move to extend the reach of its grid computing initiative.

Grid computing, in this context, refers to a vision of self-healing, self-managing systems that can be treated as modular commodities in a large datacenter or network of datacenters.

"It makes sense for IBM to introduce self-managing functions in products such as DB2," said Galen Schreck, an analyst at Forrester Research in Cambridge, Mass. "It allows them to test some of the components of grid computing in a controlled environment."

On the XML front, Jones said DB2 will offer more support for XQuery, one of the emerging standards for querying XML data.

"We will demonstrate how XQuery can talk to DB2 later this month," Jones said. "This is an intermediate step for us in XML."

Further down the road, Jones said IBM also plans to offer a separate, nonrelational XML data repository, part of another larger IBM initiative dubbed Xperanto.

Meanwhile, IBM's plans represent a marked contrast from competitors Oracle and Microsoft, which are sticking to the relational database paradigm.

Jeff Ressler, lead product manager for SQL Server at Microsoft in Redmond, Wash., believes XML data will be very compatible with relational databases.

"As XML becomes more ubiquitous, it will become more integrated with the RDBMS [relational database management system] and also with everything else," Ressler said.

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

More about Forrester ResearchIBM AustraliaMicrosoft

Show Comments
[]