Kognitio Tries Fast, Faster, Fastest Data Warehouse Strategy - 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.

Software // Information Management
12:57 PM
Connect Directly

Kognitio Tries Fast, Faster, Fastest Data Warehouse Strategy

Microsoft Excel-friendly analysis engine and three appliance configurations cover the spectrum of big-data performance demands.

8 Big Data Deployments In Detail
(click image for larger view)
Slideshow: 8 Big DataDeployments In Detail
Fast, faster, and fastest. Kognitio became the latest data warehousing vendor to offer this three-speed appliance strategy last week. And following up this week, Kognitio added a virtual-OLAP analysis engine aimed at flexible, what-if analysis by business users.

Kognitio's OLAP-style offering is Pablo, a Picaso-inspired name for a new cube-analysis extension of the vendor's WX2 relational database. Pablo supports multidimensional analysis, but unlike conventional OLAP cubes, which have to be prebuilt, the optional module builds virtualized cubes on the fly. Thus, any dimension of data in a WX2 database can be used for rapid-fire analysis from a cube held entirely in memory.

We're not talking about SQL querying here, so you need a business intelligence tool for business-user friendly multidimensional analysis. Kognitio's answer is A La Carte, a Pablo feature that lets Microsoft Excel tap into the dozens, if not hundreds, of terabytes in Kognitio deployments. Excel is familiar to almost any data analyst, so Kognitio is following a well-worn path by integrating with world's most popular data interface.

Kognitio is a database vendor that doesn't have its own hardware. But bowing to customer interest in rapid deployment, the company has for many years put together complete appliances using hardware from HP or IBM. These appliances have typically been built to customer specs, but Kognitio responded to offerings by EMC, IBM Netezza, and Teradata last week by introducing standardized appliances at three performance levels. Lakes, Rivers, Rapids are conceptually named after the analysis required.

The Lakes appliance is focused on analyzing large pools of data at low cost, with 10 terabytes of storage and 48 compute cores per module. The memory-to-disk ratio is 17.36, so it's not about rapid data flow. Telcos or financial services might use this configuration to scan vast stores of call-data-records or financial transaction records required for compliance purposes.

The Rivers appliance balances speed and capacity, with 2.5 terabytes of storage, 48 cores per module, and a memory-to-disk ratio of 4.34. This is suitable for a general-purpose mix of speed and scale, so you can quickly answer business-critical questions while still offering what Kognitio says is a reasonable cost-to-performance ratio.

For the ultimate in query performance, the Rapids appliance applies 96 cores of processing power to just 1.5 terabytes per module. The memory-to-disk ratio is 2.92, so much of the data analyzed can be held in memory. The configuration is aimed at financial firms doing algorithmic trading and other exotic, high-end performance demands.

Teradata set the three-speed trend in 2009 when it announced high-capacity and high-performance appliances to complement its standard products. EMC and IBM Netezza recently followed with capacity- and performance-oriented products complementing their standard appliances.

Pablo's OLAP-style analysis is also not new. Teradata has offered a virtual OLAP-analysis option and a tie to Microsoft BI tools (including Excel) for several years.

The Pablo option for WX2 and the Lakes, Rivers, and Rapids appliance configurations are available immediately. Kognitio declined to detail pricing. Kognitio has 30 customers, half of which use hosted WX2 deployments.

The economies of storage networking have changed dramatically, especially in the options available for small and midsize enterprises. We analyze SME responses to our 2011 State of Enterprise Storage Survey and discuss which techs will best serve these businesses. Download our report now. (Free registration required.)

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
10 Ways to Transition Traditional IT Talent to Cloud Talent
Lisa Morgan, Freelance Writer,  11/23/2020
Top 10 Data and Analytics Trends for 2021
Jessica Davis, Senior Editor, Enterprise Apps,  11/13/2020
Can Low Code Measure Up to Tomorrow's Programming Demands?
Joao-Pierre S. Ruth, Senior Writer,  11/16/2020
White Papers
Register for InformationWeek Newsletters
Current Issue
Why Chatbots Are So Popular Right Now
In this IT Trend Report, you will learn more about why chatbots are gaining traction within businesses, particularly while a pandemic is impacting the world.
Flash Poll