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

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

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!

Cathy Giles

Brother MFC-L8900CDW

The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Laura Johnston

MSI GS65 Stealth Thin

If you can afford the price tag, it is well worth the money. It out performs any other laptop I have tried for gaming, and the transportable design and incredible display also make it ideal for work.

Andrew Teoh

Brother MFC-L9570CDW Multifunction Printer

Touch screen visibility and operation was great and easy to navigate. Each menu and sub-menu was in an understandable order and category

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?