IBM Cloud Services Take On Amazon Redshift - 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
Data Management // Software Platforms
News
10/28/2014
01:05 PM
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail
50%
50%

IBM Cloud Services Take On Amazon Redshift

IBM launches DashDB cloud-based columnar data warehouse fed by DataWorks data-integration service.

8 Robots Making Waves
8 Robots Making Waves
(Click image for larger view and slideshow.)

DashDB and DataWorks, now available on IBM's Bluemix cloud apps platform, are outgrowths of IBM's February purchase of Cloudant. DashDB is a cloud-based data warehouse service, while DataWorks is a cloud-based data-integration service. IBM is being cagey about the technological roots of these new services, though it's a safe bet that the columnar, SQL-based DashDB service is based on IBM Netezza, while the lightweight data-transformation and data-movement services of DataWorks are based on IBM CastIron.

Initially, both services are designed to work in tandem with the Cloudant NoSQL database service, but "the roadmap calls for the services to eventually work with any source," said Derek Schoettle, CEO of IBM Cloudant, in a phone interview with InformationWeek.

Customers running web or mobile applications on IBM Cloudant will be able to automatically replicate data from cloud-based NoSQL databases into DashDB for historical reporting and analysis. Using DataWorks, customers will be able to bring in transactional or enrichment data from on-premises or cloud-based sources for deeper correlation, analysis, and prediction.

[Want more on Cloudant? Read IBM Cloudant Will Power Local Data Centers, Apple Apps.]

"We've integrated quite closely such that a user of Cloudant can export a database from within Cloudant, put it through a transformation [in DataWorks], and get that data to DashDB so it can be analyzed in a traditional schema," said Schoettle. "It essentially takes JSON and figures out what the schema should be in a relational model."

DashDB is clearly IBM's answer to the Redshift data warehousing service, which Amazon Web Services reports to be one of its fastest-growing products ever. Google BigQuery is another fast-growing offering in the cloud-based data warehouse service arena. DashDB and DataWorks are being delivered in a freemium model as an extension of users' Cloudant accounts, according to Schoettle, with a free tier of service and charges based on compute and data capacities.

As InformationWeek reported on Monday, IBM is also making the Cloudant database available on-premises as Cloudant Local. Cloudant is based on CouchDB, but this is the first availability of a commercially supported version of that open-source product for deployment within corporate data centers. Cloudant executives said the cloud-based NoSQL service was instrumental in winning IBM's recent mobile apps deal with Apple.

IBM DashDB touts the ability to quickly load and view data, build BI and analytic apps, and 'run R scripts to analyze, manipulate, and visualize data.'
IBM DashDB touts the ability to quickly load and view data, build BI and analytic apps, and "run R scripts to analyze, manipulate, and visualize data."

In other news announced at IBM's Insight event in Las Vegas this week, the company said its IBM Cognos and IBM SPSS business intelligence and analytics suites are being offered as hosted, managed services in the IBM SoftLayer cloud. This will enable Cognos and SPSS customers to either expand on or completely migrate to IBM's private cloud.

IBM also introduced its Watson Analytics service, which was announced last month, and what sounded more like warmed-over versions of previously announced "solution accelerators" for Customer Insight, Operations Insight, Security and Fraud Insight, Risk and Compliance Insight, and Data Warehouse Modernization. The accelerators are pre-integrated collections of IBM software that can be deployed -- with the help of IBM services -- in on-premises data centers, in private clouds (yours or IBMs), or in hybrid combinations of the two.

What will you use for your big-data platform? A high-scale relational database? NoSQL database? Hadoop? Event-processing technology? One size doesn't fit all. Here's how to decide. Get the new Pick Your Platform For Big Data issue of InformationWeek Tech Digest today. (Free registration required.)

Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio

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
Comments
Newest First  |  Oldest First  |  Threaded View
JarrodV290
50%
50%
JarrodV290,
User Rank: Apprentice
7/28/2015 | 8:32:32 PM
Re: Cognos, SPSS in the cloud is not new.
its been around for quite some time as a cloud version.

it is new to softlayer.
pcharles09
50%
50%
pcharles09,
User Rank: Ninja
10/30/2014 | 10:52:20 PM
Re: Cognos, SPSS in the cloud is not new.
@Brian.Dean,

I gotcha. Makes sense. Less resources needed means more money to spend on other areas.
Brian.Dean
50%
50%
Brian.Dean,
User Rank: Ninja
10/28/2014 | 8:52:06 PM
Re: Cognos, SPSS in the cloud is not new.
@pcharles09, I was thinking about the computational side. Data sizes that do not require things like in-memory analysis, etc. These environments could grow to include thousands of users.
pcharles09
50%
50%
pcharles09,
User Rank: Ninja
10/28/2014 | 8:07:42 PM
Re: Cognos, SPSS in the cloud is not new.
@Brian.Dean,

What do you consider to be "small" data environments? Less than 100 users?
Charlie Babcock
50%
50%
Charlie Babcock,
User Rank: Author
10/28/2014 | 5:39:54 PM
The home of the ACID test once looked down on eventual consistency
I didn't think the inexact operations -- "eventual consistency" -- of the NoSQL systems impressed IBM too much a few years ago. Now it's bought Cloudant and is trying to catch up fast. Culturally, IBM as the home base of relational database with its ACID test for data consistency would look down on "eventual consistency" systems. But loose logic has its purposes, just as loose lips sometimes do more than sink ships. They learn about the customer, in a gossipy sort of way.
Brian.Dean
50%
50%
Brian.Dean,
User Rank: Ninja
10/28/2014 | 5:32:16 PM
Re: Cognos, SPSS in the cloud is not new.
Cognos and SPSS might not gain a lot of benefits from the infrastructure resource that the cloud offers, because I think that these solutions are mostly used in small data environments with high value. But, the value that instant updates in the cloud over, rolling out a version update enables greater value. 

SPSS is an extremely valuable solution and it has helped a lot in the field of economics, etc.
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
10/28/2014 | 2:19:29 PM
Cognos, SPSS in the cloud is not new.
I thought I had amnesia yesterday when an IBM exec insisted that Cognos and SPSS were NOT previously available in the cloud, but I've found references to their availability on the old "IBM SmartCloud."

Here's a 2012 reference: http://www.informationweek.com/cloud/infrastructure-as-a-service/ibm-smartcloud-as-much-cloud-as-you-want/d/d-id/1104413

I also found references to some offerings that sounded much like those "solution accelerators": http://www.informationweek.com/software/information-management/ibm-smart-solutions-predict-fraud-risk-customer-behavior/d/d-id/1103438

What's new, I'm guessing, is that this is the rebirth of Cognos and SPSS managed services on Softlayer, and a repackaging of thoese "solution accelerators." If they're not a single SKU with a single upgrade path and single point of support, beware. That's not what I would call agile IT no matter how quickly they claim to install.

 
Slideshows
Reflections on Tech in 2019
James M. Connolly, Editorial Director, InformationWeek and Network Computing,  12/9/2019
Slideshows
What Digital Transformation Is (And Isn't)
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/4/2019
Commentary
Watch Out for New Barriers to Faster Software Development
Lisa Morgan, Freelance Writer,  12/3/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
The Cloud Gets Ready for the 20's
This IT Trend Report explores how cloud computing is being shaped for the next phase in its maturation. It will help enterprise IT decision makers and business leaders understand some of the key trends reflected emerging cloud concepts and technologies, and in enterprise cloud usage patterns. Get it today!
Slideshows
Flash Poll