Can Oracle 11g OLAP Query Acceleration Alter BI? - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
Commentary
7/15/2007
02:27 PM
Seth Grimes
Seth Grimes
Commentary
Connect Directly
Twitter
RSS
E-Mail
50%
50%

Can Oracle 11g OLAP Query Acceleration Alter BI?

Oracle 11g is a blockbuster release, sure to maintain the company's dominant market position. Yet despite nearly 500 technology features new in 11g, InformationWeek Editor at Large Charles Babcock leads his recounting with a regression-testing feature and hot-standby systems. Those options are great but they don't send shivers down the spines of analytics types like me. I'd love to see new OLAP features that will transform the BI market, but what does 11g offer? Let's take a closer look.

Yes, Oracle 11g is a blockbuster release, sure to maintain the company's dominant market position.Yet despite nearly 500 technology features new in 11g, InformationWeek Editor at Large Charles Babcock leads his recounting with a regression-testing feature and hot-standby systems. Those options are great for you CIOs out there but they don't send shivers down the spines of analytics types like me. What does? I'd love to see new OLAP features that will transform the BI market, just what Oracle says 11g offers. Let's take a closer look.

IE editor and fellow blogger Doug Henschen reports on 11g's new OLAP-cube based management of materialized views, #3 feature on Babcock's new and noteworthy list. Oracle Database Senior VP Andy Mendelsohn, quoted by Doug, touts use of "OLAP cubes as a transparent performance accelerator" for access to materialized views. This feature is important because, according to Mendelsohn, 60 percent of Oracle's data warehousing customers use materialized views. Users "won't even know they're using OLAP."

My take? Oracle is admitting that interactive, slice-and-dice, pivot analyses have been too expensive -- too slow and difficult -- in the majority of Oracle data warehouses. The company is righting the situation with an accelerator for their previously delivered kludge, for DW reliance on materialized views, which by the way strikes me as functionally equivalent to the massive precomputation of aggregates that a number of non-RDBMS OLAP engines used to be notorious for.

Babcock quotes Charles Rozwat, Oracle executive VP for server technologies: "Oracle's new OLAP features take business intelligence 'from a specialized niche into a much broader market.'" So we can add Oracle to the long list of companies promising BI for the masses. All it took was a query accelerator!

It appears that 11g's OLAP-cube based management of materialized views is only enabling technology, that it does not deliver new end-user analytics. The accelerator sounds like good stuff -- and so do 11g's binary XML handling, encryption and compression. These new features are nutritious fare for the reliability and performance hungry database administrator and CIO. But sorry, a query accelerator will not transform BI.


Notes

  • Oracle's data sheet for the OLAP Option to the Oracle Database, 11g is available on-line.

  • You can compare it to the 10g data sheet.

  • For a write-up on the Oracle BI Suite Enterprise Edition Plus product, check out Mark Rittman's blog.


    Seth Grimes is an analytics strategist with Washington DC based Alta Plana Corporation.Oracle 11g is a blockbuster release, sure to maintain the company's dominant market position. Yet despite nearly 500 technology features new in 11g, InformationWeek Editor at Large Charles Babcock leads his recounting with a regression-testing feature and hot-standby systems. Those options are great but they don't send shivers down the spines of analytics types like me. I'd love to see new OLAP features that will transform the BI market, but what does 11g offer? Let's take a closer look.

    We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
    Comment  | 
    Print  | 
    More Insights
  • Commentary
    The Best Way to Get Started with Data Analytics
    John Edwards, Technology Journalist & Author,  7/8/2020
    Slideshows
    10 Cyberattacks on the Rise During the Pandemic
    Cynthia Harvey, Freelance Journalist, InformationWeek,  6/24/2020
    News
    IT Trade Shows Go Virtual: Your 2020 List of Events
    Jessica Davis, Senior Editor, Enterprise Apps,  5/29/2020
    White Papers
    Register for InformationWeek Newsletters
    Video
    Current Issue
    Key to Cloud Success: The Right Management
    This IT Trend highlights some of the steps IT teams can take to keep their cloud environments running in a safe, efficient manner.
    Slideshows
    Flash Poll