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 Good Gear Guide newsletter!

Error: Please check your email address.

Tags databasesapplicationsSAPsoftwaresybasedata warehousingbusiness intelligence

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 >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

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?