Big Data. Big Decisions
InformationWeek
Special Coverage Series

Commentary

Doug Henschen

Doug Henschen

Executive Editor, InformationWeek

With Hadoop, Big Data Analytics Challenges Old-School Business Intelligence

Datameer and Karmasphere say their Hadoop-based platforms are what's needed for the next era of data analysis. Are you buying it?

12 Hadoop Vendors To Watch In 2012
12 Hadoop Vendors To Watch In 2012
(click image for larger view and for slideshow)
Datameer and Karmasphere, two competing upstart vendors offering reporting, data-visualization, and data-analysis capabilities on top of Hadoop, released new versions of their software on Monday. Both talked up the need for next-generation tools.

It's not that old-school business intelligence software tools are going away, these upstarts grant. But both portray batch-oriented extract-transform-load (ETL) data integration, relational data warehousing, and old-school analytics as too slow, rigid, and expensive to keep up in the big-data era.

More Insights

Webcasts

More >>

White Papers

More >>

Reports

More >>

Hadoop is the future, these vendor's contend, because it's a massively scalable data-management and analysis environment that can handle variably structure data from many sources--log files, clickstreams, sensor data, social media sources and so on--without the delays inherent in dealing with the static schemas of relational databases.

If companies want to look at recent point-of-sale transactions alongside Web site clickstreams, recent online enrollments, email campaign results, and social media chatter, for example, it would be difficult if not impossible to quickly put all that data into a relational data warehouse and look for correlations.

[ Want more on Apache's big-data platform? Read Why Hadoop Crowd Is Hearing Much About Hortonworks. ]

Datameer and Karmasphere offer integration, data-analysis, and data visualization products that run on Hadoop. They're two of the better-established companies hoping to provide what they describe as next-generation platforms. Founded in 2009 and 2005, respectively, Datameer and Karmasphere are private companies that each have a handful of nameable customers. Datameer points to blue chip Visa, among others, while Karmasphere says Intel and Microsoft are customers.

In his company's work with a global bank on meeting Basel II capital requirements, Datameer CEO Stefan Groschupf reports that more than 250 data sources are required.

"Finding a perfect star schema and building the required ETL for that is impossible," Groschupf told InformationWeek.

In another example, a big retailer wanted to get data that helped it better understand all its interactions with customers, rather than looking at isolated transactions.

"ETL and data warehousing and BI are just fine for the problem of looking at transactions here and there, but there's no chance of bringing it all together to look at the interactions across all of the islands of information," Groschupf says.

Hadoop also scales in linear fashion to solve the data-volume challenge, and it's built on commodity hardware, so it's less expensive, terabyte for terabyte, than conventional relational systems, Datameer and Karmasphere contend.

What about the scarcity of Hadoop talent, the platform's own batch-related delays and the alternative of using "old-school" BI systems to analyse data either inside or moved out of Hadoop? Datameer and Karmasphere have responses to some of these questions, but more on that later.

What's Different?

Datameer's platform for analytics on Hadoop provides modules for data-integration (including connectors to mainframes, databases, social sources like Facebook and Twitter, and more), a spreadsheet-driven data-analysis environment, and a dashboarding and data-visualization environment, the last part being new in version 2.0. The upgrade also introduces two lower-priced editions designed for fewer users and lower data volumes than the enterprise version.

Datameer's key appeal is its spreadsheet-driven data-analysis environment, which the vendor says provides more than 200 analytic functions from simple joins to predictive analytics. Most importantly, it's said to eliminate the need for Hadoop wonks and IT people to support data analysis. The interface is designed to let business analysts--and certainly any SQL-savvy BI or data-warehousing power user--use a point-and-click interface to analyze data within Hadoop. In the background, Datameer's software turns the selections into Hadoop-based MapReduce and data-manipulation jobs without users having to write code.

Datameer Enterprise starts at $100,000 and supports Hadoop deployments with hundreds or even thousands of nodes. Datameer Workgroup is subscription based software that creates a small-scale Hadoop deployment on a single server. It starts at $3,000 per year for up to 10 users, but data volumes are limited to one terabyte. Exceed that ballpark and you'll have to upgrade to the enterprise edition, though the reports and analyses are portable.

 1 | 2  | Next Page »


Related Reading




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.

Follow InformationWeek

By The Numbers

What Are Your Primary Concerns About Using Big Data Software?

Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012

What Do You Think?

What's your attitude about SQL analysis on top of Hadoop?
We want fast, standard SQL analysis capabilities on Hadoop ASAP
Hadoop is for unstructured data; SQL is for relational databases
We'll give SQL on Hadoop a try, but relational DBs will remain the mainstay
Given strong SQL support on Hadoop, we'd nix the data warehouse
We're not interested in Hadoop
No opinion



Related Content

From Our Sponsor

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Business leaders often need a visual snapshot of data to quickly grasp and use it. This paper identifies five challenges in presenting data and how visual analytics can resolve them. Solutions are suggested to overcome the challenges of: speed, data clarity, data quality, displaying meaningful results, and dealing with outliers.

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Today's competitive advantage requires a deeper understanding of your business, your market and your customers. As an IT executive, you can drive that knowledge transformation. In this white paper, learn how to make decisions as a strategic business leader and three steps to begin an analytics initiative within your enterprise.

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

High-performance data visualization turns sophisticated analyses into meaningful graphics, leading to faster and smarter decision making. In this white paper, learn how visual analytics can transform big data, with additional features such as real-time functionality, mobile compatibility, robust applications for technical groups and accessibility for nontechnical users.

Big Data: Lessons from the Leaders

Big Data: Lessons from the Leaders

Financial performance, competitive advantage, operational efficiency, strategic decision making - every business goal can extract value from big data, and the time for doubt or inaction has long passed. In this Economist Intelligence Unit report, in-depth interviews with data pioneers reveal the link between the effective use of big data and the bottom line among other results.

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Which came first, the data or the decision? This white paper makes the case for having a decision in mind, then tailoring big data's volume, variety and velocity to achieve business results such as overcoming customer dissatisfaction or creating well-informed strategies in real time.

Informationweek Reports

Research: The Big Data Management Challenge

Research: The Big Data Management Challenge

The challenge of big data is real, but most organizations don't differentiate 'big data' from traditional data, and nearly 90% of respondents to our survey use conventional databases as the primary means of handling data. We'll help you understand what constitutes big data (it's not just size) and the numerous management challenges it poses.