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!

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 databasesData managementsoftwareapplicationssybasedata mining

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

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Tom Pope

Dynabook Portégé X30L-G

Ultimately this laptop has achieved everything I would hope for in a laptop for work, while fitting that into a form factor and weight that is remarkable.

Tom Sellers

MSI P65

This smart laptop was enjoyable to use and great to work on – creating content was super simple.

Lolita Wang

MSI GT76

It really doesn’t get more “gaming laptop” than this.

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.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?