Big Data. Big Decisions
InformationWeek
Special Coverage Series

Commentary

Doug Henschen

Doug Henschen

Executive Editor, InformationWeek

Sears Hadoop Plans: Check Out Data Warehousing's Future

Hours, Not Weeks

(Page 2 of 2)

 Big Data Talent War: 7 Ways To Win
Big Data Talent War: 7 Ways To Win
(click image for larger view and for slideshow)
In one example of the kind of tools that Shelley would like to see, Sears is using Datameer, a spreadsheet-style tool that supports data exploration and visualization directly on Hadoop, without copying or moving data.

Another vendor operating on top of Hadoop is Hadapt, which implements a SQL-queryable data store running on Hadoop. It uses the power of Hadoop's distributed infrastructure to speed processing, and it can handle unstructured data applications including full-text search.

More Insights

Webcasts

More >>

White Papers

More >>

Reports

More >>

Platfora, which launched its first product at Strata New York, is yet another company offering a new-breed analytics platform built to run on Hadoop. The software gives analysts and power-users a data catalog that enumerates the data sets that are available on a Hadoop Distributed File System. When you want to do an analysis, you use a shopping-cart-metaphor interface to pick and choose the dimensions of data you want to use. Behind the scenes, Platfora's software takes care of creating and executing MapReduce processing that brings all the requested data into an interactive data-visualization environment.

[ Want the inside story on big data plans at Sears? Read Why Sears Is Going All-In On Hadoop. ]

Once the data lens is ready, a process that takes a few hours, according to Platfora, analysts and business users alike can query and explore the data with sub-second response time because the data lens runs in memory. Adding new data types or otherwise changing the dimensions used in a data lens takes minutes or hours, says Platfora, not the days, weeks or months it might require to rebuild a conventional data warehouse.

Platfora has a who's who list of prominent venture capital backers -- Andreessen Horowitz, Sutter Hill Ventures, In-Q-Tel -- and on Tuesday it closed a $20 round of funding led by Battery Ventures. The company also reports that more than ten companies are beta testing the software, though none have shared their stories publically as yet.

Established vendors, too, are working on ways to query data in Hadoop without actually moving that data. Teradata, for one, has placed bets on the HCatalog service for Hadoop being developed by Hortonworks, and Microsoft announced last week that it would add a PolyBase feature to the SQL Server 2012 Parallel Data Warehouse that will provide federated querying of Hadoop using Hive.

To get back to the question of how data warehousing will change, it's clear that many vendors are working on ways to run data-warehouse style analyses and analytic applications on Hadoop. The most promising candidates have few references and there's no clear leader as yet.

Amid all the enthusiasm building around Hadoop, you have to catch yourself sometimes and remember that the last public customer count from Cloudera (the leading Hadoop software distributor and support provider) was in the hundreds, not thousands or tens of thousands. Relational database users number in the millions, and the leading commercial vendors have hundreds of thousands of customers each.

Keeping that dose of reality in mind, it's clear that the broad market is not going to substantially change anytime soon, but the early adopters have adopted and the fast followers are now on their heels. It's only a matter of time -- perhaps three to five years -- before the cost, scale and flexibility advantages of Hadoop will give it a sizeable presence in the enterprise market. Showing up in even 20% of large and midsize firms within that timeframe would be breakneck speed compared to how long it took for relational data warehousing to proliferate.

It's at that point that things will really start to change for the relational database.

Just as the Internet and social networks are changing what we watch and how much time we spend watching TV and reading newspapers, the rise of Hadoop will cast relational databases in more tactical roles best suited to the strengths of the platform. Fast querying of structured data is what relational databases do best. Where new data types, complex data and varied data are constantly showing up, relational databases don't adapt quickly or well. And where data volumes are extreme, cost is a killer. That's the bottom line.

What's your view on whether, when and how Hadoop will impact relational databases? Share your comments below.

« Previous Page | 1 2  


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.