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

Ben Ramsden

Sharp PN-40TC1 Huddle Board

Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

George Khoury

Sharp PN-40TC1 Huddle Board

The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic

David Coyle

Brother PocketJet PJ-773 A4 Portable Thermal Printer

I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.

Kurt Hegetschweiler

Brother PocketJet PJ-773 A4 Portable Thermal Printer

It’s perfect for mobile workers. Just take it out — it’s small enough to sit anywhere — turn it on, load a sheet of paper, and start printing.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?