Oracle, IBM DB2 Gain Intelligence

By Matthew Hicks  |  Posted 2002-04-01 Print this article Print

While the two database management systems' new business intelligence functionality will improve performance, it could also add unwanted complexity.

IN REDWOOD SHORES, Calif.--Moves by Oracle Corp. and IBM to embed new business intelligence functionality in their database management systems are designed to improve performance and simplify data warehousing. But they could also add unwanted complexity. Release 2 of Oracles 9i database, due by June 1, will offer enhanced OLAP (online analytical processing) support and additional data mining and development tools. Separately, IBM is planning to introduce within six months features to drive BI deeper into its DB2 database, according to a spokeswoman for the Armonk, N.Y., company. The plans include pushing OLAP and data mining further into the database engine.
While database administrators welcome new functionality, they said it comes with a cost: complexity.
"The more you utilize these features, the more overhead and processing that takes place," said Dave Mattia, an administrator at research and engineering company Science Applications International Corp., in San Diego. "You want to evaluate what your needs are." Oracle9i Release 2 will embed the companys Express OLAP server, replacing the previous versions slower OLAP engine. Placing the OLAP engine directly in the relational database reduces the time it takes to load data into an OLAP cube, said Oracle officials based here. One database administrator said such a scenario will be useful only in analyses that encompass more than 1 million metadata members—a rare occurrence. Oracle addresses scalability questions with two new features in Release 2. New Streams technology moves data into a data warehouse in near real time, officials said. The Cluster File System for Windows lets administrators set up a cluster of Oracle9i databases more easily. Nigel Pendse, author of The OLAP Report newsletter, considers 9i Release 2 an important—but limited—step forward, as front-end development tools for making use of OLAP will not be available until at least the end of the year. And other applications that could benefit from embedded OLAP, such as Oracle Financial Analyzer and Oracle Sales Analyzer, arent due until next year. Until those are available, Oracle customers wont reap the full benefits of the OLAP integration, Pendse said. "They were way behind and, on the whole, still are," said Pendse, in London. "They havent solved the problem of basic ease of use." Pendse welcomed another feature in 9i Release 2, Java OLAP API, which will allow users to access OLAP through SQL tools. This should open the way to such functionality as joining relational and OLAP data within the relational database engine, something other vendors cant do, he said. Vlamis Software Solutions Inc. this week will introduce VSS Business Analyzer, a tool for accessing data in 9i OLAP. Chris Claterbos, consultant and technology manager at Vlamis, said the Express integration was necessary. "The thing with 9i Release 1 was OLAP was really a separate world, and there was not an attempt to integrate the Express world," said Claterbos, in Liberty, Mo. "It, essentially, was a new product, and if you wanted to start from scratch and build OLAP applications, it was there. Now what Release 2 does is it brings [OLAP] into the mainstream." Integrating OLAP and a relational database is not a new idea. IBM in 1998 introduced its OLAP Server, which integrates OLAP from Hyperion Solutions Inc. in IBMs DB2 database. Microsoft Corp., of Redmond, Wash., introduced OLAP within its SQL Server data management system in 1998. Bala Thumma welcomed the added BI capabilities planned for Oracle9i Release 2. "We definitely are waiting for things to mature and to start to become mainstream," said Thumma, president and chief technology officer at Magma Solutions Inc., of Fremont, Calif. "If done right, its a great win for customers. If its not done right, it could cause destabilization [in the database]. The tricky part is getting all the things working well [together]." Related stories:
  • Oracles Secure, but Rest of World Isnt
  • Oracle Unveils Feature-Filled 9i Release
  • Oracles New Game Plan for 9i Database
  • Special Report: Server Databases Clash
    Matthew Hicks As an online reporter for, Matt Hicks covers the fast-changing developments in Internet technologies. His coverage includes the growing field of Web conferencing software and services. With eight years as a business and technology journalist, Matt has gained insight into the market strategies of IT vendors as well as the needs of enterprise IT managers. He joined Ziff Davis in 1999 as a staff writer for the former Strategies section of eWEEK, where he wrote in-depth features about corporate strategies for e-business and enterprise software. In 2002, he moved to the News department at the magazine as a senior writer specializing in coverage of database software and enterprise networking. Later that year Matt started a yearlong fellowship in Washington, DC, after being awarded an American Political Science Association Congressional Fellowship for Journalist. As a fellow, he spent nine months working on policy issues, including technology policy, in for a Member of the U.S. House of Representatives. He rejoined Ziff Davis in August 2003 as a reporter dedicated to online coverage for Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.

    Submit a Comment

    Loading Comments...
    Manage your Newsletters: Login   Register My Newsletters

    Rocket Fuel