IBM preps SmartCloud for real-time analytics

IBM is updating SmartCloud with the new version of DB2, which offers new data analytics-friendly features

Deploying an update of its DB2 database, IBM is pitching its SmartCloud infrastructure as a service (IaaS) for use in data reporting and analysis.

"We're the only player in the marketplace that has [a cloud service] for data-in-motion -- being able to analyze data in real time," said Bob Picciano, IBM's general manager for Information Management.

Starting in the second half of this year, the IBM SmartCloud IaaS will start using version 10.5 of IBM's DB2 database, which should be generally available by early June. One new set of technologies that will come with this database, collectively called BLU Acceleration, can speed data analysis by 25 times or more, IBM claimed.

IBM also announced that SmartCloud can now run copies of SAP's HANA in-memory database, initially for test and development jobs.

BLU (a code name that stood for Big data, Lightening fast, Ultra easy) is a set of technologies that optimize the speed of DB2 queries for in-memory databases. It offers columnar processing, in which only the needed columns of a database table are read in order to speed performance. It skips over unneeded data, such as duplicate entries. It can use multiple processor cores to execute a query, using parallel vector processing techniques. It also includes a compression technology that minimizes the amount of space a data set needs, while still providing easy accessibility for quick analysis.

A customer can continue to use preferred business intelligence (BI) software and just redirect the SQL and OLAP (Online analytical processing) queries from the BI software to the IBM service. Each DB2 instance on SmartCloud can run on up to 16 processor cores, which collectively could manage a terabyte or more of memory.

"You don't need a lot of cores to be able to take advantage of this kind of parallelism, because we're so efficient in how we're using the processors and memory," Picciano said.

With this technology, a customer could set up a system that would analyze data as it comes off the wire, Picciano said. Typically, organizations may store their data in a data warehouse or, if data is collected in sufficient quantities, in a Hadoop cluster. Then they would use various BI tools to extract patterns and other intelligence from the data set. IBM proposes keeping the data in-memory and analyzing it on the fly, using the same BI tools. The in-memory approach can cut the query times by a thousand times, Picciano said.

"Queries that used to run in seven minutes on a well-known data warehouse systems can run in 8 milliseconds on our systems," Picciano claimed.

IBM joins a number of companies that are pitching cloud computing as an ideal platform for large-scale data analysis. Google, for instance, offers its BigQuery service for crunching data online. VMware, along with parent company EMC, recently spun out a cloud service subsidiary, called Pivotal, that will focus on a providing data analysis services.

IBM also is offering to run copies of SAP HANA on its SmartCloud, where it can be used for data analysis. The company did not specify whether it will provide its own licenses for the services, or if customers should procure their own. One early customer of this service has been the department store Globus, which tracks sales for about 800,000 items on a SmartCloud instance of HANA.

Picciano did not disclose pricing information for the SmartCloud database service, stating that IBM works with each customer on a case-by-case basis.

Other cloud providers also made announcements this week. Google has cut the prices of its Google Cloud Datastore, a NoSQL data storage service, by up to 25 percent. Also, Microsoft announced that it is expanding its Azure cloud service to China, making it the first major cloud provider to do so, the company claimed.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the PC World newsletter!

Error: Please check your email address.

Tags databasesapplicationsIBMsoftwarecloud computinginternetInfrastructure services

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?