Sybase IQ updated for parallel processing

Sybase joins Microsoft in offering a database to run on a massively parallel processing architecture

Database vendor Sybase is upgrading its column-oriented database, Sybase IQ, to run on a massively parallel processing (MPP) architecture.

The company announced the beta of the new Sybase IQ, version 15.3, on Tuesday, the same day that Microsoft announced an MPP-based data warehouse version of its own SQL Server database, SQL Server 2008 R2 Parallel Data Warehouse.

Sybase's MPP architecture would be ideally suited for those organizations that need faster query response times from large data sets, said Kevin Leong, Sybase senior product manager. The parallel architecture allows a data set to split up across multiple servers to increase response time. Telecommunications firms, financial trading firms and governments should take a close look at the technology, he said.

Sybase's MPP architecture will use the company's PlexQ Distributed Query Platform. PlexQ uses what is commonly called a shared-everything design, meaning that each node in the system can share memory, processing and disk space with other nodes, Leong said. Previous versions of Sybase IQ designs could be used in clusters, but did not have a shared-everything approach.

This technique allows the platform software to balance the workload out across all the nodes. "You can buy multiple boxes, put them in a grid, and now your query can be spread across them," Leong said. "Incoming queries do not need to be queued behind a long-running, complex query."

The new version of Sybase's software will also include resource provisioning, allowing an administrator to carve out a subset of the system, called a logical image, for specific tasks.

Sybase IQ is a column-oriented database, one that distributes all the data of a single entry across different columns, rather than writing all the data elements across a single row, the traditional approach. Column-oriented databases can speed analysis in data warehouses, advocates claim.

Microsoft's beta release of the next generation SQL Server, code named Denali, will also include column-oriented data storage.

Users can now download and test the 15.3 beta. The full production release of Sybase 15.3 will probably be available in the first half of 20111, assuming all goes well with the beta version, Leong said.

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

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Tags databasesapplicationsdata miningsoftwaresybaseData management

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 Articles

Resources

PCW Evaluation Team

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Armand Abogado

HP OfficeJet 250 Mobile Printer

Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.

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.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?