Sybase IQ 15.4 features 'Big Data' theme, support for Hadoop, MapReduce

Release 15.4 of the analytic database hops on the 'Big Data' train

Sybase is hoping its IQ analytic database can make its mark in the burgeoning "Big Data" market with an array of new features, including native integration with the open-source MapReduce and Hadoop programming frameworks for large-scale data processing.

The 15.4 release of IQ, scheduled for no later than Dec. 1, will come just several months after version 15.3, which added massively parallel-processing features to the platform. But work on 15.4 actually began about a year-and-a-half ago, because Sybase set up a few different teams to work on separate upcoming editions, said Dan Lahl, senior director of product marketing. "This is not a three-month hack job."

"Big Data" is an industry buzz-phrase that refers generally to the huge amounts of information created by websites, sensors and other sources outside of traditional enterprise applications. With Tuesday's announcement, Sybase joins the wave of database, data warehousing and analytics vendors that have been moving quickly to develop premium features and services around Hadoop and MapReduce.

New features in the 15.4 release include a native MapReduce programming interface that uses standard SQL; a Hadoop integration that provides various ways to tie together data from Sybase and Hadoop; a Java interface and additional extensions for existing C++ interfaces for running in-database algorithms; support for PMML (Predictive Model Markup Language) via a partnership with Zementis; and a data mining and statistics library from Fuzzy Logix for use in conjunction with MapReduce.

Sybase is also now offering an Express edition of IQ, which can be used indefinitely, but for development purposes only and with a 5GB database size limit.

One might think that Sybase IQ lies in an increasingly uncertain position, despite the rash of recent improvements, given SAP's unrelenting hype of late around HANA, its homegrown in-memory computing engine that so far has been targeted primarily at analytic workloads.

But the two databases can play complementary roles, said Joydeep Das, director of analytics product management.

HANA's blazing performance makes it a good fit for the real-time analysis of operational data from SAP applications, he said. As for IQ, "if you have very large enterprise data warehouse with growing numbers of users and data, Sybase IQ is a very good fit because of the scalability and speed."

Companies could also analyze data in HANA and use Sybase as "near-line" storage for that information once they're finished, he added.

Overall, a customer's database environment could be compared to a wedding cake, he added. In this scenario, Hadoop would sit at the widest bottom layer, crunching large data pools to find the "needles in the haystack," or actual information of value. Those needles would then be fed into IQ for further analysis, and potentially to an even faster system like HANA, he said.

"We're saying there's a place for both, and let customers use them where they make sense."

One expert took a measured view of Sybase's announcement.

"There's a lot of goodness here, but it's just not enough. There's nothing terribly differentiating about any of this," said Forrester Research analyst James Kobielus. Other vendors such as EMC's Greenplum division are further along the trail, according to Kobielus.

That said, Sybase will undoubtedly build on these initial features later on, he added.

Missing pieces include Sybase's own distribution of Hadoop, advanced MapReduce modeling tools or support for Hadoop sub-projects like the Pig programming framework, he said.

A Hadoop distribution would give Sybase "greater control over the full stack in terms of performance."

Overall, Hadoop and MapReduce don't necessarily address anything you can't also do now with a high-end, massively parallel data warehousing system, but "it's on a roll in terms of adoption" with "a vibrant ecosystem of vendors," Kobielus said. "It's getting to the point where it's the Linux of Big Data."

Chris Kanaracus covers enterprise software and general technology breaking news for The IDG News Service. Chris's e-mail address is Chris_Kanaracus@idg.com

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Tags open sourcegreenplumapplicationsIBMSAPsoftwaresybaseemcdata warehousingbusiness intelligencedatabases

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.

Chris Kanaracus

IDG News Service
Show Comments

Essentials

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >

Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Budget

Back To Business Guide

Click for more ›

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?