Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Latest News
    • Storage

    Oracle, IBM DB2 Gain Intelligence

    By
    Matthew Hicks
    -
    April 1, 2002
    Share
    Facebook
    Twitter
    Linkedin

      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 eWEEK.com, 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 eWEEK.com. Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×