SAP's Sybase adds scalability to IQ analytic database

Sybase IQ 15.3 uses an MPP architecture that lets thousands of users be served

SAP's Sybase division announced the latest version of its IQ columnar database on Thursday, a release focused on providing enough scalability to allow many thousands and types of users within a company to access the system.

To achieve this, Sybase IQ 15.3 employs a MPP (massively parallel processing) grid architecture, wherein all compute notes share processing power, memory and access to data, which is accessed through a SAN (storage area network).

There's been much talk of late in the tech industry about the value of analyzing "big data," the term often used for the massive volumes of Web, sensor and other information being generated by companies today, said David Jonker, director of product marketing.

That vision can't be fully realized, however, unless a wide variety of business users get access to such information, according to Jonker. "We believe this transition requires a new kind of platform. The traditional enterprise data warehouse isn't holding up."

The MPP grid architecture will allow IT staffers to create "virtual data marts" for various users within a company by committing groups of physical servers to them, Jonker said.

Sybase's move got a nod of approval from one observer.

"Virtual data marts are a good idea, and too few vendors are making it easy to spin them out. They let departments start doing analytics very quickly, yet allow IT to keep partial control," said analyst Curt Monash of Monash Research.

The spirit of what Sybase is proposing, if not the same technical approach, is embodied in efforts such as rival Greenplum's Chorus platform for data-mart building.

Other features in Sybase IQ 15.3 include a Web services API (application programming interface); a Ruby on Rails language driver; an API for analyzing multimedia content; and a Web-based administration console.

Sybase IQ 15.3 arrives amid a protracted and intense marketing blitz for SAP's in-memory computing engine, HANA (High Performance Analytic Appliance). In-memory computing places data to be processed in memory instead of reading it off of disks, giving a performance boost.

There's certainly a way for IQ and HANA to work together, according to Jonker. "IQ is a natural fit for storing a lot of data on traditional disk-based storage," he said. In the longer term, IQ could serve as a "nearline" storage platform for HANA, aimed at data that needs to be accessed at some point, but which is not critical to have in HANA minute-to-minute, he said.

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 newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags databasesbusiness intelligencesoftwareapplicationsSAPdata warehousingsybase

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

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Jack Jeffries

MSI GS75

As the Maserati or BMW of laptops, it would fit perfectly in the hands of a professional needing firepower under the hood, sophistication and class on the surface, and gaming prowess (sports mode if you will) in between.

Taylor Carr

MSI PS63

The MSI PS63 is an amazing laptop and I would definitely consider buying one in the future.

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Aysha Strobbe

Microsoft Office 365/HP Spectre x360

Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications

Michael Hargreaves

Microsoft Office 365/Dell XPS 15 2-in-1

I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)

Maryellen Rose George

Brother PT-P750W

It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?