• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM Readies Query Appliance for Mainframes; What About i?

    August 17, 2009 Timothy Prickett Morgan

    As part of its Smart Analytics System announcement from a few weeks ago, Big Blue also talked a little bit–and I mean only a little bit–about another kind of business analytics hardware that it had cooking in its labs and factories and that would debut soon for its System z mainframes. And hopefully, this appliance, called the Smart Analytics Optimizer, will also soon be available for the Power Systems platform running i 6.1 (and AIX and Linux, if you care).

    The Smart Analytics System is a stack of preconfigured Power 550 systems running AIX, parallel file systems, and InfoSphere and Cognos data warehouse tools (and soon, predictive analytics from SPSS, which IBM is in the process of acquiring for $1.2 billion). The Smart Analytics Optimizer is an appliance that links to a System z mainframe through a normal Ethernet link and is used to process very complex queries–the kinds that would normally bring production systems to their knees as they are doing their daily batch and transaction processing work–on the appliance but using live, production data. So you do the kinds of work you would normally do in a data warehouse, but you don’t have to do the extract and load operation from production to data warehouse systems and you do a query on the real, live data–just not on the production machine. In a sense, it is a query co-processor.

    Exactly what is inside the Smart Analytics Optimizer is not clear, but I have heard that it makes use of SQL processing technologies that have been tweaked to run on vector processors and utilizing in-memory databases that hold a snapshot of the production data housed on mainframes. The word from IBM is that for certain kinds of queries, the Smart Analytics Optimizer runs a complex query 50 times faster than the mainframe and that the price for a complex query on this appliance will be two orders of magnitude cheaper than running it on the mainframe. I confirmed that the DB2 queries are not running on so-called specialty engines inside the mainframe, and I also think it would be very interesting to cluster or daisy chain such devices together in a manner that allows complex queries to be run all the time without having to resort to a data warehouse at all.

    Steve Mills, general manager of IBM’s Software Group, has not confirmed that the Smart Analytics Optimizer would be available for IBM’s other server platforms, but it seems highly unlikely that Big Blue won’t make it available for Power Systems running AIX and i and their respective variants of DB2. All of the same issues about performance and complex queries plague AIX and i shops as do mainframe shops–problems that spawned the big data warehousing wave back in the mid-1990s in the first place.

    RELATED STORIES

    A Peek Inside IBM’s Smart Analytics System

    IBM Gets Hybrid with Servers, Talks Up BAO Boxes

    IBM turns back on server history: To give and to hybrid (The Register)

    Beep, Beep: Roadrunner Linux Super Breaks the Petaflops Barrier

    IBM Aims for Server Expansion in 2008, Including System i Reincarnation

    Brazilian Game Site Chooses Hybrid Mainframe-Cell Platform

    IBM’s Plan for an Adjacent, Custom Systems Market



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: mtfh_rc, Volume 18, Number 30 -- August 17, 2009

    Sponsored by
    Manta Technologies

    The Leader in IBM i Education!
    Need training on anything i?
    Manta is all you need.

    During the month of May, when you purchase a license for the Free-Form RPG Programming series for any term (one, two, or three years) and any user license level, and you will get the equivalent license for the Coding Free-Form RPG course for FREE.

    130 courses and competency exams on:
    · IBM i operations
    · System Management and Security
    · IBM i Programming Tools
    · Programming in RPG, COBOL, CL, Java
    · Web Development
    · SQL, DB2, Query

    Product features:
    · Runs in every popular browser
    · Available 24/7/365
    · Free Student Reference Guides
    · Free Student Administration
    · Concurrent User License
    · Built-In IBM i Simulator

    You can download our 200-page catalog and take sample sessions at MantaTech.com.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Who Has the Strongest IT Brands? ASTI Sees Promise in Plasmon’s UDO Technology

    Leave a Reply Cancel reply

TFH Volume: 18 Issue: 30

This Issue Sponsored By

    Table of Contents

    • RPG: A Great Language with a Greater History
    • IBM Tweaks Power 570, 595 Deals Yet Again
    • Reconsidering SAN in Wake of SCSI Disk’s End
    • As I See It: Daniel, Part II
    • A Quick Analysis of Business Intelligence Planning
    • IBM Readies Query Appliance for Mainframes; What About i?
    • Computer Economics: More IT Job and Budget Cuts Expected
    • Reminder: SCSI Disks Coming to the End of the Line
    • IBM Discounts Support for Lotus Wares, Sunsets Older Domino Releases
    • Q&A with TVMUG’s Don Rima

    Content archive

    • The Four Hundred
    • Four Hundred Stuff
    • Four Hundred Guru

    Recent Posts

    • COMMON Set for First Annual Conference in Three Years
    • API Operations Management for Safe, Powerful, and High Performance APIs
    • What’s New in IBM i Services and Networking
    • Four Hundred Monitor, May 18
    • IBM i PTF Guide, Volume 24, Number 20
    • IBM i 7.3 TR12: The Non-TR Tech Refresh
    • IBM i Integration Elevates Operational Query and Analytics
    • Simplified IBM i Stack Bundling Ahead Of Subscription Pricing
    • More Price Hikes From IBM, Now For High End Storage
    • Big Blue Readies Power10 And IBM i 7.5 Training for Partners

    Subscribe

    To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

    Pages

    • About Us
    • Contact
    • Contributors
    • Four Hundred Monitor
    • IBM i PTF Guide
    • Media Kit
    • Subscribe

    Search

    Copyright © 2022 IT Jungle

    loading Cancel
    Post was not sent - check your email addresses!
    Email check failed, please try again
    Sorry, your blog cannot share posts by email.